DBA Data[Home] [Help]

APPS.AHL_MC_TREE_PVT dependencies on AHL_MC_HEADERS_V

Line 639: AHL_MC_HEADERS_V HDR,

635: HDR.MC_ID,
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)

Line 686: AHL_MC_HEADERS_V HDR,

682: HDR.MC_ID,
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

Line 728: AHL_MC_HEADERS_V HDR,

724: HDR.MC_ID,
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)