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

1818: THEN
1819: BEGIN
1820: SELECT subject_id
1821: INTO l_dummy
1822: FROM csi_ii_relationships
1823: WHERE object_id = p_instance_id
1824: AND nvl(active_end_date,(sysdate+1)) > sysdate -- rajeevk Bug#5686753
1825: and rownum < 2; -- srramakr Bug # 3647609
1826: --

Line 3329: FROM csi_ii_relationships

3325:
3326: BEGIN
3327: SELECT object_id
3328: INTO l_dummy
3329: FROM csi_ii_relationships
3330: WHERE subject_id = p_instance_id
3331: AND relationship_type_code = 'COMPONENT-OF'
3332: AND nvl(active_end_date,(sysdate+1)) > sysdate;
3333:

Line 3546: FROM csi_ii_relationships

3542: ELSIF p_quantity > 1 THEN
3543: BEGIN
3544: SELECT subject_id
3545: INTO l_dummy
3546: FROM csi_ii_relationships
3547: WHERE object_id = p_instance_id;
3548: IF SQL%FOUND THEN
3549: l_return_value := FALSE;
3550: IF (p_stack_err_msg = TRUE) THEN

Line 4083: FROM csi_ii_relationships

4079: BEGIN
4080:
4081: SELECT '1'
4082: INTO l_dummy
4083: FROM csi_ii_relationships
4084: WHERE object_id = p_instance_id
4085: and ((active_end_date is null) or (active_end_date > sysdate))
4086: and relationship_type_code = 'COMPONENT-OF'
4087: and rownum < 2;

Line 4740: FROM csi_ii_relationships

4736: i NUMBER;
4737:
4738: CURSOR link_csr(p_instance_id NUMBER) IS
4739: SELECT object_id,subject_id
4740: FROM csi_ii_relationships
4741: WHERE ( subject_id=p_instance_id
4742: OR object_id=p_instance_id)
4743: AND relationship_type_code ='CONNECTED-TO'
4744: AND SYSDATE BETWEEN NVL(active_start_date, SYSDATE) AND NVL(active_end_date, SYSDATE);