DBA Data[Home] [Help]

APPS.AST_ROUTING_PUB dependencies on OE_ORDER_HEADERS_ALL

Line 263: from oe_order_headers_all o, hz_cust_accounts a

259: l_more_partyID NUMBER;
260:
261: cursor getPartyIDfromOrderNum (p_OrderNum NUMBER) is
262: select a.party_id
263: from oe_order_headers_all o, hz_cust_accounts a
264: where o.order_number = p_OrderNum
265: and a.cust_account_id = o.sold_to_org_id;
266:
267: begin

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: