APPS.AHL_PRD_MRSHL_PVT dependencies on CSI_II_RELATIONSHIPS

Line 168: FROM CSI_II_RELATIONSHIPS

164: SELECT instance_id FROM csi_item_instances WHERE INSTANCE_ID = p_root_instance_id
165: UNION
166: SELECT
167: SUBJECT_ID INSTANCE_ID
168: FROM CSI_II_RELATIONSHIPS
169: WHERE 1=1
170: START WITH OBJECT_ID = p_root_instance_id /*root instance id*/
171: AND RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
172: AND TRUNC(NVL(ACTIVE_START_DATE,SYSDATE)) <= TRUNC(SYSDATE)

Line 597: FROM CSI_II_RELATIONSHIPS

593: SELECT instance_id FROM csi_item_instances WHERE INSTANCE_ID = p_root_instance_id
594: UNION
595: SELECT
596: SUBJECT_ID INSTANCE_ID
597: FROM CSI_II_RELATIONSHIPS
598: WHERE 1=1
599: START WITH OBJECT_ID = p_root_instance_id /*root instance id*/
600: AND RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
601: AND TRUNC(NVL(ACTIVE_START_DATE,SYSDATE)) <= TRUNC(SYSDATE)

Line 930: FROM CSI_II_RELATIONSHIPS

926: SELECT instance_id FROM csi_item_instances WHERE INSTANCE_ID = p_item_instance_id
927: UNION
928: SELECT
929: SUBJECT_ID INSTANCE_ID
930: FROM CSI_II_RELATIONSHIPS
931: WHERE 1=1
932: START WITH OBJECT_ID = p_item_instance_id /*root instance id*/
933: AND RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
934: AND TRUNC(NVL(ACTIVE_START_DATE,SYSDATE)) <= TRUNC(SYSDATE)

Line 970: FROM CSI_II_RELATIONSHIPS

966: FROM csi_item_instances
967: WHERE INSTANCE_ID = p_item_instance_id
968: UNION
969: SELECT SUBJECT_ID INSTANCE_ID
970: FROM CSI_II_RELATIONSHIPS
971: WHERE 1 =1
972: START WITH OBJECT_ID = p_item_instance_id
973: /*root instance id*/
974: AND RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'

Line 1087: FROM CSI_II_RELATIONSHIPS

1083: SELECT instance_id FROM csi_item_instances WHERE INSTANCE_ID = p_item_instance_id
1084: UNION
1085: SELECT
1086: SUBJECT_ID INSTANCE_ID
1087: FROM CSI_II_RELATIONSHIPS
1088: WHERE 1=1
1089: START WITH OBJECT_ID = p_item_instance_id /*root instance id*/
1090: AND RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
1091: AND TRUNC(NVL(ACTIVE_START_DATE,SYSDATE)) <= TRUNC(SYSDATE)

Line 1150: FROM CSI_II_RELATIONSHIPS

1146: SELECT instance_id FROM csi_item_instances WHERE INSTANCE_ID = p_item_instance_id
1147: UNION
1148: SELECT
1149: SUBJECT_ID INSTANCE_ID
1150: FROM CSI_II_RELATIONSHIPS
1151: WHERE 1=1
1152: START WITH OBJECT_ID = p_item_instance_id /*root instance id*/
1153: AND RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
1154: AND TRUNC(NVL(ACTIVE_START_DATE,SYSDATE)) <= TRUNC(SYSDATE)

Line 1230: FROM CSI_II_RELATIONSHIPS

1226: SELECT instance_id FROM csi_item_instances WHERE INSTANCE_ID = p_item_instance_id
1227: UNION
1228: SELECT
1229: SUBJECT_ID INSTANCE_ID
1230: FROM CSI_II_RELATIONSHIPS
1231: WHERE 1=1
1232: START WITH OBJECT_ID = p_item_instance_id /*root instance id*/
1233: AND RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
1234: AND TRUNC(NVL(ACTIVE_START_DATE,SYSDATE)) <= TRUNC(SYSDATE)

Line 1968: FROM CSI_II_RELATIONSHIPS

1964: UNION
1965: SELECT
1966: SUBJECT_ID INSTANCE_ID,
1967: OBJECT_ID PARENT_INSTANCE_ID
1968: FROM CSI_II_RELATIONSHIPS
1969: WHERE 1=1
1970: START WITH OBJECT_ID = p_root_instance_id
1971: AND RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
1972: AND TRUNC(NVL(ACTIVE_START_DATE,SYSDATE)) <= TRUNC(SYSDATE)