eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PA_CUSTOMER_AGREEMENTS_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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