pjc_cost_dist_lines_all. project_number, a. pjc_cost_dist_lines_all

 
project_number, apjc_cost_dist_lines_all  end_date_active

dist_acct_burdened_cost dist_acct_burdened_cost, l. The table has no primary key. ref_ae_line_num IS NULL AND xda2. 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. 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_header_id =. name; source_bu_id. When an asset line is initially created, this table contains one record for each cost distribution line summarized into the asset line. The code you enter must be ITEM, TAX, MISCELLANEOUS, or FREIGHT. Office & Switchboard Hours (all locations) Monday - Friday: 8AM - 5PM Greenville Center Tel: (903) 454-9333 Sulphur Springs Center Tel: (903) 885-1232 Help & Support. Views are logical representations of a single or combination of tables. replace the project_id. Qn2:On : Customer is requesting a way to restrict specific expenditure types to. cc_dist_line_id(+) = ccdl. Piper Sandler Completes 46th Semi-Annual Generation Z Survey of 9,193 U. ACCOUNTING_DEFINITION_ID: NUMBER: 18: Yes: Reference to the cost accounting definition line. 2021-2022 Catalog. 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. Currently I am using pjc_cost_dist_lines_all table in my query to derive cost transactions data. pjc_task_id. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. event_id = ccdl. DENORM_TOP_ELEMENT_ID. pjc_expenditure_type_id. In this Document. . enabled_flag. items. 4. transaction_id =. project_id = ppa. This flag determines if Cross Charge processing is allowed or not. Object type: TABLE. We link PJC_COST_DIST_LINES_ALL table to XLA_AE_LINES table through XLA_DISTRIBUTION_LINKS table. Burdened cost = (raw cost * (1 + burden cost multiplier) equal the sum of the items burden debit cost distributio. WHERE ( projectcostdistributionpeo. attribute6. 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. vendor_id. Paris Junior College is accredited by the Southern Association of. PJC: Oracle Fusion Project Cost Account Reconciliation Report (Doc ID 2121913. pjc_expenditure_item_date. project_number, a. DENOM_BURDENED_COST NUMBER Total burdened cost of the expenditure item in transacti. expenditure_item_id AND expenditureitempeo. lookup_code. Hi Please find the Columns and tables that we are using below SQL. 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. expenditure_item_id = expenditureitempeo. CREATED_BY EXP_CDL_DIST_CREATED_BY, trunc(cdl. March 5, 2010 in Oracle Projects Contracts. Refer to comments on the columns in the main table. The primary key on this table is:. CREATED_BY EXP_CDL_DIST_CREATED_BY, trunc(cdl. WHERE ccdl_orig. PO_DISTRIBUTIONS_ALL contains accounting distribution information for a purchase order shipment line. source_header_id_2. 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. 9. Applies to: Oracle Fusion Project. expenditure_type_id = pet. 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. . source_header_id_2. Oracle Fusion Cloud Project Management. A Junior College Owned & Operated By. pjc_cost_dist_lines_all: pjf_rate_overrides: RATE_OVERRIDE_ID: Indexes. dist_denom_burdened_cost dist_denom_burdened_cost, l. 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. 1) All accounting performed before transfer to the GL. projfunc_cost_exchange_rate src_projfunc_cost_xchng_rate, bre. Processing Start Date, calculated as the maximum award, project, task, assignment, or labor schedule start date. 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. Who column: indicates the user who created the row. PJC_COST_DIST_LINES_ALL_N1: Non Unique: Default: PROJECT_ID: PJC_COST_DIST_LINES_ALL_N10: Non. 2) Run “Create Accounting” to populate accounting events (SLA) tables. Without value the data in Project Accounting cannot be linked to Accounts Payable transactions. 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. source_line_id_4. 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. 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. 21. Schema: FUSION. WHERE ccdl_orig. You need one row for each distribution line you attach to a purchase order shipment. expenditure_item_id, cdl_line_num, prvdr_gl_date, project_raw_costSELECT x. 6 Most Important Tables Used By pa-sla-gl link query. source_header_id_1. trunc(cdl. pjc_task_id. COST_BOOK_ID: NUMBER: 18: Yes: Cost book within the cost organization for which the distribution is created. meaning. Once all lines associated with a schedule are purged, the whole schedule is purged. capitalizable_flag = 'Y' 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, pjb_errors pe, okc_k_headers_all_b okh, okc_k_lines_b okl, pjb_bill_plans_vl pjbp, okc_contract_types_tl okct, xla_distribution. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. 785. FROM pjf_burden_rate_extn bre, pjc_exp_items_all ei,. 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. 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. FROM pjf_burden_rate_extn bre, pjc_exp_items_all ei, pjc_cost_dist_lines. Indicates whether invoice line is enabled for landed cost management. expenditure_item_id = expenditureitempeo. WHERE ccdl_orig. This is the transportation cost for transfer. Index Uniqueness Tablespace Columns; PJF_WORK_TYPES_B_N1:Object Details. Paris, Texas 75460 Tel: (903) 785-7661 Contact Us. 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. For external Oracle Import, this flag is derived from the setup data atProject, Task and Document Entry level. Paris Junior College 2400 Clarksville St. An invoice can have multiple distributions. Summary: Generate Burden Costs Query. Cloud. AMOUNT_VARIANCE:. 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. Item Cost Comparison CAC Intercompany SO Shipping. expenditure_item_id. AND imp. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. 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. release_number. pjo_plan_line_details pjo_plan_lines pjo_planning_elements pjo_plan_versions_b. 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. 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. FROM pjc_cc_dist_lines_all ccdl, pjc_cc_dist_lines_all ccdl_orig , XLA_EVENTS_GT imp. source_line_id_5Qn1:The customer wants to have the ability to "view accounting" for unreleased expenditure batches. VARCHAR2. 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 PRD. Hi team, We have a scenario for which we need to fetch all the eligible expenditures for a project without using PJC tables like pjc_Exp_items_all, PJC_COST_DIST_LINES_A… Accepted answer Mayank_Khatri 22 views 3 comments 0 points Most recent by Pradeep Balakrishnan Sep 28, 2023 7:04AM Project ManagementIdentifies the commitment transaction line type as purchase order, purchase requisition, supplier invoice or third-party. OKE_K_FIFO_LOG. PJC_PRJ_ASSET_LNS_ALL. This is defaulted to a project from the project template. possible vlaues I,P,R,E. A distribution must be associated with an invoice and invoice line. Oracle Fusion Query For Join Between Project, Project Cost Distribution And Gl Code Combination (Doc ID 2856441. WHERE ccdl_orig. EVENT_ID: NUMBER: 18: Reference to the event created in the SLA for this distribution header line. ind_rate_sch_revision_id = irsr. INVOICE_TYPE_LOOKUP_CODE. Oracle Fusion Project Costing - Version 11. select a. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. PJC_FUNDING_ALLOCATION_ID FUNDING_ALLOCATION_ID/*Added for grants uptake*/, POD. 00; Paris Junior College 2400 Clarksville St. PA_MC_COST_DIST_LINES_AR. You can optionally redirect only certain. requestor_nameEnd date of the payroll period. 1. 1) Last updated on MAY 27, 2022 Applies to: Oracle Fusion Project Costing Cloud Service - Version 11. 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. Accounting data generated and stored in “Accounting Events” tables prior to transfer to GL. pjc_project_id. expenditure_type_id AND. award_distribution_batch_id. PJB_INV_CONFIG_DISTS_GT_U2. 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,. 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: pjf_periods_all: RECVR_PA_PERIOD_NAME, ORG_ID: Indexes. 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;. pjc_contract_line_id CONTRACT_LINE_ID/*Added for grants uptake*/, l. requestor_person_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. attribute1. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. xda2. 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 parameter restricts the number of resources returned. document_type. I do not know how to link the dist line the the xla lines. 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. 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. expenditure_item_id = pei. award_distribution_id. Person ID related to the person record for this labor cost. I see cost distributions and expenditures on a project from AP but when mapping the cost distribution back to the. There are more that 200 records in the table "PJC_COST_DIST_LINES_ALL" Content. AS (SELECT DISTINCT GL. 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. Supplier invoice expenditure items do not have a value for column SYSTEM_REFERENCE5 in table PA_COST_DISTRIBUTION_LINES_ALL which is. This value for the project is a default for the task fixed date. 12. PJC_COST_DIST_LINES_ALL_N1: Non Unique: Default: PROJECT_ID: PJC_COST_DIST_LINES_ALL_N10: Non. AP_INVOICE_DISTRIBUTIONS_ALL can also be used to find the connectivity between AP invoice & PO or AP invoices & Project. 1. 0. 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, pjb_errors pe, okc_k_headers_all_b okh, okc_k_lines_b okl, pjb_bill_plans_vl pjbp, okc_contract_types_tl okct,. Default flag for items charged to the task that indicates if the item can accrue revenue (Y or N). start_date_active. approved_date. PA. LAST_UPDATE_DATE). This information will be interfaced to Oracle General Ledger from Oracle Projects. Single column FK: Identifies the cost distribution header record. Previous Next JavaScript must be enabled to correctly display this content . Summary: Get all project costs Rest api not returning any values We are using below rest API to get all project cost details. task_id. R2. 0 and later: PJC: Oracle Fusion Project Cost Account Reconciliation Report. This input is required to create reports, understand links between various charts, and even for troubleshooting purpose. 1) Last updated on NOVEMBER 08, 2022. Collin County Community College District. Posted by Manjesh's Fusion World at 2:42 AM No comments: Email This BlogThis! Share to Twitter Share to Facebook Share to Pinterest. cc_dist_line_id(+) = ccdl. 18. actual_amount, 0)) - SUM(nvl(main. PA_COST_DISTRIBUTION_LINES_ALL stores information about the cost distribution of expenditure items. ae_header_id FROM xla_distribution_links xda2 WHERE xda2. 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. transaction_number. An. Oracle Fusion Cloud Project Management. 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. Purpose of this report is to display Project billable hours for Internal ===== /* Formatted on 2018/07/30 15:40 (Formatter Plus v4. ae_header_id FROM xla_distribution_links xda2 WHERE xda2. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. LINE_TYPE_. source_line_id_1. 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,. meaning. 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. inventory_item_id,i. reserved_attribute1 reserved_attribute1, ei. Used to implement optimistic locking. Default. Project Contracts Profile Options →. This column contains the identifier of. NUMBER. 01. ei_revenue_distributed_flag, x. PJC_CONTRACT_LINE_ID CONTRACT_LINE_ID/*Added for grants uptake*/ FROM. project_type,SUM(nvl(main. enabled_flag. LAST_UPDATE_DATE) EXP_CDL_LAST_UPDATED_DATE, cdl. Tablespace: Default. GL_LEDGERS g, PO_HEADERS_ALL POH, POZ_SUPPLIERS_V V,. WHERE pcdl. S. 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. expenditure_type_id = pet. Columns. COST MANAGEMENT AND CONTROL. Provision with single sign-on. Ananth. OKE: Debug File Directory. CREATION_DATE) EXP_CDL_DIST_CREATION_DATE, cdl. PA_MC_COST_DIST_LINES_ALL is an MRC sub table of PA_COST_DISTRIBUTION_LINES_ALL. The borrowed and lent revenue distribution lines are. Required fields are marked. If the task is a top task, the top_task_id is set to its own task_id. pjc_billable_flag. pjc_organization_id. source_line_id_2. rounding_class_code = 'RAW_COST_CLEARING' AND NOT EXISTS ( SELECT 1 FROM xla_distribution_links xda1 WHERE xda1. F85651-01. 72. in pjc_exp_items_all are the columns original_header_id, original_line_number, original_dist_id. PJC: Add Project Validations Using Cost Collection Descriptive Flexfields In Invoice Page (Doc ID 2417605. tag. Through testing we decided we just need one by expend…Subject: SQL query to get the Project Details, Contract Details, Invoice Details--SQL Query:--SELECT. accounting_event_id) source_header_id_1, ' ' source_header_id_2, decode(cre. projfunc_cost_exchange_rate src_projfunc_cost_xchng_rate, bre. C for cost rate override and B for bill rate override. 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. For indirect projects this flag is set. 0 and later Oracle Fusion Project Costing Cloud Service - Version 11. To get the. SELECT FROM PJF_PROJECTS_ALL_B WHERE SEGMENT1='proj_nr';-- note the project_id; 2. AND imp. PJC_CONTRACT_LINE_ID: NUMBER: 18:. prvdr_gl_period_name gl_period, trx_org. OKE: Debug Mode. 2. The Paris Junior College District. pjc_billable_flag. planned_amt, 0)) varienceBut we dont see any Column related to Person in PJC, COST DIST LINES ALL Table. We are trying to find the lookup values for the field PJC_COST_DIST_LINES_ALL. 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. ei_latest_gl_period_name, x. For external third party import, this flag should be populated while interfacing the data into PATI. Determines the classification of the cross charge amount "Cost","Revenue" OBJECT_VERSION_NUMBER: NUMBER: 9: Yes:. GL_CODE_COMBINATIONS contains valid account combinations for each accounting flexfield structure within the Oracle Fusion General Ledger application. PJC_MC_PRJ_AST_LINES_ALL is an MRC sub table of PJC_PRJ_ASSET_LNS_ALL. For indirect projects this flag is set. 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. An invoice / invoice line can have. t costs are also not populated. ae_header_id = ael1. sql_statement; select cre. VARCHAR2. award_distribution_id. 7661 • Admissions: 903. PA_COST_DISTRIBUTION_LINES_ALL stores information about the cost distribution of expenditure items. event_id = ccdl. source_line_id_1. Title and Copyright Information; Get Help; 1 Overview 2 Asset TrackingTo see a listing of courses offered, click the “Course Search” link below. AP_INVOICE_LINES_ALL. 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. per_roles_dn_tl Detail SQL Query to. approved_flag. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. name; pjc_context_category. I am not even sure if that is the right. CONTRACT_ID: NUMBER: 18: Identifier of the contract for which the rate override is defined. 1. 1) Last updated on NOVEMBER 08, 2022. 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. F81674-01. source_attribute1. 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. line_type in ('R', 'B') AND pcdl. Cloud Applications. 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. LAST_UPDATED_BY EXP_CDL_LAST_UPDATED_BY. OVERLAY_DIST_CODE_CONCAT: VARCHAR2: 250:. Transaction identifier of the burden cost. 11. award_distribution_status. 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,. BILLABLE_FLAG. event_id = ccdl. I used csv file as data source in Data Model. agreement_type, a. 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. Goal. 23C. 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. description. FROM. source_header_id_1. NAME expenditure_organization,. ei_project_numbe. 23. 0 and later. Summary: Hello, We are in a DEV environment Cloud 23B. User-defined number that uniquely identifies the element within a project or structure. ORDER BY D. FROM. COST_CENTER_SEGMENT. 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. FROM. Examples of when your Oracle Payables application automatically creates rows in this table include. I can see that the Categories in the project show the NGN exchange rate. 1. PA_CUST_EVENT_RDL_ALL. cc_dist_line_id(+) = ccdl. From my research, it seems that the OTL timecard tables are HXT_TM_MTRX and HXT_TM_HEADER. Content (required): The values in this field are RPBNN. AS (SELECT DISTINCT GL. … 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. Project Portfolio. Subledger Accounting (SLA) in R12. 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. current_run_id extn_current_run_id, bre. 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. An Equal Opportunity Institution. F81674-01. ind_rate_sch_revision_id bre. name; lookup_type. . source_line_id_1. Name of the pay element. It cc_process_labor_flag is set t. Describes tables and views for Oracle Fusion Cloud Project Management. 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. data_set_id data_set_id, ei. 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. acct_event_id. 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. Goal. 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. 3452 Spur 399 McKinney, TX 75069 (972) 881-5790. ref_ae_line_num = xda2.