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 213: FROM csi_ii_relationships

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

Line 4194: FROM AHL_MC_RELATIONSHIPS rel, CSI_II_RELATIONSHIPS CSI

4190: WHERE part_change_id = p_part_change_id;
4191: --
4192: CURSOR get_pos_mandatory_csr(p_instance_id IN NUMBER) IS
4193: SELECT rel.position_necessity_code
4194: FROM AHL_MC_RELATIONSHIPS rel, CSI_II_RELATIONSHIPS CSI
4195: WHERE csi.subject_id = p_instance_id
4196: AND rel.relationship_id = TO_NUMBER(CSI.position_reference)
4197: AND CSI.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
4198: AND TRUNC(nvl(CSI.ACTIVE_START_DATE, sysdate-1)) < TRUNC(sysdate)

Line 4807: FROM csi_ii_relationships

4803: IS
4804:
4805: CURSOR get_root_instance_csr(p_instance_id IN NUMBER) IS
4806: SELECT object_id
4807: FROM csi_ii_relationships
4808: START WITH subject_id = p_instance_id
4809: AND relationship_type_code = 'COMPONENT-OF'
4810: AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)
4811: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE)

Line 4818: SELECT 'x' FROM csi_ii_relationships

4814: AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)
4815: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
4816:
4817: CURSOR is_non_root_csr(p_instance_id NUMBER) IS
4818: SELECT 'x' FROM csi_ii_relationships
4819: WHERE subject_id = p_instance_id
4820: AND relationship_type_code = 'COMPONENT-OF'
4821: AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)
4822: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);

Line 4876: FROM csi_ii_relationships

4872: FUNCTION root_node_in_uc_headers(p_instance_id IN NUMBER) RETURN BOOLEAN
4873: IS
4874: CURSOR get_root_node(c_instance_id NUMBER) IS
4875: SELECT object_id
4876: FROM csi_ii_relationships
4877: START WITH subject_id = c_instance_id
4878: AND relationship_type_code = 'COMPONENT-OF'
4879: AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)
4880: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE)

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

4889: FROM ahl_unit_config_headers
4890: WHERE csi_item_instance_id = c_instance_id
4891: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
4892:
4893: TYPE objectid_tbl IS TABLE OF csi_ii_relationships.object_id%TYPE;
4894: l_object_id_tbl objectid_tbl;
4895: l_instance_id NUMBER;
4896: l_unit_instance_id NUMBER;
4897: l_api_name CONSTANT VARCHAR2(30) := 'root_node_in_uc_headers';