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 5057: FROM HZ_CUST_ACCT_SITES_ALL acct

5053: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5054:
5055: CURSOR c_hold_orgs IS
5056: SELECT DISTINCT org_id
5057: FROM HZ_CUST_ACCT_SITES_ALL acct
5058: WHERE acct.cust_account_id = p_hold_entity_id
5059: AND NOT EXISTS (SELECT 1
5060: FROM OE_HOLD_SOURCES_ALL src
5061: WHERE acct.cust_account_id = src.hold_entity_id

Line 5078: from HZ_CUST_ACCT_SITES_ALL hzcas

5074: and hold_entity_code = 'C'
5075: and hold_id = p_hold_id
5076: and nvl(RELEASED_FLAG, 'N') = 'N')
5077: AND NOT EXISTS (select 1
5078: from HZ_CUST_ACCT_SITES_ALL hzcas
5079: where hzcas.cust_account_id = p_hold_entity_id
5080: and hzcas.cust_account_id = hdr.sold_to_org_id);
5081:
5082: