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_PP_MATERIALS_PVT dependencies on AHL_RT_OPER_MATERIALS

Line 5608: /* MANESING::NR Analysis, 03-Jun-2011, modified cursor query to include an outer join with table AHL_RT_OPER_MATERIALS

5604: x_msg_count OUT NOCOPY NUMBER,
5605: x_msg_data OUT NOCOPY VARCHAR2)
5606: IS
5607:
5608: /* MANESING::NR Analysis, 03-Jun-2011, modified cursor query to include an outer join with table AHL_RT_OPER_MATERIALS
5609: * instead of previous inner join. This is required since material requirements for Stage workorders do not come
5610: * directly from routes.
5611: */
5612: CURSOR Sche_Mat_Cur(c_visit_task_id IN NUMBER)

Line 5647: AHL_RT_OPER_MATERIALS ARM

5643: ASM.attribute13,
5644: ASM.attribute14,
5645: ASM.attribute15
5646: FROM AHL_SCHEDULE_MATERIALS ASM,
5647: AHL_RT_OPER_MATERIALS ARM
5648: WHERE ASM.rt_oper_material_id = ARM.RT_OPER_MATERIAL_ID(+)
5649: AND ASM.visit_task_id = C_VISIT_TASK_ID
5650: AND ASM.requested_quantity > 0
5651: AND ASM.STATUS IN ('ACTIVE','IN-SERVICE');