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

Line 1867: FROM csi_ii_relationships

1863: THEN
1864: BEGIN
1865: SELECT subject_id
1866: INTO l_dummy
1867: FROM csi_ii_relationships
1868: WHERE object_id = p_instance_id
1869: AND nvl(active_end_date,(sysdate+1)) > sysdate -- rajeevk Bug#5686753
1870: and rownum < 2; -- srramakr Bug # 3647609
1871: --

Line 3381: FROM csi_ii_relationships

3377:
3378: BEGIN
3379: SELECT object_id
3380: INTO l_dummy
3381: FROM csi_ii_relationships
3382: WHERE subject_id = p_instance_id
3383: AND relationship_type_code = 'COMPONENT-OF'
3384: AND nvl(active_end_date,(sysdate+1)) > sysdate;
3385:

Line 3625: FROM csi_ii_relationships

3621: ELSIF p_quantity > 1 THEN
3622: BEGIN
3623: SELECT subject_id
3624: INTO l_dummy
3625: FROM csi_ii_relationships
3626: WHERE object_id = p_instance_id;
3627: IF SQL%FOUND THEN
3628: l_return_value := FALSE;
3629: IF (p_stack_err_msg = TRUE) THEN

Line 4167: FROM csi_ii_relationships

4163: BEGIN
4164:
4165: SELECT '1'
4166: INTO l_dummy
4167: FROM csi_ii_relationships
4168: WHERE object_id = p_instance_id
4169: and ((active_end_date is null) or (active_end_date > sysdate))
4170: and relationship_type_code = 'COMPONENT-OF'
4171: and rownum < 2;

Line 4826: FROM csi_ii_relationships

4822: i NUMBER;
4823:
4824: CURSOR link_csr(p_instance_id NUMBER) IS
4825: SELECT object_id,subject_id
4826: FROM csi_ii_relationships
4827: WHERE ( subject_id=p_instance_id
4828: OR object_id=p_instance_id)
4829: AND relationship_type_code ='CONNECTED-TO'
4830: AND SYSDATE BETWEEN NVL(active_start_date, SYSDATE) AND NVL(active_end_date, SYSDATE);