DBA Data[Home] [Help]

APPS.GME_CREATE_STEP_PVT dependencies on GME_MATERIAL_DETAILS

Line 782: FROM gme_material_details

778: END IF;
779:
780: SELECT count(*)
781: INTO l_count
782: FROM gme_material_details
783: WHERE batch_id = l_batch_id
784: AND formulaline_id = p_recipe_rout_matl_tbl (i).formulaline_id;
785:
786: -- Bug 9694223 - if this record is missing it means that the user is doing a reroute

Line 794: FROM gme_material_details

790: l_skip := 1;
791: ELSE
792: SELECT material_detail_id
793: INTO l_gme_batch_step_items (j).material_detail_id
794: FROM gme_material_details
795: WHERE batch_id = l_batch_id
796: AND formulaline_id = p_recipe_rout_matl_tbl (i).formulaline_id;
797:
798: IF (p_recipe_rout_matl_tbl (i).routingstep_id IS NOT NULL) THEN