DBA Data[Home] [Help]

APPS.AHL_COMPLEX_MX_RWSC_PVT dependencies on AHL_ITEM_GROUPS_B

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