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.

APPS.CSTPMRGL dependencies on HZ_CUST_ACCT_SITES_ALL

Line 1490: hz_cust_acct_sites_all hcasa,

1486: SET bill_to_customer_name =
1487: (SELECT SUBSTRB(hp.party_name,1,50)
1488: FROM hz_cust_accounts hca,
1489: hz_cust_site_uses_all hcsua,
1490: hz_cust_acct_sites_all hcasa,
1491: hz_parties hp
1492: WHERE
1493: NVL(hca.org_id, -999) = NVL(l_ou_id,NVL(hca.org_id, -999))
1494: and hca.cust_account_id = hcasa.cust_account_id

Line 1516: hz_cust_acct_sites_all hcasa,

1512: SET ship_to_customer_name =
1513: (SELECT SUBSTRB(hp.party_name,1,50)
1514: FROM hz_cust_accounts hca,
1515: hz_cust_site_uses_all hcsua,
1516: hz_cust_acct_sites_all hcasa,
1517: hz_parties hp
1518: WHERE
1519: NVL(hca.org_id, -999) = NVL(l_ou_id,NVL(hca.org_id, -999))
1520: and hca.cust_account_id = hcasa.cust_account_id