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. 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,. 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 identifier of the top task to which this tasks rolls up. Oracle Fusion Cloud Project Management. XLA_AE_LINES, XLA_AE_HEADERS, AP_INVOICES_ALL, AP_SUPPLIERS, GL_CODE_COMBINATIONS. PA_DRAFT_REVENUES_ALL. Content (required): The values in this field are RPBNN. rounding_class_code = 'RAW_COST_CLEARING' AND NOT EXISTS ( SELECT 1 FROM xla_distribution_links xda1 WHERE xda1. Validation. Purpose of this report is to display Project billable hours for Internal ===== /* Formatted on 2018/07/30 15:40 (Formatter Plus v4. PJC_CC_DIST_LINES_ALL. 0 version, Manage Project Costs. Piper Sandler Completes 46th Semi-Annual Generation Z Survey of 9,193 U. pa_cost_distribution_lines_all. award_distribution_batch_id. release_number. lookup_code. 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. AND imp. Person ID related to the person record for this labor cost. project_number, a. WHERE D. lookup_code. PA_CUST_REV_DIST_LINES_ALL is referenced by following: APPSPiper Sandler Companies Reports Third Quarter 2023 Results; Declares Quarterly Dividend of $0. Indexes. source_line_id_2. 1) Last updated on NOVEMBER 08, 2022. 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. Cost distribution lines amount are implicitly debit amounts. approved_date. 60 Per Share. Public. 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. . Oracle Fusion ERP Analytics. This flag determines if Cross Charge processing is allowed or not. source_line_id_5name; req_number. Paris, Texas 75460 Tel: (903) 785-7661 Contact Us. 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. transaction_number. 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:. Required fields are marked. 12. PJC_AWARD_DISTRIBUTIONS interfaces the data with invocation business functions. pa_period_name. Posts about Project Cost written by Pulkit jain. replace the project_id. 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. Goal. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. WHERE ccdl_orig. Home / Fusion / Query to Find NonBillable Expense in Oracle Fusion. Applies to: Oracle Fusion Project Costing - Version 11. pjc_cost_dist_lines_all Tables to get Project Plan and its Budget Amount. operating_unit_name, a. Unique identifier for an allocation rule for the source line: LINE_NUM: NUMBER: Yes: Line number: EXCLUDE_FLAG: VARCHAR2: 1: Yes: The flag indicates whether to exclude returned projects Y means exclude: CREATED_BY: VARCHAR2: 64: Yes: Who column: indicates the user who created the row. 21. 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. 8. 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. 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. The identifier of the top task to which this tasks rolls up. transaction_id =. We originally had our PRBS by Expenditure Category and Type. 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. 23C. pjc_contract_line_id contract_line_id/*added for grants uptake*/ from. Processing Start Date, calculated as the maximum award, project, task, assignment, or labor schedule start date. This is defaulted to a project from the project template. An Equal Opportunity Institution. Cost organization of the transaction for which the distribution is created. 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_type_id = pet. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. PROJECT_ID =P. This number is incremented every time that the row is updated. 2) Run “Create Accounting” to populate accounting events (SLA) tables. Summary: We have a requirement to create a report/integration listing Expenditure / Costing information along with Billing information. Summary: Get all project costs Rest api not returning any values We are using below rest API to get all project cost details. Intern kicks of oracle invoice number tables after a template. 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. item_description. DENORM_TOP_ELEMENT_ID. Active. name; pjc_context_category. PA. 23C. Cloud. 2. The subledger journal entry is valid, but one or more of the other subledger journal entries associated with the same accounting event are invalid. For this request we need. event_id = ccdl. . pjc_expenditure_type_id. Summary: Get all project costs Rest api not returning any values We are using below rest API to get all project cost details. AP_INVOICE_DISTRIBUTIONS. 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. Stores the events registered for the requests submitted. **. GL_LEDGERS g, PO_HEADERS_ALL POH, POZ_SUPPLIERS_V V,. PJC_XCC_BURDEN_DIST_ERRORS; PJC_XCC_BURDEN_DIST_ERRORS. name AS Ledger_name, GJS. Destination. Inventory Transactions subject area with 1 base metric. The query uses the. User-defined number that uniquely identifies the element within a project or structure. OKE: Debug File Directory. You can also narrow your search results by completing any of the additional fields. line_type in ('R', 'B') AND. , POD. The import process overrides the cost center with this value. AND PRD. Title and Copyright Information; Get Help; 1 Overview. 0 and later Oracle Fusion Project Costing Cloud Service - Version 11. 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). 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. event_id = ccdl. For external third party import, this flag should be populated while interfacing the data into PATI. 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. Add to Compare. Previous Next JavaScript must be enabled to correctly display this content Tables and Views for Financials. If the task is a top task, the top_task_id is set to its own task_id. AS (SELECT DISTINCT GL. expenditure_type_idProgram for Return to Vendor in Oracle purchasing (1) Program to create receipts for approved Purchase order (1) Project Accounting (1) Project Contract Table Links in Fusion (1) Project Cost query (1) Project Details query Fusion (1) Project Directory query in Fusion (1) Project invoice query in fusion (1)Yes. PA_DRAFT_REVENUES_ALL. release_revision. 0 and later: PJC: Oracle Fusion Project Cost Account Reconciliation Report. David. 1. CREATED_BY EXP_CDL_DIST_CREATED_BY, trunc(cdl. Paris, Texas 75460. Views are logical representations of a single or combination of tables. Review the cost in the Project UI, it is not getting transferred to the Project. display_sequencePurpose of this report is to derive all projects expenditure and event details with cost information. source_line_id_1. Content (required):. PO_DISTRIBUTIONS_ALL contains accounting distribution information for a purchase order shipment line. l. PJC: Add Project Validations Using Cost Collection Descriptive Flexfields In Invoice Page (Doc ID 2417605. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. 11. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. 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. 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 code you enter must be ITEM, TAX, MISCELLANEOUS, or FREIGHT. source_header_id_1. recalculate the revenue for an expenditure item. Symptoms. CANCELLATION_FLAG: VARCHAR2: 1: A value of Y indicates that the distribution line has been created during the Invoice Cancel. For capital projects this flag is used as capitalizable_flag. InvoicesThey can be found in MetaLink, Knowledge, (scroll down left navigator) Online Documentation, last item. A distribution must be associated with an invoice. 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. Tables and Views for Financials. You need one row for each distribution line you attach to a purchase order shipment. In this Document. attribute7. It cc_process_labor_flag is set t. All costs are subject to change by the PJC Board of Regents. I am not even sure if that is the right. 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. 1) Last updated on NOVEMBER 08, 2022. meaning. VARCHAR2. Title and Copyright Information; Get Help; 1 Overview 2 Asset TrackingTo see a listing of courses offered, click the “Course Search” link below. pjc_project_id. FROM pjc_cost_dist_lines_all projectcostdistributionpeo, pjc_exp_items_all expenditureitempeo, pjf_exp_types_vl pet. September 25 / READ. acct_event_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. printed_date. 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. OLD_DIST_LINE_NUMBER: NUMBER: 18: Old invoice distribution line number. WHERE pcdl. List price fields, oracle ar tables in an item will not use these columns or process and line to the owner. 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_txn_xface_all: pjf_work_types_b: WORK_TYPE_ID: pjc_cost_dist_lines_all: pjf_work_types_b: WORK_TYPE_ID: Indexes. AP_INVOICE_LINES_ALL contains records for invoice lines entered manually, generated automatically or imported from the Open Interface. PJC_COST_DIST_LINES_ALL_N1: Non Unique: Default: PROJECT_ID: PJC_COST_DIST_LINES_ALL_N10: Non. 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. Used as a predefined finder to search the collection. Project Portfolio. start_date_active. 9. 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. AND imp. inventory_item_id,i. 1. 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. expenditure_item_idWITH gl_cmn_tbls. PA_CUST_REV_DIST_LINES_ALL does not reference any database object. F85651-01. PA tables in fusion - Read online for free. There is one row for each invoice distribution. 9. dist_acct_burdened_cost dist_acct_burdened_cost, l. 0 and later: Detailes About Some Errors from Table PJC_TXN_ERRORS. cc_dist_line_id(+) = ccdl. Determines the classification of the cross charge amount "Cost","Revenue" OBJECT_VERSION_NUMBER: NUMBER: 9: Yes: Used to implement optimistic locking. An invoice can have one or more invoice lines. 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. PJC_AWARD_DIST_LINES_U1. 5. expenditure_item_id AND expenditureitempeo. , rd. For multi–org schedules, we purge the schedule line that meets the purge criteria. expenditure_item_id = expenditureitempeo. PA_COST_DIST_OVERRIDES stores configurations defined at the project level that redirect specific costs and revenue to another organization. October 27 / READ. dist_base_quantity dist_base_quantity, l. Oracle Application Wednesday, 28 December 2022PJC_XCC_BURDEN_DIST_ERRORS; PJC_XCC_BURDEN_DIST_ERRORS. xla_ae_lines xal, pjc_exp_items_all peiThis table contains non-persistent data and is used to expose summary data to Essbase. T. F81674-01. Oracle Fusion ERP Analytics. req_line. Ananth. in pjc_exp_items_all are the columns original_header_id, original_line_number, original_dist_id. This is defaulted to a project from the project template. 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. Each of these initial records. 1) All accounting performed before transfer to the GL. 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. ,d. Meeting support account set certain item flexfield attribute you enter the combination of the overflow. Report message to a moderator. Raw cost = (quantity * cost rate) This value should alwa. 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. FROM pjc_cc_dist_lines_all ccdl, pjc_cc_dist_lines_all ccdl_orig , XLA_EVENTS_GT imp. Tablespace: Default. Default. Founded In 1924. pjc_txn_xface_all: pjf_work_types_b: WORK_TYPE_ID: pjc_cost_dist_lines_all: pjf_work_types_b: WORK_TYPE_ID: Indexes. source_line_id_4. source_id_int_1 = ccdl. Accounting data generated and stored in “Accounting Events” tables prior to transfer to GL. Summary: We have a requirement to create a report/integration listing Expenditure / Costing information along with Billing information. 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. end_date_active. A Junior College Owned & Operated By. 1. transaction_id =. pjc_contract_line_id CONTRACT_LINE_ID/*Added for grants uptake*/, l. 1. B. expenditure_type_id = pet. source_id_int_1 = ccdl. BALANCING_SEGMENT. acct_event_id. 0 and later. 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. You can optionally redirect only certain. EVENT_ID: NUMBER: 18: Reference to the event created in the SLA for this distribution header line. PA_COST_DISTRIBUTION_LINES_ALL stores information about the cost distribution of expenditure items. contract_line_id = OKCL. These lookup codes are stored in the AP_LOOKUP_CODES 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. ,d. Goal. award_distribution_id. 0 and later Information in this document applies to any platform. We would like to show you a description here but the site won’t allow us. 1. **. My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts. trunc(cdl. award_distribution_status. enabled_flag. PROJECT_ID. ref_ae_line_num = xda2. LINE_TYPE_. How can i join CE_EXTERNAL_TRANSACTIONS into GL_JE_LINES? I need external transactions accounting period and its account status. pjc_expenditure_item_date. FROM pjc_cost_dist_lines_all projectcostdistributionpeo, pjc_exp_items_all expenditureitempeo, pjf_exp_types_vl pet WHERE (projectcostdistributionpeo. 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. actual_amount, 0)) - SUM(nvl(main. transaction_id =. For external Oracle Import, this flag is derived from the setup data atProject, Task and Document Entry level. As every AP invoice Line can be made of multiple PO. 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. dist_line_id_reversed. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. SELECT * FROM PJC_COST_DIST_LINES_ALL D, PJF_PROJECTS_ALL_B P. Column NameFlag that indicates if project related invoice distributions have been interfaced into Oracle Projects as committed cost. GL_CODE_COMBINATIONS contains valid account combinations for each accounting flexfield structure within the Oracle Fusion General Ledger application. Status becomes Closed for receiving (due to receipt close tolerance = 100% @ PO line type setup) 4. Processing Start Date, calculated as the maximum award, project, task, assignment, or labor schedule start date. event_id = ccdl. cc_dist_line_id(+) = ccdl. The issue can be reproduced at will with the following steps: 1. Solution 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 data in the SLA (XLA) tables. COST_ORGANIZATION_ID: NUMBER: 18: Yes: Cost organization of the transaction for which the distribution is created. organization_id. AND imp. identified with the function code of LRL and LRB for labor items. Oracle Fusion Project Costing Cloud Service - Version 11. per_user_roles 3. source_task_id. HTH. 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. March 5, 2010 in Oracle Projects Contracts. display_sequencePurpose of this report is to derive all projects expenditure and event details with cost information. pjc_organization_id. 1. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. 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. April 17 edited April 17. We are trying to find the lookup values for the field PJC_COST_DIST_LINES_ALL. expenditure_item_id AND expenditureitempeo. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. October 10 / READ. 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. CREATION_DATE) EXP_CDL_DIST_CREATION_DATE, cdl. AND imp. Please help in identifying the column mapping on fusion application to get the Burdened cost in Receiver Ledger Currency. FROM pjf_burden_rate_extn bre, pjc_exp_items_all ei, pjc_cost_dist_lines. Determines the classification of the cross charge amount "Cost","Revenue" OBJECT_VERSION_NUMBER: NUMBER: 9: Yes:. creation_date. 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. This parameter restricts the number of resources returned. main. This number is incremented every time that the row is updated. 1. 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. The line"s current cost amount in the reporting currency; split lines have a current cost <> original cost:. AND imp. This number is incremented every time that the row is updated. NUMBER. project_name,We have a query that extracts records from PJC_COST_DIST_LINES_ALL. PJC: Add Project Validations Using Cost Collection Descriptive Flexfields In Invoice Page (Doc ID 2417605. name columns; pjc_acct_sweeper_logs_pk. AP_Invoices_All has the unique key on invoice_id. 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. 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. po_revision. INVOICE_TYPE_LOOKUP_CODE. Distribution identifier of the burden cost. 1) Last updated on MAY 27, 2022 Applies. xda2. source_pa_date. Contents. source_line_id_1. Pa_MC_Cost_Dist_Lines_ar is a table for Archive/Purge. It cc_process_labor_flag is set t. inventory_item_id,i. 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. FROM pjc_cc_dist_lines_all ccdl, pjc_cc_dist_lines_all ccdl_orig , XLA_EVENTS_GT imp. Person ID related to the person record for this labor cost. 18. A subledger journal entry can have a status of Draft, Final, Incomplete, Invalid or Invalid Related Entry. We have a requirement to derive only accounted project cost transactions by creating custom BIP report. NUMBER. WHERE ei. 1. (2023) Abby Cater scored 20 points, including 14 of 17 from the free throw line, to lead. projfunc_cost_exchange_rate src_projfunc_cost_xchng_rate, bre. expenditure_type_id AND. . I used csv file as data source in Data Model. 1. project_organization_name, a. For example, to search for online classes only, select 'Online' in. 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 Tables Views 6 Project Costing Tables Views 7 Project Foundation Tables Views 8 Project Management Tables Views 9 Project Management Control Tables Views 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 quantity. 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. . Enter the lookup code for the type of invoice distribution that you want Payables Open Interface Import to create from this record. source_header_id_2. project_id AND pbt. 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. 0 and later. 9. FROM. xcc_data_set_id data_set_id, to_char(cre. xla_distribution_links. 72. SELECT revenue_type, TO_CHAR (customer_id) customer_id, customer_name, TO_CHAR (project_id) project_id, project_number, contract_number,. Oracle Project Contracts Module Profile Options: PROFILE OPTION SHORT CODE. This input is required to create reports, understand links between various charts, and even for troubleshooting purpose. acct_event_id. CDL_LINE_TYPE: VARCHAR2: 1: The type of the cost distribution line: COMP_DETAILS_ID: NUMBER: 18: Reference to Labor Rate Override. requestor_nameEnd date of the payroll period. AND imp. AND imp. For capital projects this flag is used as capitalizable_flag. Item Cost Comparison CAC Intercompany SO Shipping. 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.