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_OSP_SERV_ITEM_RELS_PVT dependencies on MO_GLOBAL

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

102: WHERE hou.name = p_org_name
103: AND mtl.concatenated_segments = p_item_name
104: AND mtl.organization_id = org.organization_id
105: AND hou.organization_id = org.organization_id
106: AND NVL (org.operating_unit, mo_global.get_current_org_id ()) = mo_global.get_current_org_id()
107: AND mtl.inventory_item_flag = p_item_flag
108: AND NVL(mtl.start_date_active, sysdate) <= sysdate
109: AND NVL(mtl.end_date_active, sysdate + 1) > sysdate
110: AND DECODE(p_item_flag,'N',mtl.purchasing_enabled_flag,'Y') = 'Y'

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

134: FROM mtl_system_items_b mtl, inv_organization_info_v org
135: WHERE mtl.organization_id = p_org_id
136: AND mtl.inventory_item_id = p_item_id
137: AND mtl.organization_id = org.organization_id
138: AND NVL (org.operating_unit, mo_global.get_current_org_id ()) = mo_global.get_current_org_id()
139: AND mtl.inventory_item_flag = p_item_flag
140: AND NVL(mtl.start_date_active, sysdate) <= sysdate
141: AND NVL(mtl.end_date_active, sysdate + 1) > sysdate
142: AND DECODE(p_item_flag,'N',mtl.purchasing_enabled_flag,'Y') = 'Y'

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

201: AND mtl.organization_id = isirv.inv_org_id
202: AND isirv.rank = p_rank;
203: /* Fix for the Bug# 5167378 by mpothuku on 17-Apr-06 */
204: /*
205: AND NVL(org.operating_unit, mo_global.get_current_org_id())= mo_global.get_current_org_id();
206: */
207:
208: l_Item_Ser_rel_det Item_Ser_rel_det_csr%ROWTYPE;
209: l_org_item_rank_exists_csr org_item_rank_exists_csr%ROWTYPE;

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

604: (select INV_ORG_ID from AHL_INV_SERVICE_ITEM_RELS
605: where inv_item_id = p_x_Inv_serv_item_rec.inv_item_id
606: AND service_item_id = p_x_Inv_serv_item_rec.service_item_id)
607: -- mpothuku end
608: AND NVL(org.operating_unit, mo_global.get_current_org_id()) =
609: mo_global.get_current_org_id();
610:
611: ELSE
612:

Line 609: mo_global.get_current_org_id();

605: where inv_item_id = p_x_Inv_serv_item_rec.inv_item_id
606: AND service_item_id = p_x_Inv_serv_item_rec.service_item_id)
607: -- mpothuku end
608: AND NVL(org.operating_unit, mo_global.get_current_org_id()) =
609: mo_global.get_current_org_id();
610:
611: ELSE
612:
613: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN