DBA Data[Home] [Help]

APPS.AHL_COMPLETIONS_PVT dependencies on MO_GLOBAL

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

232: WO.visit_id,
233: WO.visit_task_id
234: FROM AHL_WORKORDERS WO, FND_LOOKUP_VALUES_VL MLU,WIP_DISCRETE_JOBS WDJ,
235: (SELECT ORGANIZATION_ID FROM INV_ORGANIZATION_INFO_V WHERE
236: NVL (operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id()) ORG
237: WHERE WDJ.WIP_ENTITY_ID=WO.WIP_ENTITY_ID
238: AND MLU.LOOKUP_TYPE(+)='AHL_JOB_STATUS' AND WO.STATUS_CODE=MLU.LOOKUP_CODE(+)
239: AND WDJ.ORGANIZATION_ID = ORG.ORGANIZATION_ID
240: AND WO.workorder_id = c_workorder_id;