APPS.INV_ITEM_CATEGORY_PVT dependencies on MTL_PARAMETERS

Line 301: FROM mtl_parameters

297:
298: -- Get master org
299: SELECT MASTER_ORGANIZATION_ID
300: INTO p_master_org_id
301: FROM mtl_parameters
302: WHERE organization_id = p_organization_id;
303:
304: IF ((l_control_level = 1) and (p_organization_id <> p_master_org_id)) THEN
305: --INV_ITEM_MSG.Add_Error('INV_CAT_CANNOT_CREATE_DELETE');

Line 441: FROM mtl_parameters p , mtl_system_items_b i

437: , SYSDATE
438: , FND_GLOBAL.user_id
439: , FND_GLOBAL.login_id
440: , FND_GLOBAL.conc_request_id
441: FROM mtl_parameters p , mtl_system_items_b i
442: WHERE p.master_organization_id = p_master_org_id
443: AND i.inventory_item_id = p_inventory_item_id
444: AND i.organization_id = p.organization_id
445: AND not exists

Line 781: FROM mtl_parameters

777: CLOSE category_exists_csr;
778:
779: SELECT MASTER_ORGANIZATION_ID
780: INTO p_master_org_id
781: FROM mtl_parameters
782: WHERE organization_id = p_organization_id;
783:
784: IF ((l_control_level = 1) and (p_organization_id <> p_master_org_id)) THEN
785: --INV_ITEM_MSG.Add_Error('INV_CAT_CANNOT_CREATE_DELETE');

Line 802: FROM mtl_parameters p

798: AND category_id = p_category_id
799: AND inventory_item_id = p_inventory_item_id
800: AND organization_id =
801: (SELECT organization_id
802: FROM mtl_parameters p
803: WHERE p.master_organization_id = p_master_org_id
804: AND p.organization_id = mic.organization_id);
805: ELSE
806: -- Delete a row from the table

Line 1237: INV_ITEM_MSG.Debug(Mctx, 'Select Master Org from Mtl_Parameters');

1233:
1234: --* Disallow updation if category is master controlled and current org
1235: --* is not master org.
1236: IF (l_debug = 1) THEN
1237: INV_ITEM_MSG.Debug(Mctx, 'Select Master Org from Mtl_Parameters');
1238: END IF;
1239:
1240: SELECT MASTER_ORGANIZATION_ID
1241: INTO p_master_org_id

Line 1242: FROM mtl_parameters

1238: END IF;
1239:
1240: SELECT MASTER_ORGANIZATION_ID
1241: INTO p_master_org_id
1242: FROM mtl_parameters
1243: WHERE organization_id = p_organization_id;
1244:
1245: IF ((l_control_level = 1) and (p_organization_id <> p_master_org_id)) THEN
1246: INV_ITEM_MSG.Add_Message

Line 1312: FROM mtl_parameters p

1308: --Bug 12901485
1309: --For performance tunning, change it to exists sub-query
1310: AND exists (SELECT p.organization_id
1311: --End Bug 12901485
1312: FROM mtl_parameters p
1313: WHERE p.master_organization_id = p_master_org_id
1314: AND p.organization_id = mic.organization_id);
1315: -- for bug 12657660
1316: FOR c_Get_Revised_Orgs IN ( SELECT organization_id

Line 1317: FROM mtl_parameters p

1313: WHERE p.master_organization_id = p_master_org_id
1314: AND p.organization_id = mic.organization_id);
1315: -- for bug 12657660
1316: FOR c_Get_Revised_Orgs IN ( SELECT organization_id
1317: FROM mtl_parameters p
1318: WHERE p.master_organization_id = p_master_org_id )
1319: LOOP
1320:
1321: INV_ITEM_EVENTS_PVT.Invoke_ICX_wrapper(