View: PA_CUSTOMER_AGREEMENTS_V

Product:	PA - Projects
Description:	10SC Only
Implementation/DBA Data:	APPS.PA_CUSTOMER_AGREEMENTS_V

View Text

SELECT PC.ROWID ROW_ID
, PC.PROJECT_ID
, PC.CUSTOMER_ID
, HZ_L.ADDRESS1
, HZ_L.ADDRESS2
, HZ_L.ADDRESS3
, HZ_L.ADDRESS4 || DECODE(HZ_L.ADDRESS4
, NULL
, NULL
, '
, ') || HZ_L.CITY || '
, ' || NVL(HZ_L.STATE
, HZ_L.PROVINCE) || '
, ' || HZ_L.COUNTY ADDRESS4
FROM PA_PROJECT_CUSTOMERS PC
, HZ_LOCATIONS HZ_L
, HZ_CUST_ACCT_SITES_ALL S
, HZ_PARTY_SITES PS
WHERE PC.BILL_TO_ADDRESS_ID = S.CUST_ACCT_SITE_ID
AND PS.PARTY_SITE_ID = S.PARTY_SITE_ID
AND HZ_L.LOCATION_ID = PS.LOCATION_ID

Columns