eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_FMP_PVT dependencies on CSI_II_RELATIONSHIPS

Line 177: FROM csi_ii_relationships B

173: SELECT unit_config_header_id, name
174: FROM ahl_unit_config_headers A
175: WHERE csi_item_instance_id = c_instance_id
176: OR EXISTS (SELECT 'X'
177: FROM csi_ii_relationships B
178: WHERE B.object_id = A.csi_item_instance_id
179: START WITH subject_id = c_instance_id
180: CONNECT BY subject_id = PRIOR object_id);
181: l_get_uc_header get_uc_header%ROWTYPE;

Line 191: FROM csi_ii_relationships B

187: FROM csi_item_instances A
188: WHERE inventory_item_id = c_inventory_item_id
189: AND SYSDATE between trunc(nvl(A.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
190: AND NOT EXISTS (SELECT 'X'
191: FROM csi_ii_relationships B
192: WHERE B.subject_id = A.instance_id
193: AND relationship_type_code = 'COMPONENT-OF'
194: AND SYSDATE between trunc(nvl(B.active_start_date,sysdate)) and trunc(NVL(b.active_end_date,sysdate+1))
195: );*/

Line 216: FROM csi_ii_relationships

212: and a.master_config_id=b.position_id
213: AND b.position_id=c_relationship_id
214: and SYSDATE between trunc(nvl(A.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
215: and not exists (SELECT 'X'
216: FROM csi_ii_relationships
217: WHERE subject_id=b.csi_item_instance_id
218: AND relationship_type_code='COMPONENT_OF');*/
219:
220:

Line 231: FROM csi_ii_relationships a,ahl_applicable_instances b

227: and b.position_id= c_relationship_id
228: AND SYSDATE between trunc(nvl(A.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
229: UNION
230: SELECT a.subject_id instance_id
231: FROM csi_ii_relationships a,ahl_applicable_instances b
232: WHERE a.subject_id=b.csi_item_instance_id
233: and b.position_id=c_relationship_id
234: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
235: AND a.relationship_type_code = 'COMPONENT-OF';

Line 273: FROM csi_ii_relationships A,ahl_applicable_instances api

269: and trunc(nvl(b.active_end_date,sysdate+1))
270: AND inventory_item_id = c_inventory_item_id)
271: UNION
272: SELECT subject_id instance_id
273: FROM csi_ii_relationships A,ahl_applicable_instances api
274: WHERE api.position_id=c_relationship_id
275: and api.csi_item_instance_id=a.subject_id
276: AND relationship_type_code = 'COMPONENT-OF'
277: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate))

Line 312: FROM csi_ii_relationships B

308: WHERE A.inventory_item_id = c_inventory_item_id
309: AND sysdate between trunc(nvl(a.active_start_date,sysdate))
310: and trunc(nvl(a.active_end_date,sysdate+1))
311: AND NOT EXISTS (SELECT 'X'
312: FROM csi_ii_relationships B
313: WHERE B.subject_id = A.instance_id
314: AND sysdate between trunc(nvl(b.active_start_date,sysdate)) and trunc(nvl(b.active_end_date,sysdate+1))
315: AND B.relationship_type_code = 'COMPONENT-OF')
316: AND EXISTS (SELECT 'X'

Line 352: FROM csi_ii_relationships B

348: WHERE A.inventory_item_id = c_inventory_item_id
349: AND sysdate between trunc(nvl(a.active_start_date,sysdate))
350: and trunc(nvl(a.active_end_date,sysdate+1))
351: AND NOT EXISTS (SELECT 'X'
352: FROM csi_ii_relationships B
353: WHERE B.subject_id = A.instance_id
354: AND sysdate between trunc(nvl(b.active_start_date,sysdate)) and trunc(nvl(b.active_end_date,sysdate+1))
355: AND B.relationship_type_code = 'COMPONENT-OF')
356: AND EXISTS (SELECT 'X'

Line 386: FROM csi_ii_relationships A

382: START WITH D.pc_node_id = c_pc_node_id
383: CONNECT BY D.parent_node_id = PRIOR D.pc_node_id))
384: UNION
385: SELECT a.subject_id instance_id
386: FROM csi_ii_relationships A
387: WHERE relationship_type_code = 'COMPONENT-OF'
388: AND sysdate between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
389: AND A.SUBJECT_id IN (SELECT csi_item_instance_id from ahl_applicable_instances
390: where csi_item_instance_id=a.subject_id )

Line 427: FROM csi_ii_relationships A

423: START WITH C.pc_node_id = c_pc_node_id
424: CONNECT BY C.parent_node_id= PRIOR C.pc_node_id))
425: UNION
426: SELECT A.subject_id instance_id
427: FROM csi_ii_relationships A
428: WHERE relationship_type_code = 'COMPONENT-OF'
429: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
430: AND EXISTS (SELECT 'X'
431: FROM csi_item_instances B

Line 508: FROM csi_ii_relationships a

504: START WITH C.pc_node_id = c_pc_node_id
505: CONNECT BY C.parent_node_id= PRIOR C.pc_node_id))
506: UNION
507: SELECT a.subject_id instance_id
508: FROM csi_ii_relationships a
509: WHERE relationship_type_code = 'COMPONENT-OF'
510: AND subject_id in (Select csi_item_instance_id from ahl_applicable_instances)
511: AND sysdate between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
512: START WITH object_id IN (SELECT csi_item_instance_id

Line 551: FROM csi_ii_relationships a

547: START WITH D.pc_node_id = c_pc_node_id
548: CONNECT BY D.parent_node_id= PRIOR D.pc_node_id)))
549: UNION
550: SELECT a.subject_id instance_id
551: FROM csi_ii_relationships a
552: WHERE a.relationship_type_code = 'COMPONENT-OF'
553: AND subject_id in (Select csi_item_instance_id from ahl_applicable_instances)
554: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
555: AND subject_id in (select csi_item_instance_id from ahl_applicable_instances)

