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_APPLICABLE_INSTANCES

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 191: FROM csi_ii_relationships a,ahl_applicable_instances b

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
190: SELECT a.subject_id instance_id
191: FROM csi_ii_relationships a,ahl_applicable_instances b
192: WHERE a.subject_id=b.csi_item_instance_id
193: and b.position_id=c_relationship_id
194: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
195: AND a.relationship_type_code = 'COMPONENT-OF';

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 233: FROM csi_ii_relationships A,ahl_applicable_instances api

229: and trunc(nvl(b.active_end_date,sysdate+1))
230: AND inventory_item_id = c_inventory_item_id)
231: UNION
232: SELECT subject_id instance_id
233: FROM csi_ii_relationships A,ahl_applicable_instances api
234: WHERE api.position_id=c_relationship_id
235: and api.csi_item_instance_id=a.subject_id
236: AND relationship_type_code = 'COMPONENT-OF'
237: AND SYSDATE between trunc(nvl(a.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 349: AND A.SUBJECT_id IN (SELECT csi_item_instance_id from ahl_applicable_instances

345: SELECT a.subject_id instance_id
346: FROM csi_ii_relationships A
347: WHERE relationship_type_code = 'COMPONENT-OF'
348: AND sysdate between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
349: AND A.SUBJECT_id IN (SELECT csi_item_instance_id from ahl_applicable_instances
350: where csi_item_instance_id=a.subject_id )
351: AND EXISTS (SELECT 'X'
352: FROM csi_item_instances B
353: WHERE B.instance_id = A.subject_id

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 470: AND subject_id in (Select csi_item_instance_id from ahl_applicable_instances)

466: UNION
467: SELECT a.subject_id instance_id
468: FROM csi_ii_relationships a
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

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 513: AND subject_id in (Select csi_item_instance_id from ahl_applicable_instances)

509: UNION
510: SELECT a.subject_id instance_id
511: FROM csi_ii_relationships a
512: WHERE a.relationship_type_code = 'COMPONENT-OF'
513: AND subject_id in (Select csi_item_instance_id from ahl_applicable_instances)
514: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
515: AND subject_id in (select csi_item_instance_id from ahl_applicable_instances)
516: START WITH object_id IN (SELECT ax.instance_id
517: FROM csi_item_instances Ax

Line 515: AND subject_id in (select csi_item_instance_id from ahl_applicable_instances)

511: FROM csi_ii_relationships a
512: WHERE a.relationship_type_code = 'COMPONENT-OF'
513: AND subject_id in (Select csi_item_instance_id from ahl_applicable_instances)
514: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
515: AND subject_id in (select csi_item_instance_id from ahl_applicable_instances)
516: START WITH object_id IN (SELECT ax.instance_id
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

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 584: -- AND subject_id in (Select csi_item_instance_id from ahl_applicable_instances)

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))
586: AND EXISTS (SELECT 'X'
587: FROM csi_item_instances B
588: WHERE B.instance_id = api.csi_item_instance_id

Line 604: AND a.relationship_id in (Select position_id from AHL_APPLICABLE_INSTANCES)

600: UNION
601: SELECT a.subject_id instance_id
602: FROM csi_ii_relationships A
603: WHERE relationship_type_code = 'COMPONENT-OF'
604: AND a.relationship_id in (Select position_id from AHL_APPLICABLE_INSTANCES)
605: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
606: AND EXISTS (SELECT 'X'
607: FROM csi_item_instances B
608: WHERE B.instance_id = A.subject_id

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 652: AND a.subject_id in (Select csi_item_instance_id from AHL_APPLICABLE_INSTANCES )

648: UNION
649: SELECT subject_id instance_id
650: FROM csi_ii_relationships A
651: WHERE relationship_type_code = 'COMPONENT-OF'
652: AND a.subject_id in (Select csi_item_instance_id from AHL_APPLICABLE_INSTANCES )
653: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
654: AND EXISTS (SELECT 'X'
655: FROM csi_item_instances B
656: WHERE B.instance_id = A.subject_id

Line 699: DELETE FROM ahl_applicable_instances;

695: -- Check whether the mr_header_id exists --
696: AHL_DEBUG_PUB.debug(' Phase 1');
697:
698: DELETE FROM ahl_mr_instances_temp;
699: DELETE FROM ahl_applicable_instances;
700:
701: OPEN check_mr_exists(p_mr_header_id);
702: FETCH check_mr_exists INTO l_mr_header_id;
703: IF check_mr_exists%NOTFOUND THEN

Line 736: from ahl_applicable_instances;

732:
733: IF l_debug = 'Y' THEN
734: AHL_DEBUG_PUB.debug(' After Call to MC path positions');
735: Select count(*) into l_counter
736: from ahl_applicable_instances;
737: AHL_DEBUG_PUB.debug('Number of Recs found in ahl_applicable_instances are ...'||l_counter);
738: END IF;
739: END IF;
740: l_mr_header_id := l_mr_effect.mr_header_id;

Line 737: AHL_DEBUG_PUB.debug('Number of Recs found in ahl_applicable_instances are ...'||l_counter);

733: IF l_debug = 'Y' THEN
734: AHL_DEBUG_PUB.debug(' After Call to MC path positions');
735: Select count(*) into l_counter
736: from ahl_applicable_instances;
737: AHL_DEBUG_PUB.debug('Number of Recs found in ahl_applicable_instances are ...'||l_counter);
738: END IF;
739: END IF;
740: l_mr_header_id := l_mr_effect.mr_header_id;
741:

Line 1413: FROM ahl_applicable_instances aai,csi_item_instances cii,

1409: WHERE ciea1.instance_id = cii.instance_id AND ciea1.attribute_code = 'AHL_MFG_DATE'
1410: AND ciea1.attribute_level = 'GLOBAL') mfg_date,
1411: cii.serial_number --,
1412: --(SELECT 'Y' from ahl_mr_effectivity_dtls where mr_effectivity_id = a.mr_effectivity_id and ROWNUM < 2) eff_dtls_flag
1413: FROM ahl_applicable_instances aai,csi_item_instances cii,
1414: ahl_mr_effectivities A
1415: WHERE A.mr_header_id = NVL(c_mr_header_id, A.mr_header_id)
1416: AND A.relationship_id IS NOT NULL
1417: AND aai.position_id = A.relationship_id

Line 1627: FROM ahl_applicable_instances aai,csi_item_instances cii,ahl_mr_visit_types vis,

1623: WHERE ciea1.instance_id = cii.instance_id AND ciea1.attribute_code = 'AHL_MFG_DATE'
1624: AND ciea1.attribute_level = 'GLOBAL') mfg_date,
1625: cii.serial_number --,
1626: --(SELECT 'Y' from ahl_mr_effectivity_dtls where mr_effectivity_id = a.mr_effectivity_id and ROWNUM < 2) eff_dtls_flag
1627: FROM ahl_applicable_instances aai,csi_item_instances cii,ahl_mr_visit_types vis,
1628: ahl_mr_effectivities A
1629: WHERE A.mr_header_id = vis.mr_header_id
1630: AND vis.mr_visit_type_code = c_visit_type_code
1631: AND A.relationship_id IS NOT NULL

Line 1707: from ahl_applicable_instances

1703:
1704: -- validate patch position Id.
1705: CURSOR relationship_csr(c_instance_id IN NUMBER) IS
1706: select position_id
1707: from ahl_applicable_instances
1708: where csi_item_instance_id = c_instance_id;
1709: */
1710:
1711: /*

Line 1880: -- start processing. First populate temp table ahl_applicable_instances by calling

1876: CLOSE uc_top_inst;
1877: */
1878:
1879:
1880: -- start processing. First populate temp table ahl_applicable_instances by calling
1881: -- MC api to map instance (and components) to path positions.
1882:
1883: IF l_debug = 'Y' THEN
1884: AHL_DEBUG_PUB.debug('Start Processing..');

Line 1924: DELETE FROM ahl_applicable_instances;

1920: IF l_debug = 'Y' THEN
1921: AHL_DEBUG_PUB.debug('Processing MC Relationships..');
1922: END IF;
1923:
1924: DELETE FROM ahl_applicable_instances;
1925: -- for input instance.
1926: AHL_MC_PATH_POSITION_PVT.map_instance_to_positions
1927: (
1928: p_api_version => 1.0,

Line 2264: DELETE FROM ahl_applicable_instances;

2260: END IF;
2261:
2262: END LOOP;
2263:
2264: DELETE FROM ahl_applicable_instances;
2265:
2266: --DBMS_OUTPUT.PUT_LINE('API2: Successfully executed API2!');
2267: IF l_debug = 'Y' THEN
2268: AHL_DEBUG_PUB.debug('End private API: AHL_FMP_PVT.GET_APPLICABLE_MRS');