APPS.GME_COMPLETE_BATCH_STEP_PVT dependencies on GME_MATERIAL_DETAILS

Line 472: FROM gme_material_details matl, gme_batch_step_items item

468:
469:
470: CURSOR Cur_step_prod_byprod(v_batchstep_id NUMBER) IS
471: SELECT matl.*
472: FROM gme_material_details matl, gme_batch_step_items item
473: WHERE item.batchstep_id = v_batchstep_id
474: AND item.material_detail_id = matl.material_detail_id
475: AND (matl.line_type IN (gme_common_pvt.g_line_type_prod, gme_common_pvt.g_line_type_byprod) OR
476: (matl.line_type = gme_common_pvt.g_line_type_ing AND matl.phantom_id IS NOT NULL))

Line 482: l_matl_dtl_rec gme_material_details%ROWTYPE;

478:
479: l_api_name CONSTANT VARCHAR2 (30) := 'complete_step_material';
480:
481: l_return_status VARCHAR2(1);
482: l_matl_dtl_rec gme_material_details%ROWTYPE;
483: l_matl_dtl_tab gme_common_pvt.material_details_tab;
484: l_yield BOOLEAN;
485:
486: error_process_prod EXCEPTION;