View: EDW_TPRT_P0_TPARTNER_LCV

View Text

SELECT VND.VENDOR_NAME
, VND2.VENDOR_NAME
, 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 VND2
, PO_VENDORS VND
WHERE ELE.PARENT_VENDOR_ID = VND2.VENDOR_ID
AND ELE.VENDOR_ID = VND.VENDOR_ID
AND ELE.HIERARCHY_LEVEL = 4 UNION ALL SELECT DISTINCT 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
, INST.INSTANCE_CODE
, NULL
, NULL
, NULL
, NULL
, NULL
, VND.VENDOR_ID
, TO_CHAR(NULL)
FROM EDW_LOCAL_INSTANCE INST
, EDW_TPRT_P1_TPARTNER_LCV VND

Columns