APPS.ASO_SOURCING_PVT dependencies on ASO_QUOTE_HEADERS_ALL

Line 25: FROM aso_quote_headers_all

21: BEGIN
22:
23: SELECT cust_account_id
24: INTO x_cust_account_id
25: FROM aso_quote_headers_all
26: WHERE quote_header_id = p_quote_header_id;
27:
28: IF (SQL%NOTFOUND) THEN
29: null;

Line 56: FROM aso_quote_headers_all qh, aso_shipments qs

52: l_ship_to_cust_account_id NUMBER;
53:
54: CURSOR C_get_quote_info (l_quote_header_id NUMBER) IS
55: SELECT qh.cust_account_id, qs.ship_to_party_site_id,qs.ship_to_cust_account_id
56: FROM aso_quote_headers_all qh, aso_shipments qs
57: WHERE qh.quote_header_id = qs.quote_header_id
58: AND qh.quote_header_id = l_quote_header_id
59: AND qs.quote_line_id is NULL;
60:

Line 121: FROM aso_quote_headers_all qh, aso_shipments qs, aso_quote_lines_all ql

117: l_quote_header_id number;
118: CURSOR C_get_quote_info (l_quote_line_id NUMBER) IS
119: SELECT qh.cust_account_id, qs.ship_to_party_site_id,
120: qs.ship_to_cust_account_id,qh.quote_header_id
121: FROM aso_quote_headers_all qh, aso_shipments qs, aso_quote_lines_all ql
122: WHERE qh.quote_header_id = qs.quote_header_id
123: AND ql.quote_header_id = qh.quote_header_id
124: AND ql.quote_line_id = l_quote_line_id
125: AND ql.quote_line_id = qs.quote_line_id;

Line 189: FROM aso_quote_headers_all

185:
186:
187: CURSOR C_get_quote_info (l_quote_header_id NUMBER) IS
188: SELECT cust_account_id, invoice_to_party_site_id,invoice_to_cust_account_id
189: FROM aso_quote_headers_all
190: WHERE quote_header_id = l_quote_header_id;
191:
192: BEGIN
193:

Line 258: FROM aso_quote_headers_all qh, aso_quote_lines_all ql

254: l_quote_header_id number;
255: CURSOR C_get_quote_info (l_quote_line_id NUMBER) IS
256: SELECT qh.cust_account_id, ql.invoice_to_party_site_id,
257: ql.invoice_to_cust_account_id, qh.quote_header_id
258: FROM aso_quote_headers_all qh, aso_quote_lines_all ql
259: WHERE ql.quote_line_id = l_quote_line_id
260: AND ql.quote_header_id = qh.quote_header_id;
261:
262: BEGIN

Line 369: FROM aso_quote_headers_all qs

365: RETURN NUMBER
366: IS
367: CURSOR C_get_quote_info (l_quote_header_id NUMBER) IS
368: SELECT qs.invoice_to_party_site_id
369: FROM aso_quote_headers_all qs
370: WHERE qs.quote_header_id = l_quote_header_id;
371:
372: x_invoice_party_site_id NUMBER := NULL;
373:

Line 427: FROM aso_quote_headers_all

423: BEGIN
424:
425: SELECT party_id
426: INTO x_party_id
427: FROM aso_quote_headers_all
428: WHERE quote_header_id = p_quote_header_id;
429:
430: IF (SQL%NOTFOUND) THEN
431: null;

Line 1039: --aso_quote_headers_all h

1035:
1036: --SELECT count(*)
1037: -- INTO x_count
1038: --FROM aso_i_items_v i, aso_quote_lines_all l,
1039: --aso_quote_headers_all h
1040: --WHERE l.quote_header_id=h.quote_header_id
1041: --and h.quote_header_id = p_qte_header_id
1042: --and l.inventory_item_id = i.inventory_item_id
1043: --and l.organization_id = i.organization_id