DBA Data[Home] [Help]

APPS.GMD_QC_MIG12 dependencies on GME_MATERIAL_DETAILS

Line 3104: FROM gme_material_details

3100: -- Added code to populate material_detail_id so that Line and Type fields are populated when queried from the applications
3101: l_material_detail_id := NULL;
3102: 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
3103: SELECT material_detail_id INTO l_material_detail_id
3104: FROM gme_material_details
3105: WHERE batch_id = v_samp_rec.batch_id
3106: AND formulaline_id = v_samp_rec.formulaline_id;
3107: END IF;
3108:

Line 5459: FROM gme_material_details

5455: l_material_detail_id := NULL;
5456: IF l_wip_spec.batch_id IS NOT NULL AND l_wip_spec.formulaline_id IS NOT NULL THEN
5457: BEGIN
5458: SELECT material_detail_id INTO l_material_detail_id
5459: FROM gme_material_details
5460: WHERE batch_id = l_wip_spec.batch_id
5461: AND formulaline_id = l_wip_spec.formulaline_id;
5462: EXCEPTION
5463: WHEN OTHERS THEN