APPS.AHL_UMP_UTIL_PKG dependencies on CSI_II_RELATIONSHIPS

Line 18: FROM csi_ii_relationships

14: CURSOR get_unit_name_csr (p_csi_item_instance_id IN NUMBER) IS
15: SELECT name
16: FROM ahl_unit_config_headers uc
17: WHERE csi_item_instance_id in ( SELECT object_id
18: FROM csi_ii_relationships
19: START WITH subject_id = p_csi_item_instance_id
20: AND relationship_type_code = 'COMPONENT-OF'
21: AND trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
22: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))

Line 665: FROM csi_ii_relationships

661: FROM ahl_applicable_mrs
662: WHERE mr_header_id = p_mr_id
663: AND (csi_item_instance_id = p_item_instance_id
664: OR csi_item_instance_id IN (SELECT subject_id
665: FROM csi_ii_relationships
666: START WITH object_id = p_item_instance_id
667: AND relationship_type_code = 'COMPONENT-OF'
668: AND trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
669: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))

Line 680: FROM csi_ii_relationships

676: /* Modified for performance in R12.0. replaced with WITH clause
677: SELECT distinct csi_item_instance_id
678: FROM ahl_applicable_mrs amr,
679: (SELECT subject_id
680: FROM csi_ii_relationships
681: START WITH object_id = p_item_instance_id
682: AND relationship_type_code = 'COMPONENT-OF'
683: AND trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
684: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))

Line 697: FROM csi_ii_relationships

693: AND amr.csi_item_instance_id = cs.subject_id;
694: */
695: /* performance fix.
696: WITH INST AS (SELECT subject_id csi_item_instance_id
697: FROM csi_ii_relationships
698: START WITH object_id = p_item_instance_id
699: AND relationship_type_code = 'COMPONENT-OF'
700: AND trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
701: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))

Line 718: FROM csi_ii_relationships

714: AND amr.csi_item_instance_id = inst.csi_item_instance_id);
715: */
716:
717: SELECT subject_id csi_item_instance_id
718: FROM csi_ii_relationships
719: WHERE EXISTS (SELECT 'x'
720: FROM ahl_applicable_mrs AMR
721: WHERE amr.mr_header_id = p_mr_id
722: AND amr.csi_item_instance_id = subject_id)