VIEW: APPS.EDWBV_TPRT_P3_TPARTNER_LCV

Source

View Text - Preformatted

SELECT vnd.vendor_id || '-' || inst.instance_code || '-' || 'SUPPLIER', ele.parent_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 = 1 AND ele.vendor_id = vnd.vendor_id UNION ALL SELECT vnd.tpartner_pk, vnd.tpartner_pk, vnd.last_update_date, vnd.creation_date, vnd.tpartner_dp, vnd.name, vnd.alternate_name, vnd.start_active_date, vnd.end_active_date, vnd.sic_code, vnd.tax_reg_num, vnd.taxpayer_id, vnd.payment_terms, vnd.vendor_number, vnd.vendor_type, vnd.one_time_flag, vnd.minority_group, vnd.women_owned, vnd.small_business, vnd.hold_flag, vnd.inspect_required, vnd.receipt_required, vnd.allow_sub_receipt, vnd.allow_unorder_rcv, vnd.instance, NULL, NULL, NULL, NULL, NULL, vnd.vendor_id, to_char(NULL) FROM edw_tprt_p4_tpartner_lcv vnd

View Text - HTML Formatted

SELECT VND.VENDOR_ID || '-' || INST.INSTANCE_CODE || '-' || 'SUPPLIER'
, ELE.PARENT_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 = 1
AND ELE.VENDOR_ID = VND.VENDOR_ID UNION ALL SELECT VND.TPARTNER_PK
, VND.TPARTNER_PK
, VND.LAST_UPDATE_DATE
, VND.CREATION_DATE
, VND.TPARTNER_DP
, VND.NAME
, VND.ALTERNATE_NAME
, VND.START_ACTIVE_DATE
, VND.END_ACTIVE_DATE
, VND.SIC_CODE
, VND.TAX_REG_NUM
, VND.TAXPAYER_ID
, VND.PAYMENT_TERMS
, VND.VENDOR_NUMBER
, VND.VENDOR_TYPE
, VND.ONE_TIME_FLAG
, VND.MINORITY_GROUP
, VND.WOMEN_OWNED
, VND.SMALL_BUSINESS
, VND.HOLD_FLAG
, VND.INSPECT_REQUIRED
, VND.RECEIPT_REQUIRED
, VND.ALLOW_SUB_RECEIPT
, VND.ALLOW_UNORDER_RCV
, VND.INSTANCE
, NULL
, NULL
, NULL
, NULL
, NULL
, VND.VENDOR_ID
, TO_CHAR(NULL)
FROM EDW_TPRT_P4_TPARTNER_LCV VND