APPS.GMI_PRE_MIGRATION dependencies on IC_ITEM_MST_B

Line 106: l_table_name := 'IC_ITEM_MST_B';

102: l_context VARCHAR2(50);
103: BEGIN
104: BEGIN
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';

Line 144: p_table_name => 'IC_ITEM_MST_B',

140: GMA_COMMON_LOGGING.gma_migration_central_log (
141: p_run_id => p_migration_run_id,
142: p_log_level => FND_LOG.LEVEL_ERROR,
143: p_message_token => 'GMI_MIG_DFLEX_CONTEXT_CONFLICT',
144: p_table_name => 'IC_ITEM_MST_B',
145: p_context => 'ITEMS',
146: p_param1 => l_opm_context,
147: p_param2 => l_odm_context,
148: p_param3 => NULL,

Line 166: p_table_name => 'IC_ITEM_MST_B',

162: GMA_COMMON_LOGGING.gma_migration_central_log (
163: p_run_id => p_migration_run_id,
164: p_log_level => FND_LOG.LEVEL_ERROR,
165: p_message_token => 'GMI_MIG_DFLEX_COL_CONFLICT',
166: p_table_name => 'IC_ITEM_MST_B',
167: p_context => 'ITEMS',
168: p_param1 => conflict_columns.descriptive_flex_context_code,
169: p_param2 => conflict_columns.end_user_column_name,
170: p_param3 => conflict_columns.application_column_name,

Line 201: FROM ic_item_mst_b

197: p_migration_run_id IN NUMBER) IS
198:
199: CURSOR c_autolot IS
200: SELECT count(*) item_count
201: FROM ic_item_mst_b
202: WHERE lot_ctl = 1 AND
203: autolot_active_indicator <> 1;
204:
205: CURSOR c_lot_status IS

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 296: ic_item_mst_b i,

292: CURSOR c_neg_balances IS
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

Line 311: ic_item_mst_b i,

307: CURSOR c_mix_balances IS
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

Line 326: ic_item_mst_b i,

322: CURSOR c_decimal_dust_balances IS
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

Line 340: ic_item_mst_b i,

336: CURSOR c_non_inv_balances IS
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

Line 366: p_table_name => 'IC_ITEM_MST_B',

362: GMA_COMMON_LOGGING.gma_migration_central_log (
363: p_run_id => p_migration_run_id,
364: p_log_level => FND_LOG.LEVEL_PROCEDURE,
365: p_message_token => 'GMI_MIG_ITEM_AUTOLOT',
366: p_table_name => 'IC_ITEM_MST_B',
367: p_context => 'ITEMS',
368: p_param1 => to_char(i.item_count),
369: p_param2 => NULL,
370: p_param3 => NULL,