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_PRD_DISPOSITION_PVT dependencies on CSI_II_RELATIONSHIPS

Line 215: FROM csi_ii_relationships

211: WHERE csi_item_instance_id = c_instance_id
212: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
213: CURSOR get_sub_unit_instance(c_instance_id NUMBER) IS
214: SELECT object_id
215: FROM csi_ii_relationships
216: WHERE object_id IN (SELECT csi_item_instance_id
217: FROM ahl_unit_config_headers
218: WHERE trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE))
219: START WITH subject_id = c_instance_id

Line 4654: FROM AHL_MC_RELATIONSHIPS rel, CSI_II_RELATIONSHIPS CSI

4650: WHERE part_change_id = p_part_change_id;
4651: --
4652: CURSOR get_pos_mandatory_csr(p_instance_id IN NUMBER) IS
4653: SELECT rel.position_necessity_code
4654: FROM AHL_MC_RELATIONSHIPS rel, CSI_II_RELATIONSHIPS CSI
4655: WHERE csi.subject_id = p_instance_id
4656: AND rel.relationship_id = TO_NUMBER(CSI.position_reference)
4657: AND CSI.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
4658: AND TRUNC(nvl(CSI.ACTIVE_START_DATE, sysdate-1)) < TRUNC(sysdate)

Line 5267: FROM csi_ii_relationships

5263: IS
5264:
5265: CURSOR get_root_instance_csr(p_instance_id IN NUMBER) IS
5266: SELECT object_id
5267: FROM csi_ii_relationships
5268: START WITH subject_id = p_instance_id
5269: AND relationship_type_code = 'COMPONENT-OF'
5270: AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)
5271: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE)

Line 5278: SELECT 'x' FROM csi_ii_relationships

5274: AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)
5275: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
5276:
5277: CURSOR is_non_root_csr(p_instance_id NUMBER) IS
5278: SELECT 'x' FROM csi_ii_relationships
5279: WHERE subject_id = p_instance_id
5280: AND relationship_type_code = 'COMPONENT-OF'
5281: AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)
5282: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);

Line 5336: FROM csi_ii_relationships

5332: FUNCTION root_node_in_uc_headers(p_instance_id IN NUMBER) RETURN BOOLEAN
5333: IS
5334: CURSOR get_root_node(c_instance_id NUMBER) IS
5335: SELECT object_id
5336: FROM csi_ii_relationships
5337: START WITH subject_id = c_instance_id
5338: AND relationship_type_code = 'COMPONENT-OF'
5339: AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)
5340: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE)

Line 5353: TYPE objectid_tbl IS TABLE OF csi_ii_relationships.object_id%TYPE;

5349: FROM ahl_unit_config_headers
5350: WHERE csi_item_instance_id = c_instance_id
5351: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
5352:
5353: TYPE objectid_tbl IS TABLE OF csi_ii_relationships.object_id%TYPE;
5354: l_object_id_tbl objectid_tbl;
5355: l_instance_id NUMBER;
5356: l_unit_instance_id NUMBER;
5357: l_api_name CONSTANT VARCHAR2(30) := 'root_node_in_uc_headers';