DBA Data[Home] [Help]

APPS.GML_OPM_OM_CONV_MIG_PKG dependencies on IC_ITEM_MST

Line 152: FROM mtl_system_items m, ic_item_mst ic -- 5475003 rework

148: AND (lot_id >0 OR location <> l_IC$DEFAULT_LOCT);
149:
150: CURSOR get_item_details(p_item_id IN NUMBER, p_organization_id IN NUMBER) IS
151: SELECT m.lot_divisible_flag,m.lot_control_code,m.tracking_quantity_ind, ic.NONINV_IND -- 5475003 rework
152: FROM mtl_system_items m, ic_item_mst ic -- 5475003 rework
153: WHERE inventory_item_id = p_item_id and organization_id = p_organization_id
154: AND m.segment1 = ic.item_no; -- 5475003 rework
155:
156: CURSOR get_whse_details(p_whse_code IN VARCHAR2) IS

Line 262: IF l_opm_noninv_ind = 0 THEN -- 5475003 only check allocations if an inventory item (control from ic_item_mst)

258: GMI_RESERVATION_UTIL.println('l_opm_noninv_ind : '||l_opm_noninv_ind );
259: GMI_RESERVATION_UTIL.println('l_lot_control_code : '||l_lot_control_code);
260: GMI_RESERVATION_UTIL.println('ordered_quantity : '||open_order_line_rec.qty);
261:
262: IF l_opm_noninv_ind = 0 THEN -- 5475003 only check allocations if an inventory item (control from ic_item_mst)
263: /* -- NOTA BENE - we do not create move orders either for a non-inventory item in R12 (in 11i OPM we did ) */
264: /* Are there allocations for this? If so create reservations for these allocations */
265:
266: GMI_RESERVATION_UTIL.println('line_id is '|| open_order_line_rec.line_id);

Line 722: IF l_opm_noninv_ind = 0 THEN -- -- 5475003 rework 10/19 - only create Move Orders if an inventory item (control from ic_item_mst)

718:
719:
720: BEGIN
721:
722: IF l_opm_noninv_ind = 0 THEN -- -- 5475003 rework 10/19 - only create Move Orders if an inventory item (control from ic_item_mst)
723: /* - we do not create move orders for a non-inventory item in R12 (in 11i OPM we did ) */
724:
725: GMI_RESERVATION_UTIL.PrintLn('In move_order_line_rec cursor and this is an inventory item - Sales Order line_id : ic_txn_request_lines line id '|| to_char(open_order_line_rec.line_id)||':'||to_char(move_order_line_rec.line_id));
726: