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 257: FROM ahl_pc_associations C

253: AND sysdate between trunc(nvl(b.active_start_date,sysdate))
254: and trunc(nvl(b.active_end_date,sysdate+1))
255: AND B.inventory_item_id = c_inventory_item_id)
256: AND EXISTS (SELECT 'X'
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

Line 277: FROM ahl_pc_associations C

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'
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

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 336: FROM ahl_pc_associations C

332: WHERE B.instance_id = Api.csi_item_instance_id
333: AND sysdate between trunc(nvl(b.active_start_date,sysdate)) and trunc(nvl(b.active_end_date,sysdate+1))
334: AND B.inventory_item_id = c_inventory_item_id)
335: AND EXISTS (SELECT 'X'
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

Line 359: FROM ahl_pc_associations D

355: AND B.inventory_item_id = c_inventory_item_id)
356: START WITH object_id IN (SELECT csi_item_instance_id
357: FROM ahl_unit_config_headers C
358: WHERE EXISTS (SELECT 'X'
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

Line 377: FROM ahl_pc_associations B

373: FROM csi_item_instances A
374: WHERE A.inventory_item_id = c_inventory_item_id
375: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
376: AND EXISTS (SELECT 'X'
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

Line 399: FROM ahl_pc_associations D

395: )
396: START WITH object_id IN (SELECT C.instance_id
397: FROM csi_item_instances C
398: WHERE EXISTS (SELECT 'X'
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

Line 420: FROM ahl_pc_associations B

416: and a.csi_item_instance_id=api.csi_item_instance_id
417: --and A.master_config_id=api.position_id
418: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
419: AND EXISTS (SELECT 'X'
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

Line 439: FROM ahl_pc_associations C

435: AND EXISTS (SELECT 'X'
436: FROM csi_item_instances B
437: WHERE B.instance_id = A.csi_item_instance_id
438: AND EXISTS (SELECT 'X'
439: FROM ahl_pc_associations C
440: WHERE C.unit_item_id = B.inventory_item_id
441:
442: AND C.association_type_flag = 'I'
443: AND EXISTS (SELECT 'X'

Line 458: FROM ahl_pc_associations B

454: WHERE api.csi_item_instance_id=a.csi_item_instance_id
455: and api.position_id=c_relationship_id
456: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
457: AND EXISTS (SELECT 'X'
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

Line 476: FROM ahl_pc_associations B

472: START WITH object_id IN (SELECT csi_item_instance_id
473: FROM ahl_unit_config_headers Ax
474: WHERE ax.csi_item_instance_id=a.subject_id AND
475: EXISTS (SELECT 'X'
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

Line 501: FROM ahl_pc_associations C

497: FROM csi_item_instances B
498: WHERE B.instance_id = api.csi_item_instance_id
499: AND SYSDATE between trunc(nvl(b.active_start_date,sysdate)) and trunc(nvl(b.active_end_date,sysdate+1))
500: AND EXISTS (SELECT 'X'
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

Line 521: FROM ahl_pc_associations B

517: FROM csi_item_instances Ax
518: WHERE SYSDATE between trunc(nvl(ax.active_start_date,sysdate)) and trunc(nvl(ax.active_end_date,sysdate+1))
519: AND instance_id=a.subject_id
520: AND EXISTS (SELECT 'X'
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

Line 549: FROM ahl_pc_associations C

545: FROM csi_item_instances B
546: WHERE B.instance_id = Api.csi_item_instance_id
547: AND B.inventory_item_id = c_inventory_item_id)
548: AND EXISTS (SELECT 'X'
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

Line 570: FROM ahl_pc_associations C

566: WHERE B.instance_id = A.csi_item_instance_id
567: AND SYSDATE between trunc(nvl(b.active_start_date,sysdate)) and trunc(nvl(b.active_end_date,sysdate+1))
568: AND B.inventory_item_id = c_inventory_item_id
569: AND EXISTS (SELECT 'X'
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

Line 592: FROM ahl_pc_associations C

588: WHERE B.instance_id = api.csi_item_instance_id
589: AND SYSDATE between trunc(nvl(b.active_start_date,sysdate)) and trunc(nvl(b.active_end_date,sysdate+1))
590: AND B.inventory_item_id = c_inventory_item_id)
591: AND EXISTS (SELECT 'X'
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

Line 616: FROM ahl_pc_associations D

612: FROM ahl_unit_config_headers C,ahl_applicable_instances api
613: WHERE c.csi_item_instance_id=api.csi_item_instance_id
614: and api.position_id=c_relationship_id and
615: EXISTS (SELECT 'X'
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

Line 640: FROM ahl_pc_associations C

636: WHERE B.instance_id = api.csi_item_instance_id
637: AND SYSDATE between trunc(nvl(b.active_start_date,sysdate)) and trunc(nvl(b.active_end_date,sysdate+1))
638: AND B.inventory_item_id = c_inventory_item_id
639: AND EXISTS (SELECT 'X'
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

Line 663: FROM ahl_pc_associations D

659: START WITH object_id IN (SELECT instance_id
660: FROM csi_item_instances C
661: WHERE SYSDATE between trunc(nvl(c.active_start_date,sysdate)) and trunc(nvl(C.active_end_date,sysdate+1))
662: AND EXISTS (SELECT 'X'
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

Line 1095: from ahl_pc_associations itm, csi_item_instances csi,

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
1097: FROM csi_ii_relationships E
1098: START WITH E.subject_id = c_instance_id
1099: AND E.relationship_type_code = 'COMPONENT-OF'

Line 1110: from ahl_pc_associations unit, ahl_unit_config_headers uc,

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

Line 1149: from ahl_pc_associations itm, csi_item_instances csi,ii

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'
1151: and itm.unit_item_id = csi.inventory_item_id
1152: and csi.instance_id = ii.object_id
1153: UNION ALL

Line 1155: from ahl_pc_associations unit, ahl_unit_config_headers uc, ii

1151: and itm.unit_item_id = csi.inventory_item_id
1152: and csi.instance_id = ii.object_id
1153: UNION ALL
1154: select pc_node_id
1155: from ahl_pc_associations unit, ahl_unit_config_headers uc, ii
1156: where unit.association_type_flag = 'U'
1157: and unit.unit_item_id = uc.unit_config_header_id
1158: and uc.csi_item_instance_id = ii.object_id)
1159: CONNECT BY B.pc_node_id = PRIOR B.parent_node_id;