APPS.INV_ITEM_CATEGORY_PVT dependencies on MTL_PARAMETERS

Line 291: FROM mtl_parameters

287:
288: -- Get master org
289: SELECT MASTER_ORGANIZATION_ID
290: INTO p_master_org_id
291: FROM mtl_parameters
292: WHERE organization_id = p_organization_id;
293:
294: IF ((l_control_level = 1) and (p_organization_id <> p_master_org_id)) THEN
295: --INV_ITEM_MSG.Add_Error('INV_CAT_CANNOT_CREATE_DELETE');

Line 431: FROM mtl_parameters p , mtl_system_items_b i

427: , SYSDATE
428: , FND_GLOBAL.user_id
429: , FND_GLOBAL.login_id
430: , FND_GLOBAL.conc_request_id
431: FROM mtl_parameters p , mtl_system_items_b i
432: WHERE p.master_organization_id = p_master_org_id
433: AND i.inventory_item_id = p_inventory_item_id
434: AND i.organization_id = p.organization_id
435: AND not exists

Line 771: FROM mtl_parameters

767: CLOSE category_exists_csr;
768:
769: SELECT MASTER_ORGANIZATION_ID
770: INTO p_master_org_id
771: FROM mtl_parameters
772: WHERE organization_id = p_organization_id;
773:
774: IF ((l_control_level = 1) and (p_organization_id <> p_master_org_id)) THEN
775: --INV_ITEM_MSG.Add_Error('INV_CAT_CANNOT_CREATE_DELETE');

Line 792: FROM mtl_parameters p

788: AND category_id = p_category_id
789: AND inventory_item_id = p_inventory_item_id
790: AND organization_id =
791: (SELECT organization_id
792: FROM mtl_parameters p
793: WHERE p.master_organization_id = p_master_org_id
794: AND p.organization_id = mic.organization_id);
795: ELSE
796: -- Delete a row from the table

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

1221:
1222: --* Disallow updation if category is master controlled and current org
1223: --* is not master org.
1224: IF (l_debug = 1) THEN
1225: INV_ITEM_MSG.Debug(Mctx, 'Select Master Org from Mtl_Parameters');
1226: END IF;
1227:
1228: SELECT MASTER_ORGANIZATION_ID
1229: INTO p_master_org_id

Line 1230: FROM mtl_parameters

1226: END IF;
1227:
1228: SELECT MASTER_ORGANIZATION_ID
1229: INTO p_master_org_id
1230: FROM mtl_parameters
1231: WHERE organization_id = p_organization_id;
1232:
1233: IF ((l_control_level = 1) and (p_organization_id <> p_master_org_id)) THEN
1234: INV_ITEM_MSG.Add_Message

Line 1297: FROM mtl_parameters p

1293: WHERE category_set_id = p_category_set_id
1294: AND category_id = p_old_category_id
1295: AND inventory_item_id = p_inventory_item_id
1296: AND organization_id =(SELECT organization_id
1297: FROM mtl_parameters p
1298: WHERE p.master_organization_id = p_master_org_id
1299: AND p.organization_id = mic.organization_id);
1300:
1301: --Bug 6008273