FROM pjf_burden_rate_extn bre, pjc_exp_items_all ei, pjc_cost_dist_lines. ra_customer_trx_lines_all. 18. AMOUNT_VARIANCE:. 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. Hello All, > Oracle BI Publisher I have creating report using Oracle BI Publisher. For external Oracle Import, this flag is derived from the setup data atProject, Task and Document Entry level. See Reference for Oracle Fusion CX Analytics. CONTRACT_LINE_ID:. 0. 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. ae_header_id FROM xla_distribution_links xda2 WHERE xda2. PJC_CONTRACT_LINE_ID: NUMBER: 18: Tracks contract line information. Piper Sandler Appoints Dustin Avey and Jeremy Gerber as Co-Heads of Public Finance. 1. I used csv file as data source in Data Model. The identifier of the top task to which this tasks rolls up. source_header_id_1. PJC_MC_PRJ_AST_LINES_ALL is an MRC sub table of PJC_PRJ_ASSET_LNS_ALL. Description. 0 and later. It stores currency related information about project asset lines for each reporting set of books associated with the parent record on PJC_PRJ_ASSET_LNS_ALL. Person ID related to the person record for this labor cost. Oracle Fusion Cloud Project Management. This is defaulted to a project from the project template. For this request we need to know list of the Project tables which will be updated while running Create accounting process for the Expenditure / Costing. For external third party import, this flag should be populated while interfacing the data into PATI. COST_BOOK_ID: NUMBER: 18: Yes: Cost book within the cost organization for which the distribution is created. 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. AP_INVOICE_DISTRIBUTIONS. CONSUMPTION_ADVICE_HEADER_ID: NUMBER: 18:Feature. 4 miles. attribute1. . 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. ref_ae_header_id =. project_id = ppa. . WHERE ics. S. ref_ae_header_id =. When a cost distribution program processes an expenditure item, it creates one or more corresponding cost distribution lines to hold the cost amounts and the general ledger account information to which the cost amounts will post. An invoice can have one or more invoice lines. When a cost distribution program processes an expenditure item, it creates one or more corresponding cost distribution lines to hold the cost amounts and the general ledger account information to which the cost amounts will post. quantity), 0) FROM pjc_cost_dist_lines_all. pjc_contract_line_id CONTRACT_LINE_ID/*Added for grants uptake*/, l. This input is required to create reports, understand links between various charts, and even for troubleshooting purpose. display_sequencePurpose of this report is to derive all projects expenditure and event details with cost information. Hi 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:04AMSingle column FK: Identifies the cost distribution header record. ae_header_id FROM xla_distribution_links xda2 WHERE xda2. To override the cost center in the account, enter a value. ae_header_id = ael1. 1. 23D. display_sequencePurpose of this report is to derive all projects expenditure and event details with cost information. Previous Page. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. PA_CC_DIST_LINES_ALL stores information about the accounting distributions related to transfer price for cross charged expenditure items. 13. Piper Sandler Completes 46th Semi-Annual Generation Z Survey of 9,193 U. ref_ae_line_num IS NULL AND xda2. FROM pjc_cost_dist_lines_all projectcostdistributionpeo, pjc_exp_items_all expenditureitempeo, pjf_exp_types_vl pet WHERE ( projectcostdistributionpeo. Oracle Application Wednesday, 28 December 2022PJC_XCC_BURDEN_DIST_ERRORS; PJC_XCC_BURDEN_DIST_ERRORS. ref_ae_line_num = xda2. DENORM_TOP_ELEMENT_ID. For example, the PJC_COST_DIST_LINES_ALL table stores the cost distributions for expenditure items, including attributes such as expenditure item ID, line number, and. GL_CODE_COMBINATIONS contains valid account combinations for each accounting flexfield structure within the Oracle Fusion General Ledger application. F81674-01. INV_CONFIG_DIST_ID. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. The line"s current cost amount in the reporting currency; split lines have a current cost <> original cost:. 1. Validation. ae_header_id = ael1. Previous Next JavaScript must be enabled to correctly display this content Tables and Views for Financials. Collin County Community College District. There is one row for each invoice distribution. AP_INVOICE_LINES_ALL_ is the audit table for AP_INVOICE_LINES_ALL. The parameters for the Transaction Costing process are defined on the Cost Accounting. 2. 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. This input is required to create reports, understand links between various charts, and even for troubleshooting purpose. name; lookup_type. Approve the PO 3. Index Uniqueness Tablespace Columns; PJF_RATE_OVERRIDES_N1: Non Unique: Default:. 1) Last updated on MAY 27, 2022 Applies to: Oracle Fusion Project Costing Cloud Service - Version 11. WITH gl_cmn_tbls. Tables and Views for Project Management. sql_statement; select cre. If the task is a top task, the top_task_id is set to its own task_id. 0). ind_rate_sch_revision_id bre. projfunc_cost_exchange_rate src_projfunc_cost_xchng_rate, bre. source_id_int_1 = cdl. data_set_id data_set_id, ei. pjc_txn_xface_all: pjf_work_types_b: WORK_TYPE_ID: pjc_cost_dist_lines_all: pjf_work_types_b: WORK_TYPE_ID: Indexes. expenditure_item_id AND expenditureitempeo. name; po_number. t costs are also not populated. AS (SELECT DISTINCT GL. Processing Start Date, calculated as the maximum award, project, task, assignment, or labor schedule start date. 1) Last updated on NOVEMBER 08, 2022. 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. PA_MC_COST_DIST_LINES_AR. COST_ID: NUMBER: 18: Yes: Reference to the layer, write-off or transfer. How much does Paris Junior College cost?. This column contains the identifier of the Accounting Event in SLA. An invoice can have multiple distributions. There is one row for each invoice distribution. Title and Copyright Information; Get Help; 1 Overview 2 Asset TrackingTo see a listing of courses offered, click the “Course Search” link below. Status becomes Closed for receiving (due to receipt close tolerance = 100% @ PO line type setup) 4. 2. 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. 12. expenditure_type_id = pet. 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. xcc_data_set_id data_set_id, to_char(cre. VARCHAR2. Indicates the code used to derive default rate dates. Office & Switchboard Hours (all locations) Monday - Friday: 8AM - 5PM Greenville Center Tel: (903) 454-9333 Sulphur Springs Center Tel: (903) 885-1232 Help & Support. Solution. We are unable to understand the difference between the contexts PJC: All and PJC: Expenditure Batch in the LOV of contexts in Project Standard Cost Collection Flexfield. Loading. PROJECT_ID =P. OLD_DIST_LINE_NUMBER: NUMBER: 18: Old invoice distribution line number. We would like to show you a description here but the site won’t allow us. INVOICE_TYPE_LOOKUP_CODE. pjc_cost_dist_lines_all: pjf_rate_overrides: RATE_OVERRIDE_ID: Indexes. Free essays, homework help, flashcards, research papers, book reports, term papers, history, science, politicsAP_INVOICE_LINES_ALL is one of the most important table in P2P Cycle. 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. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. Once all lines associated with a schedule are purged, the whole schedule is purged. 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,. Summary: We have a requirement to create a report/integration listing Expenditure / Costing information along with Billing information. Summary: We have a requirement to create a report/integration listing Expenditure / Costing information along with Billing information. Summer Long - $1,800. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. event_id = ccdl. 0 version, Manage Project Costs. WHERE ics. How can we derive the segments in Payables, Purchasing and Expense using the Project Costing? Qn2:Please confirm that the distribution set be defaulted when I setup SLA even for Project Costing?Oracle Applications P2P,O2C R2R, BI, Oracle Fusion Application, Oracle E Busines Suite, Oracle Financials, SLA, MPA, Functional, Technical,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. ae_line_num AND aeh1. source_line_id_3. We want to derive the Accounting Code Combination based on Expenditure Types. PA_PROJECT_ASSET_LINE_DETAILS stores information necessary to drill down from an asset line to the cost distribution lines that are summarized in the asset line. 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_ALL. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. SELECT FROM PJF_PROJECTS_ALL_B WHERE SEGMENT1='proj_nr';-- note the project_id; 2. award_distribution_status. Without value the data in Project Accounting cannot be linked to Accounts Payable transactions. The table has no primary key. A subledger journal entry can have a status of Draft, Final, Incomplete, Invalid or Invalid Related Entry. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. pjc_project_id. xla_ae_lines xal, pjc_exp_items_all peiThis table contains non-persistent data and is used to expose summary data to Essbase. 18. AND imp. ei_revenue_distributed_flag, x. FROM pjc_cc_dist_lines_all ccdl, pjc_cc_dist_lines_all ccdl_orig , XLA_EVENTS_GT imp. AND imp. name; award_distribution_line_id. PJC_CC_DIST_LINES_ALL:. pjc_organization_id. name; pjc_context_category. VARCHAR2. Paris Junior College. 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. 782. There can be only one record for the combination of Supplier and the invoice number. expenditure_type_id AND. 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. 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. meaning. A distribution must be associated with an invoice. PA_PROJECT_ASSET_LINES_ALL stores summarized project CIP cost lines. source_line_id_4. *****. 10. lookup_code. Stores the events registered for the requests submitted. Teens. We have a requirement to derive only accounted project cost transactions by creating custom BIP report. project_status, a. pjc_contract_line_id contract_line_id/*added for grants uptake*/ from. The system generated number that uniquely identifies the work type. PJC’s Brewer drafted by Yankees (2022) Beau Brewer of McKinney,. This parameter restricts the number of resources returned. ae_line_num AND xda1. 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. It stores currency related information about project asset lines for each reporting set of books associated with the parent record on PJC_PRJ_ASSET_LNS_ALL. pjo_plan_line_details pjo_plan_lines pjo_planning_elements pjo_plan_versions_b. expenditure_item_id. ind_rate_sch_revision_idbre. Oracle Fusion Query For Join Between Project, Project Cost Distribution And Gl Code Combination (Doc ID 2856441. 2400 Clarksville Street. 1. pjc_contract_line_id CONTRACT_LINE_ID/*Added for grants uptake*/, l. 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. Yes. expenditure_item_id = cdl. In this Document. per_user_roles 3. source_line_id_3. SOURCE_LINE_ID_1:. GL_LEDGERS g, ap_invoices_all i, POZ_SUPPLIERS_V v, HR_ORGANIZATION_V o, PJF_EXPEND_TYP_SYS_LINKS es, PJF_EXP_TYPES_B et , PJF_TASKS_V t,. F81674-01. 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,. PROFILE OPTION NAME. The code you enter must be ITEM, TAX, MISCELLANEOUS, or FREIGHT. PA_DRAFT_REVENUES_ALL. I see cost distributions and expenditures on a project from AP but when mapping the cost distribution back to the. expenditure_item_id AND expenditureitempeo. 6 Most Important Tables Used By pa-sla-gl link query. 4. ae_line_num, xda2. dist_base_quantity dist_base_quantity, l. Raw cost = (quantity * cost rate) This value should alwa. item_description. Paris Junior College is accredited by the Southern Association of. Summary: Get all project costs Rest api not returning any values We are using below rest API to get all project cost details. req_line. transaction_id =. The room and board residence hall cost for academic year 2023-2024 are:. 18. As every AP invoice Line can be made of multiple PO. , rd. approved_flag. 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. denom_burdened_cost AS amount. " RAW_COST_DR_CCID" and. DENOM_BURDENED_COST NUMBER Total burdened cost of the expenditure item in transacti. name; award_distribution_line_id. dist_denom_burdened_cost dist_denom_burdened_cost, l. Tables and Views for Project Management. This information will be interfaced to Oracle General Ledger from Oracle Projects. 23C. Through testing we decided we just need one by expend…Subject: SQL query to get the Project Details, Contract Details, Invoice Details--SQL Query:--SELECT. release_revision. Also, the tables with PJF prefix w. approved_date. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. pjc_capitalizable. Schema: FUSION. Examples of when your Oracle Payables application automatically creates rows in this table include. 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. 72. ORDER BY D. From my research, it seems that the OTL timecard tables are HXT_TM_MTRX and HXT_TM_HEADER. Previous Next JavaScript must be enabled to correctly display this content . 03 USD we need to make the cost line non billable. Item Costs CAC Intercompany Relationship Setup CAC Intercompany SO Price List CAC Intercompany SO Price List vs. CONTRACT_LINE_ID:. meaning. FROM. 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. How can i join CE_EXTERNAL_TRANSACTIONS into GL_JE_LINES? I need external transactions accounting period and its account status. 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. I checked for this table PJC_COST_DIST_LINES_ALL and found these columns. 7. WHERE ccdl_orig. WHERE ei. FROM pjc_cost_dist_lines_all pcdl, pjf_projects_b_v pp, pjf_project_types_b_v ppt, pjf_proj_elements_b_v pt, pjc_exp_items_all pei, pjf_exp_types_b_v pet, pjf_exp_categories_b_v pec, pjc_cint_rate_names pcrn, pjc_cint_rate_info_all pcri, gl_period_statuses gps, pjf_bu_impl_v imp. 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. source_header_id_1. Indicates whether invoice line is enabled for landed cost management. line_type in ('R', 'B') AND pcdl. COST_CENTER_SEGMENT. 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. pjc_task_id. FROM pjc_cc_dist_lines_all ccdl, pjc_cc_dist_lines_all ccdl_orig , XLA_EVENTS_GT imp. CAC ICP PII Material Account Detail CAC ICP PII Material Account Summary CAC ICP PII WIP Material Usage Variance CAC ICP PII WIP Pending Cost Adjustment CAC ICP PII vs. Cost organization of the transaction for which the distribution is created. This number is incremented every time that the row is updated. DENOM_CURRENCY_CODE. Oklahoma residents are charged out-of-district, not out-of-state tuition at PJC. You can optionally redirect only certain. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. transaction_id =. PJC_CC_DIST_LINES_N1: Non Unique: Default: PROJECT_ID, TASK_ID: PJC_CC_DIST_LINES_N2:. Assignment ID related to the assignment record for this labor cost. **. 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. ind_rate_sch_revision_id = irsr. AND imp. prvdr_gl_period_name gl_period, trx_org. PA_COST_DIST_OVERRIDES stores configurations defined at the project level that redirect specific costs and revenue to another organization. CONTRACT_ID: NUMBER: 18: Identifier of the contract for which the rate override is defined. Name of the pay element. Used as a predefined finder to search the collection. Supplier invoice expenditure items do not have a value for column SYSTEM_REFERENCE5 in table PA_COST_DISTRIBUTION_LINES_ALL which is supposed to have INVOICE_DISTRIBUTION_ID for Oracle Payables transactions. PA_MC_COST_DIST_LINES_ALL is an MRC sub table of PA_COST_DISTRIBUTION_LINES_ALL. Paris, Texas 75460. InvoicesThey can be found in MetaLink, Knowledge, (scroll down left navigator) Online Documentation, last item. Index Uniqueness Tablespace Columns; PJF_RATE_OVERRIDES_N1: Non Unique: Default:. 8. For external third party import, this flag should be populated while interfacing the data into PATI. Oracle Project Contracts Module Profile Options: PROFILE OPTION SHORT CODE. But keep an eye on column quantity_invoiced. For external third party import, this flag should be populated while interfacing the data into PATI. source_attribute1. Each of these initial records. Fixed date to find the effective rate of the bill rate or burden schedule when determining the transfer price for labor transactions. Currently I am using pjc_cost_dist_lines_all table in my query to derive cost transactions data. PA tables in fusion - Read online for free. award_distribution_id. ACCOUNTING_DEFINITION_ID: NUMBER: 18: Yes: Reference to the cost accounting definition line. Distribution identifier of the burden cost. pjc_task_id. ind_rate_sch_revision_id It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. source_id_int_1 = ccdl. I am not even sure if that is the right. 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. expenditure_type_id = pet. 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. 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. CST_COST_DIST_LINES_I_GT. PJC_FUNDING_ALLOCATION_ID FUNDING_ALLOCATION_ID/*Added for grants uptake*/, POD. attribute6. Applies to:. source_line_id_1. release_number. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. Tables and Views for Financials. SOURCE_LINE_ID_2:. Tags: PA. I then take the. When you select a Distribution Set for an invoice, your Oracle Payables application uses this information to create invoice distribution. approved_flag. Oracle Fusion Project Costing Cloud Service - Version 11. PJC_CC_DIST_LINES_ALL. WHERE ics. For this request we need. Learn how to use a query in Oracle Fusion to find project estimation to complete based on budgeted and actual costs, hours, and revenue. The borrowed and lent revenue distribution lines are. 1. GL_LEDGERS g, ap_invoices_all i, POZ_SUPPLIERS_V v, HR_ORGANIZATION_V o, PJF_EXPEND_TYP_SYS_LINKS es, PJF_EXP_TYPES_B et , PJF_TASKS_V t,. PA_MC_COST_DIST_LINES_ALL. Paris Junior College 2400 Clarksville St. source_line_id_2PJC_PRJ_ASSET_LNS_ALL. CMT_NUMBER. source_line_id_2. r. Views are logical representations of a single or combination of tables. ACCOUNTING_DEFINITION_ID: NUMBER: 18: Yes: Reference to the cost accounting definition line. expenditure_item_id = expenditureitempeo. id) Actual_Rev_ITD_Prj_Curr ,(SELECT NVL (SUM (projectcostdistributionpeo. event_type_code, 'retro. AP_INVOICE_DISTRIBUTIONS. INVENTORY_ORG_ID: NUMBER: 18: Indicates The Inventory Org To Which The Item Belongs. EBS Tables —————————————– FUSION Tables PA_COST_DISTRIBUTION_LINES_ALL stores information about the cost distribution of expenditure items. Add to Compare. pjc_cost_dist_lines_all: pjf_rate_overrides: RATE_OVERRIDE_ID: Indexes. Default. 9. Goal. We would like to show you a description here but the site won’t allow us. Title and Copyright Information; Get Help; 1 Overview. Accounting data generated and stored in “Accounting Events” tables prior to transfer to GL. creation_date. The issue can be reproduced at will with the following steps: 1. 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. FROM pjc_cc_dist_lines_all ccdl, pjc_cc_dist_lines_all ccdl_orig , XLA_EVENTS_GT imp. 13. So we can say that this table AP_INVOICE_DISTRIBUTIONS_ALL plays a critical role in P2P Cycle in Oracle. operating_unit_name, a. In this Document. An invoice can have multiple distributions.