VIEW: APPS.ICX_SUPPLIER_ACCOUNT_V

Source

View Text - Preformatted

SELECT SUPP.VENDOR_ID , SUPP.VENDOR_NAME , SUPP_ADDR.VENDOR_SITE_ID , SUPP_ADDR.COUNTRY , SUPP_ADDR.ADDRESS_LINE1||DECODE(SUPP_ADDR.ADDRESS_LINE2,NULL,NULL, '
')||SUPP_ADDR.ADDRESS_LINE2||DECODE(SUPP_ADDR.ADDRESS_LINE3, NULL,NULL,'
')||SUPP_ADDR.ADDRESS_LINE3 ADDRESS , SUPP_ADDR.ADDRESS_LINE1 , SUPP_ADDR.ADDRESS_LINE2 , SUPP_ADDR.ADDRESS_LINE3 , SUPP_ADDR.CITY , SUPP_ADDR.PROVINCE , SUPP_ADDR.COUNTY , SUPP_ADDR.STATE , SUPP_ADDR.ZIP , CONT.VENDOR_CONTACT_ID , CONT.FIRST_NAME||' '||CONT.LAST_NAME NAME , CONT.LAST_NAME , CONT.FIRST_NAME , CONT.MAIL_STOP , CONT.PHONE , SUPP_ADDR.ORG_ID FROM PO_VENDORS SUPP, PO_VENDOR_SITES_ALL SUPP_ADDR, PO_VENDOR_CONTACTS CONT WHERE CONT.VENDOR_SITE_ID = SUPP_ADDR.VENDOR_SITE_ID AND SUPP_ADDR.VENDOR_ID = SUPP.VENDOR_ID

View Text - HTML Formatted

SELECT SUPP.VENDOR_ID
, SUPP.VENDOR_NAME
, SUPP_ADDR.VENDOR_SITE_ID
, SUPP_ADDR.COUNTRY
, SUPP_ADDR.ADDRESS_LINE1||DECODE(SUPP_ADDR.ADDRESS_LINE2
, NULL
, NULL
, '
')||SUPP_ADDR.ADDRESS_LINE2||DECODE(SUPP_ADDR.ADDRESS_LINE3
, NULL
, NULL
, '
')||SUPP_ADDR.ADDRESS_LINE3 ADDRESS
, SUPP_ADDR.ADDRESS_LINE1
, SUPP_ADDR.ADDRESS_LINE2
, SUPP_ADDR.ADDRESS_LINE3
, SUPP_ADDR.CITY
, SUPP_ADDR.PROVINCE
, SUPP_ADDR.COUNTY
, SUPP_ADDR.STATE
, SUPP_ADDR.ZIP
, CONT.VENDOR_CONTACT_ID
, CONT.FIRST_NAME||' '||CONT.LAST_NAME NAME
, CONT.LAST_NAME
, CONT.FIRST_NAME
, CONT.MAIL_STOP
, CONT.PHONE
, SUPP_ADDR.ORG_ID
FROM PO_VENDORS SUPP
, PO_VENDOR_SITES_ALL SUPP_ADDR
, PO_VENDOR_CONTACTS CONT
WHERE CONT.VENDOR_SITE_ID = SUPP_ADDR.VENDOR_SITE_ID
AND SUPP_ADDR.VENDOR_ID = SUPP.VENDOR_ID