AP_INVOICE_LINES_ALL contains records for invoice lines entered manually, generated automatically or imported from the Open Interface. XLA_AE_LINES, XLA_AE_HEADERS, AP_INVOICES_ALL, AP_SUPPLIERS, GL_CODE_COMBINATIONS. validation_status_code validation_status_code,. We would like to show you a description here but the site won’t allow us. possible vlaues I,P,R,E. Item Cost Comparison CAC Intercompany SO Shipping. The system generated number that uniquely identifies the work type. WHERE ccdl_orig. expenditure_item_id. WHERE ics. PJC’s Brewer drafted by Yankees (2022) Beau Brewer of McKinney,. PJC_CC_DIST_LINES_N1: Non Unique: Default: PROJECT_ID, TASK_ID: PJC_CC_DIST_LINES_N2:. FROM pjc_cc_dist_lines_all ccdl, pjc_cc_dist_lines_all ccdl_orig , XLA_EVENTS_GT imp. event_type_code, 'retro. CREATION_DATE) EXP_CDL_DIST_CREATION_DATE, cdl. 4 Important Tables of Oracle fusion user roles query 1. display_sequencePurpose of this report is to derive all projects expenditure and event details with cost information. source_line_id_2PJC_PRJ_ASSET_LNS_ALL. Advising and Counseling. Inventory Transactions subject area with 1 base metric. But i cant find any type join. WHERE ccdl_orig. EBS Tables. 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. attribute1. 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. Learn how to use a query in Oracle Fusion to find project estimation to complete based on budgeted and actual costs, hours, and revenue. Review the cost in the Project UI, it is not getting transferred to the Project. Founded In 1924. You can also narrow your search results by completing any of the additional fields. name columns; pjc_acct_sweeper_logs_pk. 1. t costs are also not populated. creation_date. Paris, Texas 75460. Provision with single sign-on. See Reference for Oracle Fusion CX Analytics. The identifier of the top task to which this tasks rolls up. end_date_active. BILLABLE_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. trunc(cdl. User-defined number that uniquely identifies the element within a project or structure. requestor_nameEnd date of the payroll period. name; po_number. Project Contracts Profile Options →. Through testing we decided we just need one by expend…Subject: SQL query to get the Project Details, Contract Details, Invoice Details--SQL Query:--SELECT. Item Costs CAC Intercompany Relationship Setup CAC Intercompany SO Price List CAC Intercompany SO Price List vs. Index Uniqueness Tablespace Columns Status; PJF_PERIODS_ALL_N1: Non Unique: FUSION_TS_TX_DATA: STATUS,. RAW_COST: NUMBER (22) ORG_ID: NUMBER (15) OUTPUT_VAT_TAX_ID: NUMBER: Default output tax code identifier for invoice line: OUTPUT_TAX_EXEMPT_FLAG: VARCHAR2 (1). ae_line_num AND aeh1. 1. 2. PJC: Oracle Fusion Project Cost Account Reconciliation Report (Doc ID 2121913. 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. 1. PA tables in fusionIf you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. enabled_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. acct_event_id. The identifier of the top task to which this tasks rolls up. 8) */CONNECTOR FIVETRAN_SCHEMA_NAME FIVETRAN_TABLE_NAME SOURCE_DATABASE_TABLE_MAPPING Oracle Fusion FSCM (ERP & SCM). ref_ae_line_num IS NULL AND xda2. quantity), 0) FROM pjc_cost_dist_lines_all. AP_INVOICE_DISTRIBUTIONS_ALL holds the distribution information that is manually entered or system-generated. I checked for this table PJC_COST_DIST_LINES_ALL and found these columns. SELECT FROM PJF_PROJECTS_ALL_B WHERE SEGMENT1='proj_nr'; -- note the project_id; 2. An invoice can have multiple distributions. 2. I can see that the Categories in the project show the NGN exchange rate. September 25 / READ. Paris, Texas 75460 Tel: (903) 785-7661 Contact Us. 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. 23C. PA_MC_COST_DIST_LINES_AR. PJC_AWARD_DISTRIBUTIONS interfaces the data with invocation business functions. 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. PJC: Add Project Validations Using Cost Collection Descriptive Flexfields In Invoice Page (Doc ID 2417605. inventory_item_id,i. pjc_capitalizable. Solution. Re: Needs PA, CM, FA base tables [ message #189829 is a reply to message #189618] Mon, 28 August 2006 00:54. pjc_cost_dist_lines_all: pjf_rate_overrides: RATE_OVERRIDE_ID: Indexes. Applies to: Oracle Fusion Project. Anyway, if sum (amt) for credits is "10" and sum (amt) for debits is "-10", then -sum (amt) for debits will be "10". . A distribution must be associated with an invoice. ind_rate_sch_revision_idbre. expenditure_item_date expenditure_item_date2. source_project_id. ref_ae_line_num IS NULL AND xda2. Oracle Fusion Project Costing Cloud Service - Version 11. and PROJECT_ID=. . name; award_distribution_line_id. 12. xla_ae_lines ael1, xla_distribution_links lnk1, gl_code_combinations gcc1 , pjc_cost_dist_lines_all pcd where lnk1. name AS Ledger_name, GJS. ref_ae_header_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,. Subledger Accounting (SLA) in R12. expenditure_item_id. A distribution must be associated with an invoice and invoice line. project_id = ppa. pjc_expenditure_item_date. WHERE ccdl_orig. Previous Next JavaScript must be enabled to correctly display this content . pjc_contract_line_id CONTRACT_LINE_ID/*Added for grants uptake*/, l. prvdr_gl_date. acct_event_id. We link PJC_COST_DIST_LINES_ALL table to XLA_AE_LINES table through XLA_DISTRIBUTION_LINKS table. 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 output should be Prepayment. name AS Ledger_name, GJS. reserved_attribute1 reserved_attribute1, ei. 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. approved_flag. pjc_task_id. 1. 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. line_type in ('R', 'B') AND 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. pa_date. transaction_id =. acct_event_id. An invoice can have multiple distributions. WITH gl_cmn_tbls. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. OKE: Debug File Directory. 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. 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,. Single column FK: Identifies the cost distribution header record. pjc_cost_dist_lines_all: pjf_rate_overrides: RATE_OVERRIDE_ID: Indexes. Hello All, > Oracle BI Publisher I have creating report using Oracle BI Publisher. NAME expenditure_organization,. expenditure_item_id. FROM. source_id_int_1 = ccdl. GL_CODE_COMBINATIONS contains valid account combinations for each accounting flexfield structure within the Oracle Fusion General Ledger application. Jpellman . InvoicesThey can be found in MetaLink, Knowledge, (scroll down left navigator) Online Documentation, last item. ref_ae_line_num = xda2. PrimaryKey: Finds all adjustments performed on the specified project cost. 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. 9. Cost distribution lines amount are implicitly debit amounts. PJC_MC_PRJ_AST_LINES_ALL is an MRC sub table of PJC_PRJ_ASSET_LNS_ALL. 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. It cc_process_labor_flag is set t. • All tables ending with the suffix _EN • All views listed in Tables Without WHO Columns. per_roles_dn 4. Paris, Texas 75460 Tel: (903) 785-7661 Contact Us. prvdr_gl_period_name gl_period, trx_org. WHERE ccdl_orig. ,d. organization_id. Examples of when your Oracle Payables application automatically creates rows in this table include. If the task is a top task, the top_task_id is set to its own task_id. 1. 1. Summary: Get all project costs Rest api not returning any values We are using below rest API to get all project cost details. ACCT_CURRENCY_CODE. User-defined number that uniquely identifies the element within a project or structure. pa_period_name. FROM pjc_cc_dist_lines_all ccdl, pjc_cc_dist_lines_all ccdl_orig , XLA_EVENTS_GT imp. CREATION_DATE: TIMESTAMP: Yes: Who. expenditure_item_id = expenditureitempeo. 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. For external Oracle Import, this flag is derived from the setup data atProject, Task and Document Entry level. AND imp. COST_ID: NUMBER: 18: Yes: Reference to the layer, write-off or transfer. **. 2. Pa_MC_Cost_Dist_Lines_ar is a table for Archive/Purge. v515220161. If the task is a top task, the top_task_id is set to its own task_id. 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. OKE_DEBUG_MODE. Table Foreign Table Foreign Key Column; PJF_PERIODS_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 It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. *****. This column contains the identifier of. 03 USD we need to make the cost line non billable. C for cost rate override and B for bill rate override. Cost organization of the transaction for which the distribution is created. We would like to show you a description here but the site won’t allow us. award_distribution_id. FROM. We would like to show you a description here but the site won’t allow us. Applies to:. WHERE ei. 1. If the task is a top task, the top_task_id is set to its own task_id. AS (SELECT DISTINCT GL. These lookup codes are stored in the AP_LOOKUP_CODES table. PA_CUST_REV_DIST_LINES_ALL does not reference any database object. Report message to a moderator. 0. Report Description: Packing Slip report prints all the shipment information, usually packing slip. **. 1) Last updated on NOVEMBER 08, 2022. 1) Last updated on MAY 27, 2022 Applies. items. source_line_id_3. ae_line_num, xda2. award_distribution_batch_id. AP_INVOICE_DISTRIBUTIONS. rounding_class_code = 'RAW_COST_CLEARING' AND NOT EXISTS ( SELECT 1 FROM xla_distribution_links xda1 WHERE xda1. User can “View Accounting” only after “Create Accounting” is run. My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts. CONTRACT_ID: NUMBER: 18: Identifier of the contract for which the rate override is defined. The schedule must be for the organization specified in the Submit Purge window. Solution. AP_INVOICE_DISTRIBUTIONS. 00; Paris Junior College 2400 Clarksville St. Active: TRANSFER_COST_DIST_ACCOUNT: NUMBER: 18: Transaction transfer cost distribution account: Active: WAYBILL_AIRBILL: VARCHAR2: 20:. source_id_int_1 = ccdl. Tags: PA. Column NameFlag that indicates if project related invoice distributions have been interfaced into Oracle Projects as committed cost. 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. Paris Junior College. name; lookup_type. FROM pjc_cost_dist_lines_all projectcostdistributionpeo, pjc_exp_items_all expenditureitempeo, pjf_exp_types_vl pet. 0 and later. ind_rate_sch_revision_id = irsr. 1. In this Document. S. 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. 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. We are trying to find the lookup values for the field PJC_COST_DIST_LINES_ALL. source_id_int_1 = ccdl. F81674-01. Collin County Community College District. Posted by Manjesh's Fusion World at 2:42 AM No comments: Email This BlogThis! Share to Twitter Share to Facebook Share to Pinterest. Oracle Apps R12 Sub ledger Accounting Tables and joins XLA Table joins GL_JE. 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_project_id. 21. 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. Schema: FUSION. source_header_id_1. 18. Solution. attribute2. , POD. WHERE pcdl. VARCHAR2. expenditure_type_id = pet. Processing Start Date, calculated as the maximum award, project, task, assignment, or labor schedule start date. Summary: Get all project costs Rest api not returning any values We are using below rest API to get all project cost details. 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. My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts. Loading. need_by_date. CONTRACT_LINE_ID:. CREATION_DATE) EXP_CDL_DIST_CREATION_DATE, cdl. CDL_LINE_NUM: NUMBER: 18: Line Number of the Cost Distribution Line. 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. cc_dist_line_id(+) = ccdl. Index Uniqueness Tablespace Columns; PJF_RATE_OVERRIDES_N1: Non Unique: Default:. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. project_id AND pbt. AND imp. You can optionally redirect only certain. 9. 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. Cloud. SELECT revenue_type, TO_CHAR (customer_id) customer_id, customer_name, TO_CHAR (project_id) project_id, project_number, contract_number,. 8. 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. Assignment ID related to the assignment record for this labor cost. current_run_id extn_current_run_id, bre. 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. PROJECT_ID. 1. Yes. PA_CUST_EVENT_RDL_ALL. FROM pjc_cc_dist_lines_all ccdl, pjc_cc_dist_lines_all ccdl_orig , XLA_EVENTS_GT imp. Tables and Views for Project Management. How can i join CE_EXTERNAL_TRANSACTIONS into GL_JE_LINES? I need external transactions accounting period and its account status. expenditure_item_id = pei. PA_COST_DISTRIBUTION_LINES_ALL stores information about the cost distribution of expenditure items. FROM pjc_cost_dist_lines_all projectcostdistributionpeo, pjc_exp_items_all expenditureitempeo, pjf_exp_types_vl pet WHERE (projectcostdistributionpeo. 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. expenditure_item_id = cdl. 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. 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. ever_approved_flag. An invoice can have one or more invoice lines. FROM pjf_burden_rate_extn bre, pjc_exp_items_all ei,. This column contains the identifier of the Accounting Event in SLA. ae_header_id = ael1. OKE_DEBUG_FILE_DIR. 1. 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. (ORA_PJC_PROJECT_COST_ADJUSTMENTS_WITH_APPROVAL_DUTY)* NOTE: Both the seeded Project Accountant and Grants Accountant job roles have this duty assigned. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. Previous Page. 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. id) Actual_Rev_ITD_Prj_Curr ,(SELECT NVL (SUM (projectcostdistributionpeo. PROJECT_ID =P. calc_burden_status extn_calc_burden_status, cdl. You can optionally redirect only certain. 6. dist_line_id_reversed. 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. 9. planned_amt, 0)) varienceBut we dont see any Column related to Person in PJC, COST DIST LINES ALL Table. R2. expenditure_item_id. There can be only one record for the combination of Supplier and the invoice number. PJC_CC_DIST_LINES_N1: Non Unique: Default: PROJECT_ID, TASK_ID: PJC_CC_DIST_LINES_N2:. source_pa_period_name. LAST_UPDATE_DATE) EXP_CDL_LAST_UPDATED_DATE, cdl. 5. ae_header_id FROM xla_distribution_links xda2 WHERE xda2. source_line_id_3. COST_ORGANIZATION_ID: NUMBER: 18: Yes: Cost organization of the transaction for which the distribution is created. Who column: indicates the date and time of the creation of the row. 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 expenditure. source_line_id_4. pjc_billable_flag. EVENT_ID: NUMBER: 18: Reference to the event created in the SLA for this distribution header line. Office & Switchboard Hours (all locations) Monday - Friday: 8AM - 5PM Greenville Center Tel: (903) 454-9333 Sulphur Springs Center Tel: (903) 885-1232 Help & Support. projfunc_cost_exchange_rate src_projfunc_cost_xchng_rate, bre. 0). ref_ae_header_id =. Oracle Application Wednesday, 28 December 2022PJC_XCC_BURDEN_DIST_ERRORS; PJC_XCC_BURDEN_DIST_ERRORS. For example, to search for online classes only, select 'Online' in. Content (required): I am trying to write a query to find the project number that was used in a reclassification journal. Summary: We have a requirement to create a report/integration listing Expenditure / Costing information along with Billing information. COST_BOOK_ID: NUMBER: 18: Yes: Cost book within the cost organization for which the distribution is created. 2) Run “Create Accounting” to populate accounting events (SLA) tables. pjc_contract_line_id contract_line_id/*added for grants uptake*/ from. dist_acct_raw_cost dist_acct_raw_cost, l. PJC_AWARD_DIST_LINES_U1. INVOICE_TYPE_LOOKUP_CODE. EVENT_ID: NUMBER: 18: Reference to the event created in the SLA for this distribution header line. current_run_id extn_current_run_id, bre. pjc_txn_xface_all: pjf_work_types_b: WORK_TYPE_ID: pjc_cost_dist_lines_all: pjf_work_types_b: WORK_TYPE_ID: Indexes. Contents. 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. 13. SELECT pcdl. Oracle Fusion Project Costing - Version 11. cc_dist_line_id(+) = ccdl. PA_PROJECT_ASSET_LINES_ALL stores summarized project CIP cost lines. CONTRACT_ID: NUMBER: 18: Identifier of the contract for which the rate override is defined. Index Uniqueness Tablespace Columns; PJF_WORK_TYPES_B_N1:It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. AND imp. pjc_project_id. acct_event_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. 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. 2400 Clarksville Street. source_id_int_1 = ccdl. Oracle Fusion Cloud Financials. 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. 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. transaction_id =. OKE: Debug Mode. WHERE ics. FROM. Fusion User Roles SQL Query & Tables. F81674-01. ,d. For external Oracle Import, this flag is derived from the setup data atProject, Task and Document Entry level. INVOICE_LINE_NUMBER: NUMBER: Invoice line number for parent line:. transaction_id =. How much does Paris Junior College cost?. These subject areas with base metrics are added to the automated validations for base metrics between the Oracle Applications Cloud source and Oracle Fusion Analytics Warehouse : Sales Orders subject area with 6 base metrics. PJC_MC_PRJ_AST_LINES_ALL is an MRC sub table of PJC_PRJ_ASSET_LNS_ALL. These lookup codes are stored in the AP_LOOKUP_CODES table. ei_project_name, x. 12. For indirect projects this flag is set. project_id AND pbt. 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. 13. 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.