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.AST_ROUTING_PUB dependencies on HZ_CUST_ACCOUNT_ROLES

Line 307: from oe_order_headers_all o, hz_cust_account_roles car, hz_cust_accounts ca

303: -- commented out lines above as table not available yet
304: -- from aso_quote_headers_all
305: -- where quote_number = p_CollRequest;
306: -- 01/13/2003 - not using AMS or ASO tables, going straight to OE tables
307: from oe_order_headers_all o, hz_cust_account_roles car, hz_cust_accounts ca
308: where o.order_number = p_CollRequest
309: and o.sold_to_contact_id = car.cust_account_role_id(+)
310: and o.sold_to_org_id = ca.cust_account_id;
311:

Line 352: from hz_cust_account_roles

348:
349: -- kmahajan 03/26/03 - changed cursor to fix bug 2872318
350: cursor getAccountRoles (p_AccountID NUMBER) is
351: select cust_account_id
352: from hz_cust_account_roles
353: where cust_account_id = p_AccountID;
354:
355: begin
356: if p_object_value is null or p_object_value = '' then