DBA Data[Home] [Help]

APPS.AHL_COMPLETIONS_PVT dependencies on INV_ORGANIZATION_INFO_V

Line 235: (SELECT ORGANIZATION_ID FROM INV_ORGANIZATION_INFO_V WHERE

231: WDJ.COMPLETION_LOCATOR_ID,
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