APPS.JAI_OM_UTILS_PKG dependencies on SO_PRICE_LIST_LINES_115

Line 36: -- Also table "SO_PRICE_LIST_LINES" is replaced by "SO_PRICE_LIST_LINES_115"

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
39: SELECT line_id,ordered_quantity,order_quantity_uom,inventory_item_id
40: FROM oe_order_lines_all

Line 48: FROM so_price_list_lines_115

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
49: WHERE inventory_item_id = id
50: AND unit_code = unt
51: AND price_list_id = new_list;
52:

Line 475: -- Also table "SO_PRICE_LIST_LINES" is replaced by "SO_PRICE_LIST_LINES_115"

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
478: SELECT LINE_ID,ORDERED_QUANTITY,ORDER_QUANTITY_UOM,INVENTORY_ITEM_ID
479: FROM OE_ORDER_LINES_ALL

Line 489: FROM SO_PRICE_LIST_LINES_115

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
489: FROM SO_PRICE_LIST_LINES_115
490: WHERE INVENTORY_ITEM_ID = INVENT
491: AND UNIT_CODE = UNT
492: AND PRICE_LIST_ID = NEW_NO
493: AND SYSDATE BETWEEN