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_PC_ASSOCIATIONS

Line 297: FROM ahl_pc_associations C

293: AND sysdate between trunc(nvl(b.active_start_date,sysdate))
294: and trunc(nvl(b.active_end_date,sysdate+1))
295: AND B.inventory_item_id = c_inventory_item_id)
296: AND EXISTS (SELECT 'X'
297: FROM ahl_pc_associations C
298: WHERE C.unit_item_id = A.unit_config_header_id
299: AND C.association_type_flag = 'U'
300: AND EXISTS (SELECT 'X'
301: FROM ahl_pc_nodes_b D

Line 317: FROM ahl_pc_associations C

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'
317: FROM ahl_pc_associations C
318: WHERE C.unit_item_id = A.inventory_item_id
319: AND C.association_type_flag = 'I'
320: AND EXISTS (SELECT 'X'
321: FROM ahl_pc_nodes_b D

Line 337: FROM ahl_pc_associations C

333: AND sysdate between trunc(nvl(b.active_start_date,sysdate))
334: and trunc(nvl(b.active_end_date,sysdate+1))
335: AND B.inventory_item_id = c_inventory_item_id)
336: AND EXISTS (SELECT 'X'
337: FROM ahl_pc_associations C
338: WHERE C.unit_item_id = A.unit_config_header_id
339: AND C.association_type_flag = 'U'
340: AND EXISTS (SELECT 'X'
341: FROM ahl_pc_nodes_b D

Line 357: FROM ahl_pc_associations C

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'
357: FROM ahl_pc_associations C
358: WHERE C.unit_item_id = A.inventory_item_id
359: AND C.association_type_flag = 'I'
360: AND EXISTS (SELECT 'X'
361: FROM ahl_pc_nodes_b D

Line 376: FROM ahl_pc_associations C

372: WHERE B.instance_id = Api.csi_item_instance_id
373: AND sysdate between trunc(nvl(b.active_start_date,sysdate)) and trunc(nvl(b.active_end_date,sysdate+1))
374: AND B.inventory_item_id = c_inventory_item_id)
375: AND EXISTS (SELECT 'X'
376: FROM ahl_pc_associations C
377: WHERE C.unit_item_id = A.unit_config_header_id
378: AND C.association_type_flag = 'U'
379: AND EXISTS (SELECT 'X'
380: FROM ahl_pc_nodes_b D

Line 399: FROM ahl_pc_associations D

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'
402: AND EXISTS (SELECT 'X'
403: FROM ahl_pc_nodes_b E

Line 417: FROM ahl_pc_associations B

413: FROM csi_item_instances A
414: WHERE A.inventory_item_id = c_inventory_item_id
415: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
416: AND EXISTS (SELECT 'X'
417: FROM ahl_pc_associations B
418: WHERE B.unit_item_id = A.inventory_item_id
419: AND B.association_type_flag = 'I'
420: AND EXISTS (SELECT 'X'
421: FROM ahl_pc_nodes_b C

Line 439: FROM ahl_pc_associations D

435: )
436: START WITH object_id IN (SELECT C.instance_id
437: FROM csi_item_instances C
438: WHERE EXISTS (SELECT 'X'
439: FROM ahl_pc_associations D
440: WHERE D.unit_item_id = C.inventory_item_id
441: AND D.association_type_flag = 'I'
442: AND EXISTS (SELECT 'X'
443: FROM ahl_pc_nodes_b E

Line 460: FROM ahl_pc_associations B

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))
459: AND EXISTS (SELECT 'X'
460: FROM ahl_pc_associations B
461: WHERE B.unit_item_id = A.unit_config_header_id
462: AND B.association_type_flag = 'U'
463: AND EXISTS (SELECT 'X'
464: FROM ahl_pc_nodes_b C

Line 479: FROM ahl_pc_associations C

475: AND EXISTS (SELECT 'X'
476: FROM csi_item_instances B
477: WHERE B.instance_id = A.csi_item_instance_id
478: AND EXISTS (SELECT 'X'
479: FROM ahl_pc_associations C
480: WHERE C.unit_item_id = B.inventory_item_id
481:
482: AND C.association_type_flag = 'I'
483: AND EXISTS (SELECT 'X'

Line 498: FROM ahl_pc_associations B

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'
498: FROM ahl_pc_associations B
499: WHERE B.unit_item_id = A.unit_config_header_id
500: AND B.association_type_flag = 'U'
501: AND EXISTS (SELECT 'X'
502: FROM ahl_pc_nodes_b C

Line 516: FROM ahl_pc_associations B

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
518: AND B.association_type_flag = 'U'
519: AND EXISTS (SELECT 'X'
520: FROM ahl_pc_nodes_b C

Line 541: FROM ahl_pc_associations C

537: FROM csi_item_instances B
538: WHERE B.instance_id = api.csi_item_instance_id
539: AND SYSDATE between trunc(nvl(b.active_start_date,sysdate)) and trunc(nvl(b.active_end_date,sysdate+1))
540: AND EXISTS (SELECT 'X'
541: FROM ahl_pc_associations C
542: WHERE C.unit_item_id = B.inventory_item_id
543: AND C.association_type_flag = 'I'
544: AND EXISTS (SELECT 'X'
545: FROM ahl_pc_nodes_b D

Line 561: FROM ahl_pc_associations B

557: FROM csi_item_instances Ax
558: WHERE SYSDATE between trunc(nvl(ax.active_start_date,sysdate)) and trunc(nvl(ax.active_end_date,sysdate+1))
559: AND instance_id=a.subject_id
560: AND EXISTS (SELECT 'X'
561: FROM ahl_pc_associations B
562: WHERE B.unit_item_id = Ax.inventory_item_id
563: AND B.association_type_flag = 'I'
564: AND EXISTS (SELECT 'X'
565: FROM ahl_pc_nodes_b C

Line 589: FROM ahl_pc_associations C

585: FROM csi_item_instances B
586: WHERE B.instance_id = Api.csi_item_instance_id
587: AND B.inventory_item_id = c_inventory_item_id)
588: AND EXISTS (SELECT 'X'
589: FROM ahl_pc_associations C
590: WHERE C.unit_item_id = A.unit_config_header_id
591: AND C.association_type_flag = 'U'
592: AND EXISTS (SELECT 'X'
593: FROM ahl_pc_nodes_b D

Line 610: FROM ahl_pc_associations C

606: WHERE B.instance_id = A.csi_item_instance_id
607: AND SYSDATE between trunc(nvl(b.active_start_date,sysdate)) and trunc(nvl(b.active_end_date,sysdate+1))
608: AND B.inventory_item_id = c_inventory_item_id
609: AND EXISTS (SELECT 'X'
610: FROM ahl_pc_associations C
611: WHERE C.unit_item_id = B.inventory_item_id
612: AND C.association_type_flag = 'I'
613: AND EXISTS (SELECT 'X'
614: FROM ahl_pc_nodes_b D

Line 632: FROM ahl_pc_associations C

628: WHERE B.instance_id = api.csi_item_instance_id
629: AND SYSDATE between trunc(nvl(b.active_start_date,sysdate)) and trunc(nvl(b.active_end_date,sysdate+1))
630: AND B.inventory_item_id = c_inventory_item_id)
631: AND EXISTS (SELECT 'X'
632: FROM ahl_pc_associations C
633: WHERE C.unit_item_id = A.unit_config_header_id
634: AND C.association_type_flag = 'U'
635: AND EXISTS (SELECT 'X'
636: FROM ahl_pc_nodes_b D

Line 656: FROM ahl_pc_associations D

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
657: WHERE D.unit_item_id = C.unit_config_header_id
658: AND D.association_type_flag = 'U'
659: AND EXISTS (SELECT 'X'
660: FROM ahl_pc_nodes_b E

Line 680: FROM ahl_pc_associations C

676: WHERE B.instance_id = api.csi_item_instance_id
677: AND SYSDATE between trunc(nvl(b.active_start_date,sysdate)) and trunc(nvl(b.active_end_date,sysdate+1))
678: AND B.inventory_item_id = c_inventory_item_id
679: AND EXISTS (SELECT 'X'
680: FROM ahl_pc_associations C
681: WHERE C.unit_item_id = B.inventory_item_id
682: AND C.association_type_flag = 'I'
683: AND EXISTS (SELECT 'X'
684: FROM ahl_pc_nodes_b D

Line 703: FROM ahl_pc_associations D

699: START WITH object_id IN (SELECT instance_id
700: FROM csi_item_instances C
701: WHERE SYSDATE between trunc(nvl(c.active_start_date,sysdate)) and trunc(nvl(C.active_end_date,sysdate+1))
702: AND EXISTS (SELECT 'X'
703: FROM ahl_pc_associations D
704: WHERE D.unit_item_id = C.inventory_item_id
705: AND D.association_type_flag = 'I'
706: AND EXISTS (SELECT 'X'
707: FROM ahl_pc_nodes_b E

Line 1284: from ahl_pc_associations itm, csi_item_instances csi,

1280: SELECT pc_node_id --amsriniv
1281: FROM ahl_pc_nodes_b B
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'

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 1339: from ahl_pc_associations itm, csi_item_instances csi,ii

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
1339: from ahl_pc_associations itm, csi_item_instances csi,ii
1340: where itm.association_type_flag = 'I'
1341: and itm.unit_item_id = csi.inventory_item_id
1342: and csi.instance_id = ii.object_id
1343: UNION ALL

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 1363: from ahl_pc_associations itm, csi_item_instances csi,

1359: SELECT /*+ CONNECT_BY_FILTERING */ 'x'
1360: FROM ahl_pc_nodes_b B
1361: WHERE B.pc_node_id = c_pc_node_id
1362: START WITH B.pc_node_id IN (select /*+ UNNEST */ pc_node_id
1363: from ahl_pc_associations itm, csi_item_instances csi,
1364: (select /*+ INDEX(E) */ object_id
1365: FROM ahl_config_components E
1366: START WITH E.subject_id = c_instance_id
1367: CONNECT BY E.subject_id = PRIOR E.object_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 4355: from ahl_pc_associations itm, csi_item_instances csi,

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

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 4552: from ahl_pc_associations itm, csi_item_instances csi,

4548: SELECT 'x'
4549: FROM ahl_pc_nodes_b B
4550: WHERE B.pc_node_id = c_pc_node_id
4551: START WITH B.pc_node_id IN (select pc_node_id
4552: from ahl_pc_associations itm, csi_item_instances csi,
4553: (select object_id
4554: FROM ahl_config_components E
4555: START WITH E.subject_id = c_instance_id
4556: CONNECT BY E.subject_id = PRIOR E.object_id

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