APPS.GME_RELEASE_BATCH_STEP_PVT dependencies on GME_MATERIAL_DETAILS

Line 652: FROM gme_material_details matl, gme_batch_step_items item

648: IS
649: CURSOR cur_step_ingredients (v_batchstep_id NUMBER)
650: IS
651: SELECT matl.*
652: FROM gme_material_details matl, gme_batch_step_items item
653: WHERE item.batchstep_id = v_batchstep_id
654: AND item.material_detail_id = matl.material_detail_id
655: AND matl.line_type = gme_common_pvt.g_line_type_ing
656: AND matl.release_type = gme_common_pvt.g_mtl_autobystep_release;

Line 660: l_matl_dtl_rec gme_material_details%ROWTYPE;

656: AND matl.release_type = gme_common_pvt.g_mtl_autobystep_release;
657:
658: l_api_name CONSTANT VARCHAR2 (30) := 'release_step_ingredients';
659: l_return_status VARCHAR2 (1);
660: l_matl_dtl_rec gme_material_details%ROWTYPE;
661: l_matl_dtl_tab gme_common_pvt.material_details_tab;
662: l_consume BOOLEAN;
663:
664: l_reserved_qty NUMBER; -- Bug 13795581