APPS.IBE_QUOTE_SAVE_PVT dependencies on ASO_QUOTE_LINES_ALL

Line 7550: from aso_quote_lines_all aql,

7546: aql.uom_code,
7547: aql.quantity,
7548: aqld.config_header_id,
7549: aqld.config_revision_num
7550: from aso_quote_lines_all aql,
7551: aso_quote_line_details AQLD
7552: where aqld.quote_line_id = aql.quote_line_id and
7553: aqld.ref_line_id is null and
7554: aql.quote_header_id = :1';

Line 7957: FROM aso_quote_lines_all AQL, aso_quote_line_details ALD

7953: l_quote_Line_Dtl_Tbl ASO_Quote_Pub.Qte_Line_dtl_Tbl_Type := ASO_Quote_Pub.G_MISS_QTE_LINE_DTL_TBL;
7954:
7955: CURSOR c_get_svc_lines(p_quote_header_id NUMBER) IS
7956: SELECT AQL.quote_line_id,ALD.service_ref_line_id,AQL.inventory_item_id
7957: FROM aso_quote_lines_all AQL, aso_quote_line_details ALD
7958: WHERE AQL.quote_header_id = p_quote_header_id and AQL.quote_line_id=ALD.quote_line_id
7959: and AQL.item_type_code='SRV'
7960: ORDER BY ALD.service_ref_line_id,AQL.inventory_item_id;
7961:

Line 7963: SELECT quote_line_id, quantity FROM aso_quote_lines_all

7959: and AQL.item_type_code='SRV'
7960: ORDER BY ALD.service_ref_line_id,AQL.inventory_item_id;
7961:
7962: CURSOR c_get_sva_lines(p_quote_header_id NUMBER) IS
7963: SELECT quote_line_id, quantity FROM aso_quote_lines_all
7964: WHERE quote_header_id = p_quote_header_id and ITEM_TYPE_CODE='SVA'
7965: ORDER BY quote_line_id;
7966:
7967: CURSOR c_get_line_qty(p_quote_line_id NUMBER) IS

Line 7968: SELECT quantity FROM aso_quote_lines_all

7964: WHERE quote_header_id = p_quote_header_id and ITEM_TYPE_CODE='SVA'
7965: ORDER BY quote_line_id;
7966:
7967: CURSOR c_get_line_qty(p_quote_line_id NUMBER) IS
7968: SELECT quantity FROM aso_quote_lines_all
7969: WHERE quote_line_id = p_quote_line_id;
7970: BEGIN
7971: -- Standard Start of API savepoint
7972: SAVEPOINT UPDATE_SUPPORT_LEVEL_AND_QTY;