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 970: AHL_VISIT_TASKS_B tsk

966: -- Changed for fixing perf bug:4919540
967: select DECODE( SIGN( trunc(scheduled_date) - trunc(requested_date)),1,scheduled_date,null) scheduled_date,
968: scheduled_quantity
969: from ahl_schedule_materials asmt,
970: AHL_VISIT_TASKS_B tsk
971: where TSK.VISIT_ID = ASMT.VISIT_ID
972: AND TSK.VISIT_TASK_ID = ASMT.VISIT_TASK_ID
973: AND NVL(ASMT.STATUS,' ') <> 'DELETED'
974: AND NVL(TSK.STATUS_CODE,'X') <> 'DELETED'

Line 981: AHL_VISIT_TASKS_B tsk

977: SELECT scheduled_date ,
978: status, --Added by sowsubra
979: scheduled_quantity
980: FROM ahl_schedule_materials asmt,
981: AHL_VISIT_TASKS_B tsk
982: WHERE TSK.VISIT_ID = ASMT.VISIT_ID
983: AND TSK.VISIT_TASK_ID = ASMT.VISIT_TASK_ID
984: AND NVL(ASMT.STATUS,' ') <> 'DELETED'
985: AND NVL(TSK.STATUS_CODE,'X') <> 'DELETED'