APPS.ASO_PRICING_INT dependencies on ASO_QUOTE_LINES_ALL

Line 131: aso_quote_lines_all ql

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
134: AND ql.quote_line_id = l_quote_line_id
135: AND ql.quote_line_id = qs.quote_line_id;

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 366: FROM aso_quote_lines_all qs

362: RETURN NUMBER
363: IS
364: CURSOR C_get_quote_info (l_quote_line_id NUMBER) IS
365: SELECT qs.invoice_to_party_site_id
366: FROM aso_quote_lines_all qs
367: WHERE qs.quote_line_id = l_quote_line_id;
368:
369: xl_inv_party_site_id NUMBER;
370:

Line 479: FROM aso_quote_lines_all

475: BEGIN
476:
477: SELECT SUM(nvl(quantity,0))
478: INTO l_quote_qty
479: FROM aso_quote_lines_all
480: WHERE quote_header_id=p_qte_header_id
481: AND (line_category_code<>'RETURN' OR line_category_code IS NULL)
482: GROUP BY quote_header_id;
483:

Line 504: FROM aso_quote_lines_all

500: BEGIN
501:
502: SELECT SUM((nvl(quantity,0))*(LINE_LIST_PRICE))
503: INTO l_quote_amount
504: FROM aso_quote_lines_all
505: WHERE quote_header_id=p_qte_header_id
506: AND (line_category_code<>'RETURN' OR line_category_code IS NULL)
507: AND charge_periodicity_code IS NULL
508: GROUP BY quote_header_id;

Line 533: FROM aso_i_items_v i, aso_quote_lines_all l

529: BEGIN
530:
531: SELECT shippable_item_flag
532: INTO x_shippable_item_flag
533: FROM aso_i_items_v i, aso_quote_lines_all l
534: WHERE l.quote_line_id = p_qte_line_id
535: and l.inventory_item_id = i.inventory_item_id
536: and l.organization_id = i.organization_id;
537:

Line 1248: FROM ASO_QUOTE_LINES_ALL

1244:
1245:
1246: CURSOR c_header_id IS
1247: SELECT QUOTE_HEADER_ID
1248: FROM ASO_QUOTE_LINES_ALL
1249: WHERE QUOTE_LINE_ID = p_qte_line_id;
1250:
1251: CURSOR c_list_id(l_qte_header_id NUMBER) IS
1252: SELECT price_list_id , CURRENCY_CODE