APPS.AST_ROUTING_PUB dependencies on ASO_QUOTE_HEADERS_ALL

Line 223: from aso_quote_headers_all

219: l_more_partyID NUMBER;
220:
221: cursor getPartyIDfromQuoteNum (p_QuoteNum NUMBER) is
222: select party_id
223: from aso_quote_headers_all
224: where quote_number = p_QuoteNum
225: ;
226: -- commented out as this column is introduced only in ASO.J
227: --and max_version_flag = 'Y';

Line 304: -- from aso_quote_headers_all

300: select nvl(car.party_id, ca.party_id)
301: -- from ams_request_history
302: -- where order_id = p_CollRequest;
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