VIEW: APPS.OZF_SD_TO_ROLE_V

Source

View Text - Preformatted

SELECT REQ.REQUEST_HEADER_ID REQUEST_HEADER_ID, AP.VENDOR_NAME SUPPLIER_NAME, NVL(APS.EMAIL_ADDRESS, 'NA') SUPPLIER_EMAIL, NVL(APS.PHONE, 'NA') SUPPLIER_PHONE, NVL(APS.ZIP, 'NA') SUPPLIER_POSTAL_CODE, APS.VENDOR_SITE_CODE SUPPLIER_LOCATION, NVL(APS.ADDRESS_LINE1, 'NA') SUPPLIER_ADD1, NVL(APS.ADDRESS_LINE2, 'NA') SUPPLIER_ADD2, NVL(APS.ADDRESS_LINE3, 'NA') SUPPLIER_ADD3, NVL(APS.CITY, 'NA') SUPPLIER_CITY, NVL(APS.COUNTRY, 'NA') SUPPLIER_COUNTRY, NVL(REQ.SUPPLIER_CONTACT_NAME,'NA') SUPPLIER_CONTACT_NAME, NVL(REQ.SUPPLIER_CONTACT_EMAIL_ADDRESS, 'NA') SUPPLIER_CONTACT_EMAIL_ADD, NVL(REQ.SUPPLIER_CONTACT_PHONE_NUMBER, 'NA') SUPPLIER_CONTACT_PHONE, NVL(PARTY.DUNS_NUMBER,0) SUPPLIER_DUNS_NUMBER, NVL(PARTY.CATEGORY_CODE,'NA') SUPPLIER_CATEGORY_CODE FROM OZF_SD_REQUEST_HEADERS_ALL_B REQ, AP_SUPPLIERS AP, AP_SUPPLIER_SITES_ALL APS, AP_SUPPLIER_CONTACTS APC, HZ_PARTIES PARTY WHERE REQ.SUPPLIER_ID = AP.VENDOR_ID AND REQ.SUPPLIER_SITE_ID = APS.VENDOR_SITE_ID AND REQ.SUPPLIER_CONTACT_ID = APC.VENDOR_CONTACT_ID(+) AND AP.PARTY_ID = PARTY.PARTY_ID(+)

View Text - HTML Formatted

SELECT REQ.REQUEST_HEADER_ID REQUEST_HEADER_ID
, AP.VENDOR_NAME SUPPLIER_NAME
, NVL(APS.EMAIL_ADDRESS
, 'NA') SUPPLIER_EMAIL
, NVL(APS.PHONE
, 'NA') SUPPLIER_PHONE
, NVL(APS.ZIP
, 'NA') SUPPLIER_POSTAL_CODE
, APS.VENDOR_SITE_CODE SUPPLIER_LOCATION
, NVL(APS.ADDRESS_LINE1
, 'NA') SUPPLIER_ADD1
, NVL(APS.ADDRESS_LINE2
, 'NA') SUPPLIER_ADD2
, NVL(APS.ADDRESS_LINE3
, 'NA') SUPPLIER_ADD3
, NVL(APS.CITY
, 'NA') SUPPLIER_CITY
, NVL(APS.COUNTRY
, 'NA') SUPPLIER_COUNTRY
, NVL(REQ.SUPPLIER_CONTACT_NAME
, 'NA') SUPPLIER_CONTACT_NAME
, NVL(REQ.SUPPLIER_CONTACT_EMAIL_ADDRESS
, 'NA') SUPPLIER_CONTACT_EMAIL_ADD
, NVL(REQ.SUPPLIER_CONTACT_PHONE_NUMBER
, 'NA') SUPPLIER_CONTACT_PHONE
, NVL(PARTY.DUNS_NUMBER
, 0) SUPPLIER_DUNS_NUMBER
, NVL(PARTY.CATEGORY_CODE
, 'NA') SUPPLIER_CATEGORY_CODE
FROM OZF_SD_REQUEST_HEADERS_ALL_B REQ
, AP_SUPPLIERS AP
, AP_SUPPLIER_SITES_ALL APS
, AP_SUPPLIER_CONTACTS APC
, HZ_PARTIES PARTY
WHERE REQ.SUPPLIER_ID = AP.VENDOR_ID
AND REQ.SUPPLIER_SITE_ID = APS.VENDOR_SITE_ID
AND REQ.SUPPLIER_CONTACT_ID = APC.VENDOR_CONTACT_ID(+)
AND AP.PARTY_ID = PARTY.PARTY_ID(+)