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_PRD_WORKORDER_PVT dependencies on AHL_SCHEDULE_MATERIALS

Line 3803: FROM AHL_SCHEDULE_MATERIALS MAT

3799: --sukhwsin: VCP Integration Requirements - Added cursor to get material req count that contains item group
3800: CURSOR Get_Alt_Mat_Requirment_Count(c_visit_task_id IN NUMBER)
3801: IS
3802: SELECT COUNT(MAT.scheduled_material_id)
3803: FROM AHL_SCHEDULE_MATERIALS MAT
3804: WHERE MAT.VISIT_TASK_ID = c_visit_task_id
3805: AND NVL(MAT.STATUS,'NOTDEL') <> 'DELETED'
3806: AND
3807: (

Line 4759: FROM AHL_SCHEDULE_MATERIALS ASM,

4755:
4756: CURSOR GET_WO_MATERIAL_REQ_DETAILS(P_WORKORDER_ID NUMBER)
4757: IS
4758: SELECT ASM.AOG_FLAG
4759: FROM AHL_SCHEDULE_MATERIALS ASM,
4760: AHL_VISIT_TASKS_B AVT,
4761: AHL_WORKORDERS AW
4762: WHERE ASM.VISIT_TASK_ID = AVT.VISIT_TASK_ID
4763: AND AW.VISIT_TASK_ID = AVT.VISIT_TASK_ID