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 134: FROM ahl_unit_config_headers A

130: --get unit_name and uc_header_id for an item instance
131: /*
132: CURSOR get_uc_header(c_instance_id NUMBER) IS
133: SELECT unit_config_header_id, name
134: FROM ahl_unit_config_headers A
135: WHERE csi_item_instance_id = c_instance_id
136: OR EXISTS (SELECT 'X'
137: FROM csi_ii_relationships B
138: WHERE B.object_id = A.csi_item_instance_id

Line 170: FROM ahl_unit_config_headers a,ahl_applicable_instances b

166:
167: /*CURSOR get_top_inst2(c_relationship_id NUMBER)
168: IS
169: SELECT a.csi_item_instance_id instance_id
170: FROM ahl_unit_config_headers a,ahl_applicable_instances b
171: WHERE a.csi_item_instance_id=b.csi_item_instance_id
172: and a.master_config_id=b.position_id
173: AND b.position_id=c_relationship_id
174: and SYSDATE between trunc(nvl(A.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))

Line 185: FROM ahl_unit_config_headers a,ahl_applicable_instances b

181: --same as before, but include all nodes, not only top node
182: CURSOR get_inst2(c_relationship_id NUMBER)
183: IS
184: SELECT a.csi_item_instance_id instance_id
185: FROM ahl_unit_config_headers a,ahl_applicable_instances b
186: WHERE a.csi_item_instance_id=b.csi_item_instance_id
187: and b.position_id= c_relationship_id
188: AND SYSDATE between trunc(nvl(A.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
189: UNION

Line 203: FROM ahl_unit_config_headers A,ahl_applicable_instances api

199: --top node
200: /*CURSOR get_top_inst3(c_relationship_id NUMBER, c_inventory_item_id NUMBER)
201: IS
202: SELECT a.csi_item_instance_id instance_id
203: FROM ahl_unit_config_headers A,ahl_applicable_instances api
204: --WHERE A.master_config_id=api.position_id
205: --AND A.csi_item_instance_id=api.csi_item_instance_id
206: WHERE A.csi_item_instance_id=api.csi_item_instance_id
207: AND api.position_id= C_RELATIONSHIP_ID

Line 220: FROM ahl_unit_config_headers A,ahl_applicable_instances api

216: --same as before, but include all nodes, not only top node
217: CURSOR get_inst3(c_relationship_id NUMBER, c_inventory_item_id NUMBER)
218: IS
219: SELECT a.csi_item_instance_id instance_id
220: FROM ahl_unit_config_headers A,ahl_applicable_instances api
221: WHERE A.csi_item_instance_id=api.csi_item_instance_id
222: AND api.position_id=c_relationship_id
223: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate))
224: and trunc(nvl(a.active_end_date,sysdate+1))

Line 249: FROM ahl_unit_config_headers A

245: --inventory item and PC node defined in MR effectivity definition, just top node
246: /*CURSOR get_top_inst4(c_inventory_item_id NUMBER, c_pc_node_id NUMBER)
247: IS
248: SELECT a.csi_item_instance_id instance_id
249: FROM ahl_unit_config_headers A
250: WHERE EXISTS (SELECT 'X'
251: FROM csi_item_instances B
252: WHERE B.instance_id = A.csi_item_instance_id
253: AND sysdate between trunc(nvl(b.active_start_date,sysdate))

Line 289: FROM ahl_unit_config_headers A

285: -- same as before, but include all nodes, not only top node
286:
287: CURSOR get_inst4(c_inventory_item_id NUMBER, c_pc_node_id NUMBER) 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 327: FROM ahl_unit_config_headers A,ahl_applicable_instances api

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
326: SELECT a.csi_item_instance_id instance_id
327: FROM ahl_unit_config_headers A,ahl_applicable_instances api
328: WHERE SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
329: AND a.csi_item_instance_id=api.csi_item_instance_id
330: AND EXISTS (SELECT 'X'
331: FROM csi_item_instances B

Line 357: FROM ahl_unit_config_headers C

353: WHERE B.instance_id = A.subject_id
354: AND SYSDATE between trunc(nvl(b.active_start_date,sysdate)) and trunc(nvl(b.active_end_date,sysdate+1))
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'

Line 414: FROM ahl_unit_config_headers A,ahl_applicable_instances api

410: AND a.relationship_type_code = 'COMPONENT-OF';
411: --position in MC and PC node defined in MR effectivity definition, just top node
412: /*CURSOR get_top_inst5(c_relationship_id NUMBER, c_pc_node_id NUMBER) IS
413: SELECT a.csi_item_instance_id instance_id
414: FROM ahl_unit_config_headers A,ahl_applicable_instances api
415: WHERE api.position_id = c_relationship_id
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))

Line 430: FROM ahl_unit_config_headers A,ahl_applicable_instances api

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
429: SELECT a.csi_item_instance_id instance_id
430: FROM ahl_unit_config_headers A,ahl_applicable_instances api
431: WHERE api.position_id = c_relationship_id
432: --and A.master_config_id=api.position_id
433: and api.csi_item_instance_id=a.csi_item_instance_id
434: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))

Line 453: FROM ahl_unit_config_headers A,ahl_applicable_instances api

449: );*/
450: --same as before, but include all node, not only top node
451: CURSOR get_inst5(c_relationship_id NUMBER, c_pc_node_id NUMBER) IS
452: SELECT a.csi_item_instance_id instance_id
453: FROM ahl_unit_config_headers A,ahl_applicable_instances api
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'

