APPS.INV_OPM_LOT_MIGRATION dependencies on IC_ITEM_MST_B

Line 219: FROM ic_item_mst_b

215: DECODE(sublot_ctl, 1, DECODE(l_opm_lot.sublot_no, NULL, NULL,
216: l_opm_lot.lot_no)),
217: status_ctl, lot_status
218: INTO x_lot_number, x_parent_lot_number, l_status_ctl, l_default_status
219: FROM ic_item_mst_b
220: WHERE
221: item_id = p_item_id;
222:
223: -- Get the inventory status for the lot

Line 835: FROM ic_item_mst_b i, mtl_system_items_b d

831: l_field_name := 'Matching OPM Item';
832: l_field_value := to_char(p_organization_id) ||', '||to_char(p_inventory_item_id);
833: SELECT i.item_id
834: INTO l_item_id
835: FROM ic_item_mst_b i, mtl_system_items_b d
836: WHERE
837: d.organization_id = p_organization_id AND
838: d.inventory_item_id = p_inventory_item_id AND
839: d.segment1 = i.item_no;