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 AHL_UNIT_CONFIG_HEADERS

Line 174: FROM ahl_unit_config_headers A

170: --get unit_name and uc_header_id for an item instance
171: /*
172: CURSOR get_uc_header(c_instance_id NUMBER) IS
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

Line 210: FROM ahl_unit_config_headers a,ahl_applicable_instances b

206:
207: /*CURSOR get_top_inst2(c_relationship_id NUMBER)
208: IS
209: SELECT a.csi_item_instance_id instance_id
210: FROM ahl_unit_config_headers a,ahl_applicable_instances b
211: WHERE a.csi_item_instance_id=b.csi_item_instance_id
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))

Line 225: FROM ahl_unit_config_headers a,ahl_applicable_instances b

221: --same as before, but include all nodes, not only top node
222: CURSOR get_inst2(c_relationship_id NUMBER)
223: IS
224: SELECT a.csi_item_instance_id instance_id
225: FROM ahl_unit_config_headers a,ahl_applicable_instances b
226: WHERE a.csi_item_instance_id=b.csi_item_instance_id
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

Line 243: FROM ahl_unit_config_headers A,ahl_applicable_instances api

239: --top node
240: /*CURSOR get_top_inst3(c_relationship_id NUMBER, c_inventory_item_id NUMBER)
241: IS
242: SELECT a.csi_item_instance_id instance_id
243: FROM ahl_unit_config_headers A,ahl_applicable_instances api
244: --WHERE A.master_config_id=api.position_id
245: --AND A.csi_item_instance_id=api.csi_item_instance_id
246: WHERE A.csi_item_instance_id=api.csi_item_instance_id
247: AND api.position_id= C_RELATIONSHIP_ID

Line 260: FROM ahl_unit_config_headers A,ahl_applicable_instances api

256: --same as before, but include all nodes, not only top node
257: CURSOR get_inst3(c_relationship_id NUMBER, c_inventory_item_id NUMBER)
258: IS
259: SELECT a.csi_item_instance_id instance_id
260: FROM ahl_unit_config_headers A,ahl_applicable_instances api
261: WHERE A.csi_item_instance_id=api.csi_item_instance_id
262: AND api.position_id=c_relationship_id
263: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate))
264: and trunc(nvl(a.active_end_date,sysdate+1))

Line 289: FROM ahl_unit_config_headers A

285: --inventory item and PC node defined in MR effectivity definition, just top node
286: /*CURSOR get_top_inst4(c_inventory_item_id NUMBER, c_pc_node_id NUMBER)
287: IS
288: SELECT a.csi_item_instance_id instance_id
289: FROM ahl_unit_config_headers A
290: WHERE EXISTS (SELECT 'X'
291: FROM csi_item_instances B
292: WHERE B.instance_id = A.csi_item_instance_id
293: AND sysdate between trunc(nvl(b.active_start_date,sysdate))

Line 329: FROM ahl_unit_config_headers A

325: -- same as before, but include all nodes, not only top node
326:
327: /*CURSOR get_inst4(c_inventory_item_id NUMBER, c_pc_node_id NUMBER) IS
328: SELECT a.csi_item_instance_id instance_id
329: FROM ahl_unit_config_headers A
330: WHERE EXISTS (SELECT 'X'
331: FROM csi_item_instances B
332: WHERE B.instance_id = A.csi_item_instance_id
333: AND sysdate between trunc(nvl(b.active_start_date,sysdate))

Line 367: FROM ahl_unit_config_headers A,ahl_applicable_instances api

363: START WITH D.pc_node_id = c_pc_node_id
364: CONNECT BY D.parent_node_id = PRIOR D.pc_node_id))
365: UNION -- aobe query added to fix bug number 5448015
366: SELECT a.csi_item_instance_id instance_id
367: FROM ahl_unit_config_headers A,ahl_applicable_instances api
368: WHERE SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
369: AND a.csi_item_instance_id=api.csi_item_instance_id
370: AND EXISTS (SELECT 'X'
371: FROM csi_item_instances B

Line 397: FROM ahl_unit_config_headers C

393: WHERE B.instance_id = A.subject_id
394: AND SYSDATE between trunc(nvl(b.active_start_date,sysdate)) and trunc(nvl(b.active_end_date,sysdate+1))
395: AND B.inventory_item_id = c_inventory_item_id)
396: START WITH object_id IN (SELECT csi_item_instance_id
397: FROM ahl_unit_config_headers C
398: WHERE EXISTS (SELECT 'X'
399: FROM ahl_pc_associations D
400: WHERE D.unit_item_id = C.unit_config_header_id
401: AND D.association_type_flag = 'U'

Line 454: FROM ahl_unit_config_headers A,ahl_applicable_instances api

450: AND a.relationship_type_code = 'COMPONENT-OF';*/
451: --position in MC and PC node defined in MR effectivity definition, just top node
452: /*CURSOR get_top_inst5(c_relationship_id NUMBER, c_pc_node_id NUMBER) IS
453: SELECT a.csi_item_instance_id instance_id
454: FROM ahl_unit_config_headers A,ahl_applicable_instances api
455: WHERE api.position_id = c_relationship_id
456: and a.csi_item_instance_id=api.csi_item_instance_id
457: --and A.master_config_id=api.position_id
458: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))

Line 470: FROM ahl_unit_config_headers A,ahl_applicable_instances api

466: START WITH C.pc_node_id = c_pc_node_id
467: CONNECT BY C.parent_node_id = PRIOR C.pc_node_id))
468: UNION
469: SELECT a.csi_item_instance_id instance_id
470: FROM ahl_unit_config_headers A,ahl_applicable_instances api
471: WHERE api.position_id = c_relationship_id
472: --and A.master_config_id=api.position_id
473: and api.csi_item_instance_id=a.csi_item_instance_id
474: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))

Line 493: FROM ahl_unit_config_headers A,ahl_applicable_instances api

489: );*/
490: --same as before, but include all node, not only top node
491: /*CURSOR get_inst5(c_relationship_id NUMBER, c_pc_node_id NUMBER) IS
492: SELECT a.csi_item_instance_id instance_id
493: FROM ahl_unit_config_headers A,ahl_applicable_instances api
494: WHERE api.csi_item_instance_id=a.csi_item_instance_id
495: and api.position_id=c_relationship_id
496: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
497: AND EXISTS (SELECT 'X'

Line 513: FROM ahl_unit_config_headers Ax

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
513: FROM ahl_unit_config_headers Ax
514: WHERE ax.csi_item_instance_id=a.subject_id AND
515: EXISTS (SELECT 'X'
516: FROM ahl_pc_associations B
517: WHERE B.unit_item_id = Ax.unit_config_header_id

Line 532: FROM ahl_unit_config_headers A,ahl_applicable_instances api

528: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
529: AND a.relationship_type_code = 'COMPONENT-OF'
530: UNION
531: SELECT a.csi_item_instance_id instance_id
532: FROM ahl_unit_config_headers A,ahl_applicable_instances api
533: WHERE api.position_id = c_relationship_id
534: and api.csi_item_instance_id= a.csi_item_instance_id
535: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
536: AND EXISTS (SELECT 'X'

Line 579: FROM ahl_unit_config_headers A,ahl_applicable_instances api

575: --all inventory item, position in MC and PC node defined in MR effectivity
576: --definition, just top node
577: /*CURSOR get_top_inst6(c_inventory_item_id NUMBER, c_relationship_id NUMBER, c_pc_node_id NUMBER) IS
578: SELECT a.csi_item_instance_id instance_id
579: FROM ahl_unit_config_headers A,ahl_applicable_instances api
580: WHERE api.position_id = c_relationship_id
581: AND api.csi_item_instance_id=A.csi_item_instance_id
582: --and A.master_config_id=api.position_id
583: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))

Line 599: FROM ahl_unit_config_headers A,ahl_applicable_instances api

595: START WITH D.pc_node_id = c_pc_node_id
596: CONNECT BY D.parent_node_id = PRIOR D.pc_node_id))
597: UNION
598: SELECT a.csi_item_instance_id instance_id
599: FROM ahl_unit_config_headers A,ahl_applicable_instances api
600: WHERE Api.position_id = c_relationship_id
601: AND A.csi_item_instance_id=API.csi_item_instance_id
602: --and A.master_config_id=api.position_id
603: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))

Line 621: FROM ahl_unit_config_headers A,ahl_applicable_instances api

617: CONNECT BY D.parent_node_id= PRIOR D.pc_node_id)));*/
618: --same as before, but include all nodes, not only top node
619: /*CURSOR get_inst6(c_inventory_item_id NUMBER, c_relationship_id NUMBER, c_pc_node_id NUMBER) IS
620: SELECT a.csi_item_instance_id instance_id
621: FROM ahl_unit_config_headers A,ahl_applicable_instances api
622: WHERE api.position_id = c_relationship_id
623: AND api.csi_item_instance_id=A.csi_item_instance_id
624: -- AND subject_id in (Select csi_item_instance_id from ahl_applicable_instances)
625: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))

Line 652: FROM ahl_unit_config_headers C,ahl_applicable_instances api

648: WHERE B.instance_id = A.subject_id
649: AND SYSDATE between trunc(nvl(b.active_start_date,sysdate)) and trunc(nvl(b.active_end_date,sysdate+1))
650: AND B.inventory_item_id = c_inventory_item_id)
651: START WITH object_id IN (SELECT c.csi_item_instance_id
652: FROM ahl_unit_config_headers C,ahl_applicable_instances api
653: WHERE c.csi_item_instance_id=api.csi_item_instance_id
654: and api.position_id=c_relationship_id and
655: EXISTS (SELECT 'X'
656: FROM ahl_pc_associations D

Line 670: FROM ahl_unit_config_headers A,ahl_applicable_instances api

666: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
667: AND a.relationship_type_code = 'COMPONENT-OF'
668: UNION
669: SELECT a.csi_item_instance_id instance_id
670: FROM ahl_unit_config_headers A,ahl_applicable_instances api
671: WHERE api.position_id = c_relationship_id
672: AND A.csi_item_instance_id=API.csi_item_instance_id
673: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
674: AND EXISTS (SELECT 'X'

Line 1267: FROM ahl_unit_config_headers a

1263: SELECT --NULL parent_item_instance_id,
1264: --a.csi_item_instance_id,
1265: --a.master_config_id,
1266: a.unit_config_header_id
1267: FROM ahl_unit_config_headers a
1268: WHERE a.csi_item_instance_id = c_item_instance_id
1269: /* Fix for bug#4052646
1270: * AND a.parent_uc_header_id is not null -- Line commented
1271: */

