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.CSI_GENERIC_GRP dependencies on CSI_II_RELATIONSHIPS

Line 12: FROM csi_ii_relationships

8: l_object_id NUMBER:= -1;
9: BEGIN
10: SELECT object_id
11: INTO l_object_id
12: FROM csi_ii_relationships
13: WHERE LEVEL = ( SELECT MAX(LEVEL)
14: FROM csi_ii_relationships
15: START WITH subject_id = p_instance_id
16: CONNECT BY subject_id = PRIOR object_id

Line 14: FROM csi_ii_relationships

10: SELECT object_id
11: INTO l_object_id
12: FROM csi_ii_relationships
13: WHERE LEVEL = ( SELECT MAX(LEVEL)
14: FROM csi_ii_relationships
15: START WITH subject_id = p_instance_id
16: CONNECT BY subject_id = PRIOR object_id
17: )
18: AND relationship_type_code = p_relationship_type_code

Line 780: FROM csi_ii_relationships

776: BEGIN
777:
778: SELECT 'Y'
779: INTO l_parent_found
780: FROM csi_ii_relationships
781: WHERE subject_id = exp_inst_rec.instance_id
782: AND relationship_type_code = 'COMPONENT_OF'
783: AND sysdate between nvl(active_start_date, sysdate -1)
784: and nvl(active_end_date, sysdate + 1);