APPS.GMD_SAMPLES_GRP dependencies on MTL_PARAMETERS

Line 2505: FROM mtl_parameters

2501: AND lot_number = l_lot_number ;
2502:
2503: CURSOR get_default_status_id IS -- 91432301
2504: SELECT default_status_id, NVL(wms_enabled_flag,'N') -- 12829066
2505: FROM mtl_parameters
2506: WHERE organization_id = l_organization_id;
2507:
2508:
2509: cursor cur_get_lpn IS -- 12829066 new cursor

Line 3576: FROM mtl_parameters m,

3572:
3573: -- Bug 4165704: changed for inventory convergence
3574: CURSOR c_orgn (p_organization_id NUMBER) IS
3575: SELECT 1
3576: FROM mtl_parameters m,
3577: org_access_view v
3578: WHERE v.organization_id = m.organization_id
3579: AND m.organization_id = p_organization_id
3580: AND m. process_enabled_flag = 'Y' ;

Line 3590: FROM mtl_parameters m,

3586:
3587: -- Bug 4165704: changed for inventory convergence
3588: CURSOR c_lab_orgn (p_organization_id NUMBER) IS
3589: SELECT 1
3590: FROM mtl_parameters m,
3591: gmd_quality_config g ,
3592: org_access_view v
3593: WHERE g.quality_lab_ind = 'Y'
3594: AND g.organization_id = m.organization_id

Line 3755: mtl_parameters mp,

3751: CURSOR c_order_line IS
3752: SELECT 1
3753: FROM oe_order_lines_all l,
3754: mtl_system_items_b m,
3755: mtl_parameters mp,
3756: ic_item_mst i
3757: WHERE l.header_id = p_sample.order_id
3758: AND l.line_id = p_sample.order_line_id
3759: AND l.ship_to_org_id = p_sample.ship_to_site_id

Line 3805: FROM mtl_parameters

3801: WMS_LICENSE_PLATE_NUMBERS WHERE lpn_id = p_sample.lpn_id;
3802:
3803: CURSOR get_wms_flag IS
3804: SELECT wms_enabled_flag
3805: FROM mtl_parameters
3806: WHERE organization_id = p_sample.organization_id;
3807:
3808:
3809: dummy NUMBER;

Line 5308: FROM mtl_parameters

5304: WHERE user_id = name_id ;
5305:
5306: CURSOR Cur_organization_code(orgn_id NUMBER) IS
5307: SELECT organization_code
5308: FROM mtl_parameters
5309: WHERE organization_id = orgn_id;
5310:
5311: CURSOR Cur_locator(loc_id NUMBER) IS
5312: SELECT concatenated_segments

Line 5987: MTL_PARAMETERS p

5983: ri.instance_number
5984: FROM GMD_SS_VARIANTS v,
5985: GMD_STABILITY_STUDIES_B ss,
5986: GMP_RESOURCE_INSTANCES ri,
5987: MTL_PARAMETERS p
5988: WHERE variant_id = p_variant_id
5989: AND ss.ss_id = v.ss_id
5990: AND ri.instance_id(+) = v.resource_instance_id
5991: AND p.organization_id = ss.organization_id;