VIEW: APPS.OZF_SD_END_CUST_V

Source

View Text - Preformatted

SELECT CUST.REQUEST_HEADER_ID REQUEST_HEADER_ID, NVL(PARTY.PARTY_NAME, 'NA') CUST_NAME, NVL(PARTY.DUNS_NUMBER, 0) DUNS_NUMBER, NVL(PARTY.CATEGORY_CODE, 'NA') CATEGORY_CODE, NVL(PARTY.EMAIL_ADDRESS, 'NA') EMAIL_ADDRESS, NVL(PARTY.PRIMARY_PHONE_NUMBER, 'NA') PHONE_NUMBER, NVL(CUST.SITE_USE_ID, 0) LOCATION_ID, NVL(LOC.ADDRESS1, 'NA') CUST_ADD1, NVL(LOC.ADDRESS2, 'NA') CUST_ADD2, NVL(LOC.ADDRESS3, 'NA') CUST_ADD3, NVL(LOC.CITY, 'NA') CUST_CITY, NVL(LOC.COUNTRY, 'NA') CUST_COUNTRY, NVL(LOC.POSTAL_CODE, 'NA') CUST_POSTAL_CODE, NVL(LOC.PO_BOX_NUMBER, 'NA') CUST_PO_BOX, CUST.CUST_USAGE_CODE SITE_USE_CODE FROM OZF_SD_CUSTOMER_DETAILS CUST, HZ_CUST_SITE_USES_ALL SITE, HZ_CUST_ACCT_SITES ACCT_SITE, HZ_PARTY_SITES PARTY_SITE, HZ_LOCATIONS LOC, HZ_PARTIES PARTY WHERE CUST.SITE_USE_ID = SITE.SITE_USE_ID(+) AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID(+) AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID(+) AND PARTY_SITE.LOCATION_ID = LOC.LOCATION_ID(+) AND CUST.PARTY_ID = PARTY.PARTY_ID AND CUST.END_CUSTOMER_FLAG = 'Y'

View Text - HTML Formatted

SELECT CUST.REQUEST_HEADER_ID REQUEST_HEADER_ID
, NVL(PARTY.PARTY_NAME
, 'NA') CUST_NAME
, NVL(PARTY.DUNS_NUMBER
, 0) DUNS_NUMBER
, NVL(PARTY.CATEGORY_CODE
, 'NA') CATEGORY_CODE
, NVL(PARTY.EMAIL_ADDRESS
, 'NA') EMAIL_ADDRESS
, NVL(PARTY.PRIMARY_PHONE_NUMBER
, 'NA') PHONE_NUMBER
, NVL(CUST.SITE_USE_ID
, 0) LOCATION_ID
, NVL(LOC.ADDRESS1
, 'NA') CUST_ADD1
, NVL(LOC.ADDRESS2
, 'NA') CUST_ADD2
, NVL(LOC.ADDRESS3
, 'NA') CUST_ADD3
, NVL(LOC.CITY
, 'NA') CUST_CITY
, NVL(LOC.COUNTRY
, 'NA') CUST_COUNTRY
, NVL(LOC.POSTAL_CODE
, 'NA') CUST_POSTAL_CODE
, NVL(LOC.PO_BOX_NUMBER
, 'NA') CUST_PO_BOX
, CUST.CUST_USAGE_CODE SITE_USE_CODE
FROM OZF_SD_CUSTOMER_DETAILS CUST
, HZ_CUST_SITE_USES_ALL SITE
, HZ_CUST_ACCT_SITES ACCT_SITE
, HZ_PARTY_SITES PARTY_SITE
, HZ_LOCATIONS LOC
, HZ_PARTIES PARTY
WHERE CUST.SITE_USE_ID = SITE.SITE_USE_ID(+)
AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID(+)
AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID(+)
AND PARTY_SITE.LOCATION_ID = LOC.LOCATION_ID(+)
AND CUST.PARTY_ID = PARTY.PARTY_ID
AND CUST.END_CUSTOMER_FLAG = 'Y'