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 52: FROM ahl_unit_config_headers U,

48: l_dummy VARCHAR2(1);
49: i NUMBER;
50: CURSOR check_installed_instance IS
51: SELECT 'x'
52: FROM ahl_unit_config_headers U,
53: ahl_mc_relationships R
54: WHERE U.master_config_id = R.mc_header_id
55: AND R.parent_relationship_id IS NULL
56: AND U.csi_item_instance_id = p_uc_parent_rec.instance_id

Line 75: FROM ahl_unit_config_headers A,

71: FROM csi_item_instances
72: WHERE instance_id = p_uc_parent_rec.instance_id;
73: CURSOR get_top_position(c_instance_id number) IS
74: SELECT B.relationship_id
75: FROM ahl_unit_config_headers A,
76: ahl_mc_relationships B
77: WHERE A.master_config_id = B.mc_header_id
78: AND B.parent_relationship_id IS NULL
79: AND A.csi_item_instance_id = c_instance_id;

Line 377: FROM ahl_unit_config_headers A,

373: SELECT A.csi_item_instance_id instance_id,
374: A.master_config_id,
375: B.relationship_id,
376: B.ata_code
377: FROM ahl_unit_config_headers A,
378: ahl_mc_relationships B
379: WHERE A.unit_config_header_id = c_uc_header_id
380: AND A.master_config_id = B.mc_header_id
381: AND B.parent_relationship_id IS NULL;

Line 495: FROM ahl_unit_config_headers A,

491: CURSOR check_sub_uc(c_instance_id NUMBER) IS
492: SELECT A.unit_config_header_id,
493: A.master_config_id,
494: B.relationship_id
495: FROM ahl_unit_config_headers A,
496: ahl_mc_relationships B
497: WHERE A.csi_item_instance_id = c_instance_id
498: AND trunc(nvl(A.active_end_date, SYSDATE+1)) > trunc(SYSDATE)
499: AND B.mc_header_id = A.master_config_id

Line 534: FROM AHL_UNIT_CONFIG_HEADERS B,

530: B.CSI_ITEM_INSTANCE_ID INSTANCE_ID,
531: A.RELATIONSHIP_ID,
532: 'I' NODE_TYPE,
533: 0 OWN_LEVEL
534: FROM AHL_UNIT_CONFIG_HEADERS B,
535: AHL_MC_RELATIONSHIPS A
536: WHERE B.UNIT_CONFIG_HEADER_ID = p_uc_header_id /*UC header id*/
537: AND B.CSI_ITEM_INSTANCE_ID = c_instance_id /*root instance id*/
538: AND A.MC_HEADER_ID = B.MASTER_CONFIG_ID

Line 569: FROM AHL_UNIT_CONFIG_HEADERS E

565: EXISTS (SELECT 'x'
566: FROM AHL_MC_RELATIONSHIPS D
567: WHERE D.RELATIONSHIP_ID = TO_NUMBER(A.POSITION_REFERENCE)
568: AND EXISTS (SELECT 'x'
569: FROM AHL_UNIT_CONFIG_HEADERS E
570: WHERE CSI_ITEM_INSTANCE_ID = A.SUBJECT_ID
571: AND TRUNC(NVL(E.ACTIVE_END_DATE, SYSDATE+1)) > TRUNC(SYSDATE)
572: )
573: AND TRUNC(NVL(D.ACTIVE_START_DATE,SYSDATE)) <= TRUNC(SYSDATE)

Line 1148: l_uc_header_all ahl_unit_config_headers%ROWTYPE;

1144: l_matched BOOLEAN;
1145: l_return_value BOOLEAN;
1146: l_transaction_type_id NUMBER;
1147: l_version_no NUMBER;
1148: l_uc_header_all ahl_unit_config_headers%ROWTYPE;
1149: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
1150: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
1151: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
1152: l_root_uc_header_id NUMBER;

Line 1162: FROM ahl_unit_config_headers

1158: CURSOR check_subuc_extra(c_instance_id NUMBER, c_top_instance_id NUMBER) IS
1159: SELECT object_id, subject_id, position_reference
1160: FROM csi_ii_relationships
1161: WHERE subject_id IN (SELECT csi_item_instance_id
1162: FROM ahl_unit_config_headers
1163: WHERE trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE))
1164: OR position_reference IS NULL
1165: START WITH subject_id = c_instance_id
1166: AND relationship_type_code = 'COMPONENT-OF'

