[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 |
APPS.OKE_VENDOR_SITES_V