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 6046: FROM hz_cust_acct_sites_all hcas, hz_cust_site_uses_all hcsu

6042:
6043: CURSOR c_IntrmdShipToID IS --Added cursor as part of Bugfix 8672453
6044: SELECT hcas.status, cust_account_id, hcsu.status,
6045: hcsu.site_use_id
6046: FROM hz_cust_acct_sites_all hcas, hz_cust_site_uses_all hcsu
6047: WHERE hcas.cust_acct_site_id = x_lines_rec.intrmd_ship_to_id
6048: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id
6049: AND hcsu.site_use_code = 'SHIP_TO'
6050: AND hcas.org_id = hcsu.org_id

Line 6838: FROM hz_cust_acct_sites_all hcas, hz_cust_site_uses_all hcsu

6834: ORDER BY hcsu.status; --To query first Active and then Inactive records
6835:
6836: CURSOR c_ShipToID IS --Added cursor as part of Bugfix 8672453
6837: SELECT hcas.status, cust_account_id, hcsu.status, hcsu.site_use_id
6838: FROM hz_cust_acct_sites_all hcas, hz_cust_site_uses_all hcsu
6839: WHERE hcas.cust_acct_site_id = x_lines_rec.ship_to_address_id
6840: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id
6841: AND hcsu.site_use_code = 'SHIP_TO'
6842: AND hcas.org_id = hcsu.org_id