APPS.AHL_LTP_MTL_REQ_PVT dependencies on AHL_MC_HEADERS_B

Line 169: from AHL_UNIT_CONFIG_HEADERS UC, AHL_MC_HEADERS_B MC

165: x_route_mtl_req_tbl OUT NOCOPY AHL_LTP_MTL_REQ_PVT.Route_Mtl_Req_Tbl_Type) IS
166:
167: CURSOR get_mc_dtls_csr(c_instance_id IN NUMBER) IS
168: select UC.MASTER_CONFIG_ID, MC.MC_ID, MC.VERSION_NUMBER
169: from AHL_UNIT_CONFIG_HEADERS UC, AHL_MC_HEADERS_B MC
170: where UC.CSI_ITEM_INSTANCE_ID = c_instance_id AND
171: MC.MC_HEADER_ID = UC.MASTER_CONFIG_ID;
172:
173: CURSOR get_item_from_instance_csr(c_instance_id IN NUMBER) IS

Line 865: FROM AHL_MC_CONFIG_RELATIONS CR, AHL_MC_HEADERS_B MC

861: AND parent_relationship_id is null;
862:
863: CURSOR get_sub_mc_for_pos_csr(c_position_id IN NUMBER) IS
864: SELECT CR.mc_header_id
865: FROM AHL_MC_CONFIG_RELATIONS CR, AHL_MC_HEADERS_B MC
866: WHERE CR.relationship_id = c_position_id
867: AND MC.mc_header_id = CR.mc_header_id
868: ORDER BY MC.name;
869: