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.MIGRATE_BATCH dependencies on GME_BATCH_STEP_ITEMS

Line 3361: INSERT INTO gme_batch_step_items

3357: x_return_status := FND_API.G_RET_STS_SUCCESS;
3358:
3359: report_step_item_orphans;
3360:
3361: INSERT INTO gme_batch_step_items
3362: (material_detail_id,
3363: batch_id,
3364: batchstep_id,
3365: text_code,

Line 3387: FROM gme_batch_step_items

3383: MIN (last_update_date),
3384: MIN (last_update_login)
3385: FROM pm_rout_mtl pm
3386: WHERE NOT EXISTS ( SELECT 1
3387: FROM gme_batch_step_items
3388: WHERE material_detail_id = pm.batchline_id)
3389: AND
3390: EXISTS ( SELECT 1
3391: FROM gme_batch_steps step

Line 3402: p_table_name => 'gme_batch_step_items',

3398: matl.material_detail_id = pm.batchline_id)
3399: GROUP BY batchline_id;
3400:
3401: insert_message (
3402: p_table_name => 'gme_batch_step_items',
3403: p_procedure_name => 'insert_batch_step_items',
3404: p_parameters => 'none',
3405: p_message => 'number of records inserted = ' || SQL%ROWCOUNT,
3406: p_error_type => 'P'

Line 3412: p_table_name => 'GME_BATCH_STEP_ITEMS',

3408: EXCEPTION
3409: WHEN OTHERS THEN
3410: x_return_status := 'D';
3411: insert_message (
3412: p_table_name => 'GME_BATCH_STEP_ITEMS',
3413: p_procedure_name => 'INSERT_BATCH_STEP_ITEMS',
3414: p_parameters => '',
3415: p_message => SQLERRM,
3416: p_error_type => x_return_status

Line 3426: FROM gme_batch_step_items

3422: CURSOR cur_get_orphans IS
3423: SELECT batch_id, batchstep_no, batchline_id
3424: FROM pm_rout_mtl pm
3425: WHERE NOT EXISTS ( SELECT 1
3426: FROM gme_batch_step_items
3427: WHERE material_detail_id = pm.batchline_id)
3428: AND
3429: (
3430: NOT EXISTS ( SELECT 1

Line 3448: p_table_name => 'gme_batch_step_items',

3444: OPEN cur_get_orphans;
3445: FETCH cur_get_orphans INTO l_cur_get_orphans;
3446: WHILE cur_get_orphans%FOUND LOOP
3447: insert_message (
3448: p_table_name => 'gme_batch_step_items',
3449: p_procedure_name => 'report_step_item_orphans',
3450: p_parameters => 'Batch_id=>'||to_char(l_cur_get_orphans.batch_id)
3451: ||' step_no=>'||l_cur_get_orphans.batchstep_no
3452: ||' material_detail_id=>'||to_char(l_cur_get_orphans.batchline_id),

Line 3464: p_table_name => 'GME_BATCH_STEP_ITEMS',

3460:
3461: EXCEPTION
3462: WHEN OTHERS THEN
3463: insert_message (
3464: p_table_name => 'GME_BATCH_STEP_ITEMS',
3465: p_procedure_name => 'REPORT_STEP_ITEM_ORPHANS',
3466: p_parameters => '',
3467: p_message => SQLERRM,
3468: p_error_type => 'D'