APPS.AHL_COMPLEX_MX_RWSC_PVT dependencies on AHL_MC_RELATIONSHIPS

Line 646: FROM AHL_MC_RELATIONSHIPS MCR, AHL_ITEM_GROUPS_B GRP

642: AND CSI.inv_master_organization_id = MTL.organization_id;
643:
644: CURSOR get_item_gr_info(c_relationship_id IN NUMBER) IS
645: SELECT MCR.mc_header_id, MCR.item_group_id, GRP.name item_group_name, MCR.quantity
646: FROM AHL_MC_RELATIONSHIPS MCR, AHL_ITEM_GROUPS_B GRP
647: WHERE MCR.item_group_id = GRP.item_group_id (+)
648: AND MCR.relationship_id = c_relationship_id;
649:
650: CURSOR get_sb_rules_info(c_relationship_id IN NUMBER, c_mc_header_id IN NUMBER) IS

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;