VIEW: APPS.EDWBV_TPRT_P2_TPARTNER_LCV

Source

View Text - Preformatted

SELECT vnd.vendor_id || '-' || inst.instance_code || '-' || 'SUPPLIER', DECODE(ele.hierarchy_level, 2, ele.parent_vendor_id ||'-'|| inst.instance_code ||'-'|| 'SUPPLIER', vnd.vendor_id ||'-'|| inst.instance_code ||'-'|| 'SUPPLIER'), vnd.last_update_date, vnd.creation_date, vnd.vendor_name, vnd.vendor_name, vnd.vendor_name_alt, vnd.start_date_active, vnd.end_date_active, vnd.standard_industry_class, vnd.vat_registration_num, vnd.num_1099, vnd.terms_id, vnd.segment1, vnd.vendor_type_lookup_code, vnd.one_time_flag, vnd.minority_group_lookup_code, vnd.women_owned_flag, vnd.small_business_flag, vnd.hold_flag, vnd.inspection_required_flag, vnd.receipt_required_flag, vnd.allow_substitute_receipts_flag, vnd.allow_unordered_receipts_flag, inst.instance_code, NULL, NULL, NULL, NULL, NULL, vnd.vendor_id, to_char(NULL) FROM edw_local_instance inst, edw_po_vendor_hierarchies_v ele, po_vendors vnd WHERE ele.hierarchy_level IN (1,2) AND ele.vendor_id = vnd.vendor_id UNION ALL /* push down vendors with no parent */ SELECT vnd.vendor_id || '-' || inst.instance_code || '-' || 'SUPPLIER', vnd.vendor_id || '-' || inst.instance_code || '-' || 'SUPPLIER', vnd.last_update_date, vnd.creation_date, vnd.vendor_name, vnd.vendor_name, vnd.vendor_name_alt, vnd.start_date_active, vnd.end_date_active, vnd.standard_industry_class, vnd.vat_registration_num, vnd.num_1099, vnd.terms_id, vnd.segment1, vnd.vendor_type_lookup_code, vnd.one_time_flag, vnd.minority_group_lookup_code, vnd.women_owned_flag, vnd.small_business_flag, vnd.hold_flag, vnd.inspection_required_flag, vnd.receipt_required_flag, vnd.allow_substitute_receipts_flag, vnd.allow_unordered_receipts_flag, inst.instance_code, NULL, NULL, NULL, NULL, NULL, vnd.vendor_id, to_char(NULL) FROM edw_local_instance inst, po_vendors vnd WHERE vnd.parent_vendor_id is NULL

View Text - HTML Formatted

SELECT VND.VENDOR_ID || '-' || INST.INSTANCE_CODE || '-' || 'SUPPLIER'
, DECODE(ELE.HIERARCHY_LEVEL
, 2
, ELE.PARENT_VENDOR_ID ||'-'|| INST.INSTANCE_CODE ||'-'|| 'SUPPLIER'
, VND.VENDOR_ID ||'-'|| INST.INSTANCE_CODE ||'-'|| 'SUPPLIER')
, VND.LAST_UPDATE_DATE
, VND.CREATION_DATE
, VND.VENDOR_NAME
, VND.VENDOR_NAME
, VND.VENDOR_NAME_ALT
, VND.START_DATE_ACTIVE
, VND.END_DATE_ACTIVE
, VND.STANDARD_INDUSTRY_CLASS
, VND.VAT_REGISTRATION_NUM
, VND.NUM_1099
, VND.TERMS_ID
, VND.SEGMENT1
, VND.VENDOR_TYPE_LOOKUP_CODE
, VND.ONE_TIME_FLAG
, VND.MINORITY_GROUP_LOOKUP_CODE
, VND.WOMEN_OWNED_FLAG
, VND.SMALL_BUSINESS_FLAG
, VND.HOLD_FLAG
, VND.INSPECTION_REQUIRED_FLAG
, VND.RECEIPT_REQUIRED_FLAG
, VND.ALLOW_SUBSTITUTE_RECEIPTS_FLAG
, VND.ALLOW_UNORDERED_RECEIPTS_FLAG
, INST.INSTANCE_CODE
, NULL
, NULL
, NULL
, NULL
, NULL
, VND.VENDOR_ID
, TO_CHAR(NULL)
FROM EDW_LOCAL_INSTANCE INST
, EDW_PO_VENDOR_HIERARCHIES_V ELE
, PO_VENDORS VND
WHERE ELE.HIERARCHY_LEVEL IN (1
, 2)
AND ELE.VENDOR_ID = VND.VENDOR_ID UNION ALL /* PUSH DOWN VENDORS WITH NO PARENT */ SELECT VND.VENDOR_ID || '-' || INST.INSTANCE_CODE || '-' || 'SUPPLIER'
, VND.VENDOR_ID || '-' || INST.INSTANCE_CODE || '-' || 'SUPPLIER'
, VND.LAST_UPDATE_DATE
, VND.CREATION_DATE
, VND.VENDOR_NAME
, VND.VENDOR_NAME
, VND.VENDOR_NAME_ALT
, VND.START_DATE_ACTIVE
, VND.END_DATE_ACTIVE
, VND.STANDARD_INDUSTRY_CLASS
, VND.VAT_REGISTRATION_NUM
, VND.NUM_1099
, VND.TERMS_ID
, VND.SEGMENT1
, VND.VENDOR_TYPE_LOOKUP_CODE
, VND.ONE_TIME_FLAG
, VND.MINORITY_GROUP_LOOKUP_CODE
, VND.WOMEN_OWNED_FLAG
, VND.SMALL_BUSINESS_FLAG
, VND.HOLD_FLAG
, VND.INSPECTION_REQUIRED_FLAG
, VND.RECEIPT_REQUIRED_FLAG
, VND.ALLOW_SUBSTITUTE_RECEIPTS_FLAG
, VND.ALLOW_UNORDERED_RECEIPTS_FLAG
, INST.INSTANCE_CODE
, NULL
, NULL
, NULL
, NULL
, NULL
, VND.VENDOR_ID
, TO_CHAR(NULL)
FROM EDW_LOCAL_INSTANCE INST
, PO_VENDORS VND
WHERE VND.PARENT_VENDOR_ID IS NULL