DBA Data[Home] [Help]

APPS.GME_COMPLETE_BATCH_STEP_PVT dependencies on GME_MATERIAL_DETAILS

Line 529: FROM gme_material_details matl, gme_batch_step_items item

525:
526:
527: CURSOR Cur_step_prod_byprod(v_batchstep_id NUMBER) IS
528: SELECT matl.*
529: FROM gme_material_details matl, gme_batch_step_items item
530: WHERE item.batchstep_id = v_batchstep_id
531: AND item.material_detail_id = matl.material_detail_id
532: -- 12896375 - Look at all line types.
533: -- AND (matl.line_type IN (gme_common_pvt.g_line_type_prod, gme_common_pvt.g_line_type_byprod) OR

Line 540: l_matl_dtl_rec gme_material_details%ROWTYPE;

536:
537: l_api_name CONSTANT VARCHAR2 (30) := 'complete_step_material';
538:
539: l_return_status VARCHAR2(1);
540: l_matl_dtl_rec gme_material_details%ROWTYPE;
541: l_matl_dtl_tab gme_common_pvt.material_details_tab;
542: l_yield BOOLEAN;
543:
544: error_process_prod EXCEPTION;