Line 473: FROM ahl_unit_config_headers Ax

469: WHERE relationship_type_code = 'COMPONENT-OF'
470: AND subject_id in (Select csi_item_instance_id from ahl_applicable_instances)
471: AND sysdate between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
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

Line 492: FROM ahl_unit_config_headers A,ahl_applicable_instances api

488: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
489: AND a.relationship_type_code = 'COMPONENT-OF'
490: UNION
491: SELECT a.csi_item_instance_id instance_id
492: FROM ahl_unit_config_headers A,ahl_applicable_instances api
493: WHERE api.position_id = c_relationship_id
494: and api.csi_item_instance_id= a.csi_item_instance_id
495: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
496: AND EXISTS (SELECT 'X'

Line 539: FROM ahl_unit_config_headers A,ahl_applicable_instances api

535: --all inventory item, position in MC and PC node defined in MR effectivity
536: --definition, just top node
537: /*CURSOR get_top_inst6(c_inventory_item_id NUMBER, c_relationship_id NUMBER, c_pc_node_id NUMBER) IS
538: SELECT a.csi_item_instance_id instance_id
539: FROM ahl_unit_config_headers A,ahl_applicable_instances api
540: WHERE api.position_id = c_relationship_id
541: AND api.csi_item_instance_id=A.csi_item_instance_id
542: --and A.master_config_id=api.position_id
543: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))

Line 559: FROM ahl_unit_config_headers A,ahl_applicable_instances api

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
558: SELECT a.csi_item_instance_id instance_id
559: FROM ahl_unit_config_headers A,ahl_applicable_instances api
560: WHERE Api.position_id = c_relationship_id
561: AND A.csi_item_instance_id=API.csi_item_instance_id
562: --and A.master_config_id=api.position_id
563: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))

Line 581: FROM ahl_unit_config_headers A,ahl_applicable_instances api

577: CONNECT BY D.parent_node_id= PRIOR D.pc_node_id)));*/
578: --same as before, but include all nodes, not only top node
579: CURSOR get_inst6(c_inventory_item_id NUMBER, c_relationship_id NUMBER, c_pc_node_id NUMBER) IS
580: SELECT a.csi_item_instance_id instance_id
581: FROM ahl_unit_config_headers A,ahl_applicable_instances api
582: WHERE api.position_id = c_relationship_id
583: AND api.csi_item_instance_id=A.csi_item_instance_id
584: -- AND subject_id in (Select csi_item_instance_id from ahl_applicable_instances)
585: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))

Line 612: FROM ahl_unit_config_headers C,ahl_applicable_instances api

