VIEW: APPS.OZF_SD_FROM_ROLE_V

Source

View Text - Preformatted

SELECT REQ.REQUEST_HEADER_ID REQUEST_HEADER_ID, ORG.NAME DIST_NAME, NVL(PARTY.EMAIL_ADDRESS,'NA') DIST_EMAIL, NVL(PARTY.PRIMARY_PHONE_NUMBER,'NA') DIST_TEL, 'PRODUCT DISTRIBUTOR' PARTNER_CLASSIFICATION_CODE, 'OZFSDDUNS' DIST_DUNS_NUMBER, PARTY.CATEGORY_CODE DIST_CATEGORY_CODE, REOURCES.SOURCE_NAME DIST_CONTACT_NAME, NVL(REOURCES.SOURCE_EMAIL,'NA') DIST_CONTACT_EMAIL, LOC.LOCATION_CODE DIST_LOCATION_CODE, LOC.ADDRESS_LINE_1 DIST_ADD1, LOC.ADDRESS_LINE_2 DIST_ADD2, LOC.ADDRESS_LINE_3 DIST_ADD3, LOC.TOWN_OR_CITY DIST_CITY, LOC.COUNTRY DIST_COUNTRY, LOC.POSTAL_CODE DIST_POSTAL_CODE FROM HR_ALL_ORGANIZATION_UNITS ORG,HR_LOCATIONS_ALL LOC,OZF_SD_REQUEST_HEADERS_ALL_B REQ,JTF_RS_RESOURCE_EXTNS REOURCES,HZ_PARTIES PARTY WHERE REQ.ORG_ID=ORG.ORGANIZATION_ID AND ORG.LOCATION_ID=LOC.LOCATION_ID AND REQ.REQUESTOR_ID=REOURCES.RESOURCE_ID AND ORG.PARTY_ID=PARTY.PARTY_ID(+)

View Text - HTML Formatted

SELECT REQ.REQUEST_HEADER_ID REQUEST_HEADER_ID
, ORG.NAME DIST_NAME
, NVL(PARTY.EMAIL_ADDRESS
, 'NA') DIST_EMAIL
, NVL(PARTY.PRIMARY_PHONE_NUMBER
, 'NA') DIST_TEL
, 'PRODUCT DISTRIBUTOR' PARTNER_CLASSIFICATION_CODE
, 'OZFSDDUNS' DIST_DUNS_NUMBER
, PARTY.CATEGORY_CODE DIST_CATEGORY_CODE
, REOURCES.SOURCE_NAME DIST_CONTACT_NAME
, NVL(REOURCES.SOURCE_EMAIL
, 'NA') DIST_CONTACT_EMAIL
, LOC.LOCATION_CODE DIST_LOCATION_CODE
, LOC.ADDRESS_LINE_1 DIST_ADD1
, LOC.ADDRESS_LINE_2 DIST_ADD2
, LOC.ADDRESS_LINE_3 DIST_ADD3
, LOC.TOWN_OR_CITY DIST_CITY
, LOC.COUNTRY DIST_COUNTRY
, LOC.POSTAL_CODE DIST_POSTAL_CODE
FROM HR_ALL_ORGANIZATION_UNITS ORG
, HR_LOCATIONS_ALL LOC
, OZF_SD_REQUEST_HEADERS_ALL_B REQ
, JTF_RS_RESOURCE_EXTNS REOURCES
, HZ_PARTIES PARTY
WHERE REQ.ORG_ID=ORG.ORGANIZATION_ID
AND ORG.LOCATION_ID=LOC.LOCATION_ID
AND REQ.REQUESTOR_ID=REOURCES.RESOURCE_ID
AND ORG.PARTY_ID=PARTY.PARTY_ID(+)