DBA Data[Home] [Help]

APPS.AHL_OSP_SERV_ITEM_RELS_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

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