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

Line 5604: FROM HZ_CUST_ACCT_SITES_ALL acct

5600: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5601:
5602: CURSOR c_hold_orgs IS
5603: SELECT DISTINCT org_id
5604: FROM HZ_CUST_ACCT_SITES_ALL acct
5605: WHERE acct.cust_account_id = p_hold_entity_id
5606: AND NOT EXISTS (SELECT 1
5607: FROM OE_HOLD_SOURCES_ALL src
5608: WHERE acct.cust_account_id = src.hold_entity_id

Line 5625: from HZ_CUST_ACCT_SITES_ALL hzcas

5621: and hold_entity_code = 'C'
5622: and hold_id = p_hold_id
5623: and nvl(RELEASED_FLAG, 'N') = 'N')
5624: AND NOT EXISTS (select 1
5625: from HZ_CUST_ACCT_SITES_ALL hzcas
5626: where hzcas.cust_account_id = p_hold_entity_id
5627: and hzcas.cust_account_id = hdr.sold_to_org_id);
5628:
5629: