724: WHERE
725: AMH.MC_HEADER_ID = AUCH.MASTER_CONFIG_ID AND
726: AUCH.CSI_ITEM_INSTANCE_ID IN (
727: SELECT SUBJECT_ID /* INSTANCE_ID OF ALL CHILD NODES (INCLUDING RECURSIVE NODES FROM SUB-CONFIG.) */
728: FROM CSI_II_RELATIONSHIPS
729: WHERE NVL(ACTIVE_END_DATE,SYSDATE + 1) > SYSDATE
730: START WITH OBJECT_ID IN
731: (SELECT CSI_ITEM_INSTANCE_ID /*PARENT NODE INSTANCEID */
732: FROM AHL_UNIT_CONFIG_HEADERS
750: WHERE
751: AMH.MC_HEADER_ID = AUCH.MASTER_CONFIG_ID AND
752: AUCH.CSI_ITEM_INSTANCE_ID IN (
753: SELECT SUBJECT_ID /* INSTANCE_ID OF ALL CHILD NODES (INCLUDING RECURSIVE NODES FROM SUB-CONFIG.) */
754: FROM CSI_II_RELATIONSHIPS
755: WHERE NVL(ACTIVE_END_DATE,SYSDATE + 1) > SYSDATE
756: START WITH OBJECT_ID IN
757: (SELECT CSI_ITEM_INSTANCE_ID /*PARENT NODE INSTANCEID */
758: FROM AHL_UNIT_CONFIG_HEADERS