1. Tables and Views for SCM
  2. CJM_XLA_SUPPLIER_ACCRUAL_V

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