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. end_date_active. The identifier of the top task to which this tasks rolls up. The line"s current cost amount in the reporting currency; split lines have a current cost <> original cost:. ,d. FROM. project_id = ppa. name AS Ledger_name, GJS. 1. Paris, Texas 75460. expenditure_item_id = expenditureitempeo. Oracle Fusion Cloud Financials. 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. release_revision. description. SELECT * FROM PJC_COST_DIST_LINES_ALL D,. Who column: indicates the date and time of the creation of the row. ind_rate_sch_revision_id = irsr. and URL and URB for usage items. These lookup codes are stored in the AP_LOOKUP_CODES table. Burdened cost = (raw cost * (1 + burden cost multiplier) equal the sum of the items burden debit cost distributio. This number is incremented every time that the row is updated. LINE_TYPE_. A distribution must be associated with an invoice. Yes. Status becomes Closed for receiving (due to receipt close tolerance = 100% @ PO line type setup) 4. ACCOUNTING_STATUS_CODE . Posts about Project Cost written by Pulkit jain. The output should be Prepayment. F81674-01. Refer to comments on the columns in the main table. WHERE ccdl_orig. rounding_class_code = ‘RAW_COST_CLEARING’ AND NOT EXISTS ( SELECT 1 FROM xla_distribution_links xda1 WHERE xda1. 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. 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,. PA_DRAFT_REVENUES_ALL. INVOICE_TYPE_LOOKUP_CODE. October 10 / READ. and PROJECT_ID=. This is defaulted to a project from the project template. 0 and later: PJC: Oracle Fusion Project Cost Account Reconciliation Report. source_attribute1. 4. sum of the items raw cost distribution lines. 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. Goal. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. vendor_name. Title and Copyright Information; Get Help; 1 Overview. 785. 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. 10. 1. source_line_id_2. User-defined number that uniquely identifies the element within a project or structure. Teens. WHERE ei. Symptoms. attribute7. 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. 2. 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. expenditure_item_id AND expenditureitempeo. project_status, a. organization_id. Intern kicks of oracle invoice number tables after a template. 2. ref_ae_line_num IS NULL AND xda2. 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. 0. COST_ID: NUMBER: 18: Yes: Reference to the layer, write-off or transfer. 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. event_id = ccdl. FROM pjc_cc_dist_lines_all ccdl, pjc_cc_dist_lines_all ccdl_orig , XLA_EVENTS_GT imp. DENOM_CURRENCY_CODE. recalculate the revenue for an expenditure item. WHERE ccdl_orig. AP_INVOICE_DISTRIBUTIONS_ALL holds the distribution information that is manually entered or system-generated. pjc_cost_dist_lines_all Tables to get Project Plan and its Budget Amount. 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_MC_PRJ_AST_LINES_ALL is an MRC sub table of PJC_PRJ_ASSET_LNS_ALL. For example, to search for online classes only, select 'Online' in. 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. • All tables ending with the suffix _EN • All views listed in Tables Without WHO Columns. OVERLAY_DIST_CODE_CONCAT: VARCHAR2: 250:. Re: Needs PA, CM, FA base tables [ message #189829 is a reply to message #189618] Mon, 28 August 2006 00:54. source_prvdr_gl_date. We link PJC_COST_DIST_LINES_ALL table to XLA_AE_LINES table through XLA_DISTRIBUTION_LINKS table. We would like to show you a description here but the site won’t allow us. For indirect projects this flag is set. Report Description: Packing Slip report prints all the shipment information, usually packing slip. PA_CUST_REV_DIST_LINES_ALL. xla_ae_lines xal, pjc_exp_items_all peiThis table contains non-persistent data and is used to expose summary data to Essbase. projfunc_cost_exchange_rate src_projfunc_cost_xchng_rate, bre. 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. 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. Processing Start Date, calculated as the maximum award, project, task, assignment, or labor schedule start date. AS (SELECT DISTINCT GL. pjc_txn_xface_all: pjf_work_types_b: WORK_TYPE_ID: pjc_cost_dist_lines_all: pjf_work_types_b: WORK_TYPE_ID: Indexes. PROFILE OPTION NAME. The query uses the. inventory_item_id,i. WHERE ics. transaction_number. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. 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. 7. 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. The room and board residence hall cost for academic year 2023-2024 are:. For this request we need. 2. data_set_id data_set_id, ei. Project Portfolio. Use it if possible to enhance the performance. pjc_contract_line_id CONTRACT_LINE_ID/*Added for grants uptake*/, l. Piper Sandler Appoints Dustin Avey and Jeremy Gerber as Co-Heads of Public Finance. lookup_code. OLD_DIST_LINE_NUMBER: NUMBER: 18: Old invoice distribution line number. Main: 903. project_id = ppa. 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. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. 4 Important Tables of Oracle fusion user roles query 1. transaction_id =. 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,. March 5, 2010 in Oracle Projects Contracts. PJC: Add Project Validations Using Cost Collection Descriptive Flexfields In Invoice Page (Doc ID 2417605. The table has no primary key. OKE: Debug Mode. The import process overrides the cost center with this value. item_description. … 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. NAME expenditure_organization,. But i cant find any type join. Enter the lookup code for the type of invoice distribution that you want Payables Open Interface Import to create from this record. Who column: indicates the user who created the row. PA_COST_DIST_OVERRIDES stores configurations defined at the project level that redirect specific costs and revenue to another organization. AND imp. 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. 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. CREATION_DATE) EXP_CDL_DIST_CREATION_DATE, cdl. DENORM_TOP_ELEMENT_ID. Content (required):. We want to extract only those that are posted in GL. Cloud Applications. xda2. ref_ae_line_num = xda2. ← Configurator Concurrent Programs. 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. I have a script as below to link ra_cust_trx_line_gl_dist_all to xla_ae_lines for getting the xla accounting line detail. The line"s current cost amount in the reporting currency; split lines have a current cost <> original cost:. Determines the classification of the cross charge amount "Cost","Revenue" OBJECT_VERSION_NUMBER: NUMBER: 9: Yes:. Active: TRANSFER_COST_DIST_ACCOUNT: NUMBER: 18: Transaction transfer cost distribution account: Active: WAYBILL_AIRBILL: VARCHAR2: 20:. expenditure_type_id = pet. 1. COST_ID: NUMBER: 18: Reference to layer_cost_id, writeoff_cost_id,. Burdenable Raw Cost: ACCOUNTING_EVENT_ID: NUMBER: 18:. pjo_plan_line_details pjo_plan_lines pjo_planning_elements pjo_plan_versions_b. 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. Indexes. Home / Fusion / Query to Find NonBillable Expense in Oracle Fusion. (ORA_PJC_PROJECT_COST_ADJUSTMENTS_WITH_APPROVAL_DUTY)* NOTE: Both the seeded Project Accountant and Grants Accountant job roles have this duty assigned. 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. 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. Subledger Accounting (SLA) in R12. ae_header_id AND lnk1. LINE_TYPE_. 1. Information about the cost distribution of expenditure items for each reporting set of books. 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. The code you enter must be ITEM, TAX, MISCELLANEOUS, or FREIGHT. FROM pjc_cc_dist_lines_all ccdl, pjc_cc_dist_lines_all ccdl_orig , XLA_EVENTS_GT imp. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. 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. 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. 0 and later: How does one purge the data from the Project Costing Interface table:. This column contains the identifier of the Accounting Event in SLA. SELECT * FROM PJC_COST_DIST_LINES_ALL D, PJF_PROJECTS_ALL_B P. 1. The table AP_INVOICE_LINES_ALL used by Oracle Fusion to store the line level data of AP invoices. 1. INVENTORY_ORG_ID: NUMBER: 18: Indicates The Inventory Org To Which The Item Belongs. 2. Report message to a moderator. Summer Long - $1,800. , POD. Used to implement optimistic locking. pjc_billable_flag. Raw cost = (quantity * cost rate) This value should alwa. name; po_number. denom_burdened_cost AS amount. Validation. PA_MC_COST_DIST_LINES_ALL is an MRC sub table of PA_COST_DISTRIBUTION_LINES_ALL. Describes tables and views for Oracle Fusion Cloud Project Management. For external Oracle Import, this flag is derived from the setup data atProject, Task and Document Entry level. PJC_AWARD_DISTRIBUTIONS interfaces the data with invocation business functions. 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. Previous Next JavaScript must be enabled to correctly display this content . planned_amt, 0)) varienceBut we dont see any Column related to Person in PJC, COST DIST LINES ALL Table. Cost distribution. I am not even sure if that is the right. ae_header_id FROM xla_distribution_links xda2 WHERE xda2. 21. expenditure_type_id AND. expenditure_item_id. sql_statement; select cre. 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. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. 1) Last updated on FEBRUARY 21, 2021. cc_dist_line_id(+) = ccdl. The customer is linked to an NGN AR account set, the project account set is in NGN. expenditure_type_id pjf_projects_all_b ppab, pjf_projects_all_tl ppat, hr_all_organization_units hr, hr_all_organization_units hr1, hr_operating_units op, pjc_cost_dist_lines_all pcdl, pjf_exp_categories_tl pec, gl_code_combinations gcc, per_person_names_f ppn, pjb_rev_distributions prd, pjb_errors pe, xla_distribution_links xda, xla_ae_lines xal, ap_invoice. cc_dist_line_id(+) = ccdl. source_project_id. Transaction identifier of the burden cost. PJC_FUNDING_ALLOCATION_ID FUNDING_ALLOCATION_ID/*Added for grants uptake*/, POD. main. You can optionally redirect only certain. Cloud. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. ei_project_numbe. Summary: We are trying to find the lookup values for the field PJC_COST_DIST_LINES_ALL. The system generated number that uniquely identifies the work type. COST_BOOK_ID: NUMBER: 18: Cost book within the cost organization for which the distribution is created. Keyword Analysis & Research: pjc_cost_dist_lines_all in oracle fusionMetrics added for data validation. Tables and Views for Financials. Name of the pay element. name; pjc_context_category. Fixed date to find the effective rate of the bill rate or burden schedule when determining the transfer price for labor transactions. WHERE pcdl. When an asset line is initially created, this table contains one record for each cost distribution line summarized into the asset line. display_sequencePurpose of this report is to derive all projects expenditure and event details with cost information. pjc_contract_line_id CONTRACT_LINE_ID/*Added for grants uptake*/, l. expenditure_item_id, cdl_line_num, prvdr_gl_date, project_raw_costSELECT x. line_type in ('R', 'B') AND. pjc_expenditure_item_date. ,d. Used as a predefined finder to search the collection. SOURCE_LINE_ID_1:. attribute1. PJC_CONTRACT_LINE_ID CONTRACT_LINE_ID/*Added for grants uptake*/ FROM. 1) Last updated on MAY 27, 2022 Applies. Once all lines associated with a schedule are purged, the whole schedule is purged. 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,. This parameter restricts the number of resources returned. CREATED_BY EXP_CDL_DIST_CREATED_BY, trunc(cdl. NUMBER. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. source_line_id_3. 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. ae_line_num AND aeh1. A Junior College Owned & Operated By. 18. From my research, it seems that the OTL. Processing Start Date, calculated as the maximum award, project, task, assignment, or labor schedule start date. display_sequencePurpose of this report is to derive all projects expenditure and event details with cost information. Previous Page. 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. 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. CST_COST_DIST_LINES_I_GT. 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. GL_CODE_COMBINATIONS contains valid account combinations for each accounting flexfield structure within the Oracle Fusion General Ledger application. Title and Copyright Information; Get Help; 1 Overview 2 Asset TrackingTo see a listing of courses offered, click the “Course Search” link below. PJB_INV_CONFIG_DISTS_GT_U1. 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. 0 and later Information in this document applies to any platform. xda2. Oklahoma residents are charged out-of-district, not out-of-state tuition at PJC. 1. current_run_id extn_current_run_id, bre. ind_rate_sch_revision_idFROM 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. 1. pjc_cost_dist_lines_all: pjf_rate_overrides: RATE_OVERRIDE_ID: Indexes. Tags: PA. pjc_expenditure_type_id. Enter the lookup code for the type of invoice distribution that you want Payables Open Interface Import to create from this record. project_type,SUM(nvl(main. S. document_type. PJC_MC_PRJ_AST_LINES_ALL is an MRC sub table of PJC_PRJ_ASSET_LNS_ALL. VARCHAR2. PA_COST_DISTRIBUTION_LINES_ALL stores information about the cost distribution of expenditure items. expenditure_item_id. For external third party import, this flag should be populated while interfacing the data into PATI. A subledger journal entry can have a status of Draft, Final, Incomplete, Invalid or Invalid Related Entry. 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. PA_CUST_EVENT_RDL_ALL. In PJC_EXP_ITEMS_ALL are the columns ORIGINAL_HEADER_ID, ORIGINAL_LINE_NUMBER, ORIGINAL_DIST_ID. expenditure_item_id AND expenditureitempeo. ind_rate_sch_revision_id bre. LAST_UPDATED_BY EXP_CDL_LAST_UPDATED_BY. Solution. 0 and later. AND imp. How does the raw_cost_ccid on the pjc_cost_dist_lines_all table get populated? I see cost distributions and expenditures on a project from AP but when mapping the cost distribution back to the GL, i get no resultsLedger, corresponding to the cost organization book, where the distribution should be recorded. xcc_data_set_id data_set_id, to_char(cre. 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. Unique. PA. 0. Oracle Fusion Cloud Project Management. attribute4. Examples of when your Oracle Payables application automatically creates rows in this table include. transaction_number. OKE: Debug File Directory. dist_line_id_reversed. CONSUMPTION_ADVICE_HEADER_ID: NUMBER: 18:Feature. 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. Learn how to use a query in Oracle Fusion to find project estimation to complete based on budgeted and actual costs, hours, and revenue. 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,. prvdr_gl_date. source_header_id_1. 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. expenditure_item_id = expenditureitempeo. PROJFUNC_COST_RATE_TYPE: PJC_EXP_ITEMS_ALL: pjf_work_types_b: WORK_TYPE_ID: PJC_EXP_ITEMS_ALL: pjf_txn_sources_b:. 1. 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. 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,. name; award_distribution_line_id. 1. *****. expenditure_item_id = pei. 1. Required fields are marked. Content (required): Please help in identifying the column mapping on fusion application to get the Burdened cost in Receiver Ledger Currency. Tables and Views for Project Management. T. acct_event_id. ra_customer_trx_lines_all. approved_flag. An. 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. AND imp. pjc_capitalizable. 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. For capital projects this flag is used as capitalizable_flag. expenditure_item_id. transaction_number. Previous Page. From my research, it seems that the OTL timecard tables are HXT_TM_MTRX and HXT_TM_HEADER. COST_ID: NUMBER: 18: Yes: Reference to the layer, write-off or transfer. In this Document. Previous Next JavaScript must be enabled to correctly display this content . expenditure_item_date expenditure_item_date2. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. reserved_attribute1 reserved_attribute1, ei. Qn2:On : Customer is requesting a way to restrict specific expenditure types to. WHERE ics. approved_flag. 2. transaction_number. PJC_CONTRACT_LINE_ID: NUMBER: 18:. . PA_PROJECT_ASSET_LINES_ALL stores summarized project CIP cost lines. pa_date. xla_ae_lines ael1, xla_distribution_links lnk1, gl_code_combinations gcc1 , pjc_cost_dist_lines_all pcd where lnk1. CDL_LINE_TYPE: VARCHAR2: 1: The type of the cost distribution line: COMP_DETAILS_ID: NUMBER: 18: Reference to Labor Rate Override. Columns. tag. INV_TRANSFER_ORDER_PJC_V. This input is required to create reports, understand links between various charts, and even for troubleshooting purpose. R2. inventory_item_id,i. PA_COST_DIST_OVERRIDES stores configurations defined at the project level that redirect specific costs and revenue to another organization. WHERE ccdl_orig. 60 Per Share. 782. Dec 23, 2021 12:06PM edited Dec 23, 2021 12:08PM 1 comment. OKE_K_FIFO_LOG.