VIEW: APPS.OKX_VENDORS_V

Source

View Text - Preformatted

SELECT V.VENDOR_ID ID1, '#' ID2, V.VENDOR_NAME NAME, V.ENABLED_FLAG B_STATUS, DECODE(V.ENABLED_FLAG,'Y','A','I') STATUS, V.START_DATE_ACTIVE START_DATE_ACTIVE, V.END_DATE_ACTIVE END_DATE_ACTIVE, V.MINORITY_GROUP_LOOKUP_CODE MINORITY_GROUP_LOOKUP, V.WOMEN_OWNED_FLAG WOMEN_OWNED_FLAG, V.SMALL_BUSINESS_FLAG SMALL_BUSINESS_FLAG, V.SEGMENT1 DESCRIPTION, V.SET_OF_BOOKS_ID SET_OF_BOOKS_ID, V.SEGMENT1 PARTY_NUMBER, NULL ADDRESS, V.VENDOR_TYPE_LOOKUP_CODE VENDOR_TYPE_LOOKUP_CODE, NULL COUNTRY, NULL ADDRESS1, NULL ADDRESS2, NULL ADDRESS3, NULL ADDRESS4, NULL POSTAL_CODE, NULL STATE, NULL COUNTY, NULL CITY FROM PO_VENDORS V

View Text - HTML Formatted

SELECT V.VENDOR_ID ID1
, '#' ID2
, V.VENDOR_NAME NAME
, V.ENABLED_FLAG B_STATUS
, DECODE(V.ENABLED_FLAG
, 'Y'
, 'A'
, 'I') STATUS
, V.START_DATE_ACTIVE START_DATE_ACTIVE
, V.END_DATE_ACTIVE END_DATE_ACTIVE
, V.MINORITY_GROUP_LOOKUP_CODE MINORITY_GROUP_LOOKUP
, V.WOMEN_OWNED_FLAG WOMEN_OWNED_FLAG
, V.SMALL_BUSINESS_FLAG SMALL_BUSINESS_FLAG
, V.SEGMENT1 DESCRIPTION
, V.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, V.SEGMENT1 PARTY_NUMBER
, NULL ADDRESS
, V.VENDOR_TYPE_LOOKUP_CODE VENDOR_TYPE_LOOKUP_CODE
, NULL COUNTRY
, NULL ADDRESS1
, NULL ADDRESS2
, NULL ADDRESS3
, NULL ADDRESS4
, NULL POSTAL_CODE
, NULL STATE
, NULL COUNTY
, NULL CITY
FROM PO_VENDORS V