APPS.WSMPINVL dependencies on MTL_PARAMETERS

Line 1367: from mtl_parameters

1363: EXCEPTION
1364: when too_many_rows then --bugfix 1823316
1365: select lot_number_uniqueness
1366: into mtl_unique
1367: from mtl_parameters
1368: where organization_id = crec.organization_id;
1369:
1370: if mtl_unique <> 2 then
1371: --bugfix 1995378: changed message_name

Line 2336: mtl_parameters MP

2332: x_restrict_locators_code,
2333: x_item_loc_control
2334: FROM mtl_system_items MS,
2335: mtl_secondary_inventories MSUB,
2336: mtl_parameters MP
2337: WHERE MP.organization_id = crec.organization_id
2338: AND MS.organization_id = crec.organization_id
2339: AND MS.inventory_item_id = crec.inventory_item_id
2340: AND MSUB.secondary_inventory_name = crec.subinventory_code

Line 2754: FROM mtl_parameters mtl

2750: l_wmsEnabledFlag := 'N';
2751:
2752: SELECT mtl.wms_enabled_flag
2753: INTO l_wmsEnabledFlag
2754: FROM mtl_parameters mtl
2755: WHERE mtl.organization_id = x_organization_id;
2756:
2757:
2758: IF (l_wmsEnabledFlag = 'Y') THEN

Line 2872: -- Check if the there is a record in mtl_parameters for this ORG.

2868: err_status := -1;
2869: return;
2870: END;
2871:
2872: -- Check if the there is a record in mtl_parameters for this ORG.
2873:
2874: lProcLocation := 60;
2875: BEGIN
2876: SELECT 1

Line 2878: FROM mtl_parameters

2874: lProcLocation := 60;
2875: BEGIN
2876: SELECT 1
2877: into x_dummy
2878: FROM mtl_parameters
2879: WHERE organization_id = x_organization_id;
2880: EXCEPTION when others THEN
2881: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
2882: FND_MESSAGE.SET_TOKEN('FLD_NAME','organization_id_mp');