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

Line 46: mo_global.init('AHL');

42: FETCH get_resp_id_csr INTO l_resp_id;
43: CLOSE get_resp_id_csr;
44:
45: FND_GLOBAL.apps_initialize(l_user_id,l_resp_id,867);
46: mo_global.init('AHL');
47: return Fnd_Api.G_RET_STS_SUCCESS;
48:
49: END init_user_and_role;
50:

Line 4408: l_sql_string := l_sql_string || ' FROM org_organization_definitions org, mtl_parameters mp WHERE org.organization_id = mp.organization_id AND NVL(operating_unit,mo_global.get_current_org_id()) = mo_global.get_current_org_id()) ';

4404: l_sql_string := l_sql_string || ' FROM csi_item_instances csi1,mtl_system_items_kfv ahl1 ';
4405: l_sql_string := l_sql_string || ' WHERE csi1.INV_MASTER_ORGANIZATION_ID=ahl1.organization_id ';
4406: l_sql_string := l_sql_string || ' and csi1.inventory_item_id=ahl1.inventory_item_id ';
4407: l_sql_string := l_sql_string || ' and csi1.INV_MASTER_ORGANIZATION_ID IN (SELECT master_organization_id ';
4408: l_sql_string := l_sql_string || ' FROM org_organization_definitions org, mtl_parameters mp WHERE org.organization_id = mp.organization_id AND NVL(operating_unit,mo_global.get_current_org_id()) = mo_global.get_current_org_id()) ';
4409:
4410: --Get Dynamic Search Criteria
4411: l_criteria_tbl :=p_lov_input_rec.LovCriteriaTbl;
4412: l_bind_index := 1;

Line 4649: l_sql_string2 := l_sql_string2 || ' FROM org_organization_definitions org, mtl_parameters mp WHERE org.organization_id = mp.organization_id AND NVL(operating_unit,mo_global.get_current_org_id()) = mo_global.get_current_org_id()) ';

4645: l_sql_string2 := 'SELECT * FROM ( SELECT Rownum RN, mtl.concatenated_segments , mtl.description , mtl.primary_unit_of_measure, to_number(NULL), mtl.inventory_item_id ';
4646: l_sql_string2 := l_sql_string2 || ' from mtl_system_items_kfv mtl,mtl_parameters mtlp ';
4647: l_sql_string2 := l_sql_string2 || ' WHERE mtl.organization_id = mtlp.organization_id ';
4648: l_sql_string2 := l_sql_string2 || ' and mtlp.eam_enabled_flag = ''Y'' and mtl.organization_id IN (SELECT master_organization_id ';
4649: l_sql_string2 := l_sql_string2 || ' FROM org_organization_definitions org, mtl_parameters mp WHERE org.organization_id = mp.organization_id AND NVL(operating_unit,mo_global.get_current_org_id()) = mo_global.get_current_org_id()) ';
4650:
4651: --Get Dynamic Search Criteria
4652: l_criteria_tbl :=p_lov_input_rec.LovCriteriaTbl;
4653: l_bind_index := 1;

Line 5213: --mo_global.init('AHL');

5209:
5210: -- Initialize environment
5211:
5212: --fnd_global.apps_initialize(1003259, 54506, 867);
5213: --mo_global.init('AHL');
5214: x_return_status := init_user_and_role(p_userid);
5215:
5216: -- Standard call to check for call compatibility
5217: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name, G_PKG_NAME ) THEN