608: WHERE B.instance_id = A.subject_id
609: AND SYSDATE between trunc(nvl(b.active_start_date,sysdate)) and trunc(nvl(b.active_end_date,sysdate+1))
610: AND B.inventory_item_id = c_inventory_item_id)
611: START WITH object_id IN (SELECT c.csi_item_instance_id
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

Line 630: FROM ahl_unit_config_headers A,ahl_applicable_instances api

626: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
627: AND a.relationship_type_code = 'COMPONENT-OF'
628: UNION
629: SELECT a.csi_item_instance_id instance_id
630: FROM ahl_unit_config_headers A,ahl_applicable_instances api
631: WHERE api.position_id = c_relationship_id
632: AND A.csi_item_instance_id=API.csi_item_instance_id
633: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
634: AND EXISTS (SELECT 'X'

Line 1078: FROM ahl_unit_config_headers a

1074: SELECT --NULL parent_item_instance_id,
1075: --a.csi_item_instance_id,
1076: --a.master_config_id,
1077: a.unit_config_header_id
1078: FROM ahl_unit_config_headers a
1079: WHERE a.csi_item_instance_id = c_item_instance_id
1080: /* Fix for bug#4052646
1081: * AND a.parent_uc_header_id is not null -- Line commented
1082: */

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

Line 1205: from csi_item_instances cii2, csi_ii_relationships cir2, ahl_unit_config_headers uc

1201: (select cir2.object_id,
1202: cii2.instance_id subject_id,
1203: nvl(uc.master_config_id, cir2.position_reference) position_reference,
1204: 0 depth
1205: from csi_item_instances cii2, csi_ii_relationships cir2, ahl_unit_config_headers uc
1206: where cii2.instance_id = c_instance_id
1207: and cii2.instance_id = cir2.subject_id(+)
1208: and cii2.instance_id = uc.csi_item_instance_id(+)
1209: and uc.parent_uc_header_id(+) is null

Line 1244: from csi_item_instances cii2 --, csi_ii_relationships cir2, ahl_unit_config_headers uc

1240: cii2.instance_id subject_id,
1241: --nvl(uc.master_config_id, cir2.position_reference) position_reference,
1242: 0 depth,
1243: cii2.inventory_item_id
1244: from csi_item_instances cii2 --, csi_ii_relationships cir2, ahl_unit_config_headers uc
1245: where cii2.instance_id = c_instance_id
1246: --and cii2.instance_id = cir2.subject_id(+)
1247: --and cii2.instance_id = uc.csi_item_instance_id(+)
1248: --and uc.parent_uc_header_id(+) is null

Line 1444: from csi_item_instances cii2, csi_ii_relationships cir2, ahl_unit_config_headers uc

1440: (select cir2.object_id,
1441: cii2.instance_id subject_id,
1442: nvl(uc.master_config_id, cir2.position_reference) position_reference,
1443: 0 depth
1444: from csi_item_instances cii2, csi_ii_relationships cir2, ahl_unit_config_headers uc
1445: where cii2.instance_id = c_instance_id
1446: and cii2.instance_id = cir2.subject_id(+)
1447: and cii2.instance_id = uc.csi_item_instance_id(+)
1448: and uc.parent_uc_header_id(+) is null

Line 1473: from csi_item_instances cii2 --, csi_ii_relationships cir2, ahl_unit_config_headers uc

1469: cii2.instance_id subject_id,
1470: --nvl(uc.master_config_id, cir2.position_reference) position_reference,
1471: 0 depth,
1472: cii2.inventory_item_id
1473: from csi_item_instances cii2 --, csi_ii_relationships cir2, ahl_unit_config_headers uc
1474: where cii2.instance_id = c_instance_id
1475: --and cii2.instance_id = cir2.subject_id(+)
1476: --and cii2.instance_id = uc.csi_item_instance_id(+)
1477: --and uc.parent_uc_header_id(+) is null

Line 2329: FROM ahl_unit_config_headers

2325: IS
2326: -- Get ucHeader for component
2327: CURSOR get_unit_name_com (p_item_instance_id IN NUMBER) IS
2328: SELECT unit_config_header_id, name
2329: FROM ahl_unit_config_headers
2330: WHERE csi_item_instance_id IN ( SELECT object_id
2331: FROM csi_ii_relationships
2332: START WITH subject_id = p_item_instance_id
2333: AND relationship_type_code = 'COMPONENT-OF'

Line 2347: FROM ahl_unit_config_headers

2343:
2344: -- Get ucHeader for top node
2345: CURSOR get_unit_name_top (p_item_instance_id IN NUMBER) IS
2346: SELECT unit_config_header_id, name
2347: FROM ahl_unit_config_headers
2348: WHERE csi_item_instance_id = p_item_instance_id
2349: AND sysdate between trunc(nvl(active_start_date,sysdate))
2350: AND trunc(nvl(active_end_date, SYSDATE+1));
2351:

Line 2540: FROM ahl_unit_config_headers

2536: SELECT csi.object_id
2537: FROM csi_ii_relationships csi
2538: WHERE csi.object_id IN
2539: (SELECT csi_item_instance_id
2540: FROM ahl_unit_config_headers
2541: WHERE trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
2542: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
2543: )
2544: START WITH csi.subject_id = c_csi_instance_id

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

2558: WHERE up.csi_instance_id = c_csi_instance_id;
2559:
2560: CURSOR get_top_unit_inst_csr (c_csi_instance_id IN NUMBER) IS
2561: SELECT hdr.mc_id, hdr.version_number, rel.position_key
2562: FROM ahl_mc_headers_b hdr, ahl_mc_relationships rel, ahl_unit_config_headers uch
2563: WHERE uch.csi_item_instance_id = c_csi_instance_id
2564: AND TRUNC(nvl(uch.ACTIVE_START_DATE, sysdate)) <= TRUNC(sysdate)
2565: AND TRUNC(nvl(uch.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)
2566: AND hdr.mc_header_id = uch.master_config_id