View: OKX_VENDORS_V

Product:	OKX - Contracts Integration
Description:	Suppliers
Implementation/DBA Data:	APPS.OKX_VENDORS_V

View Text

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

Columns