DBA Data[Home] [Help]

APPS.AHL_PRD_DF_PVT dependencies on INV_ORGANIZATION_INFO_V

Line 3869: (SELECT ORGANIZATION_ID FROM INV_ORGANIZATION_INFO_V

3865:
3866: SELECT WO.workorder_id
3867: FROM ahl_workorders wo, ahl_visit_tasks_b vts,
3868: ahl_visits_b vst,
3869: (SELECT ORGANIZATION_ID FROM INV_ORGANIZATION_INFO_V
3870: WHERE NVL (operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id()) ORG
3871: WHERE wo.visit_task_id = vts.visit_task_id
3872: AND vts.visit_id = vst.visit_id
3873: AND vst.organization_id = org.organization_id

Line 5925: FROM INV_ORGANIZATION_INFO_V

5921: SELECT 'x'
5922: FROM ahl_workorders wo, ahl_unit_deferrals_b udf,
5923: ahl_visit_tasks_b vts, ahl_visits_b vst,
5924: (SELECT ORGANIZATION_ID
5925: FROM INV_ORGANIZATION_INFO_V
5926: WHERE NVL (operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id()) ORG
5927: WHERE WO.VISIT_TASK_ID=VTS.VISIT_TASK_ID
5928: AND VST.VISIT_ID=VTS.VISIT_ID
5929: AND VST.ORGANIZATION_ID=ORG.ORGANIZATION_ID