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 208: AND NVL(org.operating_unit, mo_global.get_current_org_id())

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

Line 209: = mo_global.get_current_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: );*/
211:
212: SELECT concatenated_segments, inventory_item_id, organization_id
213: INTO x_item_name, x_item_id, x_org_id

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

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

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

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

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

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

Line 251: = mo_global.get_current_org_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: ) ;
253: END IF;
254: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
255: ELSE

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

312: -- Carrying-out Org as an Inventory Org
313: AND carrying_out_organization_id IN
314: ( SELECT organization_id
315: FROM INV_ORGANIZATION_INFO_V
316: WHERE NVL(operating_unit,mo_global.get_current_org_id()) =
317: mo_global.get_current_org_id()
318: );
319: */
320: /*

Line 317: mo_global.get_current_org_id()

313: AND carrying_out_organization_id IN
314: ( SELECT organization_id
315: FROM INV_ORGANIZATION_INFO_V
316: WHERE NVL(operating_unit,mo_global.get_current_org_id()) =
317: mo_global.get_current_org_id()
318: );
319: */
320: /*
321: SELECT project_id

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

323: WHERE name = p_proj_temp_name
324: AND TEMPLATE_FLAG = 'Y'
325: AND carrying_out_organization_id IN (SELECT organization_id
326: FROM org_organization_definitions
327: WHERE NVL(operating_unit, mo_global.get_current_org_id()) =
328: mo_global.get_current_org_id());
329: */
330:
331: BEGIN

Line 328: mo_global.get_current_org_id());

324: AND TEMPLATE_FLAG = 'Y'
325: AND carrying_out_organization_id IN (SELECT organization_id
326: FROM org_organization_definitions
327: WHERE NVL(operating_unit, mo_global.get_current_org_id()) =
328: mo_global.get_current_org_id());
329: */
330:
331: BEGIN
332:

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

530: AND hou.organization_id IN
531: (SELECT organization_id
532: FROM INV_ORGANIZATION_INFO_V
533: WHERE hou.organization_id = mp.organization_id
534: AND NVL(operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id())
535: AND MP.EAM_enabled_flag='Y';
536: ELSE
537: -- AnRaj:Changes made for fixing bug#4919353, issue# 5
538: SELECT hou.organization_id

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

543: AND hou.organization_id IN
544: (SELECT organization_id
545: FROM INV_ORGANIZATION_INFO_V
546: WHERE hou.organization_id = mp.organization_id
547: AND NVL(operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id())
548: AND MP.EAM_enabled_flag='Y';
549: END IF;
550: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
551: IF (l_log_procedure >= l_log_current_level) THEN

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

1002: PA_INTERFACE_UTILS_PUB.Set_Global_Info( p_api_version_number => 1.0,
1003: p_responsibility_id => Fnd_Global.RESP_ID,
1004: p_resp_appl_id => Fnd_Global.RESP_APPL_ID,
1005: p_user_id => Fnd_Global.USER_ID,
1006: p_operating_unit_id => mo_global.get_current_org_id, -- Yazhou added for MOAC changes on 05Oct2005
1007: p_msg_count => l_msg_count,
1008: p_msg_data => l_msg_data,
1009: p_return_status => x_return_status);
1010: IF (fnd_log.level_event >= l_log_current_level) THEN

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

3265: SELECT currency_code
3266: FROM cst_acct_info_v COD, GL_SETS_OF_BOOKS GSOB
3267: WHERE COD.Organization_Id = p_org_id
3268: AND LEDGER_ID = GSOB.SET_OF_BOOKS_ID
3269: AND NVL(operating_unit, mo_global.get_current_org_id())= mo_global.get_current_org_id();
3270:
3271: /*SELECT currency_code
3272: -- into x_currency_code
3273: FROM CST_ORGANIZATION_DEFINITIONS COD --,AHL_VISITS_B VST

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

3273: FROM CST_ORGANIZATION_DEFINITIONS COD --,AHL_VISITS_B VST
3274: WHERE --VST.visit_id = p_visit_id AND
3275: --COD.Organization_Id = VST.organization_id
3276: COD.Organization_Id = p_org_id
3277: AND NVL(operating_unit, mo_global.get_current_org_id())
3278: = mo_global.get_current_org_id();*/
3279:
3280: BEGIN
3281:

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

3274: WHERE --VST.visit_id = p_visit_id AND
3275: --COD.Organization_Id = VST.organization_id
3276: COD.Organization_Id = p_org_id
3277: AND NVL(operating_unit, mo_global.get_current_org_id())
3278: = mo_global.get_current_org_id();*/
3279:
3280: BEGIN
3281:
3282: IF (l_log_procedure >= l_log_current_level) THEN