DBA Data[Home] [Help]

APPS.AHL_UMP_SR_PVT dependencies on AHL_VISITS_B

Line 2951: AHL_VISITS_B VST,

2947: FROM
2948: AHL_WORKORDERS WO,
2949: WIP_DISCRETE_JOBS WIPJ,
2950: AHL_VISIT_TASKS_B VTSK,
2951: AHL_VISITS_B VST,
2952: AHL_UNIT_EFFECTIVITIES_B UE
2953: WHERE
2954: WO.status_code not in (4,12,7,5) AND -- Completed/Closed/Cancelled/Completed_No_Charge
2955: WO.wip_entity_id = WIPJ.wip_entity_id AND