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

Line 41: FROM ahl_unit_config_headers U,

37: l_dummy VARCHAR2(1);
38: i NUMBER;
39: CURSOR check_installed_instance IS
40: SELECT 'x'
41: FROM ahl_unit_config_headers U,
42: ahl_mc_relationships R
43: WHERE U.master_config_id = R.mc_header_id
44: AND R.parent_relationship_id IS NULL
45: AND U.csi_item_instance_id = p_uc_parent_rec.instance_id

Line 64: FROM ahl_unit_config_headers A,

60: FROM csi_item_instances
61: WHERE instance_id = p_uc_parent_rec.instance_id;
62: CURSOR get_top_position(c_instance_id number) IS
63: SELECT B.relationship_id
64: FROM ahl_unit_config_headers A,
65: ahl_mc_relationships B
66: WHERE A.master_config_id = B.mc_header_id
67: AND B.parent_relationship_id IS NULL
68: AND A.csi_item_instance_id = c_instance_id;

Line 363: FROM ahl_unit_config_headers A,

359: SELECT A.csi_item_instance_id instance_id,
360: A.master_config_id,
361: B.relationship_id,
362: B.ata_code
363: FROM ahl_unit_config_headers A,
364: ahl_mc_relationships B
365: WHERE A.unit_config_header_id = c_uc_header_id
366: AND A.master_config_id = B.mc_header_id
367: AND B.parent_relationship_id IS NULL;

Line 481: FROM ahl_unit_config_headers A,

477: CURSOR check_sub_uc(c_instance_id NUMBER) IS
478: SELECT A.unit_config_header_id,
479: A.master_config_id,
480: B.relationship_id
481: FROM ahl_unit_config_headers A,
482: ahl_mc_relationships B
483: WHERE A.csi_item_instance_id = c_instance_id
484: AND trunc(nvl(A.active_end_date, SYSDATE+1)) > trunc(SYSDATE)
485: AND B.mc_header_id = A.master_config_id

Line 520: FROM AHL_UNIT_CONFIG_HEADERS B,

516: B.CSI_ITEM_INSTANCE_ID INSTANCE_ID,
517: A.RELATIONSHIP_ID,
518: 'I' NODE_TYPE,
519: 0 OWN_LEVEL
520: FROM AHL_UNIT_CONFIG_HEADERS B,
521: AHL_MC_RELATIONSHIPS A
522: WHERE B.UNIT_CONFIG_HEADER_ID = p_uc_header_id /*UC header id*/
523: AND B.CSI_ITEM_INSTANCE_ID = c_instance_id /*root instance id*/
524: AND A.MC_HEADER_ID = B.MASTER_CONFIG_ID

Line 555: FROM AHL_UNIT_CONFIG_HEADERS E

551: EXISTS (SELECT 'x'
552: FROM AHL_MC_RELATIONSHIPS D
553: WHERE D.RELATIONSHIP_ID = TO_NUMBER(A.POSITION_REFERENCE)
554: AND EXISTS (SELECT 'x'
555: FROM AHL_UNIT_CONFIG_HEADERS E
556: WHERE CSI_ITEM_INSTANCE_ID = A.SUBJECT_ID
557: AND TRUNC(NVL(E.ACTIVE_END_DATE, SYSDATE+1)) > TRUNC(SYSDATE)
558: )
559: AND TRUNC(NVL(D.ACTIVE_START_DATE,SYSDATE)) <= TRUNC(SYSDATE)

Line 1106: l_uc_header_all ahl_unit_config_headers%ROWTYPE;

1102: l_matched BOOLEAN;
1103: l_return_value BOOLEAN;
1104: l_transaction_type_id NUMBER;
1105: l_version_no NUMBER;
1106: l_uc_header_all ahl_unit_config_headers%ROWTYPE;
1107: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
1108: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
1109: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
1110: l_root_uc_header_id NUMBER;

Line 1120: FROM ahl_unit_config_headers

1116: CURSOR check_subuc_extra(c_instance_id NUMBER, c_top_instance_id NUMBER) IS
1117: SELECT object_id, subject_id, position_reference
1118: FROM csi_ii_relationships
1119: WHERE subject_id IN (SELECT csi_item_instance_id
1120: FROM ahl_unit_config_headers
1121: WHERE trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE))
1122: OR position_reference IS NULL
1123: START WITH subject_id = c_instance_id
1124: AND relationship_type_code = 'COMPONENT-OF'

