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_MC_PATH_POSITION_PVT dependencies on AHL_UNIT_CONFIG_HEADERS

Line 449: FROM ahl_unit_config_headers

445: SELECT csi.object_id
446: FROM csi_ii_relationships csi
447: WHERE csi.object_id IN
448: ( SELECT csi_item_instance_id
449: FROM ahl_unit_config_headers
450: WHERE trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
451: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1)))
452: START WITH csi.subject_id = p_csi_instance_id
453: AND CSI.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'

Line 477: ahl_unit_config_headers uch, csi_unit_instances_v csi_u

473: --
474: CURSOR get_top_unit_inst_csr (p_csi_instance_id IN NUMBER) IS
475: SELECT hdr.mc_id, hdr.version_number, rel.position_key
476: FROM ahl_mc_headers_b hdr, ahl_mc_relationships rel,
477: ahl_unit_config_headers uch, csi_unit_instances_v csi_u
478: WHERE uch.csi_item_instance_id = p_csi_instance_id
479: AND TRUNC(nvl(uch.ACTIVE_START_DATE, sysdate)) <= TRUNC(sysdate)
480: AND TRUNC(nvl(uch.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)
481: AND hdr.mc_header_id = uch.master_config_id

Line 947: FROM AHL_UNIT_CONFIG_HEADERS uch

943: --
944: --Step 0) Check instance is defined in uc headers
945: CURSOR check_instance_top_csr(p_instance_id IN NUMBER) IS
946: SELECT 'X'
947: FROM AHL_UNIT_CONFIG_HEADERS uch
948: WHERE uch.csi_item_instance_id = p_instance_id;
949:
950: --
951: --Step 1) Build the path Position table object

Line 965: FROM AHL_MC_HEADERS_B hdr, AHL_UNIT_CONFIG_HEADERS uch

961: -- initial path position mc_id and version number (mc_header_id)
962: CURSOR check_top_mc_csr (p_csi_ii_id IN NUMBER, p_mc_id IN NUMBER,
963: p_ver_num IN NUMBER) IS
964: SELECT 'X'
965: FROM AHL_MC_HEADERS_B hdr, AHL_UNIT_CONFIG_HEADERS uch
966: WHERE uch.csi_item_instance_id = p_csi_ii_id
967: AND uch.master_config_id = hdr.mc_header_id
968: AND HDR.mc_id = p_mc_id
969: AND HDR.version_number = nvl(p_ver_num, HDR.version_number);

Line 1007: FROM AHL_MC_RELATIONSHIPS rel, AHL_UNIT_CONFIG_HEADERS UCH, CSI_II_RELATIONSHIPS csi_ii

1003: AND TRUNC(nvl(CSI_II.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)
1004: AND CSI_II.POSITION_REFERENCE IS NOT NULL
1005: UNION ALL
1006: SELECT uch.csi_item_instance_id, csi_ii.object_id, TO_NUMBER(csi_ii.position_reference)
1007: FROM AHL_MC_RELATIONSHIPS rel, AHL_UNIT_CONFIG_HEADERS UCH, CSI_II_RELATIONSHIPS csi_ii
1008: WHERE UCH.master_config_id = REL.mc_header_id
1009: AND REL.parent_relationship_id is NULL
1010: AND REL.position_key = p_position_key
1011: AND uch.csi_item_instance_id = p_lowest_uc_ii_id

Line 2133: FROM ahl_unit_config_headers

2129: --
2130: --Fetch the unit and unit header info for instance
2131: CURSOR get_uc_headers_csr (p_uc_header_id IN NUMBER) IS
2132: SELECT unit_config_header_id
2133: FROM ahl_unit_config_headers
2134: START WITH unit_config_header_id = p_uc_header_id
2135: CONNECT BY PRIOR parent_uc_header_id = unit_config_header_id;
2136: --
2137: CURSOR get_header_details_csr (p_uc_header_id IN NUMBER) IS

Line 2417: FROM ahl_unit_config_headers

2413: SELECT csi.object_id
2414: FROM csi_ii_relationships csi
2415: WHERE csi.object_id IN
2416: ( SELECT csi_item_instance_id
2417: FROM ahl_unit_config_headers
2418: WHERE trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
2419: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1)))
2420: START WITH csi.subject_id = p_csi_instance_id
2421: AND CSI.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'

Line 2449: ahl_unit_config_headers uch, csi_unit_instances_v csi_u

2445: /*
2446: CURSOR get_top_unit_inst_csr (p_csi_instance_id IN NUMBER) IS
2447: SELECT hdr.mc_id, hdr.version_number, rel.position_key
2448: FROM ahl_mc_headers_b hdr, ahl_mc_relationships rel,
2449: ahl_unit_config_headers uch, csi_unit_instances_v csi_u
2450: WHERE uch.csi_item_instance_id = p_csi_instance_id
2451: AND TRUNC(nvl(uch.ACTIVE_START_DATE, sysdate)) <= TRUNC(sysdate)
2452: AND TRUNC(nvl(uch.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)
2453: AND hdr.mc_header_id = uch.master_config_id

Line 2461: ahl_unit_config_headers uch

2457: */
2458: CURSOR get_top_unit_inst_csr (p_csi_instance_id IN NUMBER) IS
2459: SELECT hdr.mc_id, hdr.version_number, rel.position_key
2460: FROM ahl_mc_headers_b hdr, ahl_mc_relationships rel,
2461: ahl_unit_config_headers uch
2462: WHERE uch.csi_item_instance_id = p_csi_instance_id
2463: AND TRUNC(nvl(uch.ACTIVE_START_DATE, sysdate)) <= TRUNC(sysdate)
2464: AND TRUNC(nvl(uch.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)
2465: AND hdr.mc_header_id = uch.master_config_id

Line 2497: FROM ahl_unit_config_headers

2493: AND RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
2494: AND TRUNC(nvl(ACTIVE_START_DATE, sysdate)) <= TRUNC(sysdate)
2495: AND TRUNC(nvl(ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)))
2496: OR mc_header_id = (SELECT master_config_id
2497: FROM ahl_unit_config_headers
2498: WHERE csi_item_instance_id = p_parent_instance_id
2499: AND TRUNC(nvl(ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)));
2500:
2501: /*

Line 2504: FROM AHL_MC_RELATIONSHIPS r, AHL_UNIT_CONFIG_HEADERS uch

2500:
2501: /*
2502: AND rel.parent_relationship_id IN
2503: ( SELECT r.relationship_id
2504: FROM AHL_MC_RELATIONSHIPS r, AHL_UNIT_CONFIG_HEADERS uch
2505: WHERE uch.csi_item_instance_id = p_parent_instance_id
2506: AND uch.master_config_id = r.mc_header_id
2507: --AND r.parent_relationship_id IS NULL
2508: --Jerry commented out the above condition on 01/14/2005 to fix bug 4090856