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 MTL_SYSTEM_ITEMS_B

Line 829: mtl_system_items_b mtl

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
832: AND asm.inventory_item_id = mtl.inventory_item_id
833: AND asm.organization_id = mtl.organization_id

Line 1659: MTL_SYSTEM_ITEMS_B MSIV,

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
1663: WHERE AWOP.WORKORDER_ID = AWOS.WORKORDER_ID