APPS.AHL_PRD_MRSHL_PVT dependencies on CSI_II_RELATIONSHIPS

Line 156: FROM CSI_II_RELATIONSHIPS

152: SELECT instance_id FROM csi_item_instances WHERE INSTANCE_ID = p_root_instance_id
153: UNION
154: SELECT
155: SUBJECT_ID INSTANCE_ID
156: FROM CSI_II_RELATIONSHIPS
157: WHERE 1=1
158: START WITH OBJECT_ID = p_root_instance_id /*root instance id*/
159: AND RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
160: AND TRUNC(NVL(ACTIVE_START_DATE,SYSDATE)) <= TRUNC(SYSDATE)

Line 593: FROM CSI_II_RELATIONSHIPS

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

Line 928: FROM CSI_II_RELATIONSHIPS

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

Line 967: FROM CSI_II_RELATIONSHIPS

963: SELECT instance_id FROM csi_item_instances WHERE INSTANCE_ID = p_item_instance_id
964: UNION
965: SELECT
966: SUBJECT_ID INSTANCE_ID
967: FROM CSI_II_RELATIONSHIPS
968: WHERE 1=1
969: START WITH OBJECT_ID = p_item_instance_id /*root instance id*/
970: AND RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
971: AND TRUNC(NVL(ACTIVE_START_DATE,SYSDATE)) <= TRUNC(SYSDATE)

Line 1084: FROM CSI_II_RELATIONSHIPS

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

Line 1147: FROM CSI_II_RELATIONSHIPS

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

Line 1227: FROM CSI_II_RELATIONSHIPS

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

Line 1936: FROM CSI_II_RELATIONSHIPS

1932: UNION
1933: SELECT
1934: SUBJECT_ID INSTANCE_ID,
1935: OBJECT_ID PARENT_INSTANCE_ID
1936: FROM CSI_II_RELATIONSHIPS
1937: WHERE 1=1
1938: START WITH OBJECT_ID = p_root_instance_id
1939: AND RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
1940: AND TRUNC(NVL(ACTIVE_START_DATE,SYSDATE)) <= TRUNC(SYSDATE)