DBA Data[Home] [Help]

APPS.AHL_VWP_TASK_CST_PR_PVT dependencies on HR_ORGANIZATION_UNITS

Line 3002: FROM mtl_system_items_kfv mtl,hr_organization_units hou,inv_organization_info_v org

2998: SELECT mtl.CONCATENATED_SEGMENTS,
2999: mtl.DESCRIPTION,
3000: mtl.organization_id INVENTORY_ORG_ID,
3001: hou.name organization_name
3002: FROM mtl_system_items_kfv mtl,hr_organization_units hou,inv_organization_info_v org
3003: WHERE mtl.organization_id = org.organization_id
3004: AND hou.organization_id = org.organization_id
3005: AND NVL (org.operating_unit, mo_global.get_current_org_id ()) =mo_global.get_current_org_id()
3006: AND mtl.inventory_item_id=c_item_id