DBA Data[Home] [Help]

APPS.AHL_COMPLETIONS_PVT dependencies on MO_GLOBAL

Line 262: NVL (operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id()) ORG

258: WO.visit_id,
259: WO.visit_task_id
260: FROM AHL_WORKORDERS WO, FND_LOOKUP_VALUES_VL MLU,WIP_DISCRETE_JOBS WDJ,
261: (SELECT ORGANIZATION_ID FROM INV_ORGANIZATION_INFO_V WHERE
262: NVL (operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id()) ORG
263: WHERE WDJ.WIP_ENTITY_ID=WO.WIP_ENTITY_ID
264: AND MLU.LOOKUP_TYPE(+)='AHL_JOB_STATUS' AND WO.STATUS_CODE=MLU.LOOKUP_CODE(+)
265: AND WDJ.ORGANIZATION_ID = ORG.ORGANIZATION_ID
266: AND WO.workorder_id = c_workorder_id;