VIEW: APPS.OKX_VENDOR_SITES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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