Line 1145: FROM ahl_unit_config_headers U,

1141: C.inv_master_organization_id inventory_org_id,
1142: C.inventory_revision,
1143: C.quantity,
1144: C.unit_of_measure
1145: FROM ahl_unit_config_headers U,
1146: csi_item_instances C
1147: WHERE U.unit_config_header_id = p_uc_header_id
1148: AND trunc(nvl(U.active_end_date, SYSDATE+1)) > trunc(SYSDATE)
1149: AND U.csi_item_instance_id = C.instance_id;

Line 1221: FROM ahl_unit_config_headers A,

1217: --relationship of the sub UC's top node
1218: CURSOR check_sub_uc(c_instance_id NUMBER) IS
1219: SELECT A.master_config_id mc_header_id,
1220: B.relationship_id
1221: FROM ahl_unit_config_headers A,
1222: ahl_mc_relationships B
1223: WHERE A.csi_item_instance_id = c_instance_id
1224: AND trunc(nvl(A.active_end_date, SYSDATE+1)) > trunc(SYSDATE)
1225: AND B.mc_header_id = A.master_config_id

Line 1242: FROM ahl_unit_config_headers B,

1238: CURSOR get_non_leaf_nodes(c_instance_id NUMBER) IS
1239: SELECT TO_NUMBER(NULL) parent_instance_id, --just include the root uc node
1240: B.csi_item_instance_id instance_id,
1241: A.relationship_id
1242: FROM ahl_unit_config_headers B,
1243: ahl_mc_relationships A
1244: WHERE B.csi_item_instance_id = c_instance_id
1245: AND trunc(nvl(B.active_end_date, SYSDATE+1)) > trunc(SYSDATE)
1246: AND A.mc_header_id = B.master_config_id

Line 1514: UPDATE ahl_unit_config_headers

1510: --Update the master_config_id of p_uc_header_id to the new p_mc_header_id
1511: IF p_uc_header_id = l_root_uc_header_id THEN
1512: --For standalone no object_version_number change here because we have to update the
1513: --status for the same record after migration
1514: UPDATE ahl_unit_config_headers
1515: SET master_config_id = p_mc_header_id,
1516: last_updated_by = fnd_global.user_id,
1517: last_update_date = SYSDATE,
1518: last_update_login = fnd_global.login_id

Line 1522: UPDATE ahl_unit_config_headers

1518: last_update_login = fnd_global.login_id
1519: WHERE unit_config_header_id = p_uc_header_id
1520: AND object_version_number = l_uc_header_attr.object_version_number;
1521: ELSE
1522: UPDATE ahl_unit_config_headers
1523: SET master_config_id = p_mc_header_id,
1524: object_version_number = object_version_number + 1,
1525: last_updated_by = fnd_global.user_id,
1526: last_update_date = SYSDATE,

Line 1694: from ahl_unit_config_headers

1690: END IF;
1691: END IF;
1692: --dbms_output.put_line('l_root_uc_ovn(a)='||l_root_uc_ovn);
1693: select object_version_number into l_root_uc_ovn
1694: from ahl_unit_config_headers
1695: where unit_config_header_id = l_root_uc_header_id;
1696: --dbms_output.put_line('l_root_uc_ovn(b)='||l_root_uc_ovn);
1697:
1698: --After migration, UC(root) status change should be made.

Line 1700: UPDATE ahl_unit_config_headers

1696: --dbms_output.put_line('l_root_uc_ovn(b)='||l_root_uc_ovn);
1697:
1698: --After migration, UC(root) status change should be made.
1699: IF (l_evaluation_status = 'T' AND l_root_uc_status_code = 'INCOMPLETE') THEN
1700: UPDATE ahl_unit_config_headers
1701: SET unit_config_status_code = 'COMPLETE',
1702: active_uc_status_code = 'UNAPPROVED',
1703: object_version_number = object_version_number + 1,
1704: last_updated_by = fnd_global.user_id,

