Object type: TABLETO_CHAR (acct_period_date, 'DD-MON-YYYY') expenditur_item_date FROM (SELECT v36738276. 23B. sql file in patch 13833481. event_id = cdl. PO_LINE_ID = EXP. transaction_id, 'CST_TRANSACTIONS' source_table, ct. AND imp. creation_date5 AS acct_period_date, v103611946. Details. NAME ei_prvdr_org_name, hr1. 11. Project Contracts Profile Options →. Please help. description. Inventory item identifier and References {EGP_SYSTEM_ITEMS_B. TRANSFERRED_FROM_EXP_ITEM_ID. 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. Goal. 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. in pjc_exp_items_all are the columns original_header_id, original_line_number, original_dist_id. WITH gl_cmn_tbls. override_. 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. 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. Fusion HCM - Query for Personal Payment Method Details. organization_id =ACTUAL BEHAVIOR. tm_rep_atrb_id Pjc_Exp_Time_Repos_Atrb_id, PjcExpAtrbs. The number of line items AP_INVOICE_LINES_ALL and Distribution AP_INVIOCE_DISTRIBUTIONS_ALL do not. usages_source_id, PjcExpAtrbsUsg. Used to implement optimistic locking. The errors are recorded against a transaction (identified by TRANSACTION_TYPE_CODE and. 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. system_linkage_function /* 30623237 (SELECT exp. 18. name; event_id. The before_after_flag will specify whether the record has pre-update or post-update values. Other modules related tables list here : Tables for the PO (Purchase Order) in Oracle fusion. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. Qn1:On : 11. carrying_out_organization_id AND hou1. prvdr_pa_period_name, NVL (pei. 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:. Required fields are marked. E means Encumbrance entry. zip file in local system using “Generate CSV File” option. contract_id. PREDEFINED_FLAG = 'Y'. PA_CC_DIST_LINES_ALL stores information about the accounting distributions related to transfer price for cross charged expenditure items. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. 0 version, Manage Project Costs-Allocate Project Costs. 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). There select the Expenditure Items API, you’ll be able to see all the methods, select required method (In our case select. segment1 project_number, NVL ((SELECT pt. AP_Invoices_All has the unique key on invoice_id. Regards, Zahid Rahim. This report will display all project unbilled details. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. . txt - Free download as Text File (. Extract for Payments - Check and EFT. Unique. attribute_number1 Pjc_Project_Id, ProjectsAtrbs. expenditure_item_id. usages_source_version. AND ppald. Tables for the Items in Oracle fusion. project_id = pei. , revdist. Cost distribution. 1. . Check if the inventory item is valid. WHERE(invoiceheadereo. 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,. inventory_item_id}. Indicates an expenditure batch that will be imported from the PJC_EXP_ITEMS_ALL table. 1. expenditure_item_id = pei. Query to Find Projects Not Accruing Revenue in Oracle Fusion --*-- SELECT PE. TRUNC (peia. Schema: FUSION. Based on the Event Processing Method defined at the project level, capital events are system generated or entered manually. Oracle ERP/ FSCM. Who column: indicates the date and time of the creation of the row. project_id AND hou. Foreign Keys to Important PJC_EXPENDITURE_ITEMS_ALL Table Fields. 23B. Tablespace: APPS_TS_TX_DATA. There is one row for each invoice distribution. TRANSACTION_IDIt is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. Project Management. task_id. pjc_expenditure_type_id expenditure_type_id, crt. Our support team constitutes of highly skilled & trained technicians who have years of experience in handling technical defects. invoice_id = ail. 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. ei_revenue_distributed_flag, x. Base Table: PJC_EXP_ITEMS_ALL Import Process: Import Costs STEP 1: Download FBDI template from oracle website. Projects Self Service Reporting Duty. Requirement: --------------- 1. In my recent project, I have asked to write an outbound interface from Oracle Apps Fixed Assets R12 module to external legacy systems. posted_flag. 11. line_type. Stores receipt number for purchase order transactions and PO number or invoice number for expense adjustment transaction. operating_unit_name, a. ei_project_name, x. 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. project_id AND pei. Schema: FUSION. Applies to: Oracle Fusion Project Costing Cloud Service - Version 11. project_id AND pei. 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. r_company, x. NUMBER. /* 1. inventory_item_id}. reversing_line_flag. distribution_line_number. expenditure_item_id = pei. ct. 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 **. The inventory item associated with the incurred cost. Get it resolved, from our Support team. Tables and Views for Project Management. Previous Page. Joining these tables, there are rows with opposite capitalizable_fl… Accepted answerI am looking to pull the External Invoice Status of project expense in Oracle Fusion for a BIP Report. 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. ledger_id. 5. 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. R11i: PA: PAXTRAPE Incorrect Proj And Projfunc Burdened Cost (Doc ID 1543566. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. Goal. line_number AND ail. 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. Task Description 5. They can go online to PA Expenditure Item Inquiry and drill back to to the AP Invoice using the 'Item Details' functionality. Users are writing an audit report so that they can show the AP invoices that were entered that generated PA Expenditure Items. system_linkage_function FROM pjc_Exp_items_all exp WHERE exp. task_id. 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:. Tables for the AP Invoice in Oracle fusion. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. attribute_number2 Pjc_Task_Id, ProjectsAtrbs. FROM PJC_EXP_ITEMS_ALL EXP, PJF_TXN_SOURCES_B TSRC, PO_LINES_ALL POL. Who column: indicates the date and time of the creation of the row. 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. NUMBER. 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 . INVENTORY_ITEM_ID. Inventory item identifier and References {EGP_SYSTEM_ITEMS_B. 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. source_id_int_1 = cdl. 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. This table is used to store the errors that could ocurr in various processes in project billing. invoice_date. txt), PDF File (. expenditure_item_id. pjc_project_id project_id, crt. Task Number 4. project_id(+) AND pei. original_dist_id FROM pjc_exp_items_all expenditureitempeo) v457612106, pjc_cost_dist_lines_all pcdl,. organization_id = aid. (EMP_MAND_FOR_. organization_id = ppat. source_pa_period_name. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. pjc_exp_items_all pei. PARENT_LINE_NUMBER. NAME project_owning_org, CASE WHEN. contract_type_id. 0 version, Manage Project Costs. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. Source Line Description 7. State 2. NAME AS expenditure_org, v55152034. pjc_task_id task_id, crt. receipt_currency_code ei_receipt_currency_code, peia. Object owner: PJS. The flag indicates whether to create expenditure items automatically Y means release automatically: DUP_TARGETS_FLAG:. FROM PJC_EXP_ITEMS_ALL PEI WHERE 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. Regards, Zahid Rahim. Project Foundation, Project Costing, Project Billing, Project Control. person_type person_type, expenditureitempeo. The errors are recorded against a transaction (identified by TRANSACTION_TYPE_CODE and corresponding id). PJF_TASKS_V. Now it is showing Project Cost transaction reference for all expense types except "Itemized Expense". PJB_ERRORS_U1. 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 Projects provides all system linkages upon installation. Flag that indicates whether the item is fully reversed or the item is one of the adjusting items that fully reverse another item. project_id(+) AND pei. Value will be RCV. STEP 2: Populate the data both PJC_TXN_XFACE_STAGE_ALL sheet of template as shown below. 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. On : 11. expenditure_item_id AND ptv. AND hou. Cloud Applications. A distribution must be associated with an invoice. invoice_id AND aid. PJC_COMMITMENT_TXNS: pjf_exp_types_b: EXPENDITURE_TYPE_ID: PJC_COMMITMENT_TXNS: pjf_system_linkages: SYSTEM_LINKAGE_FUNCTION:. task_id(+) AND pei. It covers various topics such as grants, billing, collaboration, control, costing, foundation, performance, resource and reporting. GL Account analysis for PA Expenditure */. 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:. This information will be interfaced to Oracle General Ledger from Oracle Projects. pjc_exp_items_all pei, okc_k_headers_all_b okha, hz_cust_accounts hca, hz_parties hp,. The attributes columns in PJC_EXP_ITEMS_ALL for my new transactions are also nullPJC_EXP_GROUPS_ALL. PJC: Complete Flow Loading Data Using Import Project Miscellaneous Costs FBDI (Doc ID 2224954. Tablespace: FUSION_TS_TX_DATA. NAME ei_expenditure_org_name, op. project_id = ptv. AND POL. project_id = prb. task_id = pei. pjc_organization_id. val_unit_id, ct. ,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. task_id = ptv. document_id = ei. Applies to: Oracle Project Costing - Version 11. task_id = ptv. Default. Goal. There select the Expenditure Items API, you’ll be able to see all the methods, select required method (In our case select. (SELECT expenditureitempeo. SQL_Statement; SELECT. system_linkage_function /* 30623237 (SELECT exp. SELECT ppa. expenditure_item_id = cdl. pei. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. NUMBER. AP_INVOICES_ALL is the parent table of AP_INVOICE_LINES_ALL table which is used to store the Invoice Line Details. 3 there are some records with data corruption as reported in the r13833481. expenditure_item_id AND ptv. Simply search with the table name in google, you’ll get complete details about the table and columns in it. Enter information into the employee number field (automatically entered in Oracle Personal Time and Expense). task_id(+) AND pei. pjc_exp_items_all pei,. 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,. 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. Previous Next JavaScript must be enabled to correctly display this content . transaction. We would like to show you a description here but the site won’t allow us. 1. 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. TRANSACTION_NUMBER. Examples of system linkages (Expenditure Type Classes) are: Expense Report, Usages, and Straight Time. Value will be RCV. which GL accounts will be hit by the system. If the task is a top task, the top_task_id is set to its own task_id. AND imp. From my research, it seems that the OTL timecard tables are HXT_TM_MTRX and HXT_TM_HEADER. PO Number I need above. PJC_EXP_ITEMS_ALL ei, GET_PERIOD_AVG_RATE gpavg WHERE aia. 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 . 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. cost_book_id, ct. AND ct. CATEGORY_ID ITEM_CATEGORY. /*2. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. system_linkage_function /* 30623237 (SELECT exp. project_id AND ptv. ** COST_IND_RATE_SCH_ID:. Object owner: PJC. . They use stored queries that derive data from the tables on which the views are based. Cloud Applications. expenditure_item_id = pec. NAME AS expenditure_bu, v515220161. 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. Cloud. project_id AND pei. linked_task_id. ---------------. line_num_reversed. expenditure_item_id = pei. expenditure_item_id = RevDist. 1) Last updated on JULY 25, 2023. Purpose of this report is to derive all projects expenditure and event details with cost information. document_id, expenditureitempeo. project_id AND pei. linked_project_id. AND crt. An invoice can have multiple distributions. Details. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. Next Page. 50. BATCH_STATUS: VARCHAR2: 1: Status of the batch. project_id = pei. pjc_exp_items_all: pjf_proj_elements_b: TASK_ID: pjf_proj_elements_b: pjf_proj_elements_b: PARENT_STRUCTURE_ID:. PJC_CINT_EXP_TYP_ECL_ALL; PJC_CINT_EXP_TYP_ECL_ALL. An expenditure item with the same transaction source and original system reference already exists. STEP 3: Generate PjcTxnXfaceStageAll_misc. ei_project_numbe. 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. Also PO_DISTRIBUTIONS_ALL is the table which in my experience connects Purchase. expenditure_item_id = RevDist. attribute_number4 Pjc_Project_Unit, ProjectsAtrbs. creation_date5 AS acct_period_date, v103611946. project_type_id = ppt. It doesn’t matter how complex the issues would be. SELECT. 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,. attribute_varchar1 Pjc_Billable_Flag, ProjectsAtrbs. ← Configurator Concurrent Programs. WHERE ei. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. invoice_line_number = ail. TRANSACTION_SOURCE_ID. Dear All, About Oracle Fusion Applications Cloud (Oracle's SaaS ERP) . Details. WHERE ei. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. TRANSACTION_SOURCE_ID = TSRC. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. A technology service company that provides innovative solutions around the oracle platform With Laser focus on customer delight as the primary success parameter. gl_date. 11. This number is incremented every time that the row is updated. org_id employee_cost_org_id, pcdl. invoice_id = aid. source_attribute1. Stores receipt number for purchase order transactions and PO number or invoice number for expense adjustment transaction. 50. SELECT pcdl. Object type: TABLE. denom_currency_code. 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. 90; ADJUSTED_EXPENDITURE_ITEM_ID: 1993042; Project: 4056; For Item ID 1993042: Created: 14/02/2020 14:04:46; Quantity: 110. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. Asset Number 5. GL Account analysis for PA Events */. select a. VARCHAR2. source_task_id. Oracle ERP/ FSCM The table PJC_EXP_ITEMS_ALL has a foreign key to PJF_PROJ_ELEMENT as the Task table. Legal Entity 3. User-defined number that uniquely identifies the element within a project or structure. project_number, a. Details. Simply search with the table name in google, you’ll get complete details about the table and columns in it. To get the. 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. TARGET_EXP_TYPE_ID: PJC_ALLOC_RULES_ALL: pjf_rbs_headers_b: ALLOC_RBS_HEADER_ID: PJC_ALLOC_RULES_ALL: pjf_system_linkages: OFFSET_EXP_TYPE_CLASS:. source_pa_date. project_id, ppa. I can see on PJC_EXP_ITEMS_ALL that there is: Item ID 1993045 Created: 14/02/2020 14:06:31; Quantity: -110. PJC_TRANSACTION_CONTROLS. Views are logical representations of a single or combination of tables. , revdist. expenditure_item_id = cdl. For any update on columns other than the system populated columns, two records are created in this table. Fusion Inventory Queries2. UNION ALL. project_id, expenditureitempeo. WHERE 1 = 1. 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. There can be only one record for the combination of Supplier and the invoice number. expenditure_item_id = RevDist. full_name AS employee_name, v55152034. PJC_CC_DIST_LINES_ALL. name; application_id. Project Description 3. This is the hash key of the attributes which make up the composite key--- OrgId and ExpressionId ---for the Incentive Compensation Expressions resource and used to uniquely identify an instance of Incentive Compensation Expressions. NUMBER. Select aia . 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. rev_distribution_id. There select the Expenditure Items API, you’ll be able to see all the methods, select required method (In our case select. Schema: FUSION. FROM hwm_tm_rep_atrbs PjcExpAtrbs, hwm_tm_rep_atrb_usages PjcExpAtrbsUsg, HWM_TM_ATRB_FLDS_B PjcExpAtrbFlds. expenditure_item_id. 90; TRANSFERRED_FROM_EXP_ITEM_ID = 1612017; Project: 4056; There is another Item ID, 1993043, which also has the. 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. description , chr (. source_id_int_1 = cdl.