APPS.INV_MATERIAL_STATUS_GRP dependencies on MTL_PARAMETERS

Line 847: mtl_parameters mp

843: IF p_inventory_item_id <> NVL(g_old_item_id,-9999) THEN
844: SELECT NVL(msi.comms_nl_trackable_flag,'N')
845: INTO g_item_trackable
846: FROM mtl_system_items msi,
847: mtl_parameters mp
848: WHERE msi.inventory_item_id = p_inventory_item_id
849: AND msi.enabled_flag = 'Y'
850: AND nvl (msi.start_date_active, sysdate) <= sysdate
851: AND nvl (msi.end_date_active, sysdate+1) > sysdate

Line 2199: FROM MTL_PARAMETERS P,MTL_SECONDARY_INVENTORIES S,MTL_SYSTEM_ITEMS I

2195: SELECT (decode(P.STOCK_LOCATOR_CONTROL_CODE,4,
2196: decode(S.LOCATOR_TYPE,5,I.LOCATION_CONTROL_CODE,S.LOCATOR_TYPE),
2197: P.STOCK_LOCATOR_CONTROL_CODE))
2198: INTO l_loc_control
2199: FROM MTL_PARAMETERS P,MTL_SECONDARY_INVENTORIES S,MTL_SYSTEM_ITEMS I
2200: WHERE I.INVENTORY_ITEM_ID = p_inventory_item_id
2201: AND I.ORGANIZATION_ID = p_org_id
2202: AND S.SECONDARY_INVENTORY_NAME = p_sub_code
2203: AND I.ORGANIZATION_ID = S.ORGANIZATION_ID

Line 2383: FROM mtl_parameters

2379:
2380: BEGIN
2381: SELECT allow_different_status
2382: INTO l_allow_different_status
2383: FROM mtl_parameters
2384: WHERE organization_id = l_transfer_org_id ;
2385: EXCEPTION
2386: WHEN NO_DATA_FOUND THEN
2387: l_allow_different_status := 1;

Line 2799: FROM mtl_parameters

2795: WMS_Container_PUB.LPN_CONTEXT_INTRANSIT) THEN
2796:
2797: SELECT default_status_id
2798: INTO l_def_org_status
2799: FROM mtl_parameters
2800: WHERE organization_id = l_lpn_org_id;
2801: IF(g_debug = 1)THEN
2802: inv_trx_util_pub.TRACE('LPN CONTEXT IS '||l_lpn_context|| ' Status should be default org level staus which is '||l_return_status_id,'INV_MATERIAL_STATUS_GRP',9);
2803: END IF;

Line 3030: FROM mtl_parameters

3026: l_allow_diff_status --> Null Means 'Yes'
3027: */
3028: BEGIN
3029: SELECT Nvl(allow_different_status,1) INTO l_allow_diff_status
3030: FROM mtl_parameters
3031: WHERE organization_id =p_xfr_org_id ;
3032:
3033: IF(g_debug = 1)THEN
3034: inv_trx_util_pub.TRACE('Status_Commingle_Check: allow_different_status: '||l_allow_diff_status, 1);