APPS.IBE_QUOTE_SAVE_PVT dependencies on ASO_QUOTE_LINES_ALL

Line 7692: from aso_quote_lines_all aql,

7688: aql.uom_code,
7689: aql.quantity,
7690: aqld.config_header_id,
7691: aqld.config_revision_num
7692: from aso_quote_lines_all aql,
7693: aso_quote_line_details AQLD
7694: where aqld.quote_line_id = aql.quote_line_id and
7695: aqld.ref_line_id is null and
7696: aql.quote_header_id = :1';

Line 8099: FROM aso_quote_lines_all AQL, aso_quote_line_details ALD

8095: l_quote_Line_Dtl_Tbl ASO_Quote_Pub.Qte_Line_dtl_Tbl_Type := ASO_Quote_Pub.G_MISS_QTE_LINE_DTL_TBL;
8096:
8097: CURSOR c_get_svc_lines(p_quote_header_id NUMBER) IS
8098: SELECT AQL.quote_line_id,ALD.service_ref_line_id,AQL.inventory_item_id
8099: FROM aso_quote_lines_all AQL, aso_quote_line_details ALD
8100: WHERE AQL.quote_header_id = p_quote_header_id and AQL.quote_line_id=ALD.quote_line_id
8101: and AQL.item_type_code='SRV'
8102: ORDER BY ALD.service_ref_line_id,AQL.inventory_item_id;
8103:

Line 8105: SELECT quote_line_id, quantity FROM aso_quote_lines_all

8101: and AQL.item_type_code='SRV'
8102: ORDER BY ALD.service_ref_line_id,AQL.inventory_item_id;
8103:
8104: CURSOR c_get_sva_lines(p_quote_header_id NUMBER) IS
8105: SELECT quote_line_id, quantity FROM aso_quote_lines_all
8106: WHERE quote_header_id = p_quote_header_id and ITEM_TYPE_CODE='SVA'
8107: ORDER BY quote_line_id;
8108:
8109: CURSOR c_get_line_qty(p_quote_line_id NUMBER) IS

Line 8110: SELECT quantity FROM aso_quote_lines_all

8106: WHERE quote_header_id = p_quote_header_id and ITEM_TYPE_CODE='SVA'
8107: ORDER BY quote_line_id;
8108:
8109: CURSOR c_get_line_qty(p_quote_line_id NUMBER) IS
8110: SELECT quantity FROM aso_quote_lines_all
8111: WHERE quote_line_id = p_quote_line_id;
8112: BEGIN
8113: -- Standard Start of API savepoint
8114: SAVEPOINT UPDATE_SUPPORT_LEVEL_AND_QTY;