per_user_roles 3. The identifier of the top task to which this tasks rolls up. pjc_contract_line_id CONTRACT_LINE_ID/*Added for grants uptake*/, l. F81674-01. 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. 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. Refer to comments on the columns in the main table. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. PJC_CONTRACT_LINE_ID CONTRACT_LINE_ID/*Added for grants uptake*/ FROM. accounting_event_id) source_header_id_1, ' ' source_header_id_2, decode(cre. 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 thereby the source expenditure. 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,. pjc_txn_xface_all: pjf_work_types_b: WORK_TYPE_ID: pjc_cost_dist_lines_all: pjf_work_types_b: WORK_TYPE_ID: Indexes. 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. The subledger journal entry is valid, but one or more of the other subledger journal entries associated with the same accounting event are invalid. 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. This column contains the identifier of. Review the cost in the Project UI, it is not getting transferred to the Project. VARCHAR2. Fusion User Roles SQL Query & Tables. AP_INVOICE_DISTRIBUTIONS. CST_COST_DIST_LINES_I_GT. AND imp. Keyword Analysis & Research: pjc_cost_dist_lines_all in oracle fusionMetrics added for data validation. EVENT_ID: NUMBER: 18: Reference to the event created in the SLA for this distribution header line. Supply Chain Management. EBS Tables. ind_rate_sch_revision_id bre. 1 Overview Project Portfolio Management Tables and Views 2 Grants Management Tables Views 3 Project Billing Tables Views 4 Project Collaboration Tables 5 Project Control. PJB_INV_CONFIG_DISTS_GT_U1. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. expenditure_item_id = expenditureitempeo. project_name,We have a query that extracts records from PJC_COST_DIST_LINES_ALL. VARCHAR2. Object type: TABLE. validation_status_code validation_status_code,. need_by_date. B. 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. PROJECT_ID =P. Person ID related to the person record for this labor cost. When an asset line is initially created, this table contains one record for each cost distribution line summarized into the asset line. Describes tables and views for Oracle Fusion Cloud Project Management. expenditure_item_id AND expenditureitempeo. source_line_id_1. source_line_id_2. PA_COST_DIST_OVERRIDES stores configurations defined at the project level that redirect specific costs and revenue to another organization. source_line_id_2. ind_rate_sch_revision_id = irsr. 0). WHERE pcdl. sum of the items raw cost distribution lines. 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. 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. FROM pjc_exp_items_all expenditureitempeo) v457612106, pjc_cost_dist_lines_all pcdl, okc_k_headers_all_b okha, hz_cust_accounts hca, hz_parties hp, hr_all_organization_units haou,. ae_header_id = ael1. Summary: We have a requirement from client when we import AP invoices to projects for which line amount is less than 0. Approve the PO 3. See Reference for Oracle Fusion CX Analytics. PJC’s Brewer drafted by Yankees (2022) Beau Brewer of McKinney,. PROJECT_ID. These lookup codes are stored in the AP_LOOKUP_CODES table. award_distribution_batch_id. CREATION_DATE) EXP_CDL_DIST_CREATION_DATE, cdl. Examples of when your Oracle Payables application automatically creates rows in this table include. Provisioning Oracle Fusion Analytics Warehouse with single sign-on enables you to synchronize users and roles in Oracle Fusion Cloud Applications with Oracle Identity Cloud Service and then enable these users to access Oracle Fusion Analytics Warehouse. PJC: Add Project Validations Using Cost Collection Descriptive Flexfields In Invoice Page (Doc ID 2417605. You can optionally redirect only certain. BALANCING_SEGMENT. 13. pjc_expenditure_type_id. reserved_attribute1 reserved_attribute1, ei. source_line_id_1. line_type in ('R', 'B') AND pcdl. dist_acct_raw_cost dist_acct_raw_cost, l. 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. I can see that the Categories in the project show the NGN exchange rate. 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,. CREATION_DATE) EXP_CDL_DIST_CREATION_DATE, cdl. expenditure_type_id = pet. You need one row for each distribution line you attach to a purchase order shipment. tag. Default flag for items charged to the task that indicates if the item can accrue revenue (Y or N). For capital projects this flag is used as capitalizable_flag. WHERE ics. COST MANAGEMENT AND CONTROL. However, the IDs in PJC_EXP_ITEMS_ALL columns don't match any IDs in the HXT tables. Tables and Views for Financials. SELECT pcdl. 12. This number is incremented every time that the row is updated. 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. It cc_process_labor_flag is set t. This number is incremented every time that the row is updated. expenditure_item_id = pei. 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. April 17 edited April 17. Oracle Fusion Cloud Financials. WITH gl_cmn_tbls. XLA_DISTRIBUTION_LINKS XDA, xla_ae_lines xal, hr_all_organization_units_tl trx_org, per_all_people_f_v papf, per_person_names_f ppn WHERE pcdl. release_number. . DENORM_TOP_ELEMENT_ID. replace the project_id. LINE_TYPE_. INV_CONFIG_DIST_ID. expenditure_item_id = expenditureitempeo. Create PO with line type = Fixed Price Service and 2 ways match. 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. Uniqueness. Previous Page. 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. We originally had our PRBS by Expenditure Category and Type. Oracle Fusion Project Costing Cloud Service - Version 11. Solution. Use it if possible to enhance the performance. name; lookup_type. Goal. pa_date. project_unit, main. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. Summer Long - $1,800. WHERE D. expenditure_item_id, cdl_line_num, prvdr_gl_date, project_raw_costSELECT x. LINE_TYPE_. SELECT * FROM PJC_COST_DIST_LINES_ALL D, PJF_PROJECTS_ALL_B P. 10. lookup_code. March 5, 2010 in Oracle Projects Contracts. A Junior College Owned & Operated By. ACCT_CURRENCY_CODE. 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. PA_BILL_RATES_ALL ; Information about bill rates and markups of standard bill rate schedules; PA_BILLING_ASSIGNMENTS_ALL ; Assignments of billing extensions to a project type, project, or task; PA_COST_DISTRIBUTION_LINES_ALL ; Information about expenditure item cost distribution;. prvdr_gl_period_name gl_period, trx_org. 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. Posts about Project Cost written by Pulkit jain. Enter the lookup code for the type of invoice distribution that you want Payables Open Interface Import to create from this record. meaning. 13. 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. 0 and later. meaning. Project Portfolio. 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_cost_dist_lines_all pcdl, pjc_exp_items_all pei, pjf_tasks_v ptv, pjf_projects_all_b prb, pjf_projects_all_tl prl,. I checked for this table PJC_COST_DIST_LINES_ALL and found these columns. ind_rate_sch_revision_id = irsr. OKE_DEBUG_FILE_DIR. AP_INVOICE_DISTRIBUTIONS_ALL can also be used to find the connectivity between AP invoice & PO or AP invoices & Project. 21. 1. We would like to show you a description here but the site won’t allow us. 1. An invoice / invoice line can have. source_pa_period_name. v515220161. My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts. 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. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. Determines the classification of the cross charge amount "Cost","Revenue" OBJECT_VERSION_NUMBER: NUMBER: 9: Yes: Used to implement optimistic locking. 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,. attribute3. This input is required to create reports, understand links between various charts, and even for troubleshooting purpose. Goal. F81674-01. PJC : Cost shows in wrong currency Posted By months ago Hi, I have setup a project for Nigeria currency NGN. project_status, a. Teens. 1) All accounting performed before transfer to the GL. PA_PROJECT_ASSET_LINES_ALL stores summarized project CIP cost lines. FROM pjc_exp_items_all pei, pjf_projects_all_vl ppa, pjb_bill_trxs pbt, pjb_inv_line_dists pild, pjb_invoice_lines pil, pjb_invoice_headers pih, per_all_people_f ppf, per_person_names_f ppn, pjf_tasks_v pt, pjf_exp_types_vl pet, pjc_exp_comments pec WHERE 1 = 1 AND pei. SELECT FROM PJF_PROJECTS_ALL_B WHERE SEGMENT1='proj_nr'; -- note the project_id; 2. Office & Switchboard Hours (all locations) Monday - Friday: 8AM - 5PM Greenville Center Tel: (903) 454-9333 Sulphur Springs Center Tel: (903) 885-1232 Help & Support. 2. User-defined number that uniquely identifies the element within a project or structure. inventory_item_id,i. project_organization_name, a. ae_line_num AND xda1. Home / Fusion / Query to Find NonBillable Expense in Oracle Fusion. 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. name; award_distribution_line_id. S. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. l. We want to derive the Accounting Code Combination based on Expenditure Types. So we can say that this table AP_INVOICE_DISTRIBUTIONS_ALL plays a critical role in P2P Cycle in Oracle. WHERE ics. pjc_expenditure_type_id. Oracle Fusion ERP Analytics. vendor_name. document_type. My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts. 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. t costs are also not populated. cc_dist_line_id(+) = ccdl. In PJC_EXP_ITEMS_ALL are the columns ORIGINAL_HEADER_ID, ORIGINAL_LINE_NUMBER, ORIGINAL_DIST_ID. PJC_AWARD_DIST_LINES_U1. A distribution must be associated with an invoice and invoice line. 0 and later: Detailes About Some Errors from Table PJC_TXN_ERRORS. For external Oracle Import, this flag is derived from the setup data atProject, Task and Document Entry level. Oracle Fusion Cloud Project Management. Active. 0425. The line"s current cost amount in the reporting currency; split lines have a current cost <> original cost:. Supplier invoice expenditure items do not have a value for column SYSTEM_REFERENCE5 in table PA_COST_DISTRIBUTION_LINES_ALL which is. quantity), 0) FROM pjc_cost_dist_lines_all. dist_line_id_reversed. BILLABLE_FLAG. 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. pjc_billable_flag. FROM pjc_cost_dist_lines_all projectcostdistributionpeo, pjc_exp_items_all expenditureitempeo, pjf_exp_types_vl pet. T. Examples of when your Oracle Payables application automatically creates rows in this table include. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. Person ID related to the person record for this labor cost. Major release with updates for Fusion ERP Analytics, Fusion HCM Analytics, Fusion SCM Analytics, and Fusion CX Analytics. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. 1) Last updated on FEBRUARY 21, 2021. COST_CENTER_SEGMENT. , POD. SOURCE_LINE_ID_1:. acct_event_id. NUMBER. transaction_id =. expenditure_item_idIt is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. Applies to: Oracle Fusion Project Costing - Version 11. EBS Tables —————————————– FUSION Tables PA_COST_DISTRIBUTION_LINES_ALL stores information about the cost distribution of expenditure items. ra_customer_trx_lines_all. There is one row for each invoice distribution. dist_line_id_reversed. id) Actual_Rev_ITD_Prj_Curr ,(SELECT NVL (SUM (projectcostdistributionpeo. current_run_id extn_current_run_id, bre. Tables and Views for Project Management. Index Uniqueness Tablespace Columns Status; PJF_PERIODS_ALL_N1: Non Unique: FUSION_TS_TX_DATA: STATUS,. per_roles_dn_tl Detail SQL Query to. approved_flag. 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. 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. C for cost rate override and B for bill rate override. A subledger journal entry can have a status of Draft, Final, Incomplete, Invalid or Invalid Related Entry. 1. From my research, it seems that the OTL. 2) Run “Create Accounting” to populate accounting events (SLA) tables. Contents. 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. operating_unit_name, a. 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 Fusion Query For Join Between Project, Project Cost Distribution And Gl Code Combination (Doc ID 2856441. The cost distrulibution table for the ccid fields are null. Table Foreign Table Foreign Key Column; PJF_PERIODS_ALL: pjf_bu_impl_all: ORG_ID: pjc_cost_dist_lines_all: pjf_periods_all: PRVDR_PA_PERIOD_NAME, ORG_ID: pjc_cost_dist_lines_all It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. Default flag for items charged to the task that indicates if the item can accrue revenue (Y or N). For external Oracle Import, this flag is derived from the setup data atProject, Task and Document Entry level. Then XLA_AE_LINES link to XLA_AE_HEADER where we can see. Content (required): The values in this field are RPBNN. Column NameFlag that indicates if project related invoice distributions have been interfaced into Oracle Projects as committed cost. OLD_DIST_LINE_NUMBER: NUMBER: 18: Old invoice distribution line number. When you select a Distribution Set for an invoice, your Oracle Payables application uses this information to create invoice distribution. 6 Most Important Tables Used By pa-sla-gl link query. Paris, Texas 75460. (ORA_PJC_PROJECT_COST_ADJUSTMENTS_WITH_APPROVAL_DUTY)* NOTE: Both the seeded Project Accountant and Grants Accountant job roles have this duty assigned. WHERE ccdl_orig. PA_BILL_RATES_ALL: Information about bill rates and markups of standard bill rate schedules PA_BILLING_ASSIGNMENTS_ALL: Assignments of billing extensions to a project type, project, or task PA_COST_DISTRIBUTION_LINES_ALL: Information about expenditure item cost distribution PA_CUST_REV_DIST_LINES_ALL: Information. End date of the payroll period. cc_dist_line_id(+) = ccdl. Paris, Texas 75460 Tel: (903) 785-7661 Contact Us. task_id. The Paris Junior College District. PJC_CC_DIST_LINES_ALL. This input is required to create reports, understand links between various charts, and even for troubleshooting purpose. identified with the function code of LRL and LRB for labor items. cc_dist_line_id(+) = ccdl. 1) Last updated on MAY 27, 2022 Applies. F85651-01. Applies to: Oracle Fusion Project. PA_COST_DIST_OVERRIDES stores configurations defined at the project level that redirect specific costs and revenue to another organization. pjc_task_id. David. expenditure_item_date expenditure_item_date2. Pa_MC_Cost_Dist_Lines_ar is a table for Archive/Purge. ,d. 10. 6. name AS Ledger_name, GJS. WHERE ccdl_orig. ei_latest_gl_period_name, x. An invoice can have one or more invoice lines. project_id = ppa. contract_line_id = OKCL. WHERE ccdl_orig. data_set_id data_set_id, ei. Used when Oracle Contract Billing or Oracle Grants Accounting is installed. name; pjc_context_category. 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. pjc_expenditure_item_date. But i cant find any type join. vendor_id. CONTRACT_ID: NUMBER: 18: Identifier of the contract for which the rate override is defined. 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 23 views 3 comments 0 points Most recent by Pradeep Balakrishnan Sep 28, 2023 7:04AMname; data_set_id. The import process overrides the cost center with this value. 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. Founded In 1924. start_date_active. If the task is a top task, the top_task_id is set to its own task_id. CREATED_BY EXP_CDL_DIST_CREATED_BY, trunc(cdl. PA_CC_DIST_LINES_ALL stores information about the accounting distributions related to transfer price for cross charged expenditure items. 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. The identifier of the top task to which this tasks rolls up. AP_Invoices_All has the unique key on invoice_id. Hello All, > Oracle BI Publisher I have creating report using Oracle BI Publisher. ExpenditureItemId; integer; Identifier of the project cost. The primary key on this table is:. source_line_id_3. Meeting support account set certain item flexfield attribute you enter the combination of the overflow. display_sequencePurpose of this report is to derive all projects expenditure and event details with cost information. source_id_int_1 = ccdl. This flag determines if Cross Charge processing is allowed or not. PA tables in fusion - Read online for free. in pjc_exp_items_all are the columns original_header_id, original_line_number, original_dist_id. Cost distribution. event_id = ccdl. XLA_AE_LINES, XLA_AE_HEADERS, AP_INVOICES_ALL, AP_SUPPLIERS, GL_CODE_COMBINATIONS. This table corresponds to the Invoice distributions window of Invoice workbench. WHERE ics. items. expenditure_type_id = pet. AND PRD. CMT_NUMBER. COST_ID: NUMBER: 18: Yes: Reference to the layer, write-off or transfer. AND imp. source_id_int_1 = ccdl. 0 and later: How does one purge the data from the Project Costing Interface table:. 2021-2022 Catalog. 1. ref_ae_line_num = xda2. A distribution must be associated with an invoice. The Transaction Costing process picks up inventory transactions from the TRANSACTION_INV record and calculates the costs of each transaction, including, material, conversion, conversion overhead, landed, inbound, outbound, and other costs. FROM. This release works with any of the currently supported Oracle Fusion Cloud Applications versions and the minimum Oracle Fusion Cloud Applications version is 23A (11. 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. acct_event_id. Previous Next JavaScript must be enabled to correctly display this content . enabled_flag. ei_project_numbe. 01. 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,. Unique. dist_base_quantity dist_base_quantity, l. Goal. dist_line_id_reversed. This parameter restricts the number of resources returned. 8) */CONNECTOR FIVETRAN_SCHEMA_NAME FIVETRAN_TABLE_NAME SOURCE_DATABASE_TABLE_MAPPING Oracle Fusion FSCM (ERP & SCM). PA_CUST_REV_DIST_LINES_ALL. SELECT revenue_type, TO_CHAR (customer_id) customer_id, customer_name, TO_CHAR (project_id) project_id, project_number, contract_number,. ind_rate_sch_revision_id = irsr. The output should be Prepayment. 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. AND imp. attribute7. INVOICE_TYPE_LOOKUP_CODE. AND ROWNUM<=1. We would like to show you a description here but the site won’t allow us. LAST_UPDATE_DATE). PA. pa_cust_rev_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,. expenditure_item_id = expenditureitempeo. There is one row for each invoice distribution. PA_MC_COST_DIST_LINES_ALL. FROM pjc_cc_dist_lines_all ccdl, pjc_cc_dist_lines_all ccdl_orig , XLA_EVENTS_GT imp. The table AP_INVOICE_LINES_ALL used by Oracle Fusion to store the line level data of AP invoices. ind_rate_sch_revision_id = irsr. The query uses the. Indicates the code used to derive default rate dates. ref_ae_line_num = xda2. FROM pjc_cc_dist_lines_all ccdl, pjc_cc_dist_lines_all ccdl_orig , XLA_EVENTS_GT imp. ref_ae_header_id =. Only While uploading the Accounted Project costing transactions with accounting entries, the CCID columns viz. 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. This is the transportation cost for transfer. lookup_code.