APPS.AHL_VWP_RULES_PVT dependencies on MTL_PARAMETERS

Line 206: FROM org_organization_definitions org, mtl_parameters m

202: INTO x_item_name, x_item_id, x_org_id
203: FROM MTL_SYSTEM_ITEMS_KFV
204: WHERE concatenated_segments = p_item_name AND organization_id = p_org_id
205: AND organization_id IN (Select DISTINCT m.master_organization_id
206: FROM org_organization_definitions org, mtl_parameters m
207: WHERE org.organization_id = m.organization_id
208: AND NVL(org.operating_unit, mo_global.get_current_org_id())
209: = mo_global.get_current_org_id()
210: );*/

Line 220: mtl_parameters m

216: AND organization_id = p_org_id
217: AND organization_id IN
218: (SELECT DISTINCT m.master_organization_id
219: FROM INV_ORGANIZATION_INFO_V org,
220: mtl_parameters m
221: WHERE org.organization_id = m.organization_id
222: AND NVL(org.operating_unit,mo_global.get_current_org_id()) = mo_global.get_current_org_id()
223: ) ;
224: ELSIF p_item_id IS NOT NULL THEN

Line 236: FROM org_organization_definitions org, mtl_parameters m

232: INTO x_item_name, x_item_id, x_org_id
233: FROM MTL_SYSTEM_ITEMS_KFV
234: WHERE inventory_item_id = p_item_id AND organization_id = p_org_id
235: AND organization_id IN (Select DISTINCT m.master_organization_id
236: FROM org_organization_definitions org, mtl_parameters m
237: WHERE org.organization_id = m.organization_id
238: AND NVL(org.operating_unit, mo_global.get_current_org_id())
239: = mo_global.get_current_org_id()
240: ); */

Line 248: mtl_parameters m

244: FROM MTL_SYSTEM_ITEMS_KFV
245: WHERE inventory_item_id = p_item_id AND organization_id = p_org_id
246: AND organization_id IN (Select DISTINCT m.master_organization_id
247: FROM inv_organization_info_v org,
248: mtl_parameters m
249: WHERE org.organization_id = m.organization_id
250: AND NVL(org.operating_unit,mo_global.get_current_org_id())
251: = mo_global.get_current_org_id()
252: ) ;

Line 527: FROM hr_organization_units hou, mtl_parameters MP

523: IF (p_organization_id IS NOT NULL) THEN
524: -- AnRaj:Changes made for fixing bug#4919353, issue# 6
525: SELECT hou.organization_id
526: INTO x_organization_id
527: FROM hr_organization_units hou, mtl_parameters MP
528: WHERE hou.organization_id = mp.organization_id
529: AND hou.organization_id = p_organization_id
530: AND hou.organization_id IN
531: (SELECT organization_id

Line 540: FROM hr_organization_units hou, mtl_parameters MP

536: ELSE
537: -- AnRaj:Changes made for fixing bug#4919353, issue# 5
538: SELECT hou.organization_id
539: INTO x_organization_id
540: FROM hr_organization_units hou, mtl_parameters MP
541: WHERE hou.organization_id = mp.organization_id
542: AND hou.Name = p_org_name
543: AND hou.organization_id IN
544: (SELECT organization_id