DBA Data[Home] [Help]

APPS.AHL_UC_INSTANCE_PVT dependencies on AHL_WORKORDERS

Line 4619: AHL_WORKORDERS AWO

4615: VST.inv_locator_id,
4616: AWO.wip_entity_id
4617: FROM
4618: AHL_VISITS_B VST,
4619: AHL_WORKORDERS AWO
4620: WHERE
4621: VST.status_code NOT IN ('DELETED', 'CANCELLED')
4622: AND AWO.visit_id = VST.visit_id
4623: AND AWO.workorder_id = c_workorder_id;

Line 5700: FROM ahl_workorders

5696: l_instance_details_rec ahl_instance_details%ROWTYPE;
5697:
5698: CURSOR get_wip_entity_id (c_workorder_id NUMBER) IS
5699: SELECT wip_entity_id
5700: FROM ahl_workorders
5701: WHERE workorder_id = c_workorder_id;
5702: l_wip_entity_id NUMBER;
5703:
5704: CURSOR check_parent_instance(c_instance_id NUMBER) IS