eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_AVF_OPER_VSTS_PVT dependencies on AHL_VISIT_TASKS_B

Line 4923: FROM AHL_VISIT_TASKS_B

4919: -- SATRAJEN :: Bug 14464977 :: Changed for retrieving the Non Routines also :: Aug 2012
4920: /*Cursor get_visit_planned_ues(c_visit_id IN NUMBER)
4921: IS
4922: SELECT distinct unit_effectivity_id
4923: FROM AHL_VISIT_TASKS_B
4924: WHERE VISIT_ID = c_visit_id
4925: AND TASK_TYPE_CODE = 'PLANNED';*/
4926: Cursor get_visit_planned_ues(c_visit_id IN NUMBER)
4927: IS

Line 4929: FROM AHL_VISIT_TASKS_B

4925: AND TASK_TYPE_CODE = 'PLANNED';*/
4926: Cursor get_visit_planned_ues(c_visit_id IN NUMBER)
4927: IS
4928: SELECT unit_effectivity_id
4929: FROM AHL_VISIT_TASKS_B
4930: WHERE VISIT_ID = c_visit_id
4931: AND TASK_TYPE_CODE = 'PLANNED' AND SERVICE_REQUEST_ID IS NULL
4932: UNION
4933: SELECT unit_effectivity_id

Line 4934: FROM AHL_VISIT_TASKS_B

4930: WHERE VISIT_ID = c_visit_id
4931: AND TASK_TYPE_CODE = 'PLANNED' AND SERVICE_REQUEST_ID IS NULL
4932: UNION
4933: SELECT unit_effectivity_id
4934: FROM AHL_VISIT_TASKS_B
4935: WHERE VISIT_ID = c_visit_id
4936: AND TASK_TYPE_CODE = 'SUMMARY' AND originating_task_id IS NULL AND SERVICE_REQUEST_ID IS NOT NULL;
4937:
4938: