VIEW: APPS.OKE_VENDOR_SITES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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