[Home] [Help]
1289: CONNECT BY E.subject_id = PRIOR E.object_id
1290: AND E.relationship_type_code = 'COMPONENT-OF'
1291: union all
1292: select c_instance_id
1293: from dual) ii
1294: where itm.association_type_flag = 'I'
1295: and itm.unit_item_id = csi.inventory_item_id
1296: and csi.instance_id = ii.object_id
1297: UNION ALL
1304: CONNECT BY E.subject_id = PRIOR E.object_id
1305: AND E.relationship_type_code = 'COMPONENT-OF'
1306: union
1307: select c_instance_id
1308: from dual) ii
1309: where unit.association_type_flag = 'U'
1310: and unit.unit_item_id = uc.unit_config_header_id
1311: and uc.csi_item_instance_id = ii.object_id)
1312: CONNECT BY B.pc_node_id = PRIOR B.parent_node_id;
1330: AND SYSDATE between trunc(nvl(E.active_start_date,sysdate)) and trunc(nvl(E.active_end_date,sysdate+1))
1331: AND E.relationship_type_code = 'COMPONENT-OF'
1332: UNION ALL
1333: SELECT c_instance_id
1334: FROM DUAL)
1335: SELECT 'x' --pc_node_id --amsriniv
1336: FROM ahl_pc_nodes_b B
1337: WHERE B.pc_node_id = c_pc_node_id
1338: START WITH B.pc_node_id IN (select pc_node_id
1366: START WITH E.subject_id = c_instance_id
1367: CONNECT BY E.subject_id = PRIOR E.object_id
1368: UNION ALL
1369: SELECT c_instance_id
1370: FROM DUAL) ii
1371: where itm.association_type_flag = 'I'
1372: and itm.unit_item_id = csi.inventory_item_id
1373: and csi.instance_id = ii.object_id)
1374: CONNECT BY B.pc_node_id = PRIOR B.parent_node_id;
1388: START WITH E.subject_id = c_instance_id
1389: CONNECT BY E.subject_id = PRIOR E.object_id
1390: UNION ALL
1391: SELECT c_instance_id
1392: FROM DUAL) ii
1393: where unit.association_type_flag = 'U'
1394: and unit.unit_item_id = uc.unit_config_header_id
1395: and uc.csi_item_instance_id = ii.object_id)
1396: CONNECT BY B.pc_node_id = PRIOR B.parent_node_id;
2045:
2046:
2047: -- check for path position based effectivities.
2048: CURSOR relationship_csr IS
2049: SELECT 'x' from dual
2050: WHERE exists (select 'x'
2051: from ahl_mr_effectivities mre, ahl_mr_headers_b mr
2052: where mre.relationship_id is not null
2053: and mre.mr_header_id = mr.mr_header_id
2068:
2069:
2070: -- check for path position based effectivities for visit type
2071: CURSOR relationship_vtype_csr(p_visit_type_code IN VARCHAR2) IS
2072: SELECT 'x' from dual
2073: WHERE exists (select 'x'
2074: from ahl_mr_effectivities mre, ahl_mr_visit_types vis, ahl_mr_headers_b mr
2075: where vis.mr_visit_type_code = p_visit_type_code
2076: and mre.mr_header_id = vis.mr_header_id
2092: );
2093:
2094: -- check for path position based effectivities for MR
2095: CURSOR relationship_mr_csr(p_mr_header_id IN NUMBER) IS
2096: SELECT 'x' from dual
2097: WHERE exists (select 'x'
2098: from ahl_mr_effectivities
2099: where mr_header_id = p_mr_header_id
2100: and relationship_id is not null);
2232:
2233: -- added to fix perf bug# 9434441
2234: CURSOR appl_inst_exists_csr IS
2235: SELECT 'x'
2236: FROM dual
2237: WHERE EXISTS (select 'x' from ahl_applicable_instances);
2238:
2239: l_appl_inst_exists_flag BOOLEAN;
2240:
4360: CONNECT BY E.subject_id = PRIOR E.object_id
4361: AND SYSDATE between trunc(nvl(E.active_start_date,sysdate)) and trunc(nvl(E.active_end_date,sysdate+1))
4362: UNION ALL
4363: SELECT c_instance_id
4364: FROM DUAL) ii
4365: where itm.association_type_flag = 'I'
4366: and itm.unit_item_id = csi.inventory_item_id
4367: and csi.instance_id = ii.object_id)
4368: CONNECT BY B.pc_node_id = PRIOR B.parent_node_id;
4384: CONNECT BY E.subject_id = PRIOR E.object_id
4385: AND SYSDATE between trunc(nvl(E.active_start_date,sysdate)) and trunc(nvl(E.active_end_date,sysdate+1))
4386: UNION ALL
4387: SELECT c_instance_id
4388: FROM DUAL) ii
4389: where unit.association_type_flag = 'U'
4390: and unit.unit_item_id = uc.unit_config_header_id
4391: and uc.csi_item_instance_id = ii.object_id)
4392: CONNECT BY B.pc_node_id = PRIOR B.parent_node_id;
4555: START WITH E.subject_id = c_instance_id
4556: CONNECT BY E.subject_id = PRIOR E.object_id
4557: UNION ALL
4558: SELECT c_instance_id
4559: FROM DUAL) ii
4560: where itm.association_type_flag = 'I'
4561: and itm.unit_item_id = csi.inventory_item_id
4562: and csi.instance_id = ii.object_id)
4563: CONNECT BY B.pc_node_id = PRIOR B.parent_node_id;
4576: START WITH E.subject_id = c_instance_id
4577: CONNECT BY E.subject_id = PRIOR E.object_id
4578: UNION ALL
4579: SELECT c_instance_id
4580: FROM DUAL) ii
4581: where unit.association_type_flag = 'U'
4582: and unit.unit_item_id = uc.unit_config_header_id
4583: and uc.csi_item_instance_id = ii.object_id)
4584: CONNECT BY B.pc_node_id = PRIOR B.parent_node_id;
4678: ORDER BY A.mr_effectivity_id, A.mr_header_id;
4679:
4680: -- check for path position based effectivities for MR
4681: CURSOR relationship_mr_csr(p_mr_header_id IN NUMBER) IS
4682: SELECT 'x' from dual
4683: WHERE exists (select 'x'
4684: from ahl_mr_effectivities
4685: where mr_header_id = p_mr_header_id
4686: and relationship_id is not null);
4777:
4778: -- added to fix perf bug# 9434441
4779: CURSOR appl_inst_exists_csr IS
4780: SELECT 'x'
4781: FROM dual
4782: WHERE EXISTS (select 'x' from ahl_applicable_instances);
4783:
4784: l_appl_inst_exists_flag BOOLEAN;
4785: