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.

[Home] [Help]

APPS.GME_RESCHEDULE_STEP_PVT dependencies on GME_BATCH_STEP_ITEMS

Line 783: /* SELECT batchstep_id INTO l_batch_step2_rec.batchstep_id FROM GME_BATCH_STEP_ITEMS

779: l_rel_type :=
780: gme_common_pvt.is_material_auto_release
781: (l_material_detail_id_tbl (i) );
782: --Bug#5606089 Start. Added the following code.
783: /* SELECT batchstep_id INTO l_batch_step2_rec.batchstep_id FROM GME_BATCH_STEP_ITEMS
784: WHERE material_detail_id = l_material_detail_id_tbl(i);
785:
786: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step2_rec
787: ,x_batch_step2_rec) ) THEN

Line 802: SELECT batchstep_id INTO l_batch_step2_rec.batchstep_id FROM GME_BATCH_STEP_ITEMS

798: ,gme_common_pvt.g_mtl_autobystep_release)) THEN
799:
800: -- pawan kumar start bug 5929323 -- moved the fetch of batchstep_id only when step is assoc
801:
802: SELECT batchstep_id INTO l_batch_step2_rec.batchstep_id FROM GME_BATCH_STEP_ITEMS
803: WHERE material_detail_id = l_material_detail_id_tbl(i);
804:
805: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step2_rec
806: ,x_batch_step2_rec) ) THEN

Line 1104: FROM gme_batch_step_items

1100: WHERE batch_id = v_batch_id
1101: AND release_type IN (1, 2, 3)
1102: AND EXISTS (
1103: SELECT 1
1104: FROM gme_batch_step_items
1105: WHERE batch_id = v_batch_id
1106: AND batchstep_id = v_batchstep_id
1107: AND material_detail_id = det.material_detail_id);
1108: BEGIN