DBA Data[Home] [Help]

APPS.GMD_SAMPLES_PUB dependencies on MTL_PARAMETERS

Line 2621: FROM mtl_parameters m,

2617: -- FROM sy_orgn_mst
2618: -- WHERE orgn_code = p_orgn_code
2619: -- AND delete_mark = 0;
2620: SELECT 1
2621: FROM mtl_parameters m,
2622: gmd_quality_config g
2623: WHERE g.organization_id = m.organization_id
2624: AND m.organization_id = p_organization_id
2625: AND m. process_enabled_flag = 'Y' ;

Line 2646: FROM mtl_parameters m,

2642: -- WHERE orgn_code = p_orgn_code
2643: -- AND plant_ind <> 0
2644: -- AND delete_mark = 0;
2645: SELECT 1
2646: FROM mtl_parameters m,
2647: gmd_quality_config g
2648: WHERE g.organization_id = m.organization_id
2649: AND g.quality_lab_ind = 'Y'
2650: AND m.organization_id = p_organization_id

Line 2759: -- Check that orgn Code exist in mtl_parameters

2755: IF (p_sample_rec.sampler_id IS NULL ) THEN
2756: GMD_API_PUB.Log_Message('GMD_SAMPLER_ID_REQD');
2757: RAISE FND_API.G_EXC_ERROR;
2758: ELSE
2759: -- Check that orgn Code exist in mtl_parameters
2760: OPEN c_sampler(p_sample_rec.organization_id, p_sample_rec.sampler_id);
2761: FETCH c_sampler INTO l_dummy;
2762: IF c_sampler%NOTFOUND THEN
2763: GMD_API_PUB.Log_Message('GMD_SAMPLER_ID_NOTFOUND',