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 137: FROM csi_ii_relationships B

133: SELECT unit_config_header_id, name
134: FROM ahl_unit_config_headers A
135: WHERE csi_item_instance_id = c_instance_id
136: OR EXISTS (SELECT 'X'
137: FROM csi_ii_relationships B
138: WHERE B.object_id = A.csi_item_instance_id
139: START WITH subject_id = c_instance_id
140: CONNECT BY subject_id = PRIOR object_id);
141: l_get_uc_header get_uc_header%ROWTYPE;

Line 151: FROM csi_ii_relationships B

147: FROM csi_item_instances A
148: WHERE inventory_item_id = c_inventory_item_id
149: AND SYSDATE between trunc(nvl(A.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
150: AND NOT EXISTS (SELECT 'X'
151: FROM csi_ii_relationships B
152: WHERE B.subject_id = A.instance_id
153: AND relationship_type_code = 'COMPONENT-OF'
154: AND SYSDATE between trunc(nvl(B.active_start_date,sysdate)) and trunc(NVL(b.active_end_date,sysdate+1))
155: );*/

Line 176: FROM csi_ii_relationships

172: and a.master_config_id=b.position_id
173: AND b.position_id=c_relationship_id
174: and SYSDATE between trunc(nvl(A.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
175: and not exists (SELECT 'X'
176: FROM csi_ii_relationships
177: WHERE subject_id=b.csi_item_instance_id
178: AND relationship_type_code='COMPONENT_OF');*/
179:
180:

Line 191: FROM csi_ii_relationships a,ahl_applicable_instances b

187: and b.position_id= c_relationship_id
188: AND SYSDATE between trunc(nvl(A.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
189: UNION
190: SELECT a.subject_id instance_id
191: FROM csi_ii_relationships a,ahl_applicable_instances b
192: WHERE a.subject_id=b.csi_item_instance_id
193: and b.position_id=c_relationship_id
194: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
195: AND a.relationship_type_code = 'COMPONENT-OF';

Line 233: FROM csi_ii_relationships A,ahl_applicable_instances api

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

Line 272: FROM csi_ii_relationships B

268: WHERE A.inventory_item_id = c_inventory_item_id
269: AND sysdate between trunc(nvl(a.active_start_date,sysdate))
270: and trunc(nvl(a.active_end_date,sysdate+1))
271: AND NOT EXISTS (SELECT 'X'
272: FROM csi_ii_relationships B
273: WHERE B.subject_id = A.instance_id
274: AND sysdate between trunc(nvl(b.active_start_date,sysdate)) and trunc(nvl(b.active_end_date,sysdate+1))
275: AND B.relationship_type_code = 'COMPONENT-OF')
276: AND EXISTS (SELECT 'X'

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 346: FROM csi_ii_relationships A

342: START WITH D.pc_node_id = c_pc_node_id
343: CONNECT BY D.parent_node_id = PRIOR D.pc_node_id))
344: UNION
345: SELECT a.subject_id instance_id
346: FROM csi_ii_relationships A
347: WHERE relationship_type_code = 'COMPONENT-OF'
348: AND sysdate between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
349: AND A.SUBJECT_id IN (SELECT csi_item_instance_id from ahl_applicable_instances
350: where csi_item_instance_id=a.subject_id )

Line 387: FROM csi_ii_relationships A

383: START WITH C.pc_node_id = c_pc_node_id
384: CONNECT BY C.parent_node_id= PRIOR C.pc_node_id))
385: UNION
386: SELECT A.subject_id instance_id
387: FROM csi_ii_relationships A
388: WHERE relationship_type_code = 'COMPONENT-OF'
389: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
390: AND EXISTS (SELECT 'X'
391: FROM csi_item_instances B

Line 468: FROM csi_ii_relationships a

464: START WITH C.pc_node_id = c_pc_node_id
465: CONNECT BY C.parent_node_id= PRIOR C.pc_node_id))
466: UNION
467: SELECT a.subject_id instance_id
468: FROM csi_ii_relationships a
469: WHERE relationship_type_code = 'COMPONENT-OF'
470: AND subject_id in (Select csi_item_instance_id from ahl_applicable_instances)
471: AND sysdate between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
472: START WITH object_id IN (SELECT csi_item_instance_id

Line 511: FROM csi_ii_relationships a

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

Line 602: FROM csi_ii_relationships A

598: START WITH D.pc_node_id = c_pc_node_id
599: CONNECT BY D.parent_node_id= PRIOR D.pc_node_id))
600: UNION
601: SELECT a.subject_id instance_id
602: FROM csi_ii_relationships A
603: WHERE relationship_type_code = 'COMPONENT-OF'
604: AND a.relationship_id in (Select position_id from AHL_APPLICABLE_INSTANCES)
605: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
606: AND EXISTS (SELECT 'X'

Line 650: FROM csi_ii_relationships A

646: START WITH D.pc_node_id = c_pc_node_id
647: CONNECT BY D.parent_node_id= PRIOR D.pc_node_id)))
648: UNION
649: SELECT subject_id instance_id
650: FROM csi_ii_relationships A
651: WHERE relationship_type_code = 'COMPONENT-OF'
652: AND a.subject_id in (Select csi_item_instance_id from AHL_APPLICABLE_INSTANCES )
653: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
654: AND EXISTS (SELECT 'X'

Line 1097: FROM csi_ii_relationships E

1093: --WHERE B.pc_node_id = c_pc_node_id
1094: START WITH B.pc_node_id IN (select pc_node_id
1095: from ahl_pc_associations itm, csi_item_instances csi,
1096: (SELECT object_id
1097: FROM csi_ii_relationships E
1098: START WITH E.subject_id = c_instance_id
1099: AND E.relationship_type_code = 'COMPONENT-OF'
1100: CONNECT BY E.subject_id = PRIOR E.object_id
1101: AND E.relationship_type_code = 'COMPONENT-OF'

Line 1112: FROM csi_ii_relationships E

1108: UNION ALL
1109: select pc_node_id
1110: from ahl_pc_associations unit, ahl_unit_config_headers uc,
1111: (SELECT object_id
1112: FROM csi_ii_relationships E
1113: START WITH E.subject_id = c_instance_id
1114: AND E.relationship_type_code = 'COMPONENT-OF'
1115: CONNECT BY E.subject_id = PRIOR E.object_id
1116: AND E.relationship_type_code = 'COMPONENT-OF'

Line 1131: FROM csi_ii_relationships E

1127: CURSOR validate_pc_node_csr (c_instance_id NUMBER,
1128: c_pc_node_id NUMBER)
1129: IS
1130: WITH ii AS (SELECT object_id
1131: FROM csi_ii_relationships E
1132: START WITH E.subject_id = c_instance_id
1133: -- sunil- fix for bug7411016
1134: AND SYSDATE between trunc(nvl(E.active_start_date,sysdate)) and trunc(nvl(E.active_end_date,sysdate+1))
1135: AND E.relationship_type_code = 'COMPONENT-OF'

Line 1178: FROM csi_ii_relationships root

1174: /* not used
1175: -- Added for performance bug - 6138653
1176: CURSOR csi_root_instance_csr (p_instance_id IN NUMBER) IS
1177: SELECT root.object_id
1178: FROM csi_ii_relationships root
1179: WHERE NOT EXISTS (SELECT 'x'
1180: FROM csi_ii_relationships
1181: WHERE subject_id = root.object_id
1182: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))

Line 1180: FROM csi_ii_relationships

1176: CURSOR csi_root_instance_csr (p_instance_id IN NUMBER) IS
1177: SELECT root.object_id
1178: FROM csi_ii_relationships root
1179: WHERE NOT EXISTS (SELECT 'x'
1180: FROM csi_ii_relationships
1181: WHERE subject_id = root.object_id
1182: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
1183: )
1184: START WITH root.subject_id = p_instance_id

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

1201: (select cir2.object_id,
1202: cii2.instance_id subject_id,
1203: nvl(uc.master_config_id, cir2.position_reference) position_reference,
1204: 0 depth
1205: from csi_item_instances cii2, csi_ii_relationships cir2, ahl_unit_config_headers uc
1206: where cii2.instance_id = c_instance_id
1207: and cii2.instance_id = cir2.subject_id(+)
1208: and cii2.instance_id = uc.csi_item_instance_id(+)
1209: and uc.parent_uc_header_id(+) is null

Line 1215: FROM csi_ii_relationships a

1211: UNION ALL
1212: SELECT a.object_id,
1213: a.subject_id,
1214: to_number(a.position_reference), level depth
1215: FROM csi_ii_relationships a
1216: WHERE c_components_flag = 'Y'
1217: START WITH object_id = c_instance_id
1218: AND relationship_type_code = 'COMPONENT-OF'
1219: AND SYSDATE between trunc(nvl(active_start_date,sysdate)) and trunc(NVL(active_end_date,sysdate+1))

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

1240: cii2.instance_id subject_id,
1241: --nvl(uc.master_config_id, cir2.position_reference) position_reference,
1242: 0 depth,
1243: cii2.inventory_item_id
1244: from csi_item_instances cii2 --, csi_ii_relationships cir2, ahl_unit_config_headers uc
1245: where cii2.instance_id = c_instance_id
1246: --and cii2.instance_id = cir2.subject_id(+)
1247: --and cii2.instance_id = uc.csi_item_instance_id(+)
1248: --and uc.parent_uc_header_id(+) is null

Line 1259: FROM csi_ii_relationships a

1255: level depth,
1256: (select inventory_item_id
1257: from csi_item_instances
1258: where instance_id = a.subject_id) inventory_item_id
1259: FROM csi_ii_relationships a
1260: WHERE c_components_flag = 'Y'
1261: START WITH object_id = c_instance_id
1262: AND relationship_type_code = 'COMPONENT-OF'
1263: AND SYSDATE between trunc(nvl(active_start_date,sysdate))

Line 1342: FROM csi_ii_relationships a

1338: AND ciea1.attribute_level = 'GLOBAL') mfg_date,
1339: ii.serial_number --,
1340: --(SELECT 'Y' from ahl_mr_effectivity_dtls where mr_effectivity_id = a.mr_effectivity_id and ROWNUM < 2) eff_dtls_flag
1341: FROM ( SELECT a.subject_id
1342: FROM csi_ii_relationships a
1343: START WITH object_id = c_instance_id
1344: AND relationship_type_code = 'COMPONENT-OF'
1345: AND SYSDATE between trunc(nvl(active_start_date,sysdate))
1346: AND trunc(NVL(active_end_date,sysdate+1))

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

1440: (select cir2.object_id,
1441: cii2.instance_id subject_id,
1442: nvl(uc.master_config_id, cir2.position_reference) position_reference,
1443: 0 depth
1444: from csi_item_instances cii2, csi_ii_relationships cir2, ahl_unit_config_headers uc
1445: where cii2.instance_id = c_instance_id
1446: and cii2.instance_id = cir2.subject_id(+)
1447: and cii2.instance_id = uc.csi_item_instance_id(+)
1448: and uc.parent_uc_header_id(+) is null

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

1469: cii2.instance_id subject_id,
1470: --nvl(uc.master_config_id, cir2.position_reference) position_reference,
1471: 0 depth,
1472: cii2.inventory_item_id
1473: from csi_item_instances cii2 --, csi_ii_relationships cir2, ahl_unit_config_headers uc
1474: where cii2.instance_id = c_instance_id
1475: --and cii2.instance_id = cir2.subject_id(+)
1476: --and cii2.instance_id = uc.csi_item_instance_id(+)
1477: --and uc.parent_uc_header_id(+) is null

Line 1555: FROM csi_ii_relationships a

1551: AND ciea1.attribute_level = 'GLOBAL') mfg_date,
1552: cii.serial_number --,
1553: --(SELECT 'Y' from ahl_mr_effectivity_dtls where mr_effectivity_id = a.mr_effectivity_id and ROWNUM < 2) eff_dtls_flag
1554: FROM ( SELECT a.subject_id
1555: FROM csi_ii_relationships a
1556: START WITH object_id = c_instance_id
1557: AND relationship_type_code = 'COMPONENT-OF'
1558: AND SYSDATE between trunc(nvl(active_start_date,sysdate))
1559: AND trunc(NVL(active_end_date,sysdate+1))

Line 1752: FROM csi_ii_relationships

1748:
1749: -- to get configuration nodes.
1750: CURSOR get_config_tree_csr ( p_csi_instance_id IN NUMBER) IS
1751: SELECT subject_id
1752: FROM csi_ii_relationships
1753: START WITH object_id = p_csi_instance_id
1754: AND relationship_type_code = 'COMPONENT-OF'
1755: AND trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
1756: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))

Line 2331: FROM csi_ii_relationships

2327: CURSOR get_unit_name_com (p_item_instance_id IN NUMBER) IS
2328: SELECT unit_config_header_id, name
2329: FROM ahl_unit_config_headers
2330: WHERE csi_item_instance_id IN ( SELECT object_id
2331: FROM csi_ii_relationships
2332: START WITH subject_id = p_item_instance_id
2333: AND relationship_type_code = 'COMPONENT-OF'
2334: AND sysdate between trunc(nvl(active_start_date,sysdate))
2335: AND trunc(nvl(active_end_date, SYSDATE+1))

Line 2387: FROM csi_ii_relationships

2383: CURSOR get_instance_top (p_item_instance_id IN NUMBER) IS
2384: SELECT A.instance_id
2385: FROM csi_item_instances A
2386: WHERE A.instance_id IN ( SELECT object_id
2387: FROM csi_ii_relationships
2388: START WITH subject_id = p_item_instance_id
2389: AND relationship_type_code = 'COMPONENT-OF'
2390: AND sysdate between trunc(nvl(active_start_date,sysdate))
2391: AND trunc(nvl(active_end_date, SYSDATE+1))

Line 2400: FROM csi_ii_relationships B

2396: )
2397: AND sysdate between trunc(nvl(active_start_date,sysdate))
2398: AND trunc(nvl(active_end_date, SYSDATE+1))
2399: AND NOT EXISTS (SELECT 'X'
2400: FROM csi_ii_relationships B
2401: WHERE B.subject_id = A.instance_id
2402: AND relationship_type_code = 'COMPONENT-OF'
2403: AND SYSDATE between trunc(nvl(B.active_start_date,sysdate)) and trunc(NVL(b.active_end_date,sysdate+1))
2404: );

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

2522:
2523: --Fetches lowest level info
2524: CURSOR get_last_uc_rec_csr(c_csi_instance_id IN NUMBER) IS
2525: SELECT hdr.mc_id, hdr.version_number, rel.position_key
2526: FROM ahl_mc_headers_b hdr, ahl_mc_relationships rel, csi_ii_relationships csi_ii
2527: WHERE csi_ii.subject_id = c_csi_instance_id
2528: AND CSI_II.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
2529: AND TRUNC(nvl(CSI_II.ACTIVE_START_DATE, sysdate)) <= TRUNC(sysdate)
2530: AND TRUNC(nvl(CSI_II.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)

Line 2537: FROM csi_ii_relationships csi

2533:
2534: --Traverse up and fetch all unit instance ids
2535: CURSOR get_unit_instance_csr(c_csi_instance_id IN NUMBER) IS
2536: SELECT csi.object_id
2537: FROM csi_ii_relationships csi
2538: WHERE csi.object_id IN
2539: (SELECT csi_item_instance_id
2540: FROM ahl_unit_config_headers
2541: WHERE trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)

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

2565: AND TRUNC(nvl(uch.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)
2566: AND hdr.mc_header_id = uch.master_config_id
2567: AND rel.mc_header_id = hdr.mc_header_id
2568: AND rel.parent_relationship_id IS NULL
2569: AND NOT EXISTS (SELECT 'X' FROM CSI_II_RELATIONSHIPS CIR
2570: WHERE CIR.SUBJECT_ID = uch.csi_item_instance_id
2571: AND CIR.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
2572: AND TRUNC(nvl(CIR.ACTIVE_START_DATE, sysdate)) <= TRUNC(sysdate)
2573: AND TRUNC(nvl(CIR.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate));