APPS.AHL_UMP_UTIL_PKG dependencies on CSI_II_RELATIONSHIPS

Line 27: FROM csi_ii_relationships

23: CURSOR get_unit_name_csr (p_csi_item_instance_id IN NUMBER) IS
24: SELECT name
25: FROM ahl_unit_config_headers uc
26: WHERE csi_item_instance_id in ( SELECT object_id
27: FROM csi_ii_relationships
28: START WITH subject_id = p_csi_item_instance_id
29: AND relationship_type_code = 'COMPONENT-OF'
30: AND trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
31: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))

Line 837: FROM csi_ii_relationships

833: FROM ahl_applicable_mrs
834: WHERE mr_header_id = p_mr_id
835: AND (csi_item_instance_id = p_item_instance_id
836: OR csi_item_instance_id IN (SELECT subject_id
837: FROM csi_ii_relationships
838: START WITH object_id = p_item_instance_id
839: AND relationship_type_code = 'COMPONENT-OF'
840: AND trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
841: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))

Line 852: FROM csi_ii_relationships

848: /* Modified for performance in R12.0. replaced with WITH clause
849: SELECT distinct csi_item_instance_id
850: FROM ahl_applicable_mrs amr,
851: (SELECT subject_id
852: FROM csi_ii_relationships
853: START WITH object_id = p_item_instance_id
854: AND relationship_type_code = 'COMPONENT-OF'
855: AND trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
856: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))

Line 869: FROM csi_ii_relationships

865: AND amr.csi_item_instance_id = cs.subject_id;
866: */
867: /* performance fix.
868: WITH INST AS (SELECT subject_id csi_item_instance_id
869: FROM csi_ii_relationships
870: START WITH object_id = p_item_instance_id
871: AND relationship_type_code = 'COMPONENT-OF'
872: AND trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
873: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))

Line 891: FROM csi_ii_relationships

887: */
888:
889: /* perf tuning: bug# 9434441
890: SELECT subject_id csi_item_instance_id
891: FROM csi_ii_relationships
892: WHERE EXISTS (SELECT 'x'
893: FROM ahl_applicable_mrs AMR
894: WHERE amr.mr_header_id = p_mr_id
895: AND amr.csi_item_instance_id = subject_id)

Line 1405: (select 'Y' from csi_ii_relationships where object_id = ii.subject_id

1401: -- get config elements.
1402: -- added query to get indicator child_exists to fix bug# 13629335
1403: CURSOR get_config_components(p_root_instance_id IN NUMBER) IS
1404: SELECT ii.subject_id, ii.object_id,
1405: (select 'Y' from csi_ii_relationships where object_id = ii.subject_id
1406: and relationship_type_code = 'COMPONENT-OF'
1407: and trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
1408: and trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
1409: and rownum = 1) child_exists

Line 1410: FROM csi_ii_relationships ii

1406: and relationship_type_code = 'COMPONENT-OF'
1407: and trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
1408: and trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
1409: and rownum = 1) child_exists
1410: FROM csi_ii_relationships ii
1411: START WITH ii.object_id = p_root_instance_id
1412: AND ii.relationship_type_code = 'COMPONENT-OF'
1413: AND trunc(nvl(ii.active_start_date,sysdate)) <= trunc(sysdate)
1414: AND trunc(sysdate) < trunc(nvl(ii.active_end_date, sysdate+1))