DBA Data[Home] [Help]

APPS.AHL_COMPLEX_MX_RWSC_PVT dependencies on AHL_RT_OPER_MATERIALS

Line 714: AHL_RT_OPER_MATERIALS ROM

710: CURSOR get_replace_rework_per(c_inventory_item_id IN NUMBER, c_relationship_id IN NUMBER, c_visit_id IN NUMBER) IS
711: SELECT *
712: FROM (SELECT ROM.rework_percent, ROM.replace_percent
713: FROM AHL_SCHEDULE_MATERIALS ASL,
714: AHL_RT_OPER_MATERIALS ROM
715: WHERE ASL.position_path_id IS NOT NULL
716: AND ASL.relationship_id = c_relationship_id
717: AND ASL.visit_id = c_visit_id
718: AND ASL.rt_oper_material_id = ROM.rt_oper_material_id

Line 728: AHL_RT_OPER_MATERIALS ROM

724:
725: -- For item based dispositions
726: SELECT ROM.rework_percent, ROM.replace_percent
727: FROM AHL_SCHEDULE_MATERIALS ASL,
728: AHL_RT_OPER_MATERIALS ROM
729: WHERE ASL.position_path_id IS NULL
730: AND ASL.inventory_item_id = c_inventory_item_id
731: AND ASL.visit_id = c_visit_id
732: AND ASL.rt_oper_material_id = ROM.rt_oper_material_id