DBA Data[Home] [Help]

APPS.AHL_PP_MATERIALS_PVT dependencies on CSI_II_RELATIONSHIPS

Line 728: FROM CSI_II_RELATIONSHIPS

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

Line 754: FROM CSI_II_RELATIONSHIPS

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