AND imp. 1. transaction_number. The ACCT_EVENT_ID field in the PA_COST_DISTRIBUTION_LINES_ALL table is the simplest and most direct link between cost distribution lines in Projects (and. approved_flag. ,d. Pa_MC_Cost_Dist_Lines_ar is a table for Archive/Purge. … Received Response Gopal Krishna Thammana 34 views 3 comments 0 points Most recent by Gopal Krishna Thammana Sep 21, 2022 11:01AM Project ManagementHi team, We have a scenario for which we need to fetch all the eligible expenditures for a project without using PJC tables like pjc_Exp_items_all, PJC_COST_DIST_LINES_A… Accepted answer Mayank_Khatri 22 views 3 comments 0 points Most recent by Pradeep Balakrishnan Sep 28, 2023 7:04AM Project ManagementCurrently I am using pjc_cost_dist_lines_all table in my quer… Accepted answer Ankit_Bhadja 11 views 1 comment 0 points Most recent by Vinodhini Vobhilineni-Oracle Aug 28, 2023 9:44AM Project Managementname; pjc_context_category. " RAW_COST_DR_CCID" and. Indicates the code used to derive default rate dates. Paris Junior College. WHERE ccdl_orig. CREATION_DATE DESC-- find the expenditure_item_id, ie:10000 Description: One of the most common requirement for every technical consultant working in oracle and Related technologies is to find out specific database tables which hold a particular piece of information. pjc_expenditure_item_date. expenditure_item_date expenditure_item_date2. AS (SELECT DISTINCT GL. This column contains the identifier of. rounding_class_code = 'RAW_COST_CLEARING' AND NOT EXISTS ( SELECT 1 FROM xla_distribution_links xda1 WHERE xda1. FROM pjc_cc_dist_lines_all ccdl, pjc_cc_dist_lines_all ccdl_orig , XLA_EVENTS_GT imp. When one transaction associated to 2 lines and the 2 lines associated to 2 different code combination, there are 4 lines return with my script. 10. Total burdened cost of the expenditure item in transaction currency Burdened cost = (raw cost * (1 + burden cost multiplier)) This must equal the sum of the items burden debit cost distribution lines For non-burdened items, burdened cost = raw cost. cc_dist_line_id(+) = ccdl. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. pjc_txn_xface_all: pjf_work_types_b: WORK_TYPE_ID: pjc_cost_dist_lines_all: pjf_work_types_b: WORK_TYPE_ID: Indexes. AND PRD. source_line_id_2It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. ind_rate_sch_revision_idbre. PA_COST_DIST_OVERRIDES stores configurations defined at the project level that redirect specific costs and revenue to another organization. The table AP_INVOICE_LINES_ALL used by Oracle Fusion to store the line level data of AP invoices. 0 and later: Detailes About Some Errors from Table PJC_TXN_ERRORS. FROM pjc_cost_dist_lines_all projectcostdistributionpeo, pjc_exp_items_all expenditureitempeo, pjf_exp_types_vl pet WHERE ( projectcostdistributionpeo. Hi Please find the Columns and tables that we are using below SQL. DENORM_TOP_ELEMENT_ID. Goal FROM pjc_cost_dist_lines_all cdl, pjc_exp_items_all ei, pjf_ind_compiled_sets ics, pjf_irs_revisions irsr, pjf_cost_base_exp_types cbet, pjf_compiled_multipliers cm, pjf_ind_cost_codes icc, pjf_txn_document_b td, pjf_p_periods_all_v p, pjf_ind_rate_sch_b irs. acct_event_id. pjf_projects_all_b ppab, pjf_projects_all_tl ppat, hr_all_organization_units hr, hr_all_organization_units hr1, hr_operating_units op, pjc_cost_dist_lines_all pcdl, pjf_exp_categories_tl pec, gl_code_combinations gcc, pjb_errors pe, okc_k_headers_all_b okh, okc_k_lines_b okl, pjb_bill_plans_vl pjbp, okc_contract_types_tl okct, xla_distribution. expenditure_type_id AND. CONTRACT_LINE_ID:. This column contains the identifier of the Accounting Event in SLA. AP_INVOICE_DISTRIBUTIONS. October 10 / READ. 4 Important Tables of Oracle fusion user roles query 1. end_date_active. For capital projects this flag is used as capitalizable_flag. attribute7. INVOICE_LINE_NUMBER: NUMBER: Invoice line number for parent line:. ACCOUNTING_STATUS_CODE . Index Uniqueness Tablespace Columns; PJF_WORK_TYPES_B_N1:It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. A distribution must be associated with an invoice. Examples of when your Oracle Payables application automatically creates rows in this table include. ei_project_name, x. enabled_flag. Also, our requirement is to open a DFF at Project Expenditure Batch Header Level, but unable to find one. FROM pjc_exp_items_all ei , pjc_cost_dist_lines_all cdl, xla_events_gt imp, GL_ENCUMBRANCE_TYPES_VL GLET, pjf_txn_document_b doc Oracle Fusion Query For Join Between Project, Project Cost Distribution And Gl Code Combination (Doc ID 2856441. DENOM_BURDENED_COST NUMBER Total burdened cost of the expenditure item in transacti. meaning. Project Portfolio. OKE_DEBUG_MODE. PA_MC_COST_DIST_LINES_AR. Please help in identifying the column mapping on fusion application to get the Burdened cost in Receiver Ledger Currency. AP_INVOICE_LINES_ALL. 1. tag. This information will be interfaced to Oracle General Ledger from Oracle Projects. COST_ID: NUMBER: 18: Yes: Reference to the layer, write-off or transfer. Transaction identifier of the burden cost. project_id = ppa. WHERE pcdl. Foreign Keys to Important PJC_EXPENDITURE_ITEMS_ALL Table Fields Here is a table that lists the foreign keys of the ORIGINAL_HEADER_ID, ORIGINAL_DIST_ID, and ORIGINAL_LINE_NUMBER fields in the PJC_EXPENDITURE_ITEMS_ALL table in some of the most commonly-used transaction sources and documents. Summary: We have a requirement to create a report/integration listing Expenditure / Costing information along with Billing information. Index Uniqueness Tablespace Columns; PJF_WORK_TYPES_B_N1:Object Details. vendor_id. Provision with single sign-on. Object type: TABLE. PJC_PRJ_ASSET_LNS_ALL. Person ID related to the person record for this labor cost. FROM pjc_exp_items_all ei , pjc_cost_dist_lines_all cdl, xla_events_gt imp, GL_ENCUMBRANCE_TYPES_VL GLET, pjf_txn_document_b doc. ae_header_id AND lnk1. The line"s current cost amount in the reporting currency; split lines have a current cost <> original cost:. The level of summarization in this table is controlled by the CIP Grouping Method for the project type, as well as by the level (task or. line_type in ('R', 'B') AND. project_id AND pbt. transaction_id =. These lookup codes are stored in the AP_LOOKUP_CODES table. 0425. Major release with updates for Fusion ERP Analytics, Fusion HCM Analytics, Fusion SCM Analytics, and Fusion CX Analytics. This table is used to temporarily store a subset of the data from cst_cost_distribution_lines table for internal processing within the cost processor. source_line_id_1. inventory_item_id,i. We have a requirement to derive only accounted project cost transactions by creating custom BIP report. ae_line_num, xda2. Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active: PJC_PROJECT_ID: NUMBER: 18:AP_INVOICE_DISTRIBUTIONS_ALL holds the distribution information that is manually entered or system-generated. User-defined number that uniquely identifies the element within a project or structure. pjc_contract_line_id CONTRACT_LINE_ID/*Added for grants uptake*/, l. Index Uniqueness Tablespace Columns; PJF_RATE_OVERRIDES_N1: Non Unique: Default:. po_revision. The identifier of the top task to which this tasks rolls up. name columns; pjc_acct_sweeper_logs_pk. acct_event_id. FROM pjc_cost_dist_lines_all pcdl, pjc_exp_items_all pei, pjf_tasks_v ptv, pjf_projects_all_b prb, pjf_projects_all_tl prl,. source_line_id_2PJC_PRJ_ASSET_LNS_ALL. Then XLA_AE_LINES link to XLA_AE_HEADER where we can see. PJC_AWARD_DIST_LINES_U1. Yes. Oracle Application Wednesday, 28 December 2022PJC_XCC_BURDEN_DIST_ERRORS; PJC_XCC_BURDEN_DIST_ERRORS. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. To get the. t costs are also not populated. So we can say that this table AP_INVOICE_DISTRIBUTIONS_ALL plays a critical role in P2P Cycle in Oracle. 1) Last updated on FEBRUARY 21, 2021. If the task is a top task, the top_task_id is set to its own task_id. I am not even sure if that is the right. ei_project_numbe. Contents. meaning. CDL_LINE_NUM: NUMBER: 18: Line Number of the Cost Distribution Line. Examples of when your Oracle Payables application automatically creates rows in this table include. VARCHAR2. expenditure_item_id = expenditureitempeo. Used to implement optimistic locking. data_set_id data_set_id, ei. project_id = ppa. These subject areas with base metrics are added to the automated validations for base metrics between the Oracle Applications Cloud source and Oracle Fusion Analytics Warehouse : Sales Orders subject area with 6 base metrics. expenditure_type_id pjf_projects_all_b ppab, pjf_projects_all_tl ppat, hr_all_organization_units hr, hr_all_organization_units hr1, hr_operating_units op, pjc_cost_dist_lines_all pcdl, pjf_exp_categories_tl pec, gl_code_combinations gcc, per_person_names_f ppn, pjb_rev_distributions prd, pjb_errors pe, xla_distribution_links xda, xla_ae_lines xal, ap_invoice. The room and board residence hall cost for academic year 2023-2024 are:. AND imp. AP_Invoices_All has the unique key on invoice_id. David. attribute4. This value for the project is a default for the task fixed date. Collin County Community College District. SOURCE_LINE_ID_2:. Oracle Fusion ERP Analytics. source_line_id_3. You can optionally redirect only certain. Founded In 1924. name; source_bu_id. You can define a cost distribution override to redirect the costs and revenues generated by a specific employee or by all employees assigned to a specified organization. Currently I am using pjc_cost_dist_lines_all table in my quer… Accepted answer Ankit_Bhadja 11 views 1 comment 0 points Most recent by Vinodhini Vobhilineni-Oracle Aug 28, 2023 9:44AM Project ManagementTable to store Catalog of Federal Domestic Assistance values. ref_ae_header_id =. WHERE ics. The cost distrulibution table for the ccid fields are null. PrimaryKey: Finds all adjustments performed on the specified project cost. PROJECT_ID =P. PJC_CONTRACT_LINE_ID: NUMBER: 18: DFF Column used by Standardized Project Cost Collection Widget: Active: PJC_FUNDING_ALLOCATION_ID:All: Closed: Capital data (asset line details) Capital: Closed: Actuals: - Cost distribution lines - Expenditure items and related tables - Cross charge transactions - Staffing transactions: All: Closed: Actuals: - Customer invoices - Revenue distribution lines: Contract: Closed: Actuals: - Cost distribution lines - Expenditure items and. Unique identifier for an allocation rule for the source line: LINE_NUM: NUMBER: Yes: Line number: EXCLUDE_FLAG: VARCHAR2: 1: Yes: The flag indicates whether to exclude returned projects Y means exclude: CREATED_BY: VARCHAR2: 64: Yes: Who column: indicates the user who created the row. WITH last_creation_info AS ( SELECT MAX(creation_date) AS creation_date, project_id FROM ( SELECT transaction_project_id AS project_id, MAX(creation_date) creation_date FROM pjb_inv_line_dists GROUP BY transaction_project_id UNION ALL SELECT project_id, MAX(creation_date) creation_date FROM pjc_cost_dist_lines_all. pjf_projects_all_b ppab, pjf_projects_all_tl ppat, hr_all_organization_units hr, hr_all_organization_units hr1, hr_operating_units op, pjc_cost_dist_lines_all pcdl, pjf_exp_categories_tl pec, gl_code_combinations gcc, per_person_names_f ppn, pjb_rev_distributions prd, pjb_errors pe, xla_distribution_links xda, xla_ae_lines xal,. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. We originally had our PRBS by Expenditure Category and Type. FROM. 1) Last updated on MAY 27, 2022 Applies. FROM. Description. The level of summarization in this table is controlled by the CIP Grouping Method for the project type, as well as by the level (task or. ind_rate_sch_revision_id = irsr. NAME expenditure_organization,. How does the raw_cost_ccid on the pjc_cost_dist_lines_all table get populated? I see cost distributions and expenditures on a project from AP but when mapping the cost distribution back to the GL, i get no resultsLedger, corresponding to the cost organization book, where the distribution should be recorded. 1. 1. OKE: Debug Mode. description. Symptoms. InvoicesThey can be found in MetaLink, Knowledge, (scroll down left navigator) Online Documentation, last item. expenditure_item_id. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. PA. PA_MC_COST_DIST_LINES_ALL. Contents. An. ei_latest_gl_period_name, x. The code you enter must be ITEM, TAX, MISCELLANEOUS, or FREIGHT. ,d. But keep an eye on column quantity_invoiced. 1. PA tables in fusion - Read online for free. PA_CUST_REV_DIST_LINES_ALL is referenced by following: APPSPiper Sandler Companies Reports Third Quarter 2023 Results; Declares Quarterly Dividend of $0. This flag determines if Cross Charge processing is allowed or not. Cost distribution lines amount are implicitly debit amounts. SELECT pcdl. Paris, Texas 75460 Tel: (903) 785-7661 Contact Us. gl_ledgers g, per_person_names_f_v req, po_line_types lt, por_requisition_lines_all rl, por_requisition_headers_all rh, pjf_tasks_v t, hr_organization_v o, pjf_exp_types_vl et, por_req_distributions_all rd, pjf_projects_all_vl p, pjf_exp_categories_vl cat, fun_all. Content (required): The values in this field are RPBNN. AND imp. expenditure_item_idIf you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. and PROJECT_ID=. Hello All, > Oracle BI Publisher I have creating report using Oracle BI Publisher. ACCOUNTING_DEFINITION_ID: NUMBER: 18: Yes: Reference to the cost accounting definition line. source_header_id_2. Applies to: Oracle Fusion Project. pa_cost_distribution_lines_all. source_line_id_3. creation_date. These lookup codes are stored in the AP_LOOKUP_CODES table. Indicates whether invoice line is enabled for landed cost management. name; lookup_type. Used as a predefined finder to search the collection. Title and Copyright Information; Get Help; 1 Overview 2 Asset TrackingTo see a listing of courses offered, click the “Course Search” link below. This input is required to create reports, understand links between various charts, and even for troubleshooting purpose. 7661 • Admissions: 903. transaction_number. AND imp. Feature Description Additional subject areas These subject areas have been added: • Project Budget provides the ability to report on cost, revenue, margin, and the changes to. The parameters for the Transaction Costing process are defined on the Cost Accounting. Solution. This table corresponds to the Invoice distributions window of Invoice workbench. 7. R2. tag. Goal. Total burdened cost of the expenditure item in transaction currency Burdened cost = (raw cost * (1 + burden cost multiplier)) This must equal the sum of the items burden debit cost distribution lines For non-burdened items, burdened cost. trunc(cdl. 0. I see cost distributions and expenditures on a project from AP but when mapping the cost distribution back to the GL, i get no results. B. pjc_contract_line_id CONTRACT_LINE_ID/*Added for grants uptake*/, l. Paris Junior College 2400 Clarksville St. PA_DRAFT_REVENUES_ALL. 1. 0 and later: PJC: Oracle Fusion Project Cost Account Reconciliation Report. . source_line_id_1. v515220161. PJC_AWARD_DISTRIBUTIONS interfaces the data with invocation business functions. ae_line_num AND aeh1. source_line_id_4. Public. PJC: Oracle Fusion Project Cost Account Reconciliation Report (Doc ID 2121913. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Destination. We would like to show you a description here but the site won’t allow us. WHERE ccdl_orig. attribute6. WHERE ei. Refer to comments on the columns in the main table. Name of the pay element. expenditure_item_id = expenditureitempeo. But I am unable to find a column which will specify whether a cost transaction is accounted or not from the table pjc_cost_dist_lines_all. Name of the pay element. Distribution identifier of the burden cost. WHERE pcdl. Oracle Fusion Project Costing Cloud Service - Version 11. CONSUMPTION_ADVICE_HEADER_ID: NUMBER: 18:Feature. PJC_MC_PRJ_AST_LINES_ALL is an MRC sub table of PJC_PRJ_ASSET_LNS_ALL. My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts. transaction_id =. pjc_organization_id. Summary: Hello, We are in a DEV environment Cloud 23B. 1) Last updated on MAY 27, 2022 Applies to: Oracle Fusion Project Costing Cloud Service - Version 11. 12. In this Document. I used csv file as data source in Data Model. NUMBER. For external third party import, this flag should be populated while interfacing the data into PATI. Default flag for items charged to the task that indicates if the item can accrue revenue (Y or N). attribute3. l. If the task is a top task, the top_task_id is set to its own task_id. 5. Purpose of this report is to display Project billable hours for Internal ===== /* Formatted on 2018/07/30 15:40 (Formatter Plus v4. expenditure_item_id. 1. 18. Columns. source_header_id_1. This input is required to create reports, understand links between various charts, and even for troubleshooting purpose. PA tables in fusionIf you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. PJC_CONTRACT_LINE_ID: NUMBER: 18: Tracks contract line information. User-defined number that uniquely identifies the element within a project or structure. end_date_active. dist_acct_burdened_cost dist_acct_burdened_cost, l. dist_acct_raw_cost dist_acct_raw_cost, l. replace the project_id. award_distribution_batch_id. Supply Chain Management. OKE_DEBUG_FILE_DIR. ref_ae_header_id =. Foreign Keys to Important PJC_EXPENDITURE_ITEMS_ALL Table Fields Here is a table that lists the foreign keys of the ORIGINAL_HEADER_ID, ORIGINAL_DIST_ID, and ORIGINAL_LINE_NUMBER fields in the PJC_EXPENDITURE_ITEMS_ALL table in some of the most commonly-used transaction sources and documents. xla_distribution_links. PO_DISTRIBUTIONS_ALL contains accounting distribution information for a purchase order shipment line. Processing Start Date, calculated as the maximum award, project, task, assignment, or labor schedule start date. 0. AS (SELECT DISTINCT GL. A quick summary of accounting entries in Order to Cash cycle Sales order creation – No entries Pick release: Inventory St. ACCT_CURRENCY_CODE. Oracle Fusion Query For Join Between Project, Project Cost Distribution And Gl Code Combination (Doc ID 2856441. This number is incremented every time that the row is updated. Project Contracts Profile Options →. r. Feature Description Additional subject areas These subject areas have been added: • Project Budget provides the ability to report on cost, revenue, margin, and the changes to. acct_event_id. Report message to a moderator. sum of the items raw cost distribution lines. This number is incremented every time that the row is updated. je_source_name AS JE_SOURCE_NAME,It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. FROM pjf_burden_rate_extn bre, pjc_exp_items_all ei, pjc_cost_dist_lines. The line"s current cost amount in the reporting currency; split lines have a current cost <> original cost:. 18. ind_rate_sch_revision_id = irsr. FROM pjc_cc_dist_lines_all ccdl, pjc_cc_dist_lines_all ccdl_orig , XLA_EVENTS_GT imp. F81674-01. 60 Per Share. PJC_CC_DIST_LINES_ALL:. The value must be a valid value for the cost center segment of the accounting flexfield. You need one row for each distribution line you attach to a purchase order shipment. I have tried linking xla_distribution_links with PJC_COST_DIST_LINES_ALL but I am not sure what to link to source_distribution_id_num_1 to get the right value. We are trying to find the lookup values for the field PJC_COST_DIST_LINES_ALL. SELECT FROM PJF_PROJECTS_ALL_B WHERE SEGMENT1='proj_nr';-- note the project_id; 2. You can optionally redirect only certain. . ei_revenue_distributed_flag, x. 9. Summary: We have a requirement to create a report/integration listing Expenditure / Costing information along with Billing information. ae_header_id. WITH gl_cmn_tbls. printed_date. Previous Next JavaScript must be enabled to correctly display this content . 1. PA_CC_DIST_LINES_ALL stores information about the accounting distributions related to transfer price for cross charged expenditure items. Fixed date to find the effective rate of the bill rate or burden schedule when determining the transfer price for labor transactions. AP_DISTRIBUTION_SET_LINES_ALL contains detailed information about individual distribution lines you define for a Distribution Set. I checked for this table PJC_COST_DIST_LINES_ALL and found these columns. requestor_person_id. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. FROM pjc_cc_dist_lines_all ccdl, pjc_cc_dist_lines_all ccdl_orig , XLA_EVENTS_GT imp. 2. Each of these initial records. pa_date. AND imp. Cloud Applications. attribute5. Summer Long - $1,800. We would like to show you a description here but the site won’t allow us. Paris, Texas 75460. Burdenable Raw Cost: ACCOUNTING_EVENT_ID: NUMBER: 18:. Paris, Texas 75460 Tel: (903) 785-7661 Contact Us. WHERE ics. The schedule header Last Update Date must be on or before the Last Activity DateDuplication in counts and amounts happened when a cost transaction mapped to multiple contract lines. Enter the lookup code for the type of invoice distribution that you want Payables Open Interface Import to create from this record. The output should be Prepayment. Currently I am using pjc_cost_dist_lines_all table in my quer… Accepted answer Ankit_Bhadja 14 views 1 comment 0 points Most recent by Vinodhini Vobhilineni-Oracle Aug 28, 2023 9:44AM Project Management23. 2. ACCT_CURRENCY_CODE. PA_CUST_REV_DIST_LINES_ALL. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. EBS Tables. Only While uploading the Accounted Project costing transactions with accounting entries, the CCID columns viz. name; lookup_type. Processing Start Date, calculated as the maximum award, project, task, assignment, or labor schedule start date. source_line_id_1. Advising and Counseling. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Tables and Views for Financials. attribute1. On the course search page, select the term, select 'Undergraduate' for division, and then click the 'Search' button. BILLABLE_FLAG. PA_COST_DIST_OVERRIDES stores configurations defined at the project level that redirect specific costs and revenue to another organization. capitalizable_flag = 'Y' pjf_projects_all_b ppab, pjf_projects_all_tl ppat, hr_all_organization_units hr, hr_all_organization_units hr1, hr_operating_units op, pjc_cost_dist_lines_all pcdl, pjf_exp_categories_tl pec, gl_code_combinations gcc, pjb_errors pe, okc_k_headers_all_b okh, okc_k_lines_b okl, pjb_bill_plans_vl pjbp, okc_contract_types_tl okct, xla_distribution. 0. S. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. I have a script as below to link ra_cust_trx_line_gl_dist_all to xla_ae_lines for getting the xla accounting line detail. Report: Packing Slip Report Report Short Code: WSHRDPAK Module: Oracle Shipping Report Navigation: Shipping super user responsibility -> Shipping -> Reports and Documents -> Select the report name as ‘Packing Slip Report’ -> Enter parameters. CREATED_BY EXP_CDL_DIST_CREATED_BY, trunc(cdl. pjc_project_id. expenditure_item_id AND expenditureitempeo. But I am unable to find a column which will specify whether a cost transaction is accounted or not from the table pjc_cost_dist_lines_all. expenditure_item_id, cdl_line_num, prvdr_gl_date, project_raw_costSELECT x. COST_ORGANIZATION_ID: NUMBER: 18: Yes: Cost organization of the transaction for which the distribution is created. List price fields, oracle ar tables in an item will not use these columns or process and line to the owner. DENORM_TOP_ELEMENT_ID. Content (required): When Generate Burden Costs runs, and new Burden Expenditure Items are created, I can see the following in the background tables:name; project_id. I see cost distributions and expenditures on a project from AP but when mapping the cost distribution back to the. , POD. AP_INVOICE_LINES_ALL_ is the audit table for AP_INVOICE_LINES_ALL. *****. RAW_COST: NUMBER (22) ORG_ID: NUMBER (15) OUTPUT_VAT_TAX_ID: NUMBER: Default output tax code identifier for invoice line: OUTPUT_TAX_EXEMPT_FLAG: VARCHAR2 (1).