APPS.AHL_MC_TREE_PVT dependencies on AHL_MC_RELATIONSHIPS

Line 128: FROM AHL_MC_RELATIONSHIPS

124: p_rel_id IN NUMBER
125: )
126: IS
127: SELECT NVL(COUNT(*), 0) NUM_CHILDREN
128: FROM AHL_MC_RELATIONSHIPS
129: WHERE PARENT_RELATIONSHIP_ID = p_rel_id;
130:
131: -- Define cursor to check whether the particular node has any subconfig_association
132: CURSOR check_subconfig_assos

Line 149: FROM AHL_MC_RELATIONSHIPS

145: )
146: IS
147: SELECT RELATIONSHIP_ID,
148: ACTIVE_END_DATE
149: FROM AHL_MC_RELATIONSHIPS
150: WHERE MC_HEADER_ID = p_mc_header_id AND
151: PARENT_RELATIONSHIP_ID IS NULL;
152:
153: -- Define cursor to retrieve the position path id given a position path

Line 685: FROM AHL_MC_RELATIONSHIPS REL,

681: REL.MC_HEADER_ID,
682: HDR.MC_ID,
683: HDR.VERSION_NUMBER,
684: HDR.CONFIG_STATUS_CODE
685: FROM AHL_MC_RELATIONSHIPS REL,
686: (
687: SELECT MCB.MC_HEADER_ID,
688: MCB.MC_ID,
689: MCB.VERSION_NUMBER,

Line 694: FROM AHL_MC_HEADERS_B MCB, AHL_MC_RELATIONSHIPS MCR

690: DECODE (MCB.CONFIG_STATUS_CODE,
691: 'CLOSED', MCB.CONFIG_STATUS_CODE,
692: DECODE (SIGN(TRUNC(NVL(MCR.ACTIVE_END_DATE, SYSDATE+1)) - TRUNC(SYSDATE)),
693: 1, MCB.CONFIG_STATUS_CODE, 'EXPIRED')) CONFIG_STATUS_CODE
694: FROM AHL_MC_HEADERS_B MCB, AHL_MC_RELATIONSHIPS MCR
695: WHERE MCB.MC_HEADER_ID = MCR.MC_HEADER_ID
696: AND MCR.PARENT_RELATIONSHIP_ID IS NULL
697: ) HDR,
698: FND_LOOKUP_VALUES FPRC,

Line 743: FROM AHL_MC_RELATIONSHIPS REL,

739: DECODE (HDR.CONFIG_STATUS_CODE,
740: 'CLOSED', HDR.CONFIG_STATUS_CODE,
741: DECODE (SIGN(TRUNC(NVL(REL.ACTIVE_END_DATE, SYSDATE+1)) - TRUNC(SYSDATE)),
742: 1, HDR.CONFIG_STATUS_CODE, 'EXPIRED')) CONFIG_STATUS_CODE
743: FROM AHL_MC_RELATIONSHIPS REL,
744: AHL_MC_HEADERS_B HDR,
745: FND_LOOKUP_VALUES FPRC,
746: FND_LOOKUP_VALUES FPNC,
747: FND_LOOKUP_VALUES FATA

Line 787: FROM AHL_MC_RELATIONSHIPS REL,

783: REL.MC_HEADER_ID,
784: HDR.MC_ID,
785: HDR.VERSION_NUMBER,
786: HDR.CONFIG_STATUS_CODE
787: FROM AHL_MC_RELATIONSHIPS REL,
788: (
789: SELECT MCB.MC_HEADER_ID,
790: MCB.MC_ID,
791: MCB.VERSION_NUMBER,

Line 796: FROM AHL_MC_HEADERS_B MCB, AHL_MC_RELATIONSHIPS MCR

792: DECODE (MCB.CONFIG_STATUS_CODE,
793: 'CLOSED', MCB.CONFIG_STATUS_CODE,
794: DECODE (SIGN(TRUNC(NVL(MCR.ACTIVE_END_DATE, SYSDATE+1)) - TRUNC(SYSDATE)),
795: 1, MCB.CONFIG_STATUS_CODE, 'EXPIRED')) CONFIG_STATUS_CODE
796: FROM AHL_MC_HEADERS_B MCB, AHL_MC_RELATIONSHIPS MCR
797: WHERE MCB.MC_HEADER_ID = MCR.MC_HEADER_ID
798: AND MCR.PARENT_RELATIONSHIP_ID IS NULL
799: ) HDR,
800: FND_LOOKUP_VALUES FPRC,

Line 850: FROM AHL_MC_RELATIONSHIPS REL,

846: REL.MC_HEADER_ID,
847: HDR.MC_ID,
848: HDR.VERSION_NUMBER,
849: HDR.CONFIG_STATUS_CODE
850: FROM AHL_MC_RELATIONSHIPS REL,
851: AHL_MC_HEADERS_V HDR,
852: FND_LOOKUP_VALUES_VL FPRC,
853: FND_LOOKUP_VALUES_VL FPNC,
854: FND_LOOKUP_VALUES_VL FATA

Line 897: FROM AHL_MC_RELATIONSHIPS REL,

893: REL.MC_HEADER_ID,
894: HDR.MC_ID,
895: HDR.VERSION_NUMBER,
896: HDR.CONFIG_STATUS_CODE
897: FROM AHL_MC_RELATIONSHIPS REL,
898: AHL_MC_HEADERS_V HDR,
899: FND_LOOKUP_VALUES_VL FPRC,
900: FND_LOOKUP_VALUES_VL FPNC,
901: FND_LOOKUP_VALUES_VL FATA

Line 939: FROM AHL_MC_RELATIONSHIPS REL,

935: REL.MC_HEADER_ID,
936: HDR.MC_ID,
937: HDR.VERSION_NUMBER,
938: HDR.CONFIG_STATUS_CODE
939: FROM AHL_MC_RELATIONSHIPS REL,
940: AHL_MC_HEADERS_V HDR,
941: FND_LOOKUP_VALUES_VL FPRC,
942: FND_LOOKUP_VALUES_VL FPNC,
943: FND_LOOKUP_VALUES_VL FATA