Line 1187: FROM ahl_unit_config_headers U,

1183: C.inv_master_organization_id inventory_org_id,
1184: C.inventory_revision,
1185: C.quantity,
1186: C.unit_of_measure
1187: FROM ahl_unit_config_headers U,
1188: csi_item_instances C
1189: WHERE U.unit_config_header_id = p_uc_header_id
1190: AND trunc(nvl(U.active_end_date, SYSDATE+1)) > trunc(SYSDATE)
1191: AND U.csi_item_instance_id = C.instance_id;

Line 1263: FROM ahl_unit_config_headers A,

1259: --relationship of the sub UC's top node
1260: CURSOR check_sub_uc(c_instance_id NUMBER) IS
1261: SELECT A.master_config_id mc_header_id,
1262: B.relationship_id
1263: FROM ahl_unit_config_headers A,
1264: ahl_mc_relationships B
1265: WHERE A.csi_item_instance_id = c_instance_id
1266: AND trunc(nvl(A.active_end_date, SYSDATE+1)) > trunc(SYSDATE)
1267: AND B.mc_header_id = A.master_config_id

Line 1284: FROM ahl_unit_config_headers B,

1280: CURSOR get_non_leaf_nodes(c_instance_id NUMBER) IS
1281: SELECT TO_NUMBER(NULL) parent_instance_id, --just include the root uc node
1282: B.csi_item_instance_id instance_id,
1283: A.relationship_id
1284: FROM ahl_unit_config_headers B,
1285: ahl_mc_relationships A
1286: WHERE B.csi_item_instance_id = c_instance_id
1287: AND trunc(nvl(B.active_end_date, SYSDATE+1)) > trunc(SYSDATE)
1288: AND A.mc_header_id = B.master_config_id

Line 1577: UPDATE ahl_unit_config_headers

1573: --Update the master_config_id of p_uc_header_id to the new p_mc_header_id
1574: IF p_uc_header_id = l_root_uc_header_id THEN
1575: --For standalone no object_version_number change here because we have to update the
1576: --status for the same record after migration
1577: UPDATE ahl_unit_config_headers
1578: SET master_config_id = p_mc_header_id,
1579: last_updated_by = fnd_global.user_id,
1580: last_update_date = SYSDATE,
1581: last_update_login = fnd_global.login_id

Line 1585: UPDATE ahl_unit_config_headers

1581: last_update_login = fnd_global.login_id
1582: WHERE unit_config_header_id = p_uc_header_id
1583: AND object_version_number = l_uc_header_attr.object_version_number;
1584: ELSE
1585: UPDATE ahl_unit_config_headers
1586: SET master_config_id = p_mc_header_id,
1587: object_version_number = object_version_number + 1,
1588: last_updated_by = fnd_global.user_id,
1589: last_update_date = SYSDATE,

Line 1757: from ahl_unit_config_headers

1753: END IF;
1754: END IF;
1755: --dbms_output.put_line('l_root_uc_ovn(a)='||l_root_uc_ovn);
1756: select object_version_number into l_root_uc_ovn
1757: from ahl_unit_config_headers
1758: where unit_config_header_id = l_root_uc_header_id;
1759: --dbms_output.put_line('l_root_uc_ovn(b)='||l_root_uc_ovn);
1760:
1761: --After migration, UC(root) status change should be made.

Line 1763: UPDATE ahl_unit_config_headers

1759: --dbms_output.put_line('l_root_uc_ovn(b)='||l_root_uc_ovn);
1760:
1761: --After migration, UC(root) status change should be made.
1762: IF (l_evaluation_status = 'T' AND l_root_uc_status_code = 'INCOMPLETE') THEN
1763: UPDATE ahl_unit_config_headers
1764: SET unit_config_status_code = 'COMPLETE',
1765: active_uc_status_code = 'UNAPPROVED',
1766: object_version_number = object_version_number + 1,
1767: last_updated_by = fnd_global.user_id,

