APPS.AHL_PP_MATERIALS_PVT dependencies on AHL_RT_OPER_MATERIALS

Line 4082: AHL_RT_OPER_MATERIALS ARM

4078: ASM.mr_route_id,
4079: ASM.material_request_type,
4080: ASM.status
4081: FROM AHL_SCHEDULE_MATERIALS ASM,
4082: AHL_RT_OPER_MATERIALS ARM
4083: WHERE ASM.rt_oper_material_id = ARM.RT_OPER_MATERIAL_ID
4084: AND ASM.visit_task_id = C_VISIT_TASK_ID
4085: AND ASM.requested_quantity > 0
4086: AND ASM.STATUS IN ('ACTIVE','IN-SERVICE');