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 789: /* SELECT batchstep_id INTO l_batch_step2_rec.batchstep_id FROM GME_BATCH_STEP_ITEMS

785: l_rel_type :=
786: gme_common_pvt.is_material_auto_release
787: (l_material_detail_id_tbl (i) );
788: --Bug#5606089 Start. Added the following code.
789: /* SELECT batchstep_id INTO l_batch_step2_rec.batchstep_id FROM GME_BATCH_STEP_ITEMS
790: WHERE material_detail_id = l_material_detail_id_tbl(i);
791:
792: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step2_rec
793: ,x_batch_step2_rec) ) THEN

Line 808: SELECT batchstep_id INTO l_batch_step2_rec.batchstep_id FROM GME_BATCH_STEP_ITEMS

804: ,gme_common_pvt.g_mtl_autobystep_release)) THEN
805:
806: -- pawan kumar start bug 5929323 -- moved the fetch of batchstep_id only when step is assoc
807:
808: SELECT batchstep_id INTO l_batch_step2_rec.batchstep_id FROM GME_BATCH_STEP_ITEMS
809: WHERE material_detail_id = l_material_detail_id_tbl(i);
810:
811: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step2_rec
812: ,x_batch_step2_rec) ) THEN

Line 1110: FROM gme_batch_step_items

1106: WHERE batch_id = v_batch_id
1107: AND release_type IN (1, 2, 3)
1108: AND EXISTS (
1109: SELECT 1
1110: FROM gme_batch_step_items
1111: WHERE batch_id = v_batch_id
1112: AND batchstep_id = v_batchstep_id
1113: AND material_detail_id = det.material_detail_id);
1114: BEGIN