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_WORKORDERS

Line 826: FROM ahl_workorders awo,

822: SELECT asm.inventory_item_id,
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

Line 1633: AHL_WORKORDERS_V AWOS,

1629: SUM(NVL(MAT.quantity,0)) quantity,
1630: MSIV.primary_uom_code uom_code
1631: -- MAT.uom uom_code
1632: FROM AHL_WORKORDER_MTL_TXNS MAT,
1633: AHL_WORKORDERS_V AWOS,
1634: MTL_SYSTEM_ITEMS_VL MSIV,
1635: AHL_VISITS_B V,
1636: AHL_VISIT_TASKS_B VT,
1637: AHL_WORKORDER_OPERATIONS_V AWOP

Line 1658: AHL_WORKORDERS AWOS,

1654: MAT.creation_date,
1655: SUM(NVL(MAT.quantity,0)) quantity,
1656: MSIV.primary_uom_code uom_code
1657: FROM AHL_WORKORDER_MTL_TXNS MAT,
1658: AHL_WORKORDERS AWOS,
1659: MTL_SYSTEM_ITEMS_B MSIV,
1660: AHL_VISITS_B V,
1661: AHL_VISIT_TASKS_B VT,
1662: AHL_WORKORDER_OPERATIONS_V AWOP