APPS.GMD_SAMPLES_GRP dependencies on MTL_PARAMETERS

Line 2981: FROM mtl_parameters m,

2977:
2978: -- Bug 4165704: changed for inventory convergence
2979: CURSOR c_orgn (p_organization_id NUMBER) IS
2980: SELECT 1
2981: FROM mtl_parameters m,
2982: org_access_view v
2983: WHERE v.organization_id = m.organization_id
2984: AND m.organization_id = p_organization_id
2985: AND m. process_enabled_flag = 'Y' ;

Line 2995: FROM mtl_parameters m,

2991:
2992: -- Bug 4165704: changed for inventory convergence
2993: CURSOR c_lab_orgn (p_organization_id NUMBER) IS
2994: SELECT 1
2995: FROM mtl_parameters m,
2996: gmd_quality_config g ,
2997: org_access_view v
2998: WHERE g.quality_lab_ind = 'Y'
2999: AND g.organization_id = m.organization_id

Line 3160: mtl_parameters mp,

3156: CURSOR c_order_line IS
3157: SELECT 1
3158: FROM oe_order_lines_all l,
3159: mtl_system_items_b m,
3160: mtl_parameters mp,
3161: ic_item_mst i
3162: WHERE l.header_id = p_sample.order_id
3163: AND l.line_id = p_sample.order_line_id
3164: AND l.ship_to_org_id = p_sample.ship_to_site_id

Line 4663: FROM mtl_parameters

4659: WHERE user_id = name_id ;
4660:
4661: CURSOR Cur_organization_code(orgn_id NUMBER) IS
4662: SELECT organization_code
4663: FROM mtl_parameters
4664: WHERE organization_id = orgn_id;
4665:
4666: CURSOR Cur_locator(loc_id NUMBER) IS
4667: SELECT concatenated_segments

Line 5319: MTL_PARAMETERS p

5315: ri.instance_number
5316: FROM GMD_SS_VARIANTS v,
5317: GMD_STABILITY_STUDIES_B ss,
5318: GMP_RESOURCE_INSTANCES ri,
5319: MTL_PARAMETERS p
5320: WHERE variant_id = p_variant_id
5321: AND ss.ss_id = v.ss_id
5322: AND ri.instance_id(+) = v.resource_instance_id
5323: AND p.organization_id = ss.organization_id;