APPS.AHL_OSP_SERV_ITEM_RELS_PVT dependencies on INV_ORGANIZATION_INFO_V

Line 101: FROM mtl_system_items_kfv mtl, inv_organization_info_v org, hr_all_organization_units hou

97:
98: SELECT
99: mtl.inventory_item_id,
100: mtl.organization_id inventory_org_id
101: FROM mtl_system_items_kfv mtl, inv_organization_info_v org, hr_all_organization_units hou
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

Line 134: FROM mtl_system_items_b mtl, inv_organization_info_v org

130: --Changed by mpothuku for fixing the Performance Bug# 4919315
131: SELECT
132: mtl.inventory_item_id,
133: mtl.organization_id inventory_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()

Line 191: inv_organization_info_v org

187: fix 5350882, mpothuku 26-Jul-06 */
188: FROM ahl_inv_service_item_rels_v isirv,
189: mtl_system_items_b mtl
190: /*
191: inv_organization_info_v org
192: */
193: WHERE isirv.inv_item_id = p_inv_item_id
194: AND isirv.service_item_id <> p_service_item_id
195: /*

Line 595: inv_organization_info_v org

591: NULL
592: FROM mtl_system_items_kfv Inv,
593: mtl_system_items_kfv Serv,
594: --Modified by mpothuku on 17-Jan-05 to fix the performance Bug 4919315
595: inv_organization_info_v org
596: WHERE Inv.ORGANIZATION_ID = Serv.ORGANIZATION_ID
597: AND org.organization_id = Inv.ORGANIZATION_ID
598: AND Inv.inventory_item_flag = 'Y'
599: AND Serv.inventory_item_flag = 'N'