Flag that indicates whether the item is fully reversed or the item is one of the adjusting items that fully reverse another item. This report will display all project unbilled details. NUMBER. SELECT pcdl. Tables for the Items in Oracle fusion. A distribution must be associated with an invoice. Our support team constitutes of highly skilled & trained technicians who have years of experience in handling technical defects. Posts about Project Cost written by Pulkit jainhr_all_organization_units_tl trx_org, pjb_rev_distributions prd, per_person_names_f ppn, per_all_people_f papf WHERE 1 = 1 AND pei. FROM pjc_exp_items_all EXP , pjf_proj_elements_b pt , pjf_projects_all_b pp , pjf_exp_types_vl et , pjf_system_linkages_vl syslink, pjf_exp_categories_vl exp_cat, PJF_NON_LABOR_RES_VL non_lab_res, PJF_TXN_SOURCES_VL TXN_SRC, pjf_txn_document_vl TXN_DOC, PJF_TXN_DOC_ENTRY_VL TXN_DOC_ENTRY, HR_ALL_ORGANIZATION_UNITS_VL HR_ORG. PJC_COMMITMENT_TXNS: pjf_exp_types_b: EXPENDITURE_TYPE_ID: PJC_COMMITMENT_TXNS: pjf_system_linkages: SYSTEM_LINKAGE_FUNCTION:. expenditure_item_id. 1. Previous Page. segment1 project_number, NVL ((SELECT pt. 18. 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. This table is used to store the errors that could ocurr in various processes in project billing. source_project_id. Goal. select a. NAME ei_expenditure_org_name, op. Project Description 3. Inventory item identifier and References {EGP_SYSTEM_ITEMS_B. Hi, I have a report with expenses using tables like (EXM_EXPENSES, exm_expense_reports, exm_expense_types, EXM_EXPENSE_DISTS, pjc_exp_items_all, ap_invoices_all and ap_invoice_distributions_all). 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_item_id = pei. Result: So if you pass ExpenditureItemId, ExternalBillRateSourceName values to REST service, it’ll update the attribute ‘EXT_OVRD_BILL_RATE_SOURCE_NAME’ with the value coming from ‘ExternalBillRateSourceName’ for the already exist record with given ExpenditureItemId. denom_currency_code. crt. Flag that indicates whether the work type is billable or capitalizable. Inventory item identifier and References {EGP_SYSTEM_ITEMS_B. VARCHAR2. Extract for Payments - Check and EFT. AP_Invoices_All has the unique key on invoice_id. project_id AND pei. AP_INVOICES_ALL is the parent table of AP_INVOICE_LINES_ALL table which is used to store the Invoice Line Details. User-defined number that uniquely identifies the element within a project or structure. Enter information into the employee number field (automatically entered in Oracle Personal Time and Expense). 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. invoice_id AND aid. 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_exp_items_all pei. document_id = ei. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. There select the Expenditure Items API, you’ll be able to see all the methods, select required method (In our case select. . project_id = prb. Base Table: PJC_EXP_ITEMS_ALL Import Process: Import Costs STEP 1: Download FBDI template from oracle website. organization_id = aid. expenditure_item_id, expenditureitempeo. TRANSFERRED_FROM_EXP_ITEM_ID. Also PO_DISTRIBUTIONS_ALL is the table which in my experience connects Purchase. name; invoice_number. I want to get the. project_id AND pei. Object owner: PJC. Stores receipt number for purchase order transactions and PO number or invoice number for expense adjustment transaction. Foreign Keys to Important PJC_EXPENDITURE_ITEMS_ALL Table Fields. expenditure_item_id = cdl. expenditure_item_id. ← Configurator Concurrent Programs. Who column: indicates the date and time of the creation of the row. An expenditure item with the same transaction source and original system reference already exists. invoice_id AND aid. quantity. WHERE EXP. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. PJF_EXP_TYPES_VL. expenditure_item_id. AND imp. Object type: TABLETO_CHAR (acct_period_date, 'DD-MON-YYYY') expenditur_item_date FROM (SELECT v36738276. Simply search with the table name in google, you’ll get complete details about the table and columns in it. FROM pjf_projects_all_vl PPA,pjb_cntrct_proj_links PCPL,okc_k_lines_b OKL,okc_k_headers_all_b OKH,okc_contract_types_vl OCTV,pjf_project_types_vl PPT,hr_all_organization_units HOUPA_EXPEND_ITEM_ADJ_ACTIVITIES stores audit records of actions chosen by users in any of the Oracle Projects expenditure adjustment windows that may cause adjustments to the cost, revenue, and/or invoice amounts of an expenditure item. Joining these tables, there are rows with opposite capitalizable_flag in two tables. It also includes some PO data and project data as well. PJC_ACCT_SWEEPER_LOGS: pjc_exp_items_all: EXPENDITURE_ITEM_ID: Indexes. zip file in local system using “Generate CSV File” option. 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. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. Examples of when your Oracle Payables application automatically creates rows in this table include. Find the query of Receivable (AR) for the Invoice Number (TRX_NUMBER) Wise, Customer wise, Sales Order Wise, Transaction Date and GL Date Wise in Oracle Apps EBS R12. full_name AS employee_name,. Value will be RCV. Skip to Content; Skip to Search; Home; Cloud ApplicationsIf 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. To get the. All Revenue Management. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. entered_currency_codeIt can be R (raw) or B (burdened) Cost type of offset transactions. rev_distribution_id. invoice_num as "Invoice Number" , replace ( replace ( aida . NAME AS expenditure_org, v55152034. LINKED_PROJECT_ID, ERRORING_PROCESS, TRANSACTION_TYPE_CODE. expenditure_item_id = cdl. Tablespace: FUSION_TS_TX_DATA. The before_after_flag will specify whether the record has pre-update or post-update values. 90; ADJUSTED_EXPENDITURE_ITEM_ID: 1993042; Project: 4056; For Item ID 1993042: Created: 14/02/2020 14:04:46; Quantity: 110. Who column: indicates the date and time of the creation of the row. creation_date5 AS acct_period_date, v103611946. project_type_id = ppt. Extract for Payments - Check and EFT. Users are writing an audit report so that they can show the AP invoices that were entered that generated PA Expenditure Items. This information will be interfaced to Oracle General Ledger from Oracle Projects. Qn1:On : 11. expenditure_type_id. 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. INVENTORY_ITEM_ID. Requirement: --------------- 1. Details. pjc_expenditure_item_date expenditure_item_date, crt. 5. person_type person_type, expenditureitempeo. source_attribute2Goal. Details. Oracle Projects provides all system linkages upon installation. Comment - Asset Source Line I need above fields will be in the fixed asset module 1. Value will be RCV. usages_source_version. period_name PERIOD_NAME. line_type. State 2. Object owner: PJC. Required fields are marked. project_id, expenditureitempeo. project_id = ptv. expenditure_item_id. SQL_Statement. inventory_item_id}. FROM hwm_tm_rep_atrbs PjcExpAtrbs, hwm_tm_rep_atrb_usages PjcExpAtrbsUsg, HWM_TM_ATRB_FLDS_B PjcExpAtrbFlds. cdl. NUMBER. 11. The table PJC_EXP_ITEMS_ALL has a foreign key to PJF_PROJ_ELEMENT as the Task table. ei_project_name, x. INVENTORY_ITEM_ID. , revdist. TRANSACTION_IDTable Foreign Table Foreign Key Column; PJC_PATI_ADJ_QUEUE: pjc_exp_items_all: 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. cost_book_id, ct. This web page provides a list of tables and views for Oracle Fusion Cloud Project Management, a cloud-based application for project portfolio management. DENORM_TOP_ELEMENT_ID. We would like to show you a description here but the site won’t allow us. Object type: TABLE. project_type_id. /* 1. 18. 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. , revdist. CATEGORY_ID ITEM_CATEGORY. Schema: FUSION. expenditure_item_id AND ptv. project_id = pei. PA_CC_DIST_LINES_ALL stores information about the accounting distributions related to transfer price for cross charged expenditure items. AND imp. They would like to replicate this for custom reporting. The relationships between Expenditure Types and System Linkages. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. PREDEFINED_FLAG = 'Y'. source_id_int_1 = cdl. Details. ei_revenue_distributed_flag, x. task_id(+) AND pei. task_id = ptv. expenditure_item_id. transaction_source_id, expenditureitempeo. linked_task_id. inventory_item_id, NULL resource_id,I have configured the following DFF: 'Project Expenditure Item' It did not import any data to the IE's: I have then tried to configure these DFF's: 'Project Unprocessed Expenditure Item' Imported new transactions, but still no DFF values. posted_flag. sql file in patch 13833481. source_task_id. Any idea in which table this can be found or any query to achieve this. PJC_PRJ_PO_DIST_V. 2. event_id = cdl. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. Applies to: Oracle Project Costing - Version 11. 11. pjc_task_id task_id, crt. PJC_TRANSACTION_CONTROLS. 11. Project Management. project_id AND pei. FROM pjc_exp_items_all pei, pjf_projects_all_vl ppa, pjb_bill_trxs pbt, pjb_inv_line_dists pild, pjb_invoice_lines pil,. cmr_rcv_transaction_id. Stores receipt number for purchase order transactions and PO number or invoice number for expense adjustment transaction. Goal. Asset Cost 6. So let’s go with the specific requirement that to update Expenditure Items table (pjc_exp_items_all). Task Number 4. GL Account analysis for PA Events */. Stores expenditure type exclusions by interest rate code for each operating unit. Title and Copyright Information; Get Help; 1 Overview. Details. FROM PJC_EXP_ITEMS_ALL EXP, PJF_TXN_SOURCES_B TSRC, PO_LINES_ALL POL. TRANSACTION_SOURCE_ID. 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. Tablespace: APPS_TS_TX_DATA. creation_date5 AS acct_period_date, v103611946. So let’s go with the specific requirement that to update Expenditure Items table (pjc_exp_items_all). Now we need to join one of above table to ap_invoice_distributions_all table to get the distribution_id and later on we will join invoice_id and Invoice_distributoin_id to get expenditure_item_id from pjc_exp_items_all table. source_pa_date. Query. . system_linkage_function /* 30623237 (SELECT exp. NUMBER. § Ensure that all issues, receipts, and adjustments have been entered and verify that no hard copy records exist or are awaiting data entry. Title and Copyright Information; Get Help; 1 Overview. Relationship between AP invoice line items and Distributions. e. 23B. 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, pjc_exp_comments pec1, pjf_exp_types_vl pet,. Examples of system linkages (Expenditure Type Classes) are: Expense Report, Usages, and Straight Time. TRANSACTION_SOURCE_ID = TSRC. denom_amountPurpose of Report: For the Work Order Execution of the MP battery, the production operator prints the Name Plate Label which contains the description of the product, logo, Designation, Type of MP Battery, Battery Number, Tray Number, Serial Number, Date, Nominal Voltage, Capacity, Number of cells, Weight, Volume of Acid,. 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. An invoice can have multiple distributions. TRANSACTION_NUMBER. NAME ei_prvdr_org_name, hr1. project_id = prl. project_number, a. cmr_rcv_transaction_id = crt. 50. Check if the inventory item is valid. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. So let’s go with the specific requirement that to update Expenditure Items table (pjc_exp_items_all). LAST_UPDATED_BY EXP_CDL_LAST_UPDATED_BY. Regards, Zahid Rahim. 0 and later Information in this document applies to any platform. AND crt. which GL accounts will be hit by the system. PJC_CC_DIST_LINES_ALL. /*2. project_name,Possible values A - successfully interfaced to projects, P-interfaced to projects and waiting for projects' cost processing, R- rejected, F- failed to interface. project_id = pei. Other modules related tables list here : Tables for the PO (Purchase Order) in Oracle fusion. I can see on PJC_EXP_ITEMS_ALL that there is: Item ID 1993045 Created: 14/02/2020 14:06:31; Quantity: -110. The PJC_PRJ_REQ_DIST_V view displays attributes such as requisition number, item description, and vendor name. From my research, it seems that the OTL timecard tables are HXT_TM_MTRX and HXT_TM_HEADER. Simply search with the table name in google, you’ll get complete details about the table and columns in it. hr_all_organization_units_tl trx_org, pjb_rev_distributions prd, per_person_names_f ppn, per_all_people_f papf WHERE 1 = 1 AND pei. The identifier of the top task to which this tasks rolls up. PJC_EXP_ITEMS_ALL_N38: Non Unique: Default: PARENT_HEADER_ID: PJC_EXP_ITEMS_ALL_N39: Non Unique:. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. All, Can anyone provide me a table level link to the Oracle iExpenses tables, AP_EXP*REPORT* tables and the AP_INVOICES/AP_INV. pjc_exp_items_all expeo, pjf_projects_all_vl prj, pjf_proj_elements_vl trn_tsk, RA_CUSTOMER_TRX_all RCTA, RA_CUST_TRX_TYPES_ALL RACTL, PER_PERSON_NAMES_F_V PersonNameDPEO, PER_ALL_ASSIGNMENTS_M PAAM, PER_PERSON_TYPES_vl PPTL. attribute_number1 Pjc_Project_Id, ProjectsAtrbs. | Data Managementexpenditure_item_id source_exp_item_id, line_num source_line_num, expenditure_item_date source_exp_item_date, burden_cost source_burden_cost, denom_burdened_cost source_denom_burdened_cost, acct_burdened_cost source_acct_burdened_cost, project_burdened_cost source_project_burdened_cost,. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. The inventory item associated with the incurred cost. PJC_ALLOC_RULES_ALL: pjf_exp_types_b: OFFSET_EXP_TYPE_ID: PJC_ALLOC_RULES_ALL: pjf_projects_all_b: OFFSET_PROJECT_ID: PJC_ALLOC_RULES_ALL: pjf_proj_elements_b:. TRUNC (peia. VARCHAR2. AND TSRC. contract_id. PA_TXN_INTERFACE_AUDIT_ALL is used for auditing the updates taking place on PA_TRANSACTION_INTERFACE_ALL table. PJC_PROJECT_ID = ppat. Indicates an expenditure batch that will be imported from the PJC_EXP_ITEMS_ALL table. inventory_item_id}. project_id AND ptv. PO_LINE_ID = EXP. Next Page. pei. INVENTORY_ITEM_ID. 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. We want to derive the Accounting Code Combination based on Expenditure Types. TRANSACTION_NUMBER. There select the Expenditure Items API, you’ll be able to see all the methods, select required method (In our case select. Contents. 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. system_linkage_function FROM pjc_Exp_items_all exp WHERE exp. attribute_varchar1 Pjc_Billable_Flag, ProjectsAtrbs. Index Uniqueness Tablespace Columns; PJC_TXN_UPGRADE_TEMP_U1: Unique: Default: PK1_ID: This table is used in work type upgrade process as temporary table . AND TSRC. project_id. 10. cdl_line_number. They use stored queries that derive data from the tables on which the views are based. The errors are recorded against a transaction (identified by TRANSACTION_TYPE_CODE and. When a cost distribution program processes an expenditure item, it creates one or more corresponding cost distribution lines to hold the cost amounts and the general ledger account information to which the cost amounts will post. It doesn’t matter how complex the issues would be. AND POL. Tables and Views for Project Management. 1. source_attribute1. distribution_line_number. Based on the Event Processing Method defined at the project level, capital events are system generated or entered manually. acct_event_id. project_organization_name, a. For third party integrations, the customer may interface the name or the identifier. WHERE(invoiceheadereo. Possible values are S for Submitted,P for Processed and E for Error: ADJUSTMENT_FLAG: VARCHAR2: 1: Indicates whether the batch that will be impoted is for expenditure item adjustments: CREATION_DATE:. Transaction controls are used to control what expenditure items can be charged to a particular project or task, and whether the items are non-billable. tm_rep_atrb_id Pjc_Exp_Time_Repos_Atrb_id, PjcExpAtrbs. source_prvdr_gl_date. Object type: TABLE. , revdist. Object owner: PJC. name; application_id. Please help. 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 Applications P2P,O2C R2R, BI, Oracle Fusion Application, Oracle E Busines Suite, Oracle Financials, SLA, MPA, Functional, Technical,The system generated number that uniquely identifies the work type. expenditure_item_id = RevDist. operating_unit_name, a. PJC_TXN_UPGRADE_TEMP: pjc_exp_items_all: PK1_ID: Indexes. Unit Number 4. accounting_period AS GL_PERIODNow we need to join one of above table to ap_invoice_distributions_all table to get the distribution_id and later on we will join invoice_id and Invoice_distributoin_id to get expenditure_item_id from pjc_exp_items_all table. SELECT ppa. WHERE EXP. SELECT PjcExpAtrbs. TRANSACTION_SOURCE = 'OSCM'. Oracle ERP/ FSCM The table PJC_EXP_ITEMS_ALL has a foreign key to PJF_PROJ_ELEMENT as the Task 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. NAME project_owning_org, CASE WHEN. Used to implement optimistic locking. in pjc_exp_items_all are the columns original_header_id, original_line_number, original_dist_id. 1) Last updated on JULY 25, 2023. invoice_line_number = ail. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. Generate Draft Invoice uses the flag to exclude fully reversed, uninvoiced items from a customer invoice. ERROR_ID. . There select the Expenditure Items API, you’ll be able to see all the methods, select required method (In our case select. txt), PDF File (. AND ct. How can I Link what exists in the Project Costing Table (PJC_EXP_ITEMS_ALL) with what is Accounted for, through the SubLedgerAccounting (SLA), for a Receipt Accounting origin?Greetings and thanks in advance. task_id = pei. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. expenditure_item_id = pei. NAME AS expenditure_bu, v515220161. 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. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. Oracle ERP/ FSCM The table PJC_EXP_ITEMS_ALL has a foreign key to PJF_PROJ_ELEMENT as the Task table. This causes some records to exist with NULL values in the DOCUMENT_DISTRIBUTION_ID in the PA_EXPENDITURE_ITEMS_ALL table. 50. Task Description 5. project_id AND pei. pjc_exp_items_all expenditureitempeo, pjf_exp_types_vl pet. PJB_ERRORS. . There can be only one record for the combination of Supplier and the invoice number. The labor cost multiplier is populated for all overtime expenditure items charged to the task upon manual entry of the items or in the Overtime Calculation program **. attribute_category Pjc_Expenditure_Type, PjcExpAtrbsUsg. Cloud Applications. 1. description. PJB_ERRORS_U1. AP_INVOICE_DISTRIBUTIONS_ALL holds the distribution information that is manually entered or system-generated. event_id = cdl. val_unit_id, ct. approved_flag. 3 there are some records with data corruption as reported in the r13833481. line_num_reversed. However, the IDs in PJC_EXP_ITEMS_ALL columns don't match any IDs in the HXT tables. pjc_exp_items_all pei, okc_k_headers_all_b okha, hz_cust_accounts hca, hz_parties hp,. Project Contracts Profile Options →. system_linkage_function /* 30623237 (SELECT exp. PJC_ORGANIZATION_ID 1. A technology service company that provides innovative solutions around the oracle platform With Laser focus on customer delight as the primary success parameter. source_id_int_1 = cdl. Source Line Description 7. 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 my recent project, I have asked to write an outbound interface from Oracle Apps Fixed Assets R12 module to external legacy systems. 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. contract_type_id. project_currency_code ei_project_currency_code, hr. TRANSFERRED_FROM_EXP_ITEM_ID: NUMBER (15) The identifier of the expenditure item from which this expenditure item originated. expenditure_item_id = RevDist. Project Portfolio. CONNECTOR FIVETRAN_SCHEMA_NAME FIVETRAN_TABLE_NAME SOURCE_DATABASE_TABLE_MAPPING Oracle Fusion FSCM (ERP & SCM). 90; TRANSFERRED_FROM_EXP_ITEM_ID = 1612017; Project: 4056; There is another Item ID, 1993043, which also has the. 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. r_company, x. Find the query of Receivable (AR) for the Invoice Number (TRX_NUMBER) Wise, Customer wise, Sales Order Wise, Transaction Date and GL Date Wise in Oracle Apps EBS R12. Cloud. AND imp. project_status, a. Tags: PA. override_. ,pjc_exp_items_all PEI ,pjf_projects_all_vl PPA ,pjf_tasks_v PT ,okc_k_headers_all_b OKH ,okc_k_lines_b OKL ,pjf_txn_sources_vl PTS ,hr_operating_units HOU ,pjf_exp_types_vl PET ,pjf_exp_categories_vl PEC ,per_person_names_f PPN ,per_all_people_f PPF ,poz_suppliers_v PS. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. AND imp. expenditure_item_id = pec. Oracle Projects creates expenditure groups for supplier invoices transferred from Oracle Payables. 23B. system_linkage_function /* 30623237 (SELECT exp. There select the Expenditure Items API, you’ll be able to see all the methods, select required method (In our case select. line_number. Project Foundation, Project Costing, Project Billing, Project Control. Oracle ERP/ FSCM. Cost associated with each expenditure type is excluded from the capitalized interest calculation. . transaction_id, 'CST_TRANSACTIONS' source_table, ct. 50. organization_id =ACTUAL BEHAVIOR. 1. acct_event_id. (EMP_MAND_FOR_. . 14. attribute_number2 Pjc_Task_Id, ProjectsAtrbs.