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_LTP_MATRL_AVAL_PVT dependencies on AHL_VISIT_TASKS_B

Line 944: AHL_VISIT_TASKS_B tsk

940: -- Changed for fixing perf bug:4919540
941: select DECODE( SIGN( trunc(scheduled_date) - trunc(requested_date)),1,scheduled_date,null) scheduled_date,
942: scheduled_quantity
943: from ahl_schedule_materials asmt,
944: AHL_VISIT_TASKS_B tsk
945: where TSK.VISIT_ID = ASMT.VISIT_ID
946: AND TSK.VISIT_TASK_ID = ASMT.VISIT_TASK_ID
947: AND NVL(ASMT.STATUS,' ') <> 'DELETED'
948: AND NVL(TSK.STATUS_CODE,'X') <> 'DELETED'

Line 955: AHL_VISIT_TASKS_B tsk

951: SELECT scheduled_date ,
952: status, --Added by sowsubra
953: scheduled_quantity
954: FROM ahl_schedule_materials asmt,
955: AHL_VISIT_TASKS_B tsk
956: WHERE TSK.VISIT_ID = ASMT.VISIT_ID
957: AND TSK.VISIT_TASK_ID = ASMT.VISIT_TASK_ID
958: AND NVL(ASMT.STATUS,' ') <> 'DELETED'
959: AND NVL(TSK.STATUS_CODE,'X') <> 'DELETED'