APPS.AHL_COMPLEX_MX_RWSC_PVT dependencies on AHL_SCHEDULE_MATERIALS

Line 713: FROM AHL_SCHEDULE_MATERIALS ASL,

709: -- TODO: We may need to fix it when we finilise the quantity field(scheduled or requested) to consider here.
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

Line 727: FROM AHL_SCHEDULE_MATERIALS ASL,

723: UNION ALL
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

Line 747: FROM AHL_SCHEDULE_MATERIALS ASM, AHL_MC_RELATIONSHIPS MCR

743: WHEN 0 THEN 'N'
744: WHEN 1 THEN 'Y'
745: ELSE 'M'
746: END position_material
747: FROM AHL_SCHEDULE_MATERIALS ASM, AHL_MC_RELATIONSHIPS MCR
748: WHERE MCR.relationship_id = c_relationship_id
749: AND ASM.visit_id = c_visit_id
750: AND ASM.mc_header_id = MCR.mc_header_id
751: AND ASM.position_key = MCR.position_key;