APPS.JAI_OM_UTILS_PKG dependencies on OE_ORDER_LINES_ALL

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

30: SUM_TOT NUMBER;
31: NO NUMBER;
32:
33: -- Changed For Migration To R11i on 17-10-2000 by A.Raina
34: -- Table "SO_LINES_ALL IS REPLACED BY "OE_ORDER_LINES_ALL"
35: -- so field "UNIT_CODE" is replace by "ORDER_QUANTITY_UOM" .
36: -- Also table "SO_PRICE_LIST_LINES" is replaced by "SO_PRICE_LIST_LINES_115"
37:
38: CURSOR sel_line_id is

Line 40: FROM oe_order_lines_all

36: -- Also table "SO_PRICE_LIST_LINES" is replaced by "SO_PRICE_LIST_LINES_115"
37:
38: CURSOR sel_line_id is
39: SELECT line_id,ordered_quantity,order_quantity_uom,inventory_item_id
40: FROM oe_order_lines_all
41: WHERE line_id = il6;
42:
43: CURSOR sel_ato_lines(ln_id number) is select line_id,ato_line_id,ordered_quantity,inventory_itEM_ID,ORDER_QUANTITY_UOM
44: FROM oe_order_lines_all

Line 44: FROM oe_order_lines_all

40: FROM oe_order_lines_all
41: WHERE line_id = il6;
42:
43: CURSOR sel_ato_lines(ln_id number) is select line_id,ato_line_id,ordered_quantity,inventory_itEM_ID,ORDER_QUANTITY_UOM
44: FROM oe_order_lines_all
45: WHERE ato_line_id = ln_id;
46:
47: CURSOR n_lst_price(id number,unt varchar2) is select list_price
48: FROM so_price_list_lines_115

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

469: ASUM_TOT NUMBER;
470: ANO NUMBER;
471:
472: -- Changed For Migration To R11i on 17-10-2000 by A.Raina
473: -- Table "SO_LINES_ALL IS REPLACED BY "OE_ORDER_LINES_ALL"
474: -- so field "UNIT_CODE" is replace by "ORDER_QUANTITY_UOM" .
475: -- Also table "SO_PRICE_LIST_LINES" is replaced by "SO_PRICE_LIST_LINES_115"
476:
477: CURSOR ASEL_LINE_ID IS

Line 479: FROM OE_ORDER_LINES_ALL

475: -- Also table "SO_PRICE_LIST_LINES" is replaced by "SO_PRICE_LIST_LINES_115"
476:
477: CURSOR ASEL_LINE_ID IS
478: SELECT LINE_ID,ORDERED_QUANTITY,ORDER_QUANTITY_UOM,INVENTORY_ITEM_ID
479: FROM OE_ORDER_LINES_ALL
480: WHERE LINE_ID = IL6;
481:
482: CURSOR ASEL_ATO_LINES(LN_ID NUMBER) IS
483: SELECT LINE_ID,ATO_LINE_ID,ORDERED_QUANTITY,INVENTORY_ITEM_ID,ORDER_QUANTITY_UOM

Line 484: FROM OE_ORDER_LINES_ALL

480: WHERE LINE_ID = IL6;
481:
482: CURSOR ASEL_ATO_LINES(LN_ID NUMBER) IS
483: SELECT LINE_ID,ATO_LINE_ID,ORDERED_QUANTITY,INVENTORY_ITEM_ID,ORDER_QUANTITY_UOM
484: FROM OE_ORDER_LINES_ALL
485: WHERE ATO_LINE_ID = LN_ID;
486:
487: CURSOR AN_LIST_PRICE (INVENT NUMBER,UNT NUMBER,NEW_NO NUMBER) IS
488: SELECT LIST_PRICE