APPS.INV_MATERIAL_STATUS_GRP dependencies on MTL_PARAMETERS

Line 869: mtl_parameters mp

865: IF p_inventory_item_id <> NVL(g_old_item_id,-9999) THEN
866: SELECT NVL(msi.comms_nl_trackable_flag,'N')
867: INTO g_item_trackable
868: FROM mtl_system_items msi,
869: mtl_parameters mp
870: WHERE msi.inventory_item_id = p_inventory_item_id
871: AND msi.enabled_flag = 'Y'
872: AND nvl (msi.start_date_active, sysdate) <= sysdate
873: AND nvl (msi.end_date_active, sysdate+1) > sysdate

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

2701: SELECT (decode(P.STOCK_LOCATOR_CONTROL_CODE,4,
2702: decode(S.LOCATOR_TYPE,5,I.LOCATION_CONTROL_CODE,S.LOCATOR_TYPE),
2703: P.STOCK_LOCATOR_CONTROL_CODE))
2704: INTO l_loc_control
2705: FROM MTL_PARAMETERS P,MTL_SECONDARY_INVENTORIES S,MTL_SYSTEM_ITEMS I
2706: WHERE I.INVENTORY_ITEM_ID = p_inventory_item_id
2707: AND I.ORGANIZATION_ID = p_org_id
2708: AND S.SECONDARY_INVENTORY_NAME = p_sub_code
2709: AND I.ORGANIZATION_ID = S.ORGANIZATION_ID

Line 2891: FROM mtl_parameters

2887:
2888: /*BEGIN
2889: SELECT allow_different_status
2890: INTO l_allow_different_status
2891: FROM mtl_parameters
2892: WHERE organization_id = l_transfer_org_id ;
2893: EXCEPTION
2894: WHEN NO_DATA_FOUND THEN
2895: l_allow_different_status := 1;

Line 3330: FROM mtl_parameters

3326: WMS_Container_PUB.LPN_CONTEXT_INTRANSIT) THEN
3327:
3328: SELECT default_status_id
3329: INTO l_def_org_status
3330: FROM mtl_parameters
3331: WHERE organization_id = l_lpn_org_id;
3332: IF(g_debug = 1)THEN
3333: 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);
3334: END IF;

Line 3561: FROM mtl_parameters

3557: l_allow_diff_status --> Null Means 'Yes'
3558: */
3559: BEGIN
3560: SELECT Nvl(allow_different_status,1) INTO l_allow_diff_status
3561: FROM mtl_parameters
3562: WHERE organization_id =p_xfr_org_id ;
3563:
3564: IF(g_debug = 1)THEN
3565: inv_trx_util_pub.TRACE('Status_Commingle_Check: allow_different_status: '||l_allow_diff_status, 1);