APPS.ASO_SOURCING_PVT dependencies on ASO_I_ITEMS_V

Line 617: FROM aso_i_items_v i, aso_quote_lines_all l

613: BEGIN
614:
615: SELECT shippable_item_flag
616: INTO x_shippable_item_flag
617: FROM aso_i_items_v i, aso_quote_lines_all l
618: WHERE l.quote_line_id = p_qte_line_id
619: and l.inventory_item_id = i.inventory_item_id
620: and l.organization_id = i.organization_id;
621:

Line 1038: --FROM aso_i_items_v i, aso_quote_lines_all l,

1034: END IF;
1035:
1036: --SELECT count(*)
1037: -- INTO x_count
1038: --FROM aso_i_items_v i, aso_quote_lines_all l,
1039: --aso_quote_headers_all h
1040: --WHERE l.quote_header_id=h.quote_header_id
1041: --and h.quote_header_id = p_qte_header_id
1042: --and l.inventory_item_id = i.inventory_item_id