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.ASO_PRICING_INT dependencies on ASO_QUOTE_HEADERS_ALL

Line 48: FROM aso_quote_headers_all

44: BEGIN
45:
46: SELECT cust_account_id
47: INTO x_cust_account_id
48: FROM aso_quote_headers_all
49: WHERE quote_header_id = p_quote_header_id;
50:
51: IF (SQL%NOTFOUND) THEN
52: null;

Line 76: FROM aso_quote_headers_all qh, aso_shipments qs

72: l_ship_to_cust_account_id NUMBER;
73:
74: CURSOR C_get_quote_info (l_quote_header_id NUMBER) IS
75: SELECT qh.cust_account_id, qs.ship_to_party_site_id,qs.ship_to_cust_account_id
76: FROM aso_quote_headers_all qh, aso_shipments qs
77: WHERE qh.quote_header_id = qs.quote_header_id
78: AND qh.quote_header_id = l_quote_header_id
79: AND qs.quote_line_id is NULL;
80:

Line 129: FROM aso_quote_headers_all qh,

125: l_ship_to_cust_account_id NUMBER;
126:
127: CURSOR C_get_quote_info (l_quote_line_id NUMBER) IS
128: SELECT qh.cust_account_id, qs.ship_to_party_site_id,qs.ship_to_cust_account_id
129: FROM aso_quote_headers_all qh,
130: aso_shipments qs,
131: aso_quote_lines_all ql
132: WHERE qh.quote_header_id = qs.quote_header_id
133: AND ql.quote_header_id = qh.quote_header_id

Line 189: FROM aso_quote_headers_all

185: CURSOR C_get_quote_info (l_quote_header_id NUMBER) IS
186: SELECT cust_account_id,
187: invoice_to_party_site_id,
188: 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 247: FROM aso_quote_headers_all qh, aso_quote_lines_all ql

243: CURSOR C_get_quote_info (l_quote_line_id NUMBER) IS
244: SELECT qh.cust_account_id,
245: ql.invoice_to_party_site_id,
246: ql.invoice_to_cust_account_id
247: FROM aso_quote_headers_all qh, aso_quote_lines_all ql
248: WHERE ql.quote_line_id = l_quote_line_id
249: AND ql.quote_header_id = qh.quote_header_id;
250:
251: BEGIN

Line 342: FROM aso_quote_headers_all qs

338: RETURN NUMBER
339: IS
340: CURSOR C_get_quote_info (l_quote_header_id NUMBER) IS
341: SELECT qs.invoice_to_party_site_id
342: FROM aso_quote_headers_all qs
343: WHERE qs.quote_header_id = l_quote_header_id;
344:
345: x_invoice_party_site_id NUMBER := NULL;
346:

Line 1238: FROM ASO_QUOTE_HEADERS_ALL

1234: WHERE QUOTE_LINE_ID = p_qte_line_id;
1235:
1236: CURSOR c_list_id(l_qte_header_id NUMBER) IS
1237: SELECT price_list_id , CURRENCY_CODE
1238: FROM ASO_QUOTE_HEADERS_ALL
1239: WHERE QUOTE_HEADER_ID = l_qte_header_id;
1240:
1241: BEGIN
1242: