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_NODES_B

Line 301: FROM ahl_pc_nodes_b D

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
302: WHERE D.pc_node_id = C.pc_node_id
303: START WITH D.pc_node_id = c_pc_node_id
304: CONNECT BY D.parent_node_id = PRIOR D.pc_node_id))
305: UNION

Line 321: FROM ahl_pc_nodes_b D

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
322: WHERE D.pc_node_id = C.pc_node_id
323: START WITH D.pc_node_id = c_pc_node_id
324: CONNECT BY D.parent_node_id = PRIOR D.pc_node_id));*/
325: -- same as before, but include all nodes, not only top node

Line 341: FROM ahl_pc_nodes_b D

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
342: WHERE D.pc_node_id = C.pc_node_id
343: START WITH D.pc_node_id = c_pc_node_id
344: CONNECT BY D.parent_node_id = PRIOR D.pc_node_id))
345: UNION

Line 361: FROM ahl_pc_nodes_b D

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
362: WHERE D.pc_node_id = C.pc_node_id
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

Line 380: FROM ahl_pc_nodes_b D

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
381: WHERE D.pc_node_id = C.pc_node_id
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

Line 403: FROM ahl_pc_nodes_b E

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
404: WHERE E.pc_node_id = D.pc_node_id
405: START WITH E.pc_node_id = c_pc_node_id
406: CONNECT BY E.parent_node_id= PRIOR E.pc_node_id)))
407: CONNECT BY object_id = PRIOR subject_id

Line 421: FROM ahl_pc_nodes_b C

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
422: WHERE C.pc_node_id = B.pc_node_id
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

Line 443: FROM ahl_pc_nodes_b E

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
444: WHERE E.pc_node_id = D.pc_node_id
445: START WITH E.pc_node_id = c_pc_node_id
446: CONNECT BY E.parent_node_id= PRIOR E.pc_node_id)))
447: CONNECT BY object_id = PRIOR subject_id

Line 464: FROM ahl_pc_nodes_b C

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
465: WHERE C.pc_node_id = B.pc_node_id
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

Line 484: FROM ahl_pc_nodes_b D

480: WHERE C.unit_item_id = B.inventory_item_id
481:
482: AND C.association_type_flag = 'I'
483: AND EXISTS (SELECT 'X'
484: FROM ahl_pc_nodes_b D
485: WHERE D.pc_node_id = C.pc_node_id
486: START WITH D.pc_node_id = c_pc_node_id
487: CONNECT BY D.parent_node_id= PRIOR D.pc_node_id)
488: )

Line 502: FROM ahl_pc_nodes_b C

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
503: WHERE C.pc_node_id = B.pc_node_id
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

Line 520: FROM ahl_pc_nodes_b C

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
521: WHERE C.pc_node_id = B.pc_node_id
522: START WITH C.pc_node_id = c_pc_node_id
523: CONNECT BY C.parent_node_id= PRIOR C.pc_node_id)
524: )

Line 545: FROM ahl_pc_nodes_b D

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
546: WHERE D.pc_node_id = C.pc_node_id
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

Line 565: FROM ahl_pc_nodes_b C

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
566: WHERE C.pc_node_id = B.pc_node_id
567: START WITH C.pc_node_id = c_pc_node_id
568: CONNECT BY C.parent_node_id= PRIOR C.pc_node_id)
569: )

Line 593: FROM ahl_pc_nodes_b D

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
594: WHERE D.pc_node_id = C.pc_node_id
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

Line 614: FROM ahl_pc_nodes_b D

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
615: WHERE D.pc_node_id = C.pc_node_id
616: START WITH D.pc_node_id = c_pc_node_id
617: CONNECT BY D.parent_node_id= PRIOR D.pc_node_id)));*/
618: --same as before, but include all nodes, not only top node

Line 636: FROM ahl_pc_nodes_b D

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
637: WHERE D.pc_node_id = C.pc_node_id
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

Line 660: FROM ahl_pc_nodes_b E

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
661: WHERE E.pc_node_id = D.pc_node_id
662: START WITH E.pc_node_id = c_pc_node_id
663: CONNECT BY E.parent_node_id= PRIOR E.pc_node_id)))
664: CONNECT BY object_id = PRIOR subject_id

Line 684: FROM ahl_pc_nodes_b D

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
685: WHERE D.pc_node_id = C.pc_node_id
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

Line 707: FROM ahl_pc_nodes_b E

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
708: WHERE E.pc_node_id = D.pc_node_id
709: START WITH E.pc_node_id = c_pc_node_id
710: CONNECT BY E.parent_node_id= PRIOR E.pc_node_id)
711: )

Line 1281: FROM ahl_pc_nodes_b B

1277: /* rewrote query for performance
1278: CURSOR validate_pc_node_csr (c_instance_id NUMBER) --amsriniv
1279: IS
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

Line 1336: FROM ahl_pc_nodes_b B

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
1339: from ahl_pc_associations itm, csi_item_instances csi,ii
1340: where itm.association_type_flag = 'I'

Line 1360: FROM ahl_pc_nodes_b B

1356: CURSOR validate_itm_node_csr (c_instance_id NUMBER,
1357: c_pc_node_id NUMBER)
1358: IS
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

Line 1382: FROM ahl_pc_nodes_b B

1378: CURSOR validate_unit_node_csr (c_instance_id NUMBER,
1379: c_pc_node_id NUMBER)
1380: IS
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

Line 4352: FROM ahl_pc_nodes_b B

4348: CURSOR validate_itm_node_csr (c_instance_id NUMBER,
4349: c_pc_node_id NUMBER)
4350: IS
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

Line 4376: FROM ahl_pc_nodes_b B

4372: CURSOR validate_unit_node_csr (c_instance_id NUMBER,
4373: c_pc_node_id NUMBER)
4374: IS
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

Line 4549: FROM ahl_pc_nodes_b B

4545: CURSOR validate_itm_node_csr (c_instance_id NUMBER,
4546: c_pc_node_id NUMBER)
4547: IS
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

Line 4570: FROM ahl_pc_nodes_b B

4566: CURSOR validate_unit_node_csr (c_instance_id NUMBER,
4567: c_pc_node_id NUMBER)
4568: IS
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