[Home] [Help]
1100: CONNECT BY E.subject_id = PRIOR E.object_id
1101: AND E.relationship_type_code = 'COMPONENT-OF'
1102: union all
1103: select c_instance_id
1104: from dual) ii
1105: where itm.association_type_flag = 'I'
1106: and itm.unit_item_id = csi.inventory_item_id
1107: and csi.instance_id = ii.object_id
1108: UNION ALL
1115: CONNECT BY E.subject_id = PRIOR E.object_id
1116: AND E.relationship_type_code = 'COMPONENT-OF'
1117: union
1118: select c_instance_id
1119: from dual) ii
1120: where unit.association_type_flag = 'U'
1121: and unit.unit_item_id = uc.unit_config_header_id
1122: and uc.csi_item_instance_id = ii.object_id)
1123: CONNECT BY B.pc_node_id = PRIOR B.parent_node_id;
1140: AND SYSDATE between trunc(nvl(E.active_start_date,sysdate)) and trunc(nvl(E.active_end_date,sysdate+1))
1141: AND E.relationship_type_code = 'COMPONENT-OF'
1142: UNION ALL
1143: SELECT c_instance_id
1144: FROM DUAL)
1145: SELECT 'x' --pc_node_id --amsriniv
1146: FROM ahl_pc_nodes_b B
1147: WHERE B.pc_node_id = c_pc_node_id
1148: START WITH B.pc_node_id IN (select pc_node_id
1647:
1648:
1649: -- check for path position based effectivities.
1650: CURSOR relationship_csr IS
1651: SELECT 'x' from dual
1652: WHERE exists (select 'x'
1653: from ahl_mr_effectivities mre
1654: where mre.relationship_id is not null
1655: and exists (SELECT 'x' from ahl_mr_headers_app_v MR
1667:
1668:
1669: -- check for path position based effectivities for visit type
1670: CURSOR relationship_vtype_csr(p_visit_type_code IN VARCHAR2) IS
1671: SELECT 'x' from dual
1672: WHERE exists (select 'x'
1673: from ahl_mr_effectivities mre, ahl_mr_visit_types vis
1674: where vis.mr_visit_type_code = p_visit_type_code
1675: and mre.mr_header_id = vis.mr_header_id
1688: );
1689:
1690: -- check for path position based effectivities for MR
1691: CURSOR relationship_mr_csr(p_mr_header_id IN NUMBER) IS
1692: SELECT 'x' from dual
1693: WHERE exists (select 'x'
1694: from ahl_mr_effectivities
1695: where mr_header_id = p_mr_header_id
1696: and relationship_id is not null);