Line 642: FROM csi_ii_relationships A

638: START WITH D.pc_node_id = c_pc_node_id
639: CONNECT BY D.parent_node_id= PRIOR D.pc_node_id))
640: UNION
641: SELECT a.subject_id instance_id
642: FROM csi_ii_relationships A
643: WHERE relationship_type_code = 'COMPONENT-OF'
644: AND a.relationship_id in (Select position_id from AHL_APPLICABLE_INSTANCES)
645: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
646: AND EXISTS (SELECT 'X'

Line 690: FROM csi_ii_relationships A

686: START WITH D.pc_node_id = c_pc_node_id
687: CONNECT BY D.parent_node_id= PRIOR D.pc_node_id)))
688: UNION
689: SELECT subject_id instance_id
690: FROM csi_ii_relationships A
691: WHERE relationship_type_code = 'COMPONENT-OF'
692: AND a.subject_id in (Select csi_item_instance_id from AHL_APPLICABLE_INSTANCES )
693: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
694: AND EXISTS (SELECT 'X'

Line 1286: FROM csi_ii_relationships E

1282: --WHERE B.pc_node_id = c_pc_node_id
1283: START WITH B.pc_node_id IN (select pc_node_id
1284: from ahl_pc_associations itm, csi_item_instances csi,
1285: (SELECT object_id
1286: FROM csi_ii_relationships E
1287: START WITH E.subject_id = c_instance_id
1288: AND E.relationship_type_code = 'COMPONENT-OF'
1289: CONNECT BY E.subject_id = PRIOR E.object_id
1290: AND E.relationship_type_code = 'COMPONENT-OF'

Line 1301: FROM csi_ii_relationships E

1297: UNION ALL
1298: select pc_node_id
1299: from ahl_pc_associations unit, ahl_unit_config_headers uc,
1300: (SELECT object_id
1301: FROM csi_ii_relationships E
1302: START WITH E.subject_id = c_instance_id
1303: AND E.relationship_type_code = 'COMPONENT-OF'
1304: CONNECT BY E.subject_id = PRIOR E.object_id
1305: AND E.relationship_type_code = 'COMPONENT-OF'

Line 1323: FROM csi_ii_relationships E

1319: CURSOR validate_pc_node_csr (c_instance_id NUMBER,
1320: c_pc_node_id NUMBER)
1321: IS
1322: WITH ii AS (SELECT object_id
1323: FROM csi_ii_relationships E
1324: START WITH E.subject_id = c_instance_id
1325: -- sunil- fix for bug7411016
1326: AND SYSDATE between trunc(nvl(E.active_start_date,sysdate)) and trunc(nvl(E.active_end_date,sysdate+1))
1327: AND E.relationship_type_code = 'COMPONENT-OF'

Line 1438: FROM csi_ii_relationships root

1434: /* not used
1435: -- Added for performance bug - 6138653
1436: CURSOR csi_root_instance_csr (p_instance_id IN NUMBER) IS
1437: SELECT root.object_id
1438: FROM csi_ii_relationships root
1439: WHERE NOT EXISTS (SELECT 'x'
1440: FROM csi_ii_relationships
1441: WHERE subject_id = root.object_id
1442: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))

Line 1440: FROM csi_ii_relationships

1436: CURSOR csi_root_instance_csr (p_instance_id IN NUMBER) IS
1437: SELECT root.object_id
1438: FROM csi_ii_relationships root
1439: WHERE NOT EXISTS (SELECT 'x'
1440: FROM csi_ii_relationships
1441: WHERE subject_id = root.object_id
1442: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
1443: )
1444: START WITH root.subject_id = p_instance_id

Line 1465: from csi_item_instances cii2, csi_ii_relationships cir2, ahl_unit_config_headers uc

1461: (select cir2.object_id,
1462: cii2.instance_id subject_id,
1463: nvl(uc.master_config_id, cir2.position_reference) position_reference,
1464: 0 depth
1465: from csi_item_instances cii2, csi_ii_relationships cir2, ahl_unit_config_headers uc
1466: where cii2.instance_id = c_instance_id
1467: and cii2.instance_id = cir2.subject_id(+)
1468: and cii2.instance_id = uc.csi_item_instance_id(+)
1469: and uc.parent_uc_header_id(+) is null

Line 1475: FROM csi_ii_relationships a

1471: UNION ALL
1472: SELECT a.object_id,
1473: a.subject_id,
1474: to_number(a.position_reference), level depth
1475: FROM csi_ii_relationships a
1476: WHERE c_components_flag = 'Y'
1477: START WITH object_id = c_instance_id
1478: AND relationship_type_code = 'COMPONENT-OF'
1479: AND SYSDATE between trunc(nvl(active_start_date,sysdate)) and trunc(NVL(active_end_date,sysdate+1))

Line 1504: from csi_item_instances cii2 --, csi_ii_relationships cir2, ahl_unit_config_headers uc

1500: cii2.instance_id subject_id,
1501: --nvl(uc.master_config_id, cir2.position_reference) position_reference,
1502: 0 depth,
1503: cii2.inventory_item_id
1504: from csi_item_instances cii2 --, csi_ii_relationships cir2, ahl_unit_config_headers uc
1505: where cii2.instance_id = c_instance_id
1506: --and cii2.instance_id = cir2.subject_id(+)
1507: --and cii2.instance_id = uc.csi_item_instance_id(+)
1508: --and uc.parent_uc_header_id(+) is null

Line 1519: FROM csi_ii_relationships a

1515: level depth,
1516: (select inventory_item_id
1517: from csi_item_instances
1518: where instance_id = a.subject_id) inventory_item_id
1519: FROM csi_ii_relationships a
1520: WHERE c_components_flag = 'Y'
1521: START WITH object_id = c_instance_id
1522: AND relationship_type_code = 'COMPONENT-OF'
1523: AND SYSDATE between trunc(nvl(active_start_date,sysdate))

Line 1592: -- replaced csi_ii_relationships with ahl_config_components to fix bug# 9434441

1588: ORDER BY appl_mr.depth, appl_mr.subject_id; -- depth, subject_id
1589: */
1590:
1591: -- for the configuration components, get valid mr effectivities based on inventory items.
1592: -- replaced csi_ii_relationships with ahl_config_components to fix bug# 9434441
1593: -- performance fix for bug# 13629335: split cursor to do away with nvl(c_mr_header_id, A.mr_header_id)
1594: -- and removed one level of inner query
1595: CURSOR get_comp_mr_inv_csr(c_instance_id IN NUMBER, c_appln_usg_code IN VARCHAR2) IS
1596: SELECT A.mr_header_id, A.mr_effectivity_id,

Line 1607: --FROM csi_ii_relationships a

1603: AND ciea1.attribute_level = 'GLOBAL') mfg_date,
1604: ii.serial_number --,
1605: --(SELECT 'Y' from ahl_mr_effectivity_dtls where mr_effectivity_id = a.mr_effectivity_id and ROWNUM < 2) eff_dtls_flag
1606: FROM ( SELECT a.subject_id
1607: --FROM csi_ii_relationships a
1608: FROM ahl_config_components a
1609: START WITH object_id = c_instance_id
1610: --AND relationship_type_code = 'COMPONENT-OF'
1611: --AND SYSDATE between trunc(nvl(active_start_date,sysdate))

Line 1834: from csi_item_instances cii2, csi_ii_relationships cir2, ahl_unit_config_headers uc

1830: (select cir2.object_id,
1831: cii2.instance_id subject_id,
1832: nvl(uc.master_config_id, cir2.position_reference) position_reference,
1833: 0 depth
1834: from csi_item_instances cii2, csi_ii_relationships cir2, ahl_unit_config_headers uc
1835: where cii2.instance_id = c_instance_id
1836: and cii2.instance_id = cir2.subject_id(+)
1837: and cii2.instance_id = uc.csi_item_instance_id(+)
1838: and uc.parent_uc_header_id(+) is null

Line 1863: from csi_item_instances cii2 --, csi_ii_relationships cir2, ahl_unit_config_headers uc

1859: cii2.instance_id subject_id,
1860: --nvl(uc.master_config_id, cir2.position_reference) position_reference,
1861: 0 depth,
1862: cii2.inventory_item_id
1863: from csi_item_instances cii2 --, csi_ii_relationships cir2, ahl_unit_config_headers uc
1864: where cii2.instance_id = c_instance_id
1865: --and cii2.instance_id = cir2.subject_id(+)
1866: --and cii2.instance_id = uc.csi_item_instance_id(+)
1867: --and uc.parent_uc_header_id(+) is null

Line 1935: -- replaced csi_ii_relationships with ahl_config_components to fix bug# 9434441

1931: ORDER BY appl_mr.depth, appl_mr.subject_id; -- depth, subject_id
1932: */
1933:
1934: -- for the configuration components, get valid mr effectivities based on inventory items.
1935: -- replaced csi_ii_relationships with ahl_config_components to fix bug# 9434441
1936: CURSOR get_comp_vst_inv_csr(c_instance_id NUMBER, c_visit_type_code VARCHAR2) IS
1937: SELECT A.mr_header_id, A.mr_effectivity_id,
1938: A.pc_node_id,
1939: -- JKJain, NR Analysis and Forecasting

Line 1948: --FROM csi_ii_relationships a

1944: AND ciea1.attribute_level = 'GLOBAL') mfg_date,
1945: cii.serial_number --,
1946: --(SELECT 'Y' from ahl_mr_effectivity_dtls where mr_effectivity_id = a.mr_effectivity_id and ROWNUM < 2) eff_dtls_flag
1947: FROM ( SELECT a.subject_id
1948: --FROM csi_ii_relationships a
1949: FROM ahl_config_components a
1950: START WITH object_id = c_instance_id
1951: --AND relationship_type_code = 'COMPONENT-OF'
1952: --AND SYSDATE between trunc(nvl(active_start_date,sysdate))

Line 2163: FROM csi_ii_relationships

2159:
2160: -- to get configuration nodes.
2161: CURSOR get_config_tree_csr ( p_csi_instance_id IN NUMBER) IS
2162: SELECT subject_id
2163: FROM csi_ii_relationships
2164: START WITH object_id = p_csi_instance_id
2165: AND relationship_type_code = 'COMPONENT-OF'
2166: AND trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
2167: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))

Line 3074: FROM csi_ii_relationships

3070: CURSOR get_unit_name_com (p_item_instance_id IN NUMBER) IS
3071: SELECT unit_config_header_id, name
3072: FROM ahl_unit_config_headers
3073: WHERE csi_item_instance_id IN ( SELECT object_id
3074: FROM csi_ii_relationships
3075: START WITH subject_id = p_item_instance_id
3076: AND relationship_type_code = 'COMPONENT-OF'
3077: AND sysdate between trunc(nvl(active_start_date,sysdate))
3078: AND trunc(nvl(active_end_date, SYSDATE+1))

Line 3130: FROM csi_ii_relationships

3126: CURSOR get_instance_top (p_item_instance_id IN NUMBER) IS
3127: SELECT A.instance_id
3128: FROM csi_item_instances A
3129: WHERE A.instance_id IN ( SELECT object_id
3130: FROM csi_ii_relationships
3131: START WITH subject_id = p_item_instance_id
3132: AND relationship_type_code = 'COMPONENT-OF'
3133: AND sysdate between trunc(nvl(active_start_date,sysdate))
3134: AND trunc(nvl(active_end_date, SYSDATE+1))

Line 3143: FROM csi_ii_relationships B

3139: )
3140: AND sysdate between trunc(nvl(active_start_date,sysdate))
3141: AND trunc(nvl(active_end_date, SYSDATE+1))
3142: AND NOT EXISTS (SELECT 'X'
3143: FROM csi_ii_relationships B
3144: WHERE B.subject_id = A.instance_id
3145: AND relationship_type_code = 'COMPONENT-OF'
3146: AND SYSDATE between trunc(nvl(B.active_start_date,sysdate)) and trunc(NVL(b.active_end_date,sysdate+1))
3147: );

Line 3269: FROM ahl_mc_headers_b hdr, ahl_mc_relationships rel, csi_ii_relationships csi_ii

3265:
3266: --Fetches lowest level info
3267: CURSOR get_last_uc_rec_csr(c_csi_instance_id IN NUMBER) IS
3268: SELECT hdr.mc_id, hdr.version_number, rel.position_key
3269: FROM ahl_mc_headers_b hdr, ahl_mc_relationships rel, csi_ii_relationships csi_ii
3270: WHERE csi_ii.subject_id = c_csi_instance_id
3271: AND CSI_II.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
3272: AND TRUNC(nvl(CSI_II.ACTIVE_START_DATE, sysdate)) <= TRUNC(sysdate)
3273: AND TRUNC(nvl(CSI_II.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)

Line 3280: FROM csi_ii_relationships csi

3276:
3277: --Traverse up and fetch all unit instance ids
3278: CURSOR get_unit_instance_csr(c_csi_instance_id IN NUMBER) IS
3279: SELECT csi.object_id
3280: FROM csi_ii_relationships csi
3281: WHERE csi.object_id IN
3282: (SELECT csi_item_instance_id
3283: FROM ahl_unit_config_headers
3284: WHERE trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)

Line 3312: AND NOT EXISTS (SELECT 'X' FROM CSI_II_RELATIONSHIPS CIR

3308: AND TRUNC(nvl(uch.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)
3309: AND hdr.mc_header_id = uch.master_config_id
3310: AND rel.mc_header_id = hdr.mc_header_id
3311: AND rel.parent_relationship_id IS NULL
3312: AND NOT EXISTS (SELECT 'X' FROM CSI_II_RELATIONSHIPS CIR
3313: WHERE CIR.SUBJECT_ID = uch.csi_item_instance_id
3314: AND CIR.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
3315: AND TRUNC(nvl(CIR.ACTIVE_START_DATE, sysdate)) <= TRUNC(sysdate)
3316: AND TRUNC(nvl(CIR.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate));

Line 4357: FROM csi_ii_relationships E

4353: WHERE B.pc_node_id = c_pc_node_id
4354: START WITH B.pc_node_id IN (select /*+ UNNEST */ pc_node_id
4355: from ahl_pc_associations itm, csi_item_instances csi,
4356: (select /*+ INDEX(E) */ object_id
4357: FROM csi_ii_relationships E
4358: START WITH E.subject_id = c_instance_id
4359: AND SYSDATE between trunc(nvl(E.active_start_date,sysdate)) and trunc(nvl(E.active_end_date,sysdate+1))
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))

Line 4381: FROM csi_ii_relationships E

4377: WHERE B.pc_node_id = c_pc_node_id
4378: START WITH B.pc_node_id IN (select /*+ UNNEST */ pc_node_id
4379: from ahl_pc_associations unit, ahl_unit_config_headers uc,
4380: (select /*+ INDEX(E) */ object_id
4381: FROM csi_ii_relationships E
4382: START WITH E.subject_id = c_instance_id
4383: AND SYSDATE between trunc(nvl(E.active_start_date,sysdate)) and trunc(nvl(E.active_end_date,sysdate+1))
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))

Line 4440: (select 'Y' from csi_ii_relationships where object_id = cir.subject_id

4436: -- get config elements.
4437: -- added subj_child_exists to fix BUE perf bug# 13629335
4438: CURSOR get_config_components(p_root_instance_id IN NUMBER) IS
4439: SELECT cir.subject_id, cir.object_id,
4440: (select 'Y' from csi_ii_relationships where object_id = cir.subject_id
4441: and relationship_type_code = 'COMPONENT-OF'
4442: and trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
4443: and trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
4444: and rownum = 1) subj_child_exists

Line 4445: FROM csi_ii_relationships cir

4441: and relationship_type_code = 'COMPONENT-OF'
4442: and trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
4443: and trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
4444: and rownum = 1) subj_child_exists
4445: FROM csi_ii_relationships cir
4446: START WITH cir.object_id = p_root_instance_id
4447: AND cir.relationship_type_code = 'COMPONENT-OF'
4448: AND trunc(nvl(cir.active_start_date,sysdate)) <= trunc(sysdate)
4449: AND trunc(sysdate) < trunc(nvl(cir.active_end_date, sysdate+1))

Line 4458: FROM csi_ii_relationships root

4454:
4455: -- get root instance
4456: CURSOR csi_root_instance_csr (p_instance_id IN NUMBER) IS
4457: SELECT root.object_id
4458: FROM csi_ii_relationships root
4459: WHERE NOT EXISTS (SELECT 'x'
4460: FROM csi_ii_relationships
4461: WHERE subject_id = root.object_id
4462: AND relationship_type_code = 'COMPONENT-OF'

Line 4460: FROM csi_ii_relationships

4456: CURSOR csi_root_instance_csr (p_instance_id IN NUMBER) IS
4457: SELECT root.object_id
4458: FROM csi_ii_relationships root
4459: WHERE NOT EXISTS (SELECT 'x'
4460: FROM csi_ii_relationships
4461: WHERE subject_id = root.object_id
4462: AND relationship_type_code = 'COMPONENT-OF'
4463: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
4464: )

Line 4600: -- replaced csi_ii_relationships with ahl_config_components to fix bug# 9434441

4596:
4597: l_get_mr_attri get_mr_attri%ROWTYPE;
4598:
4599: -- for the configuration components, get valid mr effectivities based on inventory items.
4600: -- replaced csi_ii_relationships with ahl_config_components to fix bug# 9434441
4601: CURSOR get_comp_mr_inv_csr(c_instance_id NUMBER, c_mr_header_id NUMBER) IS
4602: SELECT A.mr_header_id, A.mr_effectivity_id,
4603: A.pc_node_id,
4604: ii.instance_id subject_id,

Line 4610: --FROM csi_ii_relationships a

4606: WHERE ciea1.instance_id = ii.instance_id AND ciea1.attribute_code = 'AHL_MFG_DATE'
4607: AND ciea1.attribute_level = 'GLOBAL') mfg_date,
4608: ii.serial_number
4609: FROM ( SELECT a.subject_id
4610: --FROM csi_ii_relationships a
4611: FROM ahl_config_components a
4612: START WITH object_id = c_instance_id
4613: --AND relationship_type_code = 'COMPONENT-OF'
4614: --AND SYSDATE between trunc(nvl(active_start_date,sysdate))

Line 4713: FROM csi_ii_relationships

4709:
4710: -- to get configuration nodes.
4711: CURSOR get_config_tree_csr ( p_csi_instance_id IN NUMBER) IS
4712: SELECT subject_id
4713: FROM csi_ii_relationships
4714: START WITH object_id = p_csi_instance_id
4715: AND relationship_type_code = 'COMPONENT-OF'
4716: AND trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
4717: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))