CJM_XLA_SUPPLIER_ACCRUAL_V
Details
-
Schema: FUSION
-
Object owner: CJM
-
Object type: VIEW
Columns
Name |
---|
UTILIZATION_ID UTILIZATION_TYPE SUPPLIER SUPPLIER_SITE PROGRAM_TYPE PROGRAM_CODE ITEM_NUMBER ACCRUAL_DATE |
Query
SQL_Statement |
---|
SELECT util.utilization_id, cjm_utility_pkg.get_lookup_meaning('ORA_CJM_TRANSACTION_TYPE',util.utilization_type) utilization_type, vendor_party.party_name supplier, pvs.vendor_site_code supplier_site, cjm_utility_pkg.get_lookup_meaning('ORA_CJM_PROGRAM_TYPE',pgm.program_type_code) program_type, pgm.program_code program_code, CJM_UTILITY_PKG.get_item_name(util.item_level_code,util.item_id,util.bu_id) item_number, util.adjustment_date accrual_date FROM cjm_xla_accruals oxa, cjm_programs_utilized_all_b util, cjm_programs_all_b pgm, poz_suppliers poz_vendor, hz_parties vendor_party, poz_supplier_sites_all_m pvs WHERE util.accrual_type = 'SUPPLIER' AND util.utilization_id = oxa.utilization_id AND util.program_header_id = pgm.program_header_id AND util.vendor_id = poz_vendor.vendor_id AND poz_vendor.party_id = vendor_party.party_id AND util.vendor_site_id = pvs.vendor_site_id |