Line 1299: from ahl_pc_associations unit, ahl_unit_config_headers uc,

1295: and itm.unit_item_id = csi.inventory_item_id
1296: and csi.instance_id = ii.object_id
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'

Line 1345: from ahl_pc_associations unit, ahl_unit_config_headers uc, ii

1341: and itm.unit_item_id = csi.inventory_item_id
1342: and csi.instance_id = ii.object_id
1343: UNION ALL
1344: select pc_node_id
1345: from ahl_pc_associations unit, ahl_unit_config_headers uc, ii
1346: where unit.association_type_flag = 'U'
1347: and unit.unit_item_id = uc.unit_config_header_id
1348: and uc.csi_item_instance_id = ii.object_id)
1349: CONNECT BY B.pc_node_id = PRIOR B.parent_node_id;

Line 1385: from ahl_pc_associations unit, ahl_unit_config_headers uc,

1381: SELECT /*+ CONNECT_BY_FILTERING */ 'x'
1382: FROM ahl_pc_nodes_b B
1383: WHERE B.pc_node_id = c_pc_node_id
1384: START WITH B.pc_node_id IN (select /*+ UNNEST */ pc_node_id
1385: from ahl_pc_associations unit, ahl_unit_config_headers uc,
1386: (select /*+ INDEX(E) */ object_id
1387: FROM ahl_config_components E
1388: START WITH E.subject_id = c_instance_id
1389: CONNECT BY E.subject_id = PRIOR E.object_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 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 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 3072: FROM ahl_unit_config_headers

3068: IS
3069: -- Get ucHeader for component
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'

Line 3090: FROM ahl_unit_config_headers

3086:
3087: -- Get ucHeader for top node
3088: CURSOR get_unit_name_top (p_item_instance_id IN NUMBER) IS
3089: SELECT unit_config_header_id, name
3090: FROM ahl_unit_config_headers
3091: WHERE csi_item_instance_id = p_item_instance_id
3092: AND sysdate between trunc(nvl(active_start_date,sysdate))
3093: AND trunc(nvl(active_end_date, SYSDATE+1));
3094:

Line 3283: FROM ahl_unit_config_headers

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)
3285: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
3286: )
3287: START WITH csi.subject_id = c_csi_instance_id

