DBA Data[Home] [Help]

APPS.GMD_QC_MIG12 dependencies on GME_MATERIAL_DETAILS

Line 2930: FROM gme_material_details

2926: -- Added code to populate material_detail_id so that Line and Type fields are populated when queried from the applications
2927: l_material_detail_id := NULL;
2928: IF v_samp_rec.source = 'W' AND v_samp_rec.batch_id IS NOT NULL AND v_samp_rec.formulaline_id IS NOT NULL THEN
2929: SELECT material_detail_id INTO l_material_detail_id
2930: FROM gme_material_details
2931: WHERE batch_id = v_samp_rec.batch_id
2932: AND formulaline_id = v_samp_rec.formulaline_id;
2933: END IF;
2934:

Line 5190: FROM gme_material_details

5186: l_material_detail_id := NULL;
5187: IF l_wip_spec.batch_id IS NOT NULL AND l_wip_spec.formulaline_id IS NOT NULL THEN
5188: BEGIN
5189: SELECT material_detail_id INTO l_material_detail_id
5190: FROM gme_material_details
5191: WHERE batch_id = l_wip_spec.batch_id
5192: AND formulaline_id = l_wip_spec.formulaline_id;
5193: EXCEPTION
5194: WHEN OTHERS THEN