My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts. expenditure_item_id. pjc_capitalizable. A Junior College Owned & Operated By. WHERE ccdl_orig. Goal. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. rounding_class_code = 'RAW_COST_CLEARING' AND NOT EXISTS ( SELECT 1 FROM xla_distribution_links xda1 WHERE xda1. Cloud Applications. 1. Title and Copyright Information; Get Help; 1 Overview 2 Asset TrackingTo see a listing of courses offered, click the “Course Search” link below. Ananth. 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. 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,. This column contains the vlaues to identify if current transaction is from internal source or external source. ra_customer_trx_lines_all. You need one row for each distribution line you attach to a purchase order shipment. 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. 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. expenditure_item_id, cdl_line_num, prvdr_gl_date, project_raw_costSELECT x. per_users 2. (ORA_PJC_PROJECT_COST_ADJUSTMENTS_WITH_APPROVAL_DUTY)* NOTE: Both the seeded Project Accountant and Grants Accountant job roles have this duty assigned. … 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. For indirect projects this flag is set. For indirect projects this flag is set. source_attribute2DISTRIBUTE_PATTERN_SET_ID, DISTRIBUTION_SET_PRECEDENCE, DISTRIBUTE_PATTERN_RULE_ID, DISTRIBUTE_RULE_SET_NUMBER. 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. ae_header_id = ael1. Summary: We have a requirement to create a report/integration listing Expenditure / Costing information along with Billing information. Indicates the code used to derive default rate dates. current_run_id extn_current_run_id, bre. 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. 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. 7661 • Admissions: 903. pjc_capitalizable. VARCHAR2. To override the cost center in the account, enter a value. ACCOUNTING_STATUS_CODE . FROM pjc_cost_dist_lines_all projectcostdistributionpeo, pjc_exp_items_all expenditureitempeo, pjf_exp_types_vl pet WHERE ( projectcostdistributionpeo. 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. AND imp. attribute2. ei_project_name, x. 03 USD we need to make the cost line non billable. PA_CUST_REV_DIST_LINES_ALL. AND imp. Index. Paris Junior College is accredited by the Southern Association of. An invoice can have multiple distributions. This flag determines if Cross Charge processing is allowed or not. 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. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. Paris, Texas 75460 Tel: (903) 785-7661 Contact Us. 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. 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. Oracle Fusion Cloud Project Management. Oracle Apps R12 Sub ledger Accounting Tables and joins XLA Table joins GL_JE. source_line_id_5name; req_number. Burdened cost = (raw cost * (1 + burden cost multiplier) equal the sum of the items burden debit cost distributio. Goal. 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. Adding those ought to give "20", but the UNION will eliminate one of the "10"s and the answer will be "10" instead of. ae_line_num AND aeh1. 0425. FROM pjc_cost_dist_lines_all projectcostdistributionpeo, pjc_exp_items_all expenditureitempeo, pjf_exp_types_vl pet WHERE (projectcostdistributionpeo. 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. Paris, Texas 75460. The line"s current cost amount in the reporting currency; split lines have a current cost <> original cost:. start_date_active. Default flag for items charged to the task that indicates if the item can accrue revenue (Y or N). event_id = ccdl. lookup_code. 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. AP_Invoices_All has the unique key on invoice_id. expenditure_item_id AND expenditureitempeo. recalculate the revenue for an expenditure item. project_status, a. xcc_data_set_id data_set_id, to_char(cre. It stores currency related information about cost distribution lines for each reporting set of books associated with the parent record on PA_COST_DISTRIBUTION_LINES_ALL. Jpellman . ae_header_id AND lnk1. We would like to show you a description here but the site won’t allow us. Purpose of this report is to display Project billable hours for Internal ===== /* Formatted on 2018/07/30 15:40 (Formatter Plus v4. This is the transportation cost for transfer. The code you enter must be ITEM, TAX, MISCELLANEOUS, or FREIGHT. name AS Ledger_name, GJS. Item Cost Comparison CAC Intercompany SO Shipping. SELECT pcdl. 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. Contents. Inventory Transactions subject area with 1 base metric. 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. End date of the payroll period. Please guide how to get the mentioned details with the current setup?There's nothing to suggest (in the question or in accounting principles) that negative amounts are forbidden. ACCT_CURRENCY_CODE. 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. Oracle Fusion ERP Analytics. PJC_MC_PRJ_AST_LINES_ALL is an MRC sub table of PJC_PRJ_ASSET_LNS_ALL. Previous Page. expenditure_item_id = expenditureitempeo. PA_MC_COST_DIST_LINES_ALL. For capital projects this flag is used as capitalizable_flag. 6. CANCELLATION_FLAG: VARCHAR2: 1: A value of Y indicates that the distribution line has been created during the Invoice Cancel. This table stores exceptions encountered during burden cost generation, planning resource breakdown structure element mapping for raw cost and burden cost, or burden cost account generation. ei_project_numbe. v515220161. In this Document. Anyway, if sum (amt) for credits is "10" and sum (amt) for debits is "-10", then -sum (amt) for debits will be "10". pjc_contract_line_id CONTRACT_LINE_ID/*Added for grants uptake*/, l. expenditure_item_id. 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. ref_ae_line_num = xda2. Processing Start Date, calculated as the maximum award, project, task, assignment, or labor schedule start date. ae_line_num, xda2. Name of the pay element. Possible values are 'INT' , 'EXT'. ind_rate_sch_revision_idbre. 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. project_number, a. PJC_COST_DIST_LINES_ALL_N1: Non Unique: Default: PROJECT_ID: PJC_COST_DIST_LINES_ALL_N10: Non. INVOICE_LINE_NUMBER: NUMBER: Invoice line number for parent line:. CST_COST_DIST_LINES_I_GT. Determines the classification of the cross charge amount "Cost","Revenue" OBJECT_VERSION_NUMBER: NUMBER: 9: Yes:. 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. Without value the data in Project Accounting cannot be linked to Accounts Payable transactions. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. 0. cc_dist_line_id(+) = ccdl. dist_line_id_reversed. event_id = ccdl. 01. You can optionally redirect only certain. creation_date. tag. Loading. acct_event_id. The Paris Junior College District. SELECT FROM PJF_PROJECTS_ALL_B WHERE SEGMENT1='proj_nr'; -- note the project_id; 2. Use it if possible to enhance the performance. end_date_active. if you are looking to connect the AP invoice to any entity like PO/ Project etc, most probably this is your table like you can use PO_DISTRIBUTION_ID to. Examples of when your Oracle Payables application automatically creates rows in this table include. Previous Next JavaScript must be enabled to correctly display this content Tables and Views for Financials. The line"s current cost amount in the reporting currency; split lines have a current cost <> original cost:. 0 and later: Detailes About Some Errors from Table PJC_TXN_ERRORS. PJC_AWARD_DIST_LINES_U1. PA_PROJECT_ASSET_LINES_ALL stores summarized project CIP cost lines. Main: 903. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. Symptoms. Solution. We link PJC_COST_DIST_LINES_ALL table to XLA_AE_LINES table through XLA_DISTRIBUTION_LINKS table. expenditure_type_id = pet. We would like to show you a description here but the site won’t allow us. name; data_set_id. enabled_flag. source_task_id. The import process overrides the cost center with this value. description. Solution. 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. enabled_flag. INVOICE_TYPE_LOOKUP_CODE. project_organization_name, a. AND ROWNUM<=1. source_line_id_1. dist_line_id_reversed. 4 miles. The table AP_INVOICE_LINES_ALL used by Oracle Fusion to store the line level data of AP invoices. AND imp. pjc_contract_line_id CONTRACT_LINE_ID/*Added for grants uptake*/, l. Provision with single sign-on. possible vlaues I,P,R,E. 23D. pjc_txn_xface_all: pjf_work_types_b: WORK_TYPE_ID: pjc_cost_dist_lines_all: pjf_work_types_b: WORK_TYPE_ID: Indexes. CONTRACT_LINE_ID:. PJC_COST_DIST_LINES_ALL_N1: Non Unique: Default: PROJECT_ID: PJC_COST_DIST_LINES_ALL_N10: Non. 0. attribute5. Tables and Views for Project Management. expenditure_type_id AND. 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. 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. WHERE ics. 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. replace the project_id. Content (required): Please help in identifying the column mapping on fusion application to get the Burdened cost in Receiver Ledger Currency. agreement_type, a. 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. project_id = ppa. *****. Also, the tables with PJF prefix w. pjc_expenditure_type_id. prvdr_gl_period_name gl_period, trx_org. ae_header_id FROM xla_distribution_links xda2 WHERE xda2. 782. (2023) Abby Cater scored 20 points, including 14 of 17 from the free throw line, to lead. F85651-01. OKE: Debug Mode. EBS Tables —————————————– FUSION Tables PA_COST_DISTRIBUTION_LINES_ALL stores information about the cost distribution of expenditure items. Advising and Counseling. trunc(cdl. ae_header_id FROM xla_distribution_links xda2 WHERE xda2. This input is required to create reports, understand links between various charts, and even for troubleshooting purpose. project_id = ppa. Cost distribution lines amount are implicitly debit amounts. 1. Item Costs CAC Intercompany Relationship Setup CAC Intercompany SO Price List CAC Intercompany SO Price List vs. 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. meaning. PA. 2. COST_BOOK_ID: NUMBER: 18: Yes: Cost book within the cost organization for which the distribution is created. 3. PJC_CC_DIST_LINES_ALL. COST MANAGEMENT AND CONTROL. Report Description: Packing Slip report prints all the shipment information, usually packing slip. Yes. Applies to:. Summary: Get all project costs Rest api not returning any values We are using below rest API to get all project cost details. PJC_PRJ_ASSET_LNS_ALL. PA_CUST_REV_DIST_LINES_ALL is referenced by following: APPSPiper Sandler Companies Reports Third Quarter 2023 Results; Declares Quarterly Dividend of $0. I am not even sure if that is the right. Description. source_line_id_3. . 2. PJC: Oracle Fusion Project Cost Account Reconciliation Report (Doc ID 2121913. **. April 17 edited April 17. PROJECT_ID. FROM. Paris Junior College 2400 Clarksville St. r_company, x. ,d. pjc_cost_dist_lines_all Tables to get Project Plan and its Budget Amount. 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. award_distribution_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,. NUMBER. contract_line_id = OKCL. PA tables in fusion - Read online for free. source_id_int_1 = ccdl. ref_ae_header_id =. GL_CODE_COMBINATIONS contains valid account combinations for each accounting flexfield structure within the Oracle Fusion General Ledger application. ref_ae_line_num IS NULL AND xda2. CMT_NUMBER. source_attribute1. WHERE ccdl_orig. select a. name; po_number. 1. F81674-01. ← Configurator Concurrent Programs. SELECT revenue_type, TO_CHAR (customer_id) customer_id, customer_name, TO_CHAR (project_id) project_id, project_number, contract_number,. transaction_id =. 23C. PJC_CONTRACT_LINE_ID: NUMBER: 18: Tracks contract line information. Oracle Project Contracts Module Profile Options: PROFILE OPTION SHORT CODE. PJC: Add Project Validations Using Cost Collection Descriptive Flexfields In Invoice Page (Doc ID 2417605. transaction_number. ind_rate_sch_revision_id = irsr. xla_ae_lines xal, pjc_exp_items_all peiThis table contains non-persistent data and is used to expose summary data to Essbase. Summer Long - $1,800. 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. actual_amount, 0)) - SUM(nvl(main. 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. 2) Run “Create Accounting” to populate accounting events (SLA) tables. pjc_contract_line_id contract_line_id/*added for grants uptake*/ from. ,d. xla_ae_headers. DENORM_WBS_LEVEL. 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. 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. release_number. 10. 6 Most Important Tables Used By pa-sla-gl link query. 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. 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). ACCT_CURRENCY_CODE. 2. 1. WITH gl_cmn_tbls. This value for the project is a default for the task fixed date. Public. 2400 Clarksville Street. OKE_DEBUG_FILE_DIR. Oracle Fusion Project Costing Cloud Service - Version 11. pjc_expenditure_item_date. WHERE D. Summary: We have a requirement from client when we import AP invoices to projects for which line amount is less than 0. Index Uniqueness Tablespace Columns Status; PJF_PERIODS_ALL_N1: Non Unique: FUSION_TS_TX_DATA: STATUS,. ae_line_num, xda2. 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. Burdenable Raw Cost: ACCOUNTING_EVENT_ID: NUMBER: 18:. CONTRACT_ID: NUMBER: 18: Identifier of the contract for which the rate override is defined. The code you enter must be ITEM, TAX, MISCELLANEOUS, or FREIGHT. Required fields are marked. ae_header_id = ael1. attribute3. Piper Sandler Completes 46th Semi-Annual Generation Z Survey of 9,193 U. Distribution identifier of the burden cost. This number is incremented every time that the row is updated. prvdr_gl_date. Refer to comments on the columns in the main 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. AS (SELECT DISTINCT GL. 9. SELECT * FROM PJC_COST_DIST_LINES_ALL D,. per_roles_dn 4. AP_DISTRIBUTION_SET_LINES_ALL contains detailed information about individual distribution lines you define for a Distribution Set. dist_line_id_reversed. 1) Last updated on MAY 27, 2022 Applies to: Oracle Fusion Project Costing Cloud Service - Version 11. We want to derive the Accounting Code Combination based on Expenditure Types. The borrowed and lent revenue distribution lines are. FROM pjc_cc_dist_lines_all ccdl, pjc_cc_dist_lines_all ccdl_orig , XLA_EVENTS_GT imp. PA. Unique. source_id_int_1 = ccdl. dist_base_amount dist_base_amount, l. Collin County Community College District. attribute6. pjc_cost_dist_lines_all: pjf_rate_overrides: RATE_OVERRIDE_ID: Indexes. COST_ID: NUMBER: 18: Yes: Reference to the layer, write-off or transfer. acct_event_id. CONTRACT_LINE_ID:. pjc_contract_line_id CONTRACT_LINE_ID/*Added for grants uptake*/, l. award_distribution_status. We would like to show you a description here but the site won’t allow us. There is one row for each invoice distribution. expenditure_item_date expenditure_item_date2. 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. projfunc_cost_exchange_rate src_projfunc_cost_xchng_rate, bre. display_sequencePurpose of this report is to derive all projects expenditure and event details with cost information. 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,. start_date_active. pjc_task_id. PJC: Add Project Validations Using Cost Collection Descriptive Flexfields In Invoice Page (Doc ID 2417605. ,d. Object type: TABLE. , rd. PJB_INV_CONFIG_DISTS_GT_U1. COST_BOOK_ID: NUMBER: 18: Cost book within the cost organization for which the distribution is created. Tables and Views for Financials. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. cc_dist_line_id(+) = ccdl. 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. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. expenditure_type_id = pet. . It cc_process_labor_flag is set t. 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. It cc_process_labor_flag is set t. task_id. quantity), 0) FROM pjc_cost_dist_lines_all. FROM. AND imp. Enter the lookup code for the type of invoice distribution that you want Payables Open Interface Import to create from this record. event_id = ccdl. 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. I checked for this table PJC_COST_DIST_LINES_ALL and found these columns. 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. CDL_LINE_NUM: NUMBER: 18: Line Number of the Cost Distribution Line. 2. 1) Last updated on NOVEMBER 08, 2022. Active. When an asset line is initially created, this table contains one record for each cost distribution line summarized into the asset line. r. I see cost distributions and expenditures on a project from AP but when mapping the cost distribution back to the. There can be only one record for the combination of Supplier and the invoice number. FROM pjc_cc_dist_lines_all ccdl, pjc_cc_dist_lines_all ccdl_orig , XLA_EVENTS_GT imp. operating_unit_name, a. cc_dist_line_id(+) = ccdl. 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. 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. name; pjc_context_category. PA_DRAFT_REVENUES_ALL. September 25 / READ.