APPS.ASO_TRADEIN_PVT dependencies on ASO_QUOTE_LINES_ALL

Line 34: SELECT inventory_item_id, line_category_code from aso_quote_lines_all

30: WHERE inventory_item_id = l_inv_item_id
31: AND organization_id = p_qte_line_rec.organization_id;
32:
33: CURSOR C_inventory_item is
34: SELECT inventory_item_id, line_category_code from aso_quote_lines_all
35: where quote_line_id = p_qte_line_rec.quote_line_id;
36:
37: CURSOR C_item_type IS
38: SELECT item_type_code FROM aso_quote_lines_all

Line 38: SELECT item_type_code FROM aso_quote_lines_all

34: SELECT inventory_item_id, line_category_code from aso_quote_lines_all
35: where quote_line_id = p_qte_line_rec.quote_line_id;
36:
37: CURSOR C_item_type IS
38: SELECT item_type_code FROM aso_quote_lines_all
39: WHERE quote_line_id = p_qte_line_rec.quote_line_id;
40:
41: CURSOR C_Service_Available IS
42: SELECT count(related_quote_line_id) FROM aso_line_relationships

Line 456: FROM ASO_QUOTE_LINES_ALL a, ASO_QUOTE_LINE_DETAILS b

452: CONNECT BY object_id = prior subject_id;
453:
454: CURSOR C_Ln_Dtl_Instances(l_instance_id NUMBER, l_header_id NUMBER) IS
455: SELECT 'Y'
456: FROM ASO_QUOTE_LINES_ALL a, ASO_QUOTE_LINE_DETAILS b
457: WHERE a.quote_line_id = b.quote_line_id
458: AND a.quote_header_id = l_header_id
459: AND b.instance_id = l_instance_id;
460:

Line 940: FROM ASO_QUOTE_LINES_ALL

936: WHERE quote_line_id = l_line_id;
937:
938: CURSOR C_Get_Qot_Qty(l_line_id NUMBER) IS
939: SELECT quantity
940: FROM ASO_QUOTE_LINES_ALL
941: WHERE quote_line_id = l_line_id;
942:
943: CURSOR C_Get_Ord_Qty(l_line_id NUMBER) IS
944: SELECT ordered_quantity