636: HDR.VERSION_NUMBER,
637: HDR.CONFIG_STATUS_CODE
638: FROM AHL_MC_RELATIONSHIPS REL,
639: AHL_MC_HEADERS_V HDR,
640: FND_LOOKUP_VALUES_VL FPRC,
641: FND_LOOKUP_VALUES_VL FPNC,
642: FND_LOOKUP_VALUES_VL FATA
643: WHERE NVL(REL.PARENT_RELATIONSHIP_ID,0) = NVL(p_relationship_id,0)
644: AND REL.MC_HEADER_ID = p_mc_header_id
637: HDR.CONFIG_STATUS_CODE
638: FROM AHL_MC_RELATIONSHIPS REL,
639: AHL_MC_HEADERS_V HDR,
640: FND_LOOKUP_VALUES_VL FPRC,
641: FND_LOOKUP_VALUES_VL FPNC,
642: FND_LOOKUP_VALUES_VL FATA
643: WHERE NVL(REL.PARENT_RELATIONSHIP_ID,0) = NVL(p_relationship_id,0)
644: AND REL.MC_HEADER_ID = p_mc_header_id
645: AND REL.MC_HEADER_ID = HDR.MC_HEADER_ID
638: FROM AHL_MC_RELATIONSHIPS REL,
639: AHL_MC_HEADERS_V HDR,
640: FND_LOOKUP_VALUES_VL FPRC,
641: FND_LOOKUP_VALUES_VL FPNC,
642: FND_LOOKUP_VALUES_VL FATA
643: WHERE NVL(REL.PARENT_RELATIONSHIP_ID,0) = NVL(p_relationship_id,0)
644: AND REL.MC_HEADER_ID = p_mc_header_id
645: AND REL.MC_HEADER_ID = HDR.MC_HEADER_ID
646: AND TRUNC(NVL(REL.ACTIVE_END_DATE, SYSDATE + 1)) > TRUNC(SYSDATE)
683: HDR.VERSION_NUMBER,
684: HDR.CONFIG_STATUS_CODE
685: FROM AHL_MC_RELATIONSHIPS REL,
686: AHL_MC_HEADERS_V HDR,
687: FND_LOOKUP_VALUES_VL FPRC,
688: FND_LOOKUP_VALUES_VL FPNC,
689: FND_LOOKUP_VALUES_VL FATA
690: WHERE REL.PARENT_RELATIONSHIP_ID IS NULL
691: AND REL.MC_HEADER_ID = p_mc_header_id
684: HDR.CONFIG_STATUS_CODE
685: FROM AHL_MC_RELATIONSHIPS REL,
686: AHL_MC_HEADERS_V HDR,
687: FND_LOOKUP_VALUES_VL FPRC,
688: FND_LOOKUP_VALUES_VL FPNC,
689: FND_LOOKUP_VALUES_VL FATA
690: WHERE REL.PARENT_RELATIONSHIP_ID IS NULL
691: AND REL.MC_HEADER_ID = p_mc_header_id
692: AND REL.MC_HEADER_ID = HDR.MC_HEADER_ID
685: FROM AHL_MC_RELATIONSHIPS REL,
686: AHL_MC_HEADERS_V HDR,
687: FND_LOOKUP_VALUES_VL FPRC,
688: FND_LOOKUP_VALUES_VL FPNC,
689: FND_LOOKUP_VALUES_VL FATA
690: WHERE REL.PARENT_RELATIONSHIP_ID IS NULL
691: AND REL.MC_HEADER_ID = p_mc_header_id
692: AND REL.MC_HEADER_ID = HDR.MC_HEADER_ID
693: AND FPRC.LOOKUP_CODE (+) = REL.POSITION_REF_CODE
725: HDR.VERSION_NUMBER,
726: HDR.CONFIG_STATUS_CODE
727: FROM AHL_MC_RELATIONSHIPS REL,
728: AHL_MC_HEADERS_V HDR,
729: FND_LOOKUP_VALUES_VL FPRC,
730: FND_LOOKUP_VALUES_VL FPNC,
731: FND_LOOKUP_VALUES_VL FATA
732: WHERE NVL(REL.PARENT_RELATIONSHIP_ID,0) = NVL(p_parent_rel_id,0)
733: AND REL.MC_HEADER_ID = p_mc_header_id
726: HDR.CONFIG_STATUS_CODE
727: FROM AHL_MC_RELATIONSHIPS REL,
728: AHL_MC_HEADERS_V HDR,
729: FND_LOOKUP_VALUES_VL FPRC,
730: FND_LOOKUP_VALUES_VL FPNC,
731: FND_LOOKUP_VALUES_VL FATA
732: WHERE NVL(REL.PARENT_RELATIONSHIP_ID,0) = NVL(p_parent_rel_id,0)
733: AND REL.MC_HEADER_ID = p_mc_header_id
734: AND REL.MC_HEADER_ID = HDR.MC_HEADER_ID
727: FROM AHL_MC_RELATIONSHIPS REL,
728: AHL_MC_HEADERS_V HDR,
729: FND_LOOKUP_VALUES_VL FPRC,
730: FND_LOOKUP_VALUES_VL FPNC,
731: FND_LOOKUP_VALUES_VL FATA
732: WHERE NVL(REL.PARENT_RELATIONSHIP_ID,0) = NVL(p_parent_rel_id,0)
733: AND REL.MC_HEADER_ID = p_mc_header_id
734: AND REL.MC_HEADER_ID = HDR.MC_HEADER_ID
735: AND TRUNC(NVL(REL.ACTIVE_END_DATE, SYSDATE + 1)) > TRUNC(SYSDATE)