Requirement: --------------- 1. Qn1:On : 11. They can go online to PA Expenditure Item Inquiry and drill back to to the AP Invoice using the 'Item Details' functionality. org_id employee_cost_org_id, pcdl. This query will show all the distributions that post from project invoices to GL. task_id. Tables for the Sales Contracts in Oracle fusion. Please help. PA_EXPENDITURE_GROUPS_ALL stores groups or batches of pre-approved expenditures entered by a user. 2 and laterHi 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 ManagementPrevious Next JavaScript must be enabled to correctly display this content . LAST_UPDATED_BY EXP_CDL_LAST_UPDATED_BY. Simply search with the table name in google, you’ll get complete details about the table and columns in it. Contents. attribute_category Pjc_Expenditure_Type, PjcExpAtrbsUsg. FROM PJC_EXP_ITEMS_ALL PEI WHERE PEI. Cost associated with each expenditure type is excluded from the capitalized interest calculation. 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. Examples of system linkages (Expenditure Type Classes) are: Expense Report, Usages, and Straight Time. pjc_expenditure_type_id = pet. Cloud Applications. 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. line_number AND ail. They use stored queries that derive data from the tables on which the views are based. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. VARCHAR2. 1) Last updated on JULY 25, 2023. The number of line items AP_INVOICE_LINES_ALL and Distribution AP_INVIOCE_DISTRIBUTIONS_ALL do not. WHERE EXP. inventory_item_id}. in pjc_exp_items_all are the columns original_header_id, original_line_number, original_dist_id. expenditure_item_id(+)PA_SYSTEM_LINKAGES stores system-defined categories used to determine how items should be processed. Details. name; invoice_number. There select the Expenditure Items API, you’ll be able to see all the methods, select required method (In our case select. INVENTORY_ITEM_ID. Value will be RCV. 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. Tablespace: APPS_TS_TX_DATA. Schema: FUSION. So let’s go with the specific requirement that to update Expenditure Items table (pjc_exp_items_all). Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. attribute_number1 Pjc_Project_Id, ProjectsAtrbs. /*2. State 2. description , chr (. expenditure_item_id = cdl. Check if the inventory item is valid. Used to implement optimistic locking. invoice_id = aid. project_status, a. Change the transaction source or original system reference of the expenditure item to be imported. . GL Account analysis for PA Expenditure */. TRANSACTION_IDIt is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. ct. Task Description 5. Stores expenditure type exclusions by interest rate code for each operating unit. /* 1. 15. Legal Entity 3. Joining these tables, there are rows with opposite capitalizable_fl… Accepted answerlooking for PVO for BICC SYNC having columns TXN_XFACE_CTRL_ID and USER_BATCH_NAME from Table PJC_EXP_ITEMS_ALL. We would like to show you a description here but the site won’t allow us. Project Name 2. pjc_exp_items_all pei,. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. expenditure_item_id. Our support team constitutes of highly skilled & trained technicians who have years of experience in handling technical defects. For any update on columns other than the system populated columns, two records are created in this table. source_task_id. ProjectsAtrbs. expenditure_item_id AND ptv. Cost distribution. All Revenue Management. LINKED_PROJECT_ID, ERRORING_PROCESS, TRANSACTION_TYPE_CODE. PJF_EXP_TYPES_VL. Details. WHERE pcdl. 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. Stores receipt number for purchase order transactions and PO number or invoice number for expense adjustment transaction. To get the. select a. 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. prvdr_gl_period_name gl_period, pcdl. ** COST_IND_RATE_SCH_ID:. TRANSFERRED_FROM_EXP_ITEM_ID. 14. line_number. Tags: PA. Tables for the AP Invoice in Oracle fusion. pjc_organization_id. NAME ei_expenditure_org_name, op. expenditure_item_id = pei. Object owner: PJC. invoice_id = ail. task_id = ptv. project_currency_code ei_project_currency_code, hr. 1. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. Asset Number 5. There is one row for each invoice distribution. AND ppald. TRANSACTION_NUMBER. AND imp. PJC_EXP_ITEMS_ALL ei, GET_PERIOD_AVG_RATE gpavg WHERE aia. sql file in patch 13833481. AS (SELECT DISTINCT GL. Next Page. NUMBER. So let’s go with the specific requirement that to update Expenditure Items table (pjc_exp_items_all). Project Contracts Profile Options →. . gl_date. NUMBER. 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:. It doesn’t matter how complex the issues would be. § Ensure that all issues, receipts, and adjustments have been entered and verify that no hard copy records exist or are awaiting data entry. R11i: PA: PAXTRAPE Incorrect Proj And Projfunc Burdened Cost (Doc ID 1543566. WHERE ei. tm_rep_atrb_id Pjc_Exp_Time_Repos_Atrb_id, PjcExpAtrbs. The attributes columns in PJC_EXP_ITEMS_ALL for my new transactions are also nullPJC_EXP_GROUPS_ALL. There can be only one record for the combination of Supplier and the invoice number. segment1 project_number, NVL ((SELECT pt. Version (include the version you are using, if applicable):This table contains non-persistent data and is used to expose summary data to Essbase. AP_INVOICE_DISTRIBUTIONS_ALL holds the distribution information that is manually entered or system-generated. pdf) or read online for free. usages_source_version. TRANSACTION_SOURCE_ID = TSRC. There is a invoiced_flag and ic_invoiced_flag(Invoiced flag for Inter company project) in the PJC_EXP_ITEMS_ALL table but I need the External Invoice Status. Object owner: PJC. , revdist. 50. PJC_EXP_ITEMS_ALL_N38: Non Unique: Default: PARENT_HEADER_ID: PJC_EXP_ITEMS_ALL_N39: Non Unique:. e. pjc_exp_items_all: pjf_proj_elements_b: TASK_ID: pjf_proj_elements_b: pjf_proj_elements_b: PARENT_STRUCTURE_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. task_id(+) AND pei. cost_org_id, ct. 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. event_id = cdl. invoice_date. Views are logical representations of a single or combination of tables. attribute_varchar1 Pjc_Billable_Flag, ProjectsAtrbs. name; application_id. 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. 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,. 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 = RevDist. An invoice can have multiple distributions. Fusion Inventory Queries2. TRUNC (peia. system_linkage_function /* 30623237 (SELECT exp. Fusion HCM - Query for Personal Payment Method Details. 90; ADJUSTED_EXPENDITURE_ITEM_ID: 1993042; Project: 4056; For Item ID 1993042: Created: 14/02/2020 14:04:46; Quantity: 110. pjc_expenditure_type_id expenditure_type_id, crt. transaction_id, 'CST_TRANSACTIONS' source_table, ct. pjc_capital_events Stores information about events used to group costs and assets for capitalization and events used to generate retirement cost adjustments. However, the IDs in PJC_EXP_ITEMS_ALL columns don't match any IDs in the HXT tables. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. ---------------. line_type. FROM pjc_exp_items_all pei, pjf_projects_all_vl ppa, pjb_bill_trxs pbt, pjb_inv_line_dists pild, pjb_invoice_lines pil,. Comment - Asset Source Line I need above fields will be in the fixed asset module 1. Task Number 4. txt), PDF File (. event_id = cdl. revenue_category. Tables and Views for Project Management; PJC_LOOKUPSGL Account analysis for PA Expenditure & Event query. expenditure_item_id AND ptv. PJB_ERRORS_U1. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. Goal. . PJC_ORGANIZATION_ID 1. So let’s go with the specific requirement that to update Expenditure Items table (pjc_exp_items_all). SELECT PjcExpAtrbs. ERROR_ID. 50. person_number AS employee_number,. ei_project_name, x. project_id AND hou. PA_CC_DIST_LINES_ALL stores information about the accounting distributions related to transfer price for cross charged expenditure items. Select aia . organization_id = ppat. PA_CC_DIST_LINES_ALL stores information about the accounting distributions related to transfer price for cross charged expenditure items. AP_Invoices_All has the unique key on invoice_id. 0 version, Manage Project Costs. 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. They would like to replicate this for custom reporting. STEP 2: Populate the data both PJC_TXN_XFACE_STAGE_ALL sheet of template as shown below. All, Can anyone provide me a table level link to the Oracle iExpenses tables, AP_EXP*REPORT* tables and the AP_INVOICES/AP_INV. Oracle ERP/ FSCM The table PJC_EXP_ITEMS_ALL has a foreign key to PJF_PROJ_ELEMENT as the Task table. project_id, ppa. expenditure_item_id = pec. PJC_ACCT_SWEEPER_LOGS: pjc_exp_items_all: EXPENDITURE_ITEM_ID: Indexes. It can be N (none) , A (source project and task), B (source project, use client extension for task), C (specific project and task) or D (use client extension for project and task) Allocation run status. Object owner: PJC. line_num_reversed. AR Transactions and Tax Query - India Localization. 18. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. 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. AND crt. Applies to: Oracle Project Costing - Version 11. WITH gl_cmn_tbls. 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. 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. Tables for the Items in Oracle fusion. source_project_id. 18. The errors are recorded against a transaction (identified by TRANSACTION_TYPE_CODE and. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. Indicates Balance type. expenditure_item_id. Tablespace: FUSION_TS_TX_DATA. Details. Object type: TABLE. document_id = ei. In the process of understanding the fixed assets tables, I have prepared few queries to fetch the different asset data from FA. 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. project_id AND ptv. transaction. Stores receipt number for purchase order transactions and PO number or invoice number for expense adjustment transaction. 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. Oracle ERP/ FSCM The table PJC_EXP_ITEMS_ALL has a foreign key to PJF_PROJ_ELEMENT as the Task table. Tables and Views for Project Management. source_pa_date. prvdr_pa_period_name, NVL (pei. NAME AS expenditure_org, v55152034. 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,. TRANSACTION_SOURCE_ID. This table is used to store the errors that could ocurr in various processes in project billing. pjc_expenditure_item_date expenditure_item_date, crt. system_linkage_function FROM pjc_Exp_items_all exp WHERE exp. ei_latest_gl_period_name, x. 0 version, Manage Project Costs-Allocate Project Costs. Extract for Payments - Check and EFT. WHERE(invoiceheadereo. Indicates an expenditure batch that will be imported from the PJC_EXP_ITEMS_ALL table. name; event_id. AND TSRC. source_attribute1. val_unit_id, ct. AP_INVOICES_ALL is the parent table of AP_INVOICE_LINES_ALL table which is used to store the Invoice Line Details. Unique. acct_event_id. 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). It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. PJF_TASKS_V. ← Configurator Concurrent Programs. AND TSRC. source_prvdr_gl_date. cmr_rcv_transaction_id = crt. Based on the Event Processing Method defined at the project level, capital events are system generated or entered manually. contract_type_id. PJC_TRANSACTION_CONTROLS. 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. This information will be interfaced to Oracle General Ledger from Oracle Projects. Cloud. Purpose of this report is to derive all projects expenditure and event details with cost information. API Create a valid category set. 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. VARCHAR2. 90; TRANSFERRED_FROM_EXP_ITEM_ID = 1612017; Project: 4056; There is another Item ID, 1993043, which also has the. cost_book_id, ct. Object type: TABLE. It also includes some PO data and project data as well. After upgrading from 11i to 12. NAME AS expenditure_org, v55152034. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. expenditure_item_id AS expenditure_item_id,. 11. inventory_item_id}. project_id AND pei. 3 there are some records with data corruption as reported in the r13833481. The table PJC_EXP_ITEMS_ALL has a foreign key to PJF_PROJ_ELEMENT as the Task table. project_id = prb. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. PA_COST_DISTRIBUTION_LINES_ALL stores information about the cost distribution of expenditure items. contract_line_id. . 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,. I want to get the. pei. TRANSACTION_NUMBER. AND ppa. Project Portfolio. project_id = pei. AND imp. Date Placed in Service 8. project_type_id = ppt. Other modules related tables list here : Tables for the PO (Purchase Order) in Oracle fusion. Default. PO Number I need above. 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?-- Core processing tbale PJC_TXN_XFACE_ALL will be populated with all required ID columns after performing mapping of name to ID -- This control file can accept six different types of trasactions (Labor, Non Labor, Misc, Inventory, Supplier Invoices, Expenses) -- For each of above type, sequence of columns in CSV is defined as per following order. PJC_PRJ_PO_DIST_V. PA_TXN_INTERFACE_AUDIT_ALL is used for auditing the updates taking place on PA_TRANSACTION_INTERFACE_ALL table. Simply search with the table name in google, you’ll get complete details about the table and columns in it. Foreign Keys to Important PJC_EXPENDITURE_ITEMS_ALL Table Fields. Query. SELECT pcdl. system_linkage_function /* 30623237 (SELECT exp. Unit Number 4. FROM PJC_EXP_ITEMS_ALL EXP, PJF_TXN_SOURCES_B TSRC, PO_LINES_ALL POL. posted_flag. Project Portfolio. approved_flag. 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. expenditure_item_date) ei_expenditure_item_date, peia. task_id = ptv. r_company, x. expenditure_item_id(+)name; source_bu_id. Enter information into the employee number field (automatically entered in Oracle Personal Time and Expense). AND POL. distribution_line_number. E means Encumbrance entry. Who column: indicates the date and time of the creation of the row. TO_CHAR (acct_period_date, 'DD-MON-YYYY') expenditur_item_date FROM (SELECT v36738276. TRANSACTION_NUMBER. 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 web page provides a list of tables and views for Oracle Fusion Cloud Project Management, a cloud-based application for project portfolio management. expenditure_item_id), 'OPEN') CINT_CDL_STATUS, gps. The errors are recorded against a transaction (identified by TRANSACTION_TYPE_CODE and corresponding id). We want to derive the Accounting Code Combination based on Expenditure Types. VARCHAR2. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. If the task is a top task, the top_task_id is set to its own task_id. Who column: indicates the date and time of the creation of the row. invoice_id AND aid. Now it is showing Project Cost transaction reference for all expense types except "Itemized Expense". 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. PO_LINE_ID = EXP. pjc_task_id task_id, crt. source_id_int_1 = cdl. This expenditure item is the new item that is system created when an item is transferred and is charged to the new project/task: CONVERTED_FLAG: VARCHAR2 (1) Flag set to 'Y' if the item is converted. WHERE 1 = 1. task_id. Required fields are marked. Index Uniqueness Tablespace Columns; PJC_ACCT_SWEEPER_LOGS_N2: Non Unique: Default: PJS_SUMMARY_ID: PJC_ACCT_SWEEPER_LOGS_N3: Non Unique: Default: PROJECT_ID: PJC_ACCT_SWEEPER_LOGS_U1:The flag indicates whether to create expenditure items automatically Y means release automatically: DUP_TARGETS_FLAG:. WHERE ei. 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. carrying_out_organization_id AND hou1. PARENT_LINE_NUMBER. Previous Next JavaScript must be enabled to correctly display this content . project_id = PPA. SELECT EXP. Flag that indicates whether the item is fully reversed or the item is one of the adjusting items that fully reverse another item. attribute_number2 Pjc_Task_Id, ProjectsAtrbs. Inventory item identifier and References {EGP_SYSTEM_ITEMS_B. project_id AND ptv. 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,. contract_id =. ,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. WHERE pcdl. Previous Next JavaScript must be enabled to correctly display this content . The reason why the distribution is created by linking to the invoice line and the line and the distribution are not limited to one to one. Schema: FUSION. override_. EXPENDITURE_ITEM_ID EXP_ITEM_ID, POL. Title and Copyright Information; Get Help; 1 Overview. 1. operating_unit_name, a. line_number. zip file in local system using “Generate CSV File” option. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. This number is incremented every time that the row is updated. 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. 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. It can be B (burdened) or R (raw) Offset method. 50. inventory_item_id}. Schema: FUSION. NAME AS expenditure_bu, v515220161. 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:. project. AND imp. 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. document_id, expenditureitempeo. 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. 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. The flag indicates whether to create expenditure items automatically Y means release automatically: DUP_TARGETS_FLAG:. Stores receipt number for purchase order transactions and PO number or invoice number for expense adjustment transaction. TRANSACTION_IDFROM pjc_exp_items_all peia, pjf_exp_types_vl pet, pjf_tasks_v ptv, 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. . 5. CONNECTOR FIVETRAN_SCHEMA_NAME FIVETRAN_TABLE_NAME SOURCE_DATABASE_TABLE_MAPPING Oracle Fusion FSCM (ERP & SCM). 2. WHERE EXP. attribute_number7 Pjc_Work_Type,. project_id = ptv. Object type: TABLE. 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 PJC_CC_DIST_LINES_ALL. Extract for Payments - Check and EFT.