APPS.GMD_SAMPLES_PUB dependencies on MTL_PARAMETERS

Line 283: FROM mtl_parameters

279: WMS_LICENSE_PLATE_NUMBERS WHERE LICENSE_PLATE_NUMBER = p_lpn;
280:
281: CURSOR get_wms_flag IS
282: SELECT wms_enabled_flag
283: FROM mtl_parameters
284: WHERE organization_id = p_qc_samples_rec.organization_id;
285:
286: -- 7027149
287: cursor get_lpn is

Line 2751: FROM mtl_parameters m,

2747: -- FROM sy_orgn_mst
2748: -- WHERE orgn_code = p_orgn_code
2749: -- AND delete_mark = 0;
2750: SELECT 1
2751: FROM mtl_parameters m,
2752: gmd_quality_config g
2753: WHERE g.organization_id = m.organization_id
2754: AND m.organization_id = p_organization_id
2755: AND m. process_enabled_flag = 'Y' ;

Line 2776: FROM mtl_parameters m,

2772: -- WHERE orgn_code = p_orgn_code
2773: -- AND plant_ind <> 0
2774: -- AND delete_mark = 0;
2775: SELECT 1
2776: FROM mtl_parameters m,
2777: gmd_quality_config g
2778: WHERE g.organization_id = m.organization_id
2779: AND g.quality_lab_ind = 'Y'
2780: AND m.organization_id = p_organization_id

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

2885: IF (p_sample_rec.sampler_id IS NULL ) THEN
2886: GMD_API_PUB.Log_Message('GMD_SAMPLER_ID_REQD');
2887: RAISE FND_API.G_EXC_ERROR;
2888: ELSE
2889: -- Check that orgn Code exist in mtl_parameters
2890: OPEN c_sampler(p_sample_rec.organization_id, p_sample_rec.sampler_id);
2891: FETCH c_sampler INTO l_dummy;
2892: IF c_sampler%NOTFOUND THEN
2893: GMD_API_PUB.Log_Message('GMD_SAMPLER_ID_NOTFOUND',