We want to derive the Accounting Code Combination based on Expenditure Types. CONTRACT_ID: NUMBER: 18: Identifier of the contract for which the rate override is defined. pjc_task_id. Paris Junior College is accredited by the Southern Association of. source_header_id_2. ever_approved_flag. PJC_MC_PRJ_AST_LINES_ALL is an MRC sub table of PJC_PRJ_ASSET_LNS_ALL. pjo_plan_line_details pjo_plan_lines pjo_planning_elements pjo_plan_versions_b. … 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. CREATION_DATE) EXP_CDL_DIST_CREATION_DATE, cdl. 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. This flag determines if Cross Charge processing is allowed or not. Description. An invoice can have multiple distributions. name; po_number. Home / Fusion / Query to Find NonBillable Expense in Oracle Fusion. Object owner: CST. cc_dist_line_id(+) = ccdl. description. source_line_id_3. 785. source_line_id_5Qn1:The customer wants to have the ability to "view accounting" for unreleased expenditure batches. ref_ae_line_num IS NULL AND xda2. An Equal Opportunity Institution. DENORM_TOP_ELEMENT_ID. COST_ID: NUMBER: 18: Yes: Reference to the layer, write-off or transfer. possible vlaues I,P,R,E. OKE: Debug Mode. An invoice can have multiple distributions. ACCT_CURRENCY_CODE. 0 and later: How does one purge the data from the Project Costing Interface table:. Cloud Applications. ref_ae_line_num = xda2. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. Indicates if the application should derive the raw cost for the project cost transaction. denom_burdened_cost AS amount. WHERE ics. Column NameFlag that indicates if project related invoice distributions have been interfaced into Oracle Projects as committed cost. PJC_COST_DIST_LINES_ALL_N1: Non Unique: Default: PROJECT_ID: PJC_COST_DIST_LINES_ALL_N10: Non. source_attribute2DISTRIBUTE_PATTERN_SET_ID, DISTRIBUTION_SET_PRECEDENCE, DISTRIBUTE_PATTERN_RULE_ID, DISTRIBUTE_RULE_SET_NUMBER. source_line_id_4. LAST_UPDATE_DATE) EXP_CDL_LAST_UPDATED_DATE, cdl. CST_COST_DIST_LINES_I_GT. Previous Page. document_type. projfunc_cost_exchange_rate src_projfunc_cost_xchng_rate, bre. Previous Next JavaScript must be enabled to correctly display this content . It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. name; data_set_id. For example, to search for online classes only, select 'Online' in. SELECT FROM PJF_PROJECTS_ALL_B WHERE SEGMENT1='proj_nr';-- note the project_id; 2. expenditure_item_id, cdl_line_num, prvdr_gl_date, project_raw_costSELECT x. 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. data_set_id data_set_id, ei. pjc_capitalizable. The query uses the. Report message to a moderator. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. Anyway, if sum (amt) for credits is "10" and sum (amt) for debits is "-10", then -sum (amt) for debits will be "10". Hi Please find the Columns and tables that we are using below SQL. AP_INVOICE_DISTRIBUTIONS. pjc_expenditure_type_id. ,d. end_date_active. Schema: FUSION. ,d. ACCOUNTING_DEFINITION_ID: NUMBER: 18: Yes: Reference to the cost accounting definition line. Oracle Application Wednesday, 28 December 2022PJC_XCC_BURDEN_DIST_ERRORS; PJC_XCC_BURDEN_DIST_ERRORS. If the task is a top task, the top_task_id is set to its own task_id. PROFILE OPTION NAME. 6. project_id AND pbt. ei_latest_gl_period_name, x. AP_DISTRIBUTION_SET_LINES_ALL contains detailed information about individual distribution lines you define for a Distribution Set. This column contains the vlaues to identify if current transaction is from internal source or external source. 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. This parameter restricts the number of resources returned. req_line. 2. Content (required):. pjc_contract_line_id CONTRACT_LINE_ID/*Added for grants uptake*/, l. expenditure_item_idWITH gl_cmn_tbls. 8. • All tables ending with the suffix _EN • All views listed in Tables Without WHO Columns. INV_TRANSFER_ORDER_PJC_V. This column contains the identifier of. The subledger journal entry is valid, but one or more of the other subledger journal entries associated with the same accounting event are invalid. PJC_CC_DIST_LINES_ALL. We originally had our PRBS by Expenditure Category and Type. ae_line_num, xda2. Item Cost Comparison CAC Intercompany SO Shipping. 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. INVOICE_TYPE_LOOKUP_CODE. 60 Per Share. expenditure_item_id. 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. They need a way to review their expenditure costs and the accounting to see how it will affect their financials before the expenditures ever gets released. source_header_id_1. Once all lines associated with a schedule are purged, the whole schedule is purged. CONTRACT_LINE_ID:. For external Oracle Import, this flag is derived from the setup data atProject, Task and Document Entry level. Object type: TABLE. . 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_item_id = expenditureitempeo. However, the IDs in PJC_EXP_ITEMS_ALL columns don't match any IDs in the HXT tables. Fusion User Roles SQL Query & Tables. item_description. CREATED_BY EXP_CDL_DIST_CREATED_BY, trunc(cdl. PJC_CC_DIST_LINES_N1: Non Unique: Default: PROJECT_ID, TASK_ID: PJC_CC_DIST_LINES_N2:. Content (required): Please help in identifying the column mapping on fusion application to get the Burdened cost in Receiver Ledger Currency. 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. Then XLA_AE_LINES link to XLA_AE_HEADER where we can see. AP_Invoices_All has the unique key on invoice_id. FROM pjc_cost_dist_lines_all projectcostdistributionpeo, pjc_exp_items_all expenditureitempeo, pjf_exp_types_vl pet WHERE ( projectcostdistributionpeo. The primary key on this table is:. ae_line_num AND xda1. Applies to: Oracle Fusion Project Costing - Version 11. project_id AND pbt. Indexes. name; lookup_type. 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. source_project_id. Oracle Fusion Cloud Project Management. source_line_id_4. Project Portfolio. End date of the payroll period. 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. HTH. 4 Important Tables of Oracle fusion user roles query 1. CDL_LINE_TYPE: VARCHAR2: 1: The type of the cost distribution line: COMP_DETAILS_ID: NUMBER: 18: Reference to Labor Rate Override. (ORA_PJC_PROJECT_COST_ADJUSTMENTS_WITH_APPROVAL_DUTY)* NOTE: Both the seeded Project Accountant and Grants Accountant job roles have this duty assigned. User-defined number that uniquely identifies the element within a project or structure. source_header_id_1. PA_DRAFT_REVENUES_ALL. sql_statement; select cre. pjc_contract_line_id CONTRACT_LINE_ID/*Added for grants uptake*/, l. Contents. 1. ei_project_numbe. To get the. ref_ae_line_num IS NULL AND xda2. 1) Last updated on MAY 27, 2022 Applies. ind_rate_sch_revision_id = irsr. 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. LINE_TYPE_. The Paris Junior College District. ORDER BY D. Adding those ought to give "20", but the UNION will eliminate one of the "10"s and the answer will be "10" instead of. 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. expenditure_item_id AND expenditureitempeo. PJC_COST_DIST_LINES_ALL_N1: Non Unique: Default: PROJECT_ID: PJC_COST_DIST_LINES_ALL_N10: Non. 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. Refer to comments on the columns in the main table. 18. source_prvdr_gl_date. display_sequencePurpose of this report is to derive all projects expenditure and event details with cost information. Unique. Cloud. PA. 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,. Solution. 2. 1) Last updated on NOVEMBER 08, 2022. acct_event_id. A distribution must be associated with an invoice. COST_BOOK_ID: NUMBER: 18: Yes: Cost book within the cost organization for which the distribution is created. trunc(cdl. PA_CUST_REV_DIST_LINES_ALL. Index. 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. 10. For external third party import, this flag should be populated while interfacing the data into PATI. 0425. FROM pjc_cc_dist_lines_all ccdl, pjc_cc_dist_lines_all ccdl_orig , XLA_EVENTS_GT imp. User-defined number that uniquely identifies the element within a project or structure. Add to Compare. But i cant find any type join. 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. PA_COST_DISTRIBUTION_LINES_ALL stores information about the cost distribution of expenditure items. PROJECT_ID. pjc_cost_dist_lines_all: pjf_rate_overrides: RATE_OVERRIDE_ID: Indexes. The line"s current cost amount in the reporting currency; split lines have a current cost <> original cost:. WHERE ccdl_orig. Processing Start Date, calculated as the maximum award, project, task, assignment, or labor schedule start date. F85651-01. The issue can be reproduced at will with the following steps: 1. PJC’s Brewer drafted by Yankees (2022) Beau Brewer of McKinney,. 7. Person ID related to the person record for this labor cost. COST_ORGANIZATION_ID: NUMBER: 18: Yes: Cost organization of the transaction for which the distribution is created. 0 and later Information in this document applies to any platform. start_date_active. 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. WHERE ics. WHERE ccdl_orig. Keyword Analysis & Research: pjc_cost_dist_lines_all in oracle fusionMetrics added for data validation. attribute2. 1. For this request we need. event_id = ccdl. Public. pjc_billable_flag. per_users 2. source_id_int_1 = ccdl. prvdr_gl_date. So we can say that this table AP_INVOICE_DISTRIBUTIONS_ALL plays a critical role in P2P Cycle in Oracle. 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. 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. FROM pjf_burden_rate_extn bre, pjc_exp_items_all ei,. An invoice / invoice line can have. INV_CONFIG_DIST_ID. cc_dist_line_id(+) = ccdl. Views are logical representations of a single or combination of tables. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. acct_event_id. PJC: Add Project Validations Using Cost Collection Descriptive Flexfields In Invoice Page (Doc ID 2417605. Also, our requirement is to open a DFF at Project Expenditure Batch Header Level, but unable to find one. Tables and Views for Project Management. approved_flag. 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. T. Please help in identifying the column mapping on fusion application to get the Burdened cost in Receiver Ledger Currency. l. PA_PROJECT_ASSET_LINES_ALL stores summarized project CIP cost lines. 1) All accounting performed before transfer to the GL. 03 USD we need to make the cost line non billable. We link PJC_COST_DIST_LINES_ALL table to XLA_AE_LINES table through XLA_DISTRIBUTION_LINKS table. Currently I am using pjc_cost_dist_lines_all table in my query to derive cost transactions data. 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,. 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. pjc_contract_line_id CONTRACT_LINE_ID/*Added for grants uptake*/, l. main. There are more that 200 records in the table "PJC_COST_DIST_LINES_ALL" Content. name; lookup_type. document_type. source_id_int_1 = ccdl. You can optionally redirect only certain. pa_cust_rev_dist_lines_all. VARCHAR2. 0. Symptoms. Provision with single sign-on. Oracle Projects Tables: PA_ACCUM_COLUMNS PA_ACCUM_COLUMN_VALUES PA_ACCUM_TXN_TIME PA_ACTION_SETS PA_ACTION_SETS_AR PA_ACTION_SET_LINES PA_ACTION_SET_LINES_AR PA. 3. project_unit, main. My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts. acct_event_id. The line"s current cost amount in the reporting currency; split lines have a current cost <> original cost:. The identifier of the top task to which this tasks rolls up. meaning. 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. COST_ID: NUMBER: 18: Reference to layer_cost_id, writeoff_cost_id,. attribute5. How much does Paris Junior College cost?. attribute4. AND imp. Determines the classification of the cross charge amount "Cost","Revenue" OBJECT_VERSION_NUMBER: NUMBER: 9: Yes: Used to implement optimistic locking. Cost distribution. 1. Raw cost = (quantity * cost rate) This value should alwa. 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. select a. 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. AP_INVOICE_LINES_ALL contains records for invoice lines entered manually, generated automatically or imported from the Open Interface. 13. PA_COST_DISTRIBUTION_LINES_ALL stores information about the cost distribution of expenditure items. Qn1:On : 11. pjc_organization_id. Teens. Piper Sandler Appoints Dustin Avey and Jeremy Gerber as Co-Heads of Public Finance. If the task is a top task, the top_task_id is set to its own task_id. But keep an eye on column quantity_invoiced. line_type in ('R', 'B') AND pcdl. Supplier invoice expenditure items do not have a value for column SYSTEM_REFERENCE5 in table PA_COST_DISTRIBUTION_LINES_ALL which is. 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. validation_status_code validation_status_code,. AND PRD. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. You can optionally redirect only certain. 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. AND imp. Fixed date to find the effective rate of the bill rate or burden schedule when determining the transfer price for labor transactions. 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_cost_distribution_lines_all. This input is required to create reports, understand links between various charts, and even for troubleshooting purpose. I can see that the Categories in the project show the NGN exchange rate. ae_header_id FROM xla_distribution_links xda2 WHERE xda2. 1. expenditure_type_id = pet. There is one row for each invoice distribution. AND imp. 72. 18. PA_COST_DIST_OVERRIDES stores configurations defined at the project level that redirect specific costs and revenue to another organization. PJC_PRJ_ASSET_LNS_ALL. approved_date. 0). AP_INVOICE_DISTRIBUTIONS_ALL can also be used to find the connectivity between AP invoice & PO or AP invoices & Project. Previous Next JavaScript must be enabled to correctly display this content Tables and Views for Financials. expenditure_item_id = cdl. vendor_name. 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. For indirect projects this flag is set. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. 1. xla_distribution_links. Subledger Accounting (SLA) in R12. There can be only one record for the combination of Supplier and the invoice number. FROM pjc_exp_items_all pei, pjf_exp_types_tl pet, pjf_projects_all_b ppa, pjf_projects_all_tl ppt, pjf_project_statuses_tl pps, pjf_proj_elements_b ppeb, pjf_proj_elements_tl ppet, pjb_bill_trxs pbt, pjb_invoice_headers pih, pjb_invoice_lines pil, pjb_inv_line_dists pild, pjb_rev_distributions prd, pjc_xla_ccdl_lines_adj_v ccdl, hr_all. pjc_project_id. COMMITMENT_TYPE. transaction_id =. 1) Last updated on NOVEMBER 08, 2022. 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. event_id = ccdl. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. calc_burden_status extn_calc_burden_status, cdl. EBS Tables. DENORM_TOP_ELEMENT_ID. Jpellman . pa_date. Without value the data in Project Accounting cannot be linked to Accounts Payable transactions. expenditure_item_id. VARCHAR2. PA_CUST_EVENT_RDL_ALL. 1) you account for borrowed and lent revenue for labor or usage. 9. 1. Oracle Fusion Project Costing Cloud Service - Version 11. VARCHAR2. 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. 2) adjusting revenue distribution lines are created when you. As every AP invoice Line can be made of multiple PO. These lookup codes are stored in the AP_LOOKUP_CODES table. PJC_AWARD_DIST_LINES_U1. The schedule must be for the organization specified in the Submit Purge window. meaning. transaction_number. 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. PA_CUST_REV_DIST_LINES_ALL is referenced by following: APPSPiper Sandler Companies Reports Third Quarter 2023 Results; Declares Quarterly Dividend of $0. 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. source_line_id_2. pjc_cost_dist_lines_all Tables to get Project Plan and its Budget Amount. AND ROWNUM<=1. 9. expenditure_item_idAP_INVOICE_DISTRIBUTIONS_ALL holds the distribution information that is manually entered or system-generated. 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,. PJC : Cost shows in wrong currency Posted By months ago Hi, I have setup a project for Nigeria currency NGN. Goal. An. xla_ae_lines. Oracle Fusion Cloud Financials. WHERE ics. project_id = ppa. pjc_billable_flag. 23C. 2. Symptoms. 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. 23D. source_line_id_1. event_id = cdl. Previous Page. 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,. AP_INVOICE_LINES_ALL_ is the audit table for AP_INVOICE_LINES_ALL. Columns. This information will be interfaced to Oracle General Ledger from Oracle Projects. requestor_person_id. 10. Destination. 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. Office & Switchboard Hours (all locations) Monday - Friday: 8AM - 5PM Greenville Center Tel: (903) 454-9333 Sulphur Springs Center Tel: (903) 885-1232 Help & Support. xla_ae_lines ael1, xla_distribution_links lnk1, gl_code_combinations gcc1 , pjc_cost_dist_lines_all pcd where lnk1. See Reference for Oracle Fusion CX Analytics. Oracle Fusion ERP Analytics. Applies to: Oracle Fusion Project Costing - Version 11. dist_line_id_reversed. expenditure_type_id = pet. AS (SELECT DISTINCT GL. projfunc_cost_exchange_rate src_projfunc_cost_xchng_rate, bre. name; award_distribution_line_id. ACCOUNTING_STATUS_CODE . Main: 903. Oracle Apps R12 Sub ledger Accounting Tables and joins XLA Table joins GL_JE. For capital projects this flag is used as capitalizable_flag. Assignment ID related to the assignment record for this labor cost.