DBA Data[Home] [Help]

APPS.AHL_UC_INSTANCE_PVT dependencies on AHL_WORKORDERS

Line 4641: AHL_WORKORDERS AWO

4637: VST.inv_locator_id,
4638: AWO.wip_entity_id
4639: FROM
4640: AHL_VISITS_B VST,
4641: AHL_WORKORDERS AWO
4642: WHERE
4643: VST.status_code NOT IN ('DELETED', 'CANCELLED')
4644: AND AWO.visit_id = VST.visit_id
4645: AND AWO.workorder_id = c_workorder_id;

Line 5807: FROM ahl_workorders

5803: l_instance_details_rec ahl_instance_details%ROWTYPE;
5804:
5805: CURSOR get_wip_entity_id (c_workorder_id NUMBER) IS
5806: SELECT wip_entity_id
5807: FROM ahl_workorders
5808: WHERE workorder_id = c_workorder_id;
5809: l_wip_entity_id NUMBER;
5810:
5811: CURSOR check_parent_instance(c_instance_id NUMBER) IS