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.RLM_VALIDATEDEMAND_SV dependencies on HZ_CUST_ACCT_SITES_ALL

Line 6118: FROM hz_cust_acct_sites_all hcas, hz_cust_site_uses_all hcsu

6114: SELECT hcas.status, cust_account_id, hcsu.status,
6115: hcsu.site_use_id
6116: INTO v_addStatus, v_int_shp_to_cust_id, v_siteUseStatus,
6117: x_lines_rec.intrmd_st_site_use_id
6118: FROM hz_cust_acct_sites_all hcas, hz_cust_site_uses_all hcsu
6119: WHERE hcas.cust_acct_site_id = x_lines_rec.intrmd_ship_to_id
6120: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id
6121: AND hcsu.site_use_code = 'SHIP_TO'
6122: AND hcas.org_id = hcsu.org_id;

Line 6978: FROM hz_cust_acct_sites_all hcas, hz_cust_site_uses_all hcsu

6974: -- Following query is changed as per TCA obsolescence project.
6975: SELECT hcas.status, cust_account_id, hcsu.status, hcsu.site_use_id
6976: INTO v_addStatus, x_lines_rec.ship_to_customer_id, v_siteUseStatus,
6977: x_lines_rec.ship_to_site_use_id
6978: FROM hz_cust_acct_sites_all hcas, hz_cust_site_uses_all hcsu
6979: WHERE hcas.cust_acct_site_id = x_lines_rec.ship_to_address_id
6980: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id
6981: AND hcsu.site_use_code = 'SHIP_TO'
6982: AND hcas.org_id = hcsu.org_id;