VIEW: APPS.EDWBV_TPRT_P4_TPARTNER_LCV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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