VIEW: APPS.PA_TASK_CUSTOMERS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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