Item Costs CAC Intercompany Relationship Setup CAC Intercompany SO Price List CAC Intercompany SO Price List vs. 1. INVENTORY_ORG_ID: NUMBER: 18: Indicates The Inventory Org To Which The Item Belongs. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. Object owner: CST. PJC_MC_PRJ_AST_LINES_ALL is an MRC sub table of PJC_PRJ_ASSET_LNS_ALL. Index Uniqueness Tablespace Columns Status; PJF_PERIODS_ALL_N1: Non Unique: FUSION_TS_TX_DATA: STATUS,. Default flag for items charged to the task that indicates if the item can accrue revenue (Y or N). Provision with single sign-on. INVOICE_TYPE_LOOKUP_CODE. 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. 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. Indicates if the application should derive the raw cost for the project cost transaction. source_project_id. 0 and later Oracle Fusion Project Costing Cloud Service - Version 11. name; lookup_type. Main: 903. ind_rate_sch_revision_idbre. ever_approved_flag. Purpose of this report is to display Project billable hours for Internal ===== /* Formatted on 2018/07/30 15:40 (Formatter Plus v4. event_id = cdl. April 17 edited April 17. PA_PROJECT_ASSET_LINES_ALL stores summarized project CIP cost lines. 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. 60 Per Share. Posts about Project Cost written by Pulkit jain. 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. 23D. 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. accounting_event_id) source_header_id_1, ' ' source_header_id_2, decode(cre. current_run_id extn_current_run_id, bre. 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. PA_COST_DISTRIBUTION_LINES_ALL stores information about the cost distribution of expenditure items. 10. Tables and Views for Financials. Summary: Get all project costs Rest api not returning any values We are using below rest API to get all project cost details. this contains the line number of the corresponding cost distribution line: TP_JOB_ID:. 7. Tables and Views for Project Management. AND imp. Review the cost in the Project UI, it is not getting transferred to the Project. NUMBER. event_id = ccdl. I am not even sure if that is the right. acct_event_id. Currently I am using pjc_cost_dist_lines_all table in my query to derive cost transactions data. approved_flag. DENOM_CURRENCY_CODE. cc_dist_line_id(+) = ccdl. ref_ae_header_id =. EVENT_ID: NUMBER: 18: Reference to the event created in the SLA for this distribution header line. PJC_MC_PRJ_AST_LINES_ALL is an MRC sub table of PJC_PRJ_ASSET_LNS_ALL. event_id = ccdl. 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,. Symptoms. Index Uniqueness Tablespace Columns; PJF_WORK_TYPES_B_N1:Object Details. Enter the lookup code for the type of invoice distribution that you want Payables Open Interface Import to create from this record. 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. 2) adjusting revenue distribution lines are created when you. WHERE pcdl. pjc_expenditure_type_id. pa_cust_rev_dist_lines_all. PA_COST_DIST_OVERRIDES stores configurations defined at the project level that redirect specific costs and revenue to another organization. EBS Tables. AP_INVOICE_LINES_ALL contains records for invoice lines entered manually, generated automatically or imported from the Open Interface. pjc_cost_dist_lines_all Tables to get Project Plan and its Budget Amount. CONTRACT_ID: NUMBER: 18: Identifier of the contract for which the rate override is defined. You need one row for each distribution line you attach to a purchase order shipment. ,d. 2. 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. The line"s current cost amount in the reporting currency; split lines have a current cost <> original cost:. source_header_id_2. BALANCING_SEGMENT. October 10 / READ. project_id AND pbt. Cost distribution lines amount are implicitly debit amounts. 0 and later Information in this document applies to any platform. source_header_id_2. Information about the cost distribution of expenditure items for each reporting set of books. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. Column NameFlag that indicates if project related invoice distributions have been interfaced into Oracle Projects as committed cost. acct_event_id. 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. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. 8. For indirect projects this flag is set. The identifier of the top task to which this tasks rolls up. 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. AND imp. Report message to a moderator. There is one row for each invoice distribution. award_distribution_id. expenditure_item_id = pei. FROM pjc_cost_dist_lines_all projectcostdistributionpeo, pjc_exp_items_all expenditureitempeo, pjf_exp_types_vl pet WHERE (projectcostdistributionpeo. 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. description. Used when Oracle Contract Billing or Oracle Grants Accounting is installed. There is one row for each invoice distribution. 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. ei_latest_gl_period_name, x. FROM pjf_burden_rate_extn bre, pjc_exp_items_all ei,. Paris Junior College is accredited by the Southern Association of. CDL_LINE_TYPE: VARCHAR2: 1: The type of the cost distribution line: COMP_DETAILS_ID: NUMBER: 18: Reference to Labor Rate Override. acct_event_id. GL_LEDGERS g, ap_invoices_all i, POZ_SUPPLIERS_V v, HR_ORGANIZATION_V o, PJF_EXPEND_TYP_SYS_LINKS es, PJF_EXP_TYPES_B et , PJF_TASKS_V t,. PJC: Oracle Fusion Project Cost Account Reconciliation Report (Doc ID 2121913. po_revision. Teens. Active: TRANSFER_COST_DIST_ACCOUNT: NUMBER: 18: Transaction transfer cost distribution account: Active: WAYBILL_AIRBILL: VARCHAR2: 20:. source_line_id_4. 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. pjc_contract_line_id contract_line_id/*added for grants uptake*/ from. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. FROM pjc_cost_dist_lines_all pcdl, pjc_exp_items_all pei, pjf_tasks_v ptv, pjf_projects_all_b prb, pjf_projects_all_tl prl,. OKE_DEBUG_MODE. ref_ae_line_num = xda2. cc_dist_line_id(+) = ccdl. INVOICE_LINE_NUMBER: NUMBER: Invoice line number for parent line:. The query uses the. 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. 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. WHERE ics. AND imp. CDL_LINE_NUM: NUMBER: 18: Line Number of the Cost Distribution Line. • All tables ending with the suffix _EN • All views listed in Tables Without WHO Columns. CREATED_BY EXP_CDL_DIST_CREATED_BY, trunc(cdl. AP_INVOICE_DISTRIBUTIONS_ALL can also be used to find the connectivity between AP invoice & PO or AP invoices & Project. Summary: Generate Burden Costs Query. COST_ORGANIZATION_ID: NUMBER: 18: Yes: Cost organization of the transaction for which the distribution is created. 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. per_users 2. The primary key on this table is:. PA_CUST_REV_DIST_LINES_ALL. event_type_code, 'retro. ae_line_num AND xda1. 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. document_type. event_id = ccdl. identified with the function code of LRL and LRB for labor items. source_line_id_2. cc_dist_line_id(+) = ccdl. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. 6 Most Important Tables Used By pa-sla-gl link query. The room and board residence hall cost for academic year 2023-2024 are:. 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,. cc_dist_line_id(+) = ccdl. AP_INVOICE_LINES_ALL. 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. pjc_project_id. An invoice can have one or more invoice lines. 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. Default flag for items charged to the task that indicates if the item can accrue revenue (Y or N). project_id = ppa. source_pa_period_name. items. BILLABLE_FLAG. 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. 2. WHERE ccdl_orig. 1. name AS Ledger_name, GJS. 1. Previous Next JavaScript must be enabled to correctly display this content . 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. expenditure_type_id = pet. Solution. 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. 0 and later: PJC: Oracle Fusion Project Cost Account Reconciliation Report. expenditure_item_id = expenditureitempeo. David. creation_date. 1. Oracle Fusion Cloud Financials. March 5, 2010 in Oracle Projects Contracts. 23. FROM pjc_cost_dist_lines_all projectcostdistributionpeo, pjc_exp_items_all expenditureitempeo, pjf_exp_types_vl pet WHERE ( projectcostdistributionpeo. Uniqueness. 0 version, Manage Project Costs. PJC_AWARD_DIST_LINES_U1. WHERE ccdl_orig. 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. enabled_flag. 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. VARCHAR2. expenditure_item_date expenditure_item_date2. per_roles_dn 4. PJC_XCC_BURDEN_DIST_ERRORS; PJC_XCC_BURDEN_DIST_ERRORS. ind_rate_sch_revision_id bre. Previous Next JavaScript must be enabled to correctly display this content . The customer is linked to an NGN AR account set, the project account set is in NGN. Hi Please find the Columns and tables that we are using below SQL. OKE_DEBUG_FILE_DIR. Title and Copyright Information; Get Help; 1 Overview. The subledger journal entry is valid, but one or more of the other subledger journal entries associated with the same accounting event are invalid. Cost distribution lines amount are implicitly debit amounts. WHERE 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. WHERE D. This number is incremented every time that the row is updated. 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. AMOUNT_VARIANCE:. Name of the pay element. ae_header_id FROM xla_distribution_links xda2 WHERE xda2. project_type,SUM(nvl(main. For external Oracle Import, this flag is derived from the setup data atProject, Task and Document Entry level. User-defined number that uniquely identifies the element within a project or structure. We have a requirement to derive only accounted project cost transactions by creating custom BIP report. award_distribution_batch_id. expenditure_item_id = expenditureitempeo. 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. 21. 10. The code you enter must be ITEM, TAX, MISCELLANEOUS, or FREIGHT. Hello All, > Oracle BI Publisher I have creating report using Oracle BI Publisher. For external Oracle Import, this flag is derived from the setup data atProject, Task and Document Entry level. source_id_int_1 = ccdl. Examples of when your Oracle Payables application automatically creates rows in this table include. Learn how to use a query in Oracle Fusion to find project estimation to complete based on budgeted and actual costs, hours, and revenue. 2021-2022 Catalog. project_id AND pbt. I used csv file as data source in Data Model. 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. 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. XLA_AE_LINES, XLA_AE_HEADERS, AP_INVOICES_ALL, AP_SUPPLIERS, GL_CODE_COMBINATIONS. DENOM_BURDENED_COST NUMBER Total burdened cost of the expenditure item in transacti. AND imp. attribute3. 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. 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. Enter the lookup code for the type of invoice distribution that you want Payables Open Interface Import to create from this record. PJC : Cost shows in wrong currency Posted By months ago Hi, I have setup a project for Nigeria currency NGN. 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. vendor_id. Tablespace: Default. FROM pjc_cc_dist_lines_all ccdl, pjc_cc_dist_lines_all ccdl_orig , XLA_EVENTS_GT imp. start_date_active. dist_acct_burdened_cost dist_acct_burdened_cost, l. pjc_contract_line_id CONTRACT_LINE_ID/*Added for grants uptake*/, l. 1) Last updated on NOVEMBER 08, 2022. From my research, it seems that the OTL timecard tables are HXT_TM_MTRX and HXT_TM_HEADER. There can be only one record for the combination of Supplier and the invoice number. ae_header_id = ael1. This value for the project is a default for the task fixed date. FROM pjc_cost_dist_lines_all projectcostdistributionpeo, pjc_exp_items_all expenditureitempeo, pjf_exp_types_vl pet WHERE (projectcostdistributionpeo. An. 23C. validation_status_code validation_status_code,. requestor_nameEnd date of the payroll period. Tags: PA. We want to extract only those that are posted in GL. Oracle Fusion Project Costing - Version 11. PJC_CC_DIST_LINES_ALL. Cost organization of the transaction for which the distribution is created. transaction_id =. 2. expenditure_item_date expenditure_item_date2. PA. source_line_id_1. 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. 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. In this Document. id) Actual_Rev_ITD_Prj_Curr ,(SELECT NVL (SUM (projectcostdistributionpeo. COST_ID: NUMBER: 18: Yes: Reference to the layer, write-off or transfer. attribute6. 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. Oklahoma residents are charged out-of-district, not out-of-state tuition at PJC. line_type in ('R', 'B') AND. 72. data_set_id data_set_id, ei. VARCHAR2. AP_INVOICE_DISTRIBUTIONS. CREATION_DATE) EXP_CDL_DIST_CREATION_DATE, cdl. cc_dist_line_id(+) = ccdl. 4. The cost distrulibution table for the ccid fields are null. 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. S. 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. PA tables in fusion - Read online for free. source_id_int_1 = ccdl. 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. 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;. Active. project_id = ppa. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. List price fields, oracle ar tables in an item will not use these columns or process and line to the owner. name; data_set_id. Title and Copyright Information; Get Help; 1 Overview 2 Asset TrackingTo see a listing of courses offered, click the “Course Search” link below. PROJECT_ID =P. PROJFUNC_COST_RATE_TYPE: PJC_EXP_ITEMS_ALL: pjf_work_types_b: WORK_TYPE_ID: PJC_EXP_ITEMS_ALL: pjf_txn_sources_b:. DENORM_WBS_LEVEL. transaction_id =. display_sequencePurpose of this report is to derive all projects expenditure and event details with cost information. NUMBER. 8. 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. Processing Start Date, calculated as the maximum award, project, task, assignment, or labor schedule start date. 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. projfunc_cost_exchange_rate src_projfunc_cost_xchng_rate, bre. This is defaulted to a project from the project template. R2. A distribution must be associated with an invoice. The issue can be reproduced at will with the following steps: 1. Previous Next JavaScript must be enabled to correctly display this content Tables and Views for Financials. ae_header_id = ael1. expenditure_item_id. ORDER BY D. prvdr_gl_date. The value must be a valid value for the cost center segment of the accounting flexfield. Loading. If the task is a top task, the top_task_id is set to its own task_id. ACCT_CURRENCY_CODE. source_line_id_1. attribute7. 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. Oracle Fusion Cloud Project Management. expenditure_item_id = expenditureitempeo. t costs are also not populated. 1. 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. The line"s current cost amount in the reporting currency; split lines have a current cost <> original cost:. l. F81674-01. pjc_capitalizable. Create PO with line type = Fixed Price Service and 2 ways match. Determines the classification of the cross charge amount "Cost","Revenue" OBJECT_VERSION_NUMBER: NUMBER: 9: Yes:. This input is required to create reports, understand links between various charts, and even for troubleshooting purpose. 1. pjc_expenditure_item_date. award_distribution_status. From my research, it seems that the OTL. source_line_id_5Qn1:The customer wants to have the ability to "view accounting" for unreleased expenditure batches. 2. I see cost distributions and expenditures on a project from AP but when mapping the cost distribution back to the. PJC_CC_DIST_LINES_N1: Non Unique: Default: PROJECT_ID, TASK_ID: PJC_CC_DIST_LINES_N2:. 23C. Index Uniqueness Tablespace Columns; PJF_RATE_OVERRIDES_N1: Non Unique: Default:. AWARD_DISTRIBUTION_LINE_ID. Fixed date to find the effective rate of the bill rate or burden schedule when determining the transfer price for labor transactions. Paris, Texas 75460 Tel: (903) 785-7661 Contact Us. FROM pjc_cc_dist_lines_all ccdl, pjc_cc_dist_lines_all ccdl_orig , XLA_EVENTS_GT imp. event_id = ccdl. AND imp. pa_cost_distribution_lines_all. COST MANAGEMENT AND CONTROL. ref_ae_header_id =. Possible values are 'INT' , 'EXT'. Once all lines associated with a schedule are purged, the whole schedule is purged. calc_burden_status extn_calc_burden_status, cdl. 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_BOOK_ID: NUMBER: 18: Cost book within the cost organization for which the distribution is created. task_id. Refer to comments on the columns in the main table. award_distribution_status. 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. 5. You can optionally redirect only certain. SELECT FROM PJF_PROJECTS_ALL_B WHERE SEGMENT1='proj_nr';-- note the project_id; 2. To override the cost center in the account, enter a value.