APPS.JAI_OM_UTILS_PKG dependencies on OE_ORDER_LINES_ALL

Line 50: -- Table "SO_LINES_ALL IS REPLACED BY "OE_ORDER_LINES_ALL"

46: SUM_TOT NUMBER;
47: NO NUMBER;
48:
49: -- Changed For Migration To R11i on 17-10-2000 by A.Raina
50: -- Table "SO_LINES_ALL IS REPLACED BY "OE_ORDER_LINES_ALL"
51: -- so field "UNIT_CODE" is replace by "ORDER_QUANTITY_UOM" .
52: -- Also table "SO_PRICE_LIST_LINES" is replaced by "SO_PRICE_LIST_LINES_115"
53:
54: CURSOR sel_line_id is

Line 56: FROM oe_order_lines_all

52: -- Also table "SO_PRICE_LIST_LINES" is replaced by "SO_PRICE_LIST_LINES_115"
53:
54: CURSOR sel_line_id is
55: SELECT line_id,ordered_quantity,order_quantity_uom,inventory_item_id
56: FROM oe_order_lines_all
57: WHERE line_id = il6;
58:
59: CURSOR sel_ato_lines(ln_id number) is select line_id,ato_line_id,ordered_quantity,inventory_itEM_ID,ORDER_QUANTITY_UOM
60: FROM oe_order_lines_all

Line 60: FROM oe_order_lines_all

56: FROM oe_order_lines_all
57: WHERE line_id = il6;
58:
59: CURSOR sel_ato_lines(ln_id number) is select line_id,ato_line_id,ordered_quantity,inventory_itEM_ID,ORDER_QUANTITY_UOM
60: FROM oe_order_lines_all
61: WHERE ato_line_id = ln_id;
62:
63: CURSOR n_lst_price(id number,unt varchar2) is /*select list_price
64: FROM so_price_list_lines_115

Line 877: -- Table "SO_LINES_ALL IS REPLACED BY "OE_ORDER_LINES_ALL"

873: ASUM_TOT NUMBER;
874: ANO NUMBER;
875:
876: -- Changed For Migration To R11i on 17-10-2000 by A.Raina
877: -- Table "SO_LINES_ALL IS REPLACED BY "OE_ORDER_LINES_ALL"
878: -- so field "UNIT_CODE" is replace by "ORDER_QUANTITY_UOM" .
879: -- Also table "SO_PRICE_LIST_LINES" is replaced by "SO_PRICE_LIST_LINES_115"
880:
881: CURSOR ASEL_LINE_ID IS

Line 883: FROM OE_ORDER_LINES_ALL

879: -- Also table "SO_PRICE_LIST_LINES" is replaced by "SO_PRICE_LIST_LINES_115"
880:
881: CURSOR ASEL_LINE_ID IS
882: SELECT LINE_ID,ORDERED_QUANTITY,ORDER_QUANTITY_UOM,INVENTORY_ITEM_ID
883: FROM OE_ORDER_LINES_ALL
884: WHERE LINE_ID = IL6;
885:
886: CURSOR ASEL_ATO_LINES(LN_ID NUMBER) IS
887: SELECT LINE_ID,ATO_LINE_ID,ORDERED_QUANTITY,INVENTORY_ITEM_ID,ORDER_QUANTITY_UOM

Line 888: FROM OE_ORDER_LINES_ALL

884: WHERE LINE_ID = IL6;
885:
886: CURSOR ASEL_ATO_LINES(LN_ID NUMBER) IS
887: SELECT LINE_ID,ATO_LINE_ID,ORDERED_QUANTITY,INVENTORY_ITEM_ID,ORDER_QUANTITY_UOM
888: FROM OE_ORDER_LINES_ALL
889: WHERE ATO_LINE_ID = LN_ID;
890:
891: CURSOR AN_LIST_PRICE (INVENT NUMBER,UNT NUMBER,NEW_NO NUMBER) IS
892: /*SELECT LIST_PRICE