DBA Data[Home] [Help]

APPS.AHL_VWP_TASK_CST_PR_PVT dependencies on MO_GLOBAL

Line 3005: AND NVL (org.operating_unit, mo_global.get_current_org_id ()) =mo_global.get_current_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
3007: AND mtl.organization_id=c_org_id;
3008:
3009: l_item_info_rec c_item_info%rowtype;