eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_VWP_RULES_PVT dependencies on MO_GLOBAL

Line 202: AND NVL(org.operating_unit, mo_global.get_current_org_id())

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: );*/
205:
206: SELECT concatenated_segments, inventory_item_id, organization_id

Line 203: = mo_global.get_current_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: );*/
205:
206: SELECT concatenated_segments, inventory_item_id, organization_id
207: INTO x_item_name, x_item_id, x_org_id

Line 216: AND NVL(org.operating_unit,mo_global.get_current_org_id()) = mo_global.get_current_org_id()

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
219: -- SELECT concatenated_segments, inventory_item_id, inventory_org_id
220: -- INTO x_item_name, x_item_id, x_org_id

Line 232: AND NVL(org.operating_unit, mo_global.get_current_org_id())

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: ); */
235: -- AnRaj: Changes made for fixing bug#4919353
236: SELECT concatenated_segments, inventory_item_id, organization_id

Line 233: = mo_global.get_current_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: ); */
235: -- AnRaj: Changes made for fixing bug#4919353
236: SELECT concatenated_segments, inventory_item_id, organization_id
237: INTO x_item_name, x_item_id, x_org_id

Line 244: AND NVL(org.operating_unit,mo_global.get_current_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: ) ;
247: END IF;
248: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 245: = mo_global.get_current_org_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: ) ;
247: END IF;
248: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
249: ELSE

Line 310: WHERE NVL(operating_unit,mo_global.get_current_org_id()) =

306: -- Carrying-out Org as an Inventory Org
307: AND carrying_out_organization_id IN
308: ( SELECT organization_id
309: FROM INV_ORGANIZATION_INFO_V
310: WHERE NVL(operating_unit,mo_global.get_current_org_id()) =
311: mo_global.get_current_org_id()
312: );
313: */
314: /*

Line 311: mo_global.get_current_org_id()

307: AND carrying_out_organization_id IN
308: ( SELECT organization_id
309: FROM INV_ORGANIZATION_INFO_V
310: WHERE NVL(operating_unit,mo_global.get_current_org_id()) =
311: mo_global.get_current_org_id()
312: );
313: */
314: /*
315: SELECT project_id

Line 321: WHERE NVL(operating_unit, mo_global.get_current_org_id()) =

317: WHERE name = p_proj_temp_name
318: AND TEMPLATE_FLAG = 'Y'
319: AND carrying_out_organization_id IN (SELECT organization_id
320: FROM org_organization_definitions
321: WHERE NVL(operating_unit, mo_global.get_current_org_id()) =
322: mo_global.get_current_org_id());
323: */
324:
325: BEGIN

Line 322: mo_global.get_current_org_id());

318: AND TEMPLATE_FLAG = 'Y'
319: AND carrying_out_organization_id IN (SELECT organization_id
320: FROM org_organization_definitions
321: WHERE NVL(operating_unit, mo_global.get_current_org_id()) =
322: mo_global.get_current_org_id());
323: */
324:
325: BEGIN
326:

Line 528: AND NVL(operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id())

524: AND hou.organization_id IN
525: (SELECT organization_id
526: FROM INV_ORGANIZATION_INFO_V
527: WHERE hou.organization_id = mp.organization_id
528: AND NVL(operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id())
529: AND MP.EAM_enabled_flag='Y';
530: ELSE
531: -- AnRaj:Changes made for fixing bug#4919353, issue# 5
532: SELECT hou.organization_id

Line 541: AND NVL(operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id())

537: AND hou.organization_id IN
538: (SELECT organization_id
539: FROM INV_ORGANIZATION_INFO_V
540: WHERE hou.organization_id = mp.organization_id
541: AND NVL(operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id())
542: AND MP.EAM_enabled_flag='Y';
543: END IF;
544: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
545: IF (l_log_procedure >= l_log_current_level) THEN

Line 1000: p_operating_unit_id => mo_global.get_current_org_id, -- Yazhou added for MOAC changes on 05Oct2005

996: PA_INTERFACE_UTILS_PUB.Set_Global_Info( p_api_version_number => 1.0,
997: p_responsibility_id => Fnd_Global.RESP_ID,
998: p_resp_appl_id => Fnd_Global.RESP_APPL_ID,
999: p_user_id => Fnd_Global.USER_ID,
1000: p_operating_unit_id => mo_global.get_current_org_id, -- Yazhou added for MOAC changes on 05Oct2005
1001: p_msg_count => l_msg_count,
1002: p_msg_data => l_msg_data,
1003: p_return_status => x_return_status);
1004: IF (fnd_log.level_event >= l_log_current_level) THEN

Line 2950: AND NVL(operating_unit, mo_global.get_current_org_id())= mo_global.get_current_org_id();

2946: SELECT currency_code
2947: FROM cst_acct_info_v COD, GL_SETS_OF_BOOKS GSOB
2948: WHERE COD.Organization_Id = p_org_id
2949: AND LEDGER_ID = GSOB.SET_OF_BOOKS_ID
2950: AND NVL(operating_unit, mo_global.get_current_org_id())= mo_global.get_current_org_id();
2951:
2952: /*SELECT currency_code
2953: -- into x_currency_code
2954: FROM CST_ORGANIZATION_DEFINITIONS COD --,AHL_VISITS_B VST

Line 2958: AND NVL(operating_unit, mo_global.get_current_org_id())

2954: FROM CST_ORGANIZATION_DEFINITIONS COD --,AHL_VISITS_B VST
2955: WHERE --VST.visit_id = p_visit_id AND
2956: --COD.Organization_Id = VST.organization_id
2957: COD.Organization_Id = p_org_id
2958: AND NVL(operating_unit, mo_global.get_current_org_id())
2959: = mo_global.get_current_org_id();*/
2960:
2961: BEGIN
2962:

Line 2959: = mo_global.get_current_org_id();*/

2955: WHERE --VST.visit_id = p_visit_id AND
2956: --COD.Organization_Id = VST.organization_id
2957: COD.Organization_Id = p_org_id
2958: AND NVL(operating_unit, mo_global.get_current_org_id())
2959: = mo_global.get_current_org_id();*/
2960:
2961: BEGIN
2962:
2963: IF (l_log_procedure >= l_log_current_level) THEN