Line 1786: UPDATE ahl_unit_config_headers

1782: FND_MESSAGE.set_name('AHL', 'AHL_UC_HISTORY_COPY_FAILED');
1783: FND_MSG_PUB.add;
1784: END IF;
1785: ELSIF (l_evaluation_status = 'F' AND l_root_uc_status_code = 'COMPLETE') THEN
1786: UPDATE ahl_unit_config_headers
1787: SET unit_config_status_code = 'INCOMPLETE',
1788: active_uc_status_code = 'UNAPPROVED',
1789: object_version_number = object_version_number + 1,
1790: last_updated_by = fnd_global.user_id,

Line 1811: UPDATE ahl_unit_config_headers

1807: END IF;
1808: ELSIF (l_root_uc_status_code IN ('COMPLETE', 'INCOMPLETE') AND
1809: (l_root_active_uc_status_code IS NULL OR
1810: l_root_active_uc_status_code <> 'UNAPPROVED')) THEN
1811: UPDATE ahl_unit_config_headers
1812: SET active_uc_status_code = 'UNAPPROVED',
1813: object_version_number = object_version_number + 1,
1814: last_updated_by = fnd_global.user_id,
1815: last_update_date = SYSDATE,

Line 1937: FROM ahl_unit_config_headers

1933: CURSOR check_subuc_extra(c_instance_id NUMBER, c_top_instance_id NUMBER) IS
1934: SELECT object_id, subject_id, position_reference
1935: FROM csi_ii_relationships
1936: WHERE subject_id IN (SELECT csi_item_instance_id
1937: FROM ahl_unit_config_headers
1938: WHERE trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE))
1939: OR position_reference IS NULL
1940: START WITH subject_id = c_instance_id
1941: AND relationship_type_code = 'COMPONENT-OF'

Line 1969: FROM ahl_unit_config_headers

1965: AND R.relationship_type_code = 'COMPONENT-OF'
1966: AND trunc(nvl(R.active_start_date,SYSDATE)) <= trunc(SYSDATE)
1967: AND trunc(nvl(R.active_end_date, SYSDATE+1)) > trunc(SYSDATE)
1968: AND NOT EXISTS (SELECT 'X'
1969: FROM ahl_unit_config_headers
1970: WHERE csi_item_instance_id = R.object_id
1971: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE));
1972: l_check_uc_instance check_uc_instance%ROWTYPE;
1973: --Check the given relationship_id exists and also get its item

Line 2033: FROM ahl_unit_config_headers A,

2029: --relationship of the sub UC's top node
2030: CURSOR check_sub_uc(c_instance_id NUMBER) IS
2031: SELECT A.master_config_id mc_header_id,
2032: B.relationship_id
2033: FROM ahl_unit_config_headers A,
2034: ahl_mc_relationships B
2035: WHERE A.csi_item_instance_id = c_instance_id
2036: AND trunc(nvl(A.active_end_date, SYSDATE+1)) > trunc(SYSDATE)
2037: AND B.mc_header_id = A.master_config_id

Line 2346: FROM ahl_unit_config_headers

2342: AND position_reference IS NULL
2343: AND trunc(nvl(active_start_date,SYSDATE)) <= trunc(SYSDATE)
2344: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE)
2345: AND NOT EXISTS (SELECT 'X'
2346: FROM ahl_unit_config_headers
2347: WHERE csi_item_instance_id = subject_id
2348: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE));
2349:
2350: -- Get all the children of the current instance that are NOT extra nodes

Line 2360: FROM ahl_unit_config_headers

2356: AND position_reference IS NOT NULL
2357: AND trunc(nvl(active_start_date,SYSDATE)) <= trunc(SYSDATE)
2358: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE)
2359: AND NOT EXISTS (SELECT 'X'
2360: FROM ahl_unit_config_headers
2361: WHERE csi_item_instance_id = subject_id
2362: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE));
2363:
2364: -- Validate that the child position is still valid under the parent position