Line 1723: UPDATE ahl_unit_config_headers

1719: FND_MESSAGE.set_name('AHL', 'AHL_UC_HISTORY_COPY_FAILED');
1720: FND_MSG_PUB.add;
1721: END IF;
1722: ELSIF (l_evaluation_status = 'F' AND l_root_uc_status_code = 'COMPLETE') THEN
1723: UPDATE ahl_unit_config_headers
1724: SET unit_config_status_code = 'INCOMPLETE',
1725: active_uc_status_code = 'UNAPPROVED',
1726: object_version_number = object_version_number + 1,
1727: last_updated_by = fnd_global.user_id,

Line 1748: UPDATE ahl_unit_config_headers

1744: END IF;
1745: ELSIF (l_root_uc_status_code IN ('COMPLETE', 'INCOMPLETE') AND
1746: (l_root_active_uc_status_code IS NULL OR
1747: l_root_active_uc_status_code <> 'UNAPPROVED')) THEN
1748: UPDATE ahl_unit_config_headers
1749: SET active_uc_status_code = 'UNAPPROVED',
1750: object_version_number = object_version_number + 1,
1751: last_updated_by = fnd_global.user_id,
1752: last_update_date = SYSDATE,

Line 1874: FROM ahl_unit_config_headers

1870: CURSOR check_subuc_extra(c_instance_id NUMBER, c_top_instance_id NUMBER) IS
1871: SELECT object_id, subject_id, position_reference
1872: FROM csi_ii_relationships
1873: WHERE subject_id IN (SELECT csi_item_instance_id
1874: FROM ahl_unit_config_headers
1875: WHERE trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE))
1876: OR position_reference IS NULL
1877: START WITH subject_id = c_instance_id
1878: AND relationship_type_code = 'COMPONENT-OF'

Line 1906: FROM ahl_unit_config_headers

1902: AND R.relationship_type_code = 'COMPONENT-OF'
1903: AND trunc(nvl(R.active_start_date,SYSDATE)) <= trunc(SYSDATE)
1904: AND trunc(nvl(R.active_end_date, SYSDATE+1)) > trunc(SYSDATE)
1905: AND NOT EXISTS (SELECT 'X'
1906: FROM ahl_unit_config_headers
1907: WHERE csi_item_instance_id = R.object_id
1908: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE));
1909: l_check_uc_instance check_uc_instance%ROWTYPE;
1910: --Check the given relationship_id exists and also get its item

Line 1970: FROM ahl_unit_config_headers A,

1966: --relationship of the sub UC's top node
1967: CURSOR check_sub_uc(c_instance_id NUMBER) IS
1968: SELECT A.master_config_id mc_header_id,
1969: B.relationship_id
1970: FROM ahl_unit_config_headers A,
1971: ahl_mc_relationships B
1972: WHERE A.csi_item_instance_id = c_instance_id
1973: AND trunc(nvl(A.active_end_date, SYSDATE+1)) > trunc(SYSDATE)
1974: AND B.mc_header_id = A.master_config_id

Line 2283: FROM ahl_unit_config_headers

2279: AND position_reference IS NULL
2280: AND trunc(nvl(active_start_date,SYSDATE)) <= trunc(SYSDATE)
2281: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE)
2282: AND NOT EXISTS (SELECT 'X'
2283: FROM ahl_unit_config_headers
2284: WHERE csi_item_instance_id = subject_id
2285: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE));
2286:
2287: -- Get all the children of the current instance that are NOT extra nodes

Line 2297: FROM ahl_unit_config_headers

2293: AND position_reference IS NOT NULL
2294: AND trunc(nvl(active_start_date,SYSDATE)) <= trunc(SYSDATE)
2295: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE)
2296: AND NOT EXISTS (SELECT 'X'
2297: FROM ahl_unit_config_headers
2298: WHERE csi_item_instance_id = subject_id
2299: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE));
2300:
2301: -- Validate that the child position is still valid under the parent position