View: EDWBV_TPRT_P4_TPARTNER_LCV

Product:	PO - Purchasing
Description:
Implementation/DBA Data:	APPS.EDWBV_TPRT_P4_TPARTNER_LCV

View Text

SELECT VND.VENDOR_ID || '-' || INST.INSTANCE_CODE || '-' || 'SUPPLIER'
, 'ALL'
, 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

Columns