APPS.AHL_VWP_RULES_PVT dependencies on MTL_PARAMETERS

Line 200: FROM org_organization_definitions org, mtl_parameters m

196: INTO x_item_name, x_item_id, x_org_id
197: FROM MTL_SYSTEM_ITEMS_KFV
198: WHERE concatenated_segments = p_item_name AND organization_id = p_org_id
199: AND organization_id IN (Select DISTINCT m.master_organization_id
200: FROM org_organization_definitions org, mtl_parameters m
201: WHERE org.organization_id = m.organization_id
202: AND NVL(org.operating_unit, mo_global.get_current_org_id())
203: = mo_global.get_current_org_id()
204: );*/

Line 214: mtl_parameters m

210: AND organization_id = p_org_id
211: AND organization_id IN
212: (SELECT DISTINCT m.master_organization_id
213: FROM INV_ORGANIZATION_INFO_V org,
214: mtl_parameters m
215: WHERE org.organization_id = m.organization_id
216: AND NVL(org.operating_unit,mo_global.get_current_org_id()) = mo_global.get_current_org_id()
217: ) ;
218: ELSIF p_item_id IS NOT NULL THEN

Line 230: FROM org_organization_definitions org, mtl_parameters m

226: INTO x_item_name, x_item_id, x_org_id
227: FROM MTL_SYSTEM_ITEMS_KFV
228: WHERE inventory_item_id = p_item_id AND organization_id = p_org_id
229: AND organization_id IN (Select DISTINCT m.master_organization_id
230: FROM org_organization_definitions org, mtl_parameters m
231: WHERE org.organization_id = m.organization_id
232: AND NVL(org.operating_unit, mo_global.get_current_org_id())
233: = mo_global.get_current_org_id()
234: ); */

Line 242: mtl_parameters m

238: FROM MTL_SYSTEM_ITEMS_KFV
239: WHERE inventory_item_id = p_item_id AND organization_id = p_org_id
240: AND organization_id IN (Select DISTINCT m.master_organization_id
241: FROM inv_organization_info_v org,
242: mtl_parameters m
243: WHERE org.organization_id = m.organization_id
244: AND NVL(org.operating_unit,mo_global.get_current_org_id())
245: = mo_global.get_current_org_id()
246: ) ;

Line 521: FROM hr_organization_units hou, mtl_parameters MP

517: IF (p_organization_id IS NOT NULL) THEN
518: -- AnRaj:Changes made for fixing bug#4919353, issue# 6
519: SELECT hou.organization_id
520: INTO x_organization_id
521: FROM hr_organization_units hou, mtl_parameters MP
522: WHERE hou.organization_id = mp.organization_id
523: AND hou.organization_id = p_organization_id
524: AND hou.organization_id IN
525: (SELECT organization_id

Line 534: FROM hr_organization_units hou, mtl_parameters MP

530: ELSE
531: -- AnRaj:Changes made for fixing bug#4919353, issue# 5
532: SELECT hou.organization_id
533: INTO x_organization_id
534: FROM hr_organization_units hou, mtl_parameters MP
535: WHERE hou.organization_id = mp.organization_id
536: AND hou.Name = p_org_name
537: AND hou.organization_id IN
538: (SELECT organization_id