Line 3305: FROM ahl_mc_headers_b hdr, ahl_mc_relationships rel, ahl_unit_config_headers uch

3301: WHERE up.csi_instance_id = c_csi_instance_id;
3302:
3303: CURSOR get_top_unit_inst_csr (c_csi_instance_id IN NUMBER) IS
3304: SELECT hdr.mc_id, hdr.version_number, rel.position_key
3305: FROM ahl_mc_headers_b hdr, ahl_mc_relationships rel, ahl_unit_config_headers uch
3306: WHERE uch.csi_item_instance_id = c_csi_instance_id
3307: AND TRUNC(nvl(uch.ACTIVE_START_DATE, sysdate)) <= TRUNC(sysdate)
3308: AND TRUNC(nvl(uch.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)
3309: AND hdr.mc_header_id = uch.master_config_id

Line 4379: from ahl_pc_associations unit, ahl_unit_config_headers uc,

4375: SELECT /*+ CONNECT_BY_FILTERING */ 'x'
4376: FROM ahl_pc_nodes_b B
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))

Line 4573: from ahl_pc_associations unit, ahl_unit_config_headers uc,

4569: SELECT 'x'
4570: FROM ahl_pc_nodes_b B
4571: WHERE B.pc_node_id = c_pc_node_id
4572: START WITH B.pc_node_id IN (select pc_node_id
4573: from ahl_pc_associations unit, ahl_unit_config_headers uc,
4574: (select object_id
4575: FROM ahl_config_components E
4576: START WITH E.subject_id = c_instance_id
4577: CONNECT BY E.subject_id = PRIOR E.object_id