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.

[Home] [Help]

APPS.AHL_FMP_PVT dependencies on AHL_PC_NODES_B

Line 261: FROM ahl_pc_nodes_b D

257: FROM ahl_pc_associations C
258: WHERE C.unit_item_id = A.unit_config_header_id
259: AND C.association_type_flag = 'U'
260: AND EXISTS (SELECT 'X'
261: FROM ahl_pc_nodes_b D
262: WHERE D.pc_node_id = C.pc_node_id
263: START WITH D.pc_node_id = c_pc_node_id
264: CONNECT BY D.parent_node_id = PRIOR D.pc_node_id))
265: UNION

Line 281: FROM ahl_pc_nodes_b D

277: FROM ahl_pc_associations C
278: WHERE C.unit_item_id = A.inventory_item_id
279: AND C.association_type_flag = 'I'
280: AND EXISTS (SELECT 'X'
281: FROM ahl_pc_nodes_b D
282: WHERE D.pc_node_id = C.pc_node_id
283: START WITH D.pc_node_id = c_pc_node_id
284: CONNECT BY D.parent_node_id = PRIOR D.pc_node_id));*/
285: -- same as before, but include all nodes, not only top node

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: UNION -- aobe query added to fix bug number 5448015

Line 340: FROM ahl_pc_nodes_b D

336: FROM ahl_pc_associations C
337: WHERE C.unit_item_id = A.unit_config_header_id
338: AND C.association_type_flag = 'U'
339: AND EXISTS (SELECT 'X'
340: FROM ahl_pc_nodes_b D
341: WHERE D.pc_node_id = C.pc_node_id
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

Line 363: FROM ahl_pc_nodes_b E

359: FROM ahl_pc_associations D
360: WHERE D.unit_item_id = C.unit_config_header_id
361: AND D.association_type_flag = 'U'
362: AND EXISTS (SELECT 'X'
363: FROM ahl_pc_nodes_b E
364: WHERE E.pc_node_id = D.pc_node_id
365: START WITH E.pc_node_id = c_pc_node_id
366: CONNECT BY E.parent_node_id= PRIOR E.pc_node_id)))
367: CONNECT BY object_id = PRIOR subject_id

Line 381: FROM ahl_pc_nodes_b C

377: FROM ahl_pc_associations B
378: WHERE B.unit_item_id = A.inventory_item_id
379: AND B.association_type_flag = 'I'
380: AND EXISTS (SELECT 'X'
381: FROM ahl_pc_nodes_b C
382: WHERE C.pc_node_id = B.pc_node_id
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

Line 403: FROM ahl_pc_nodes_b E

399: FROM ahl_pc_associations D
400: WHERE D.unit_item_id = C.inventory_item_id
401: AND D.association_type_flag = 'I'
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 424: FROM ahl_pc_nodes_b C

420: FROM ahl_pc_associations B
421: WHERE B.unit_item_id = A.unit_config_header_id
422: AND B.association_type_flag = 'U'
423: AND EXISTS (SELECT 'X'
424: FROM ahl_pc_nodes_b C
425: WHERE C.pc_node_id = B.pc_node_id
426: START WITH C.pc_node_id = c_pc_node_id
427: CONNECT BY C.parent_node_id = PRIOR C.pc_node_id))
428: UNION

Line 444: FROM ahl_pc_nodes_b D

440: WHERE C.unit_item_id = B.inventory_item_id
441:
442: AND C.association_type_flag = 'I'
443: AND EXISTS (SELECT 'X'
444: FROM ahl_pc_nodes_b D
445: WHERE D.pc_node_id = C.pc_node_id
446: START WITH D.pc_node_id = c_pc_node_id
447: CONNECT BY D.parent_node_id= PRIOR D.pc_node_id)
448: )

Line 462: FROM ahl_pc_nodes_b C

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

Line 480: FROM ahl_pc_nodes_b C

476: FROM ahl_pc_associations B
477: WHERE B.unit_item_id = Ax.unit_config_header_id
478: AND B.association_type_flag = 'U'
479: AND EXISTS (SELECT 'X'
480: FROM ahl_pc_nodes_b C
481: WHERE C.pc_node_id = B.pc_node_id
482: START WITH C.pc_node_id = c_pc_node_id
483: CONNECT BY C.parent_node_id= PRIOR C.pc_node_id)
484: )

Line 505: FROM ahl_pc_nodes_b D

501: FROM ahl_pc_associations C
502: WHERE C.unit_item_id = B.inventory_item_id
503: AND C.association_type_flag = 'I'
504: AND EXISTS (SELECT 'X'
505: FROM ahl_pc_nodes_b D
506: WHERE D.pc_node_id = C.pc_node_id
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

Line 525: FROM ahl_pc_nodes_b C

521: FROM ahl_pc_associations B
522: WHERE B.unit_item_id = Ax.inventory_item_id
523: AND B.association_type_flag = 'I'
524: AND EXISTS (SELECT 'X'
525: FROM ahl_pc_nodes_b C
526: WHERE C.pc_node_id = B.pc_node_id
527: START WITH C.pc_node_id = c_pc_node_id
528: CONNECT BY C.parent_node_id= PRIOR C.pc_node_id)
529: )

Line 553: FROM ahl_pc_nodes_b D

549: FROM ahl_pc_associations C
550: WHERE C.unit_item_id = A.unit_config_header_id
551: AND C.association_type_flag = 'U'
552: AND EXISTS (SELECT 'X'
553: FROM ahl_pc_nodes_b D
554: WHERE D.pc_node_id = C.pc_node_id
555: START WITH D.pc_node_id = c_pc_node_id
556: CONNECT BY D.parent_node_id = PRIOR D.pc_node_id))
557: UNION

Line 574: FROM ahl_pc_nodes_b D

570: FROM ahl_pc_associations C
571: WHERE C.unit_item_id = B.inventory_item_id
572: AND C.association_type_flag = 'I'
573: AND EXISTS (SELECT 'X'
574: FROM ahl_pc_nodes_b D
575: WHERE D.pc_node_id = C.pc_node_id
576: START WITH D.pc_node_id = c_pc_node_id
577: CONNECT BY D.parent_node_id= PRIOR D.pc_node_id)));*/
578: --same as before, but include all nodes, not only top node

Line 596: FROM ahl_pc_nodes_b D

592: FROM ahl_pc_associations C
593: WHERE C.unit_item_id = A.unit_config_header_id
594: AND C.association_type_flag = 'U'
595: AND EXISTS (SELECT 'X'
596: FROM ahl_pc_nodes_b D
597: WHERE D.pc_node_id = C.pc_node_id
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

Line 620: FROM ahl_pc_nodes_b E

616: FROM ahl_pc_associations D
617: WHERE D.unit_item_id = C.unit_config_header_id
618: AND D.association_type_flag = 'U'
619: AND EXISTS (SELECT 'X'
620: FROM ahl_pc_nodes_b E
621: WHERE E.pc_node_id = D.pc_node_id
622: START WITH E.pc_node_id = c_pc_node_id
623: CONNECT BY E.parent_node_id= PRIOR E.pc_node_id)))
624: CONNECT BY object_id = PRIOR subject_id

Line 644: FROM ahl_pc_nodes_b D

640: FROM ahl_pc_associations C
641: WHERE C.unit_item_id = B.inventory_item_id
642: AND C.association_type_flag = 'I'
643: AND EXISTS (SELECT 'X'
644: FROM ahl_pc_nodes_b D
645: WHERE D.pc_node_id = C.pc_node_id
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

Line 667: FROM ahl_pc_nodes_b E

663: FROM ahl_pc_associations D
664: WHERE D.unit_item_id = C.inventory_item_id
665: AND D.association_type_flag = 'I'
666: AND EXISTS (SELECT 'X'
667: FROM ahl_pc_nodes_b E
668: WHERE E.pc_node_id = D.pc_node_id
669: START WITH E.pc_node_id = c_pc_node_id
670: CONNECT BY E.parent_node_id= PRIOR E.pc_node_id)
671: )

Line 1092: FROM ahl_pc_nodes_b B

1088: /* rewrote query for performance
1089: CURSOR validate_pc_node_csr (c_instance_id NUMBER) --amsriniv
1090: IS
1091: SELECT pc_node_id --amsriniv
1092: FROM ahl_pc_nodes_b B
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

Line 1146: FROM ahl_pc_nodes_b B

1142: UNION ALL
1143: SELECT c_instance_id
1144: FROM DUAL)
1145: SELECT 'x' --pc_node_id --amsriniv
1146: FROM ahl_pc_nodes_b B
1147: WHERE B.pc_node_id = c_pc_node_id
1148: START WITH B.pc_node_id IN (select pc_node_id
1149: from ahl_pc_associations itm, csi_item_instances csi,ii
1150: where itm.association_type_flag = 'I'