View: OKX_VENDOR_SITES_V

Product:	OKX - Contracts Integration
Description:	Supplier sites
Implementation/DBA Data:	APPS.OKX_VENDOR_SITES_V

View Text

SELECT VS.VENDOR_SITE_ID ID1
, '#' ID2
, VS.VENDOR_ID VENDOR_ID
, VS.VENDOR_SITE_CODE NAME
, VS.ORG_ID ORG_ID
, VS.INACTIVE_DATE - 1 END_DATE_ACTIVE
, DECODE(SYSDATE - NVL(VS.INACTIVE_DATE
, SYSDATE)
, 0
, SYSDATE
, DECODE(SYSDATE - NVL(VS.INACTIVE_DATE
, SYSDATE) + ABS(SYSDATE - NVL(VS.INACTIVE_DATE
, SYSDATE))
, 0
, SYSDATE
, VS.INACTIVE_DATE )) START_DATE_ACTIVE
, DECODE(SIGN(NVL(VS.INACTIVE_DATE
, SYSDATE) - SYSDATE)
, -1
, 'I'
, 'A') STATUS
, SUBSTR(ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS(NULL
, VS.ADDRESS_LINE1
, VS.ADDRESS_LINE2
, VS.ADDRESS_LINE3
, VS.ADDRESS_LINE4
, VS.CITY
, VS.COUNTY
, VS.STATE
, VS.PROVINCE
, VS.ZIP
, NULL
, VS.COUNTRY
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, 'N'
, 'N'
, 80
, 1
, 1)
, 1
, 80) DESCRIPTION
, VS.PAY_SITE_FLAG PAY_SITE_FLAG
, VS.VENDOR_ID PARTY_ID
, '#' PARTY_ID2
FROM PO_VENDOR_SITES_ALL VS

Columns