View: PA_CUSTOMER_LOV_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_CUSTOMER_LOV_V

View Text

SELECT /*+ CARDINALITY(100) FIRST_ROWS */ PC.CUSTOMER_NAME
, PC.CUSTOMER_NUMBER
, PC.CUSTOMER_ID
, R1.LOCATION
, R.ADDRESS1
, R.ADDRESS2
, R.ADDRESS3
, R.ADDRESS4
, R.DETAILS
, PC.STATUS
, R1.SITE_USE_CODE
, PC.PARTY_ID
, PC.PARTY_TYPE
, PC.CUSTOMER_NAME || '('|| PC.CUSTOMER_NUMBER || ')'
, DECODE(R1.SITE_USE_CODE
, 'BILL_TO'
, R1.LOCATION
, NULL) BILL_TO_LOCATION
FROM PA_CUSTOMERS_V PC
, (SELECT HZ_CS.CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, HZ_CS.CUST_ACCT_SITE_ID ADDRESS_ID
, HZ_L.ADDRESS1 ADDRESS1
, HZ_L.ADDRESS2 ADDRESS2
, HZ_L.ADDRESS3 ADDRESS3
, HZ_L.ADDRESS4 ADDRESS4
, HZ_L.CITY||'
, ' ||NVL(HZ_L.STATE
, HZ_L.PROVINCE)||'
, ' || HZ_L.COUNTY||'
, '||HZ_L.COUNTRY||'
, '||HZ_L.POSTAL_CODE AS DETAILS
FROM HZ_CUST_ACCT_SITES HZ_CS
, HZ_PARTY_SITES HZ_PS
, HZ_LOCATIONS HZ_L
WHERE NVL(HZ_CS.STATUS
, 'I')='A'
AND HZ_CS.PARTY_SITE_ID = HZ_PS.PARTY_SITE_ID
AND HZ_PS.LOCATION_ID = HZ_L.LOCATION_ID ) R
, (SELECT CUST_ACCT_SITE_ID ADDRESS_ID
, LOCATION
, SITE_USE_CODE
FROM HZ_CUST_SITE_USES SU
WHERE ( SU.SITE_USE_CODE ='BILL_TO' OR SU.SITE_USE_CODE='SHIP_TO')
AND NVL(SU.STATUS
, 'I')='A') R1
WHERE R.CUST_ACCOUNT_ID(+) = PC.CUSTOMER_ID
AND R.ADDRESS_ID = R1.ADDRESS_ID(+)

Columns