VIEW: APPS.POR_SUPPLIER_LOV_V

Source

View Text - Preformatted

SELECT PSV.VENDOR_ID, PSSV.VENDOR_SITE_ID, DECODE(SIGN(SYSDATE-NVL(PSCV.INACTIVE_DATE,SYSDATE+1)), -1, PSCV.VENDOR_CONTACT_ID, NULL), PSV.VENDOR_NAME, DECODE(SIGN(SYSDATE-NVL(PSCV.INACTIVE_DATE,SYSDATE+1)), -1, (DECODE (PSCV.FIRST_NAME, NULL, PSCV.LAST_NAME, PSCV.LAST_NAME||', '||PSCV.FIRST_NAME) ), NULL), PSSV.ADDRESS_LINE1, PSSV.ADDRESS_LINE2, PSSV.ADDRESS_LINE3, PSSV.CITY, PSSV.STATE, PSSV.ZIP, PSSV.COUNTRY, DECODE(SIGN(SYSDATE-NVL(PSCV.INACTIVE_DATE,SYSDATE+1)), -1, (PSCV.AREA_CODE||' '||PSCV.PHONE), NULL) TELEPHONE, PSSV.VENDOR_SITE_CODE FROM PO_VENDORS PSV, PO_VENDOR_CONTACTS PSCV, PO_VENDOR_SITES PSSV WHERE nvl(PSV.enabled_flag,'Y') = 'Y' and PSV.VENDOR_ID = PSSV.VENDOR_ID(+) and (PSV.VENDOR_TYPE_LOOKUP_CODE is null or PSV.VENDOR_TYPE_LOOKUP_CODE <> 'EMPLOYEE') and (SYSDATE between nvl(PSV.START_DATE_ACTIVE, SYSDATE-1) and nvl(PSV.END_DATE_ACTIVE, SYSDATE+1)) AND (PSSV.PURCHASING_SITE_FLAG = 'Y' or PSSV.RFQ_ONLY_SITE_FLAG = 'Y') AND SYSDATE < NVL(PSSV.INACTIVE_DATE, SYSDATE + 1) AND PSSV.VENDOR_SITE_ID = PSCV.VENDOR_SITE_ID(+)

View Text - HTML Formatted

SELECT PSV.VENDOR_ID
, PSSV.VENDOR_SITE_ID
, DECODE(SIGN(SYSDATE-NVL(PSCV.INACTIVE_DATE
, SYSDATE+1))
, -1
, PSCV.VENDOR_CONTACT_ID
, NULL)
, PSV.VENDOR_NAME
, DECODE(SIGN(SYSDATE-NVL(PSCV.INACTIVE_DATE
, SYSDATE+1))
, -1
, (DECODE (PSCV.FIRST_NAME
, NULL
, PSCV.LAST_NAME
, PSCV.LAST_NAME||'
, '||PSCV.FIRST_NAME) )
, NULL)
, PSSV.ADDRESS_LINE1
, PSSV.ADDRESS_LINE2
, PSSV.ADDRESS_LINE3
, PSSV.CITY
, PSSV.STATE
, PSSV.ZIP
, PSSV.COUNTRY
, DECODE(SIGN(SYSDATE-NVL(PSCV.INACTIVE_DATE
, SYSDATE+1))
, -1
, (PSCV.AREA_CODE||' '||PSCV.PHONE)
, NULL) TELEPHONE
, PSSV.VENDOR_SITE_CODE
FROM PO_VENDORS PSV
, PO_VENDOR_CONTACTS PSCV
, PO_VENDOR_SITES PSSV
WHERE NVL(PSV.ENABLED_FLAG
, 'Y') = 'Y'
AND PSV.VENDOR_ID = PSSV.VENDOR_ID(+)
AND (PSV.VENDOR_TYPE_LOOKUP_CODE IS NULL OR PSV.VENDOR_TYPE_LOOKUP_CODE <> 'EMPLOYEE')
AND (SYSDATE BETWEEN NVL(PSV.START_DATE_ACTIVE
, SYSDATE-1)
AND NVL(PSV.END_DATE_ACTIVE
, SYSDATE+1))
AND (PSSV.PURCHASING_SITE_FLAG = 'Y' OR PSSV.RFQ_ONLY_SITE_FLAG = 'Y')
AND SYSDATE < NVL(PSSV.INACTIVE_DATE
, SYSDATE + 1)
AND PSSV.VENDOR_SITE_ID = PSCV.VENDOR_SITE_ID(+)