eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMI_PRE_MIGRATION dependencies on IC_LOCT_INV

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 217: FROM ic_loct_inv inv2, ic_whse_mst w2

213: inv.lot_id = l.lot_id AND
214: inv.loct_onhand <> 0 AND
215: EXISTS (
216: SELECT 1
217: FROM ic_loct_inv inv2, ic_whse_mst w2
218: WHERE
219: inv.whse_code = w2.whse_code AND
220: inv.item_id = inv2.item_id AND
221: inv.lot_id = inv2.lot_id AND

Line 295: FROM ic_loct_inv inv,

291:
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

Line 310: FROM ic_loct_inv inv,

306:
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

Line 325: FROM ic_loct_inv inv,

321:
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

Line 339: FROM ic_loct_inv inv,

335:
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

Line 429: p_table_name => 'IC_LOCT_INV',

425: GMA_COMMON_LOGGING.gma_migration_central_log (
426: p_run_id => p_migration_run_id,
427: p_log_level => FND_LOG.LEVEL_PROCEDURE,
428: p_message_token => 'GMI_MIG_INCORRECT_LOCT_CTL',
429: p_table_name => 'IC_LOCT_INV',
430: p_context => 'INVENTORY BALANCES',
431: p_param1 => dl1.organization_code,
432: p_param2 => NULL,
433: p_param3 => NULL,

Line 446: p_table_name => 'IC_LOCT_INV',

442: GMA_COMMON_LOGGING.gma_migration_central_log (
443: p_run_id => p_migration_run_id,
444: p_log_level => FND_LOG.LEVEL_PROCEDURE,
445: p_message_token => 'GMI_MIG_INCORRECT_SUB_LOCT_CTL',
446: p_table_name => 'IC_LOCT_INV',
447: p_context => 'INVENTORY BALANCES',
448: p_param1 => dl1.organization_code,
449: p_param2 => dl1.secondary_inventory_name,
450: p_param3 => NULL,

Line 463: p_table_name => 'IC_LOCT_INV',

459: GMA_COMMON_LOGGING.gma_migration_central_log (
460: p_run_id => p_migration_run_id,
461: p_log_level => FND_LOG.LEVEL_PROCEDURE,
462: p_message_token => 'GMI_MIG_INCORRECT_NON_LOCT_CTL',
463: p_table_name => 'IC_LOCT_INV',
464: p_context => 'INVENTORY BALANCES',
465: p_param1 => dl2.organization_code,
466: p_param2 => NULL,
467: p_param3 => NULL,

Line 482: p_table_name => 'IC_LOCT_INV',

478: GMA_COMMON_LOGGING.gma_migration_central_log (
479: p_run_id => p_migration_run_id,
480: p_log_level => FND_LOG.LEVEL_PROCEDURE,
481: p_message_token => 'GMI_MIG_NEG_BALANCES',
482: p_table_name => 'IC_LOCT_INV',
483: p_context => 'INVENTORY BALANCES',
484: p_param1 => nb.item_no,
485: p_param2 => nb.lot_no,
486: p_param3 => nb.sublot_no,

Line 502: p_table_name => 'IC_LOCT_INV',

498: GMA_COMMON_LOGGING.gma_migration_central_log (
499: p_run_id => p_migration_run_id,
500: p_log_level => FND_LOG.LEVEL_PROCEDURE,
501: p_message_token => 'GMI_MIG_MIX_BALANCES',
502: p_table_name => 'IC_LOCT_INV',
503: p_context => 'INVENTORY BALANCES',
504: p_param1 => mb.item_no,
505: p_param2 => mb.lot_no,
506: p_param3 => mb.sublot_no,

Line 522: p_table_name => 'IC_LOCT_INV',

518: GMA_COMMON_LOGGING.gma_migration_central_log (
519: p_run_id => p_migration_run_id,
520: p_log_level => FND_LOG.LEVEL_PROCEDURE,
521: p_message_token => 'GMI_MIG_DUST_BALANCES',
522: p_table_name => 'IC_LOCT_INV',
523: p_context => 'INVENTORY BALANCES',
524: p_param1 => db.item_no,
525: p_param2 => db.lot_no,
526: p_param3 => db.sublot_no,

Line 540: p_table_name => 'IC_LOCT_INV',

536: GMA_COMMON_LOGGING.gma_migration_central_log (
537: p_run_id => p_migration_run_id,
538: p_log_level => FND_LOG.LEVEL_PROCEDURE,
539: p_message_token => 'GMI_MIG_NEG_BALANCES',
540: p_table_name => 'IC_LOCT_INV',
541: p_context => 'INVENTORY BALANCES',
542: p_param1 => nb.item_no,
543: p_param2 => nb.lot_no,
544: p_param3 => nb.sublot_no,

Line 558: p_table_name => 'IC_LOCT_INV',

554: GMA_COMMON_LOGGING.gma_migration_central_log (
555: p_run_id => p_migration_run_id,
556: p_log_level => FND_LOG.LEVEL_PROCEDURE,
557: p_message_token => 'GMI_MIG_INTRANS_BALANCES',
558: p_table_name => 'IC_LOCT_INV',
559: p_context => 'INVENTORY BALANCES',
560: p_param1 => tb.orgn_code ||' '||tb.transfer_no,
561: p_param2 => NULL,
562: p_param3 => NULL,