View: PA_TASK_CUSTOMERS_V

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

View Text

SELECT PC1.PROJECT_ID
, PT.CUSTOMER_ID
, SUBSTRB(PARTY.PARTY_NAME
, 1
, 50)
, CUST_ACCT.ACCOUNT_NUMBER
, PC1.BILL_TO_CUSTOMER_ID
, PC1.SHIP_TO_CUSTOMER_ID
, PC1.BILL_TO_ADDRESS_ID
, BA_LOC.ADDRESS1
, BA_LOC.ADDRESS2
, BA_LOC.ADDRESS3
, BA_LOC.ADDRESS4 || DECODE(BA_LOC.ADDRESS4
, NULL
, NULL
, '
, ')||BA_LOC.CITY|| '
, '||NVL(BA_LOC.STATE
, BA_LOC.PROVINCE)||' '||BA_LOC.POSTAL_CODE||'
, '||BA_LOC.COUNTY
, PC1.SHIP_TO_ADDRESS_ID
, SA_LOC.ADDRESS1
, SA_LOC.ADDRESS2
, SA_LOC.ADDRESS3
, SA_LOC.ADDRESS4 || DECODE(SA_LOC.ADDRESS4
, NULL
, NULL
, '
, ')||SA_LOC.CITY|| '
, '||NVL(SA_LOC.STATE
, SA_LOC.PROVINCE)||' '||SA_LOC.POSTAL_CODE||'
, '||SA_LOC.COUNTY
, PT.TASK_ID
FROM HZ_PARTY_SITES BA_PARTY_SITE
, HZ_LOCATIONS BA_LOC
, HZ_CUST_ACCT_SITES BA_ACCT_SITE
, HZ_PARTY_SITES SA_PARTY_SITE
, HZ_LOCATIONS SA_LOC
, HZ_CUST_ACCT_SITES SA_ACCT_SITE
, HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS CUST_ACCT
, PA_PROJECT_CUSTOMERS PC1
, PA_TASKS PT
WHERE PC1.CUSTOMER_ID = CUST_ACCT.CUST_ACCOUNT_ID
AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
AND PC1.BILL_TO_ADDRESS_ID = BA_ACCT_SITE.CUST_ACCT_SITE_ID(+)
AND BA_ACCT_SITE.PARTY_SITE_ID = BA_PARTY_SITE.PARTY_SITE_ID(+)
AND BA_PARTY_SITE.LOCATION_ID = BA_LOC.LOCATION_ID(+)
AND PC1.SHIP_TO_ADDRESS_ID = SA_ACCT_SITE.CUST_ACCT_SITE_ID(+)
AND SA_ACCT_SITE.PARTY_SITE_ID = SA_PARTY_SITE.PARTY_SITE_ID (+)
AND SA_PARTY_SITE.LOCATION_ID = SA_LOC.LOCATION_ID(+)
AND PC1.CUSTOMER_ID = PT.CUSTOMER_ID
AND PC1.PROJECT_ID = PT.PROJECT_ID

Columns