DBA Data[Home] [Help]

APPS.GME_RELEASE_BATCH_STEP_PVT dependencies on GME_BATCH_STEP_ITEMS

Line 645: FROM gme_material_details matl, gme_batch_step_items item

641: IS
642: CURSOR cur_step_ingredients (v_batchstep_id NUMBER)
643: IS
644: SELECT matl.*
645: FROM gme_material_details matl, gme_batch_step_items item
646: WHERE item.batchstep_id = v_batchstep_id
647: AND item.material_detail_id = matl.material_detail_id
648: AND matl.line_type = gme_common_pvt.g_line_type_ing
649: AND matl.release_type = gme_common_pvt.g_mtl_autobystep_release;