APPS.GMI_PRE_MIGRATION dependencies on IC_LOTS_MST

Line 109: l_table_name := 'IC_LOTS_MST';

105: IF p_opm_desc_flex_name = 'ITEM_FLEX' THEN
106: l_table_name := 'IC_ITEM_MST_B';
107: l_context := 'ITEMS';
108: ELSIF p_opm_desc_flex_name = 'LOT_FLEX' THEN
109: l_table_name := 'IC_LOTS_MST';
110: l_context := 'LOTS';
111: END IF;
112: SELECT cont.descriptive_flex_context_code
113: INTO l_opm_context

Line 207: FROM ic_loct_inv inv, ic_item_mst_b i, ic_lots_mst l, ic_whse_mst w

203: autolot_active_indicator <> 1;
204:
205: CURSOR c_lot_status IS
206: SELECT i.item_no, l.lot_no, l.sublot_no, w.orgn_code, w.whse_code, inv.location, inv.lot_status
207: FROM ic_loct_inv inv, ic_item_mst_b i, ic_lots_mst l, ic_whse_mst w
208: WHERE
209: inv.whse_code = w.whse_code AND
210: inv.item_id = i.item_id AND
211: i.lot_ctl = 1 AND

Line 297: ic_lots_mst l

293: SELECT i.item_no, l.lot_no, l.sublot_no, inv.whse_code, inv.location,
294: inv.loct_onhand, inv.loct_onhand2
295: FROM ic_loct_inv inv,
296: ic_item_mst_b i,
297: ic_lots_mst l
298: WHERE
299: inv.item_id = i.item_id AND
300: inv.item_id = l.item_id AND
301: inv.lot_id = l.lot_id AND

Line 312: ic_lots_mst l

308: SELECT i.item_no, l.lot_no, l.sublot_no, inv.whse_code, inv.location,
309: inv.loct_onhand, inv.loct_onhand2
310: FROM ic_loct_inv inv,
311: ic_item_mst_b i,
312: ic_lots_mst l
313: WHERE
314: inv.item_id = i.item_id AND
315: inv.item_id = l.item_id AND
316: inv.lot_id = l.lot_id AND

Line 327: ic_lots_mst l

323: SELECT i.item_no, l.lot_no, l.sublot_no, inv.whse_code, inv.location,
324: inv.loct_onhand, inv.loct_onhand2
325: FROM ic_loct_inv inv,
326: ic_item_mst_b i,
327: ic_lots_mst l
328: WHERE
329: inv.item_id = i.item_id AND
330: inv.item_id = l.item_id AND
331: inv.lot_id = l.lot_id AND

Line 341: ic_lots_mst l

337: SELECT i.item_no, l.lot_no, l.sublot_no, inv.whse_code, inv.location,
338: inv.loct_onhand, inv.loct_onhand2
339: FROM ic_loct_inv inv,
340: ic_item_mst_b i,
341: ic_lots_mst l
342: WHERE
343: inv.item_id = i.item_id AND
344: i.noninv_ind = 1 AND
345: inv.item_id = l.item_id AND

Line 392: p_table_name => 'IC_LOTS_MST',

388: GMA_COMMON_LOGGING.gma_migration_central_log (
389: p_run_id => p_migration_run_id,
390: p_log_level => FND_LOG.LEVEL_PROCEDURE,
391: p_message_token => 'GMI_MIG_MULTIPLE_STATUS_LOT',
392: p_table_name => 'IC_LOTS_MST',
393: p_context => 'LOTS',
394: p_param1 => ls.item_no,
395: p_param2 => ls.lot_no||l_delimiter||ls.sublot_no,
396: p_param3 => ls.whse_code,

Line 410: p_table_name => 'IC_LOTS_MST',

406: GMA_COMMON_LOGGING.gma_migration_central_log (
407: p_run_id => p_migration_run_id,
408: p_log_level => FND_LOG.LEVEL_PROCEDURE,
409: p_message_token => 'GMI_MIG_INCORRECT_LOT_UNIQ',
410: p_table_name => 'IC_LOTS_MST',
411: p_context => 'LOTS',
412: p_param1 => lu.organization_code,
413: p_param2 => NULL,
414: p_param3 => NULL,