[Home] [Help]
View: OKE_VENDOR_SITES_V
View Text
SELECT VS.VENDOR_SITE_ID
, '#'
, VS.VENDOR_ID
, VS.VENDOR_SITE_CODE
, VS.ORG_ID
, TRUNC(VS.CREATION_DATE)
, TRUNC(VS.INACTIVE_DATE) - 1
, DECODE(SIGN(NVL(VS.INACTIVE_DATE
, SYSDATE) - SYSDATE)
, -1
, 'I'
, 'A')
, 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 )
, VS.PURCHASING_SITE_FLAG
, VS.RFQ_ONLY_SITE_FLAG
, VS.PAY_SITE_FLAG
, VS.VENDOR_ID
, '#'
FROM PO_VENDOR_SITES_ALL VS
Columns
Name |
ID1 |
ID2 |
VENDOR_ID |
NAME |
ORG_ID |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
STATUS |
DESCRIPTION |
PURCHASING_SITE_FLAG |
RFQ_ONLY_SITE_FLAG |
PAY_SITE_FLAG |
PARTY_ID |
PARTY_ID2 |