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

Line 810: FROM AHL_SCHEDULE_MATERIALS_V MAT

806: SELECT MAT.inventory_item_id,
807: MAT.requested_date,
808: SUM(NVL(MAT.requested_quantity,0)) quantity,
809: MAT.uom_code
810: FROM AHL_SCHEDULE_MATERIALS_V MAT
811: WHERE MAT.visit_task_id =c_visit_task_id
812: AND MAT.JOB_STATUS_CODE <> 22 -- 'deleted' status
813: AND MAT.JOB_STATUS_CODE <> 7 -- 'cancelled' status
814: AND MAT.inventory_item_id is not null

Line 827: ahl_schedule_materials asm,

823: wiro.DATE_REQUIRED requested_date,
824: sum(nvl(wiro.REQUIRED_QUANTITY,0)) quantity,
825: mtl.primary_uom_code uom_code
826: FROM ahl_workorders awo,
827: ahl_schedule_materials asm,
828: wip_requirement_operations wiro,
829: mtl_system_items_b mtl
830: WHERE awo.visit_task_id = c_visit_task_id
831: AND awo.visit_task_id = asm.visit_task_id