APPS.MIGRATE_BATCH dependencies on PM_ROUT_MTL

Line 2295: IF (is_table_migrated (p_table_name => 'PM_ROUT_MTL') = FALSE) THEN

2291: COMMIT;
2292: END IF;
2293: END IF;
2294:
2295: IF (is_table_migrated (p_table_name => 'PM_ROUT_MTL') = FALSE) THEN
2296: l_pos := 12;
2297: insert_batch_step_items (x_return_status => l_return_status);
2298: l_pos := 13;
2299:

Line 2305: p_table_name => 'PM_ROUT_MTL',

2301: RAISE error_detail;
2302: END IF;
2303:
2304: set_table_migrated (
2305: p_table_name => 'PM_ROUT_MTL',
2306: x_return_status => l_return_status
2307: );
2308:
2309: IF p_commit THEN

Line 3385: FROM pm_rout_mtl pm

3381: MIN (creation_date),
3382: MIN (last_updated_by),
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

Line 3424: FROM pm_rout_mtl pm

3420: PROCEDURE report_step_item_orphans IS
3421:
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