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

Line 2151: (SELECT 'X' FROM CSI_II_RELATIONSHIPS CIR

2147: SELECT 1
2148: FROM CSI_ITEM_INSTANCES CII
2149: WHERE CII.INSTANCE_ID = p_csi_ii_id AND
2150: NOT EXISTS
2151: (SELECT 'X' FROM CSI_II_RELATIONSHIPS CIR
2152: WHERE CIR.SUBJECT_ID = CII.INSTANCE_ID AND
2153: CIR.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF' AND
2154: NVL(CIR.ACTIVE_START_DATE, SYSDATE - 1) < SYSDATE AND
2155: NVL(CIR.ACTIVE_END_DATE, SYSDATE + 1) > SYSDATE);

Line 4681: AND NOT EXISTS (select subject_id from csi_ii_relationships where

4677: CURSOR val_exg_instance_id_csr(p_instance_id IN NUMBER) IS
4678: SELECT 'x' FROM csi_item_instances csi
4679: WHERE instance_id = p_instance_id
4680: AND nvl(csi.active_end_date, sysdate + 1) > sysdate
4681: AND NOT EXISTS (select subject_id from csi_ii_relationships where
4682: subject_id = p_instance_id and
4683: relationship_type_code = 'COMPONENT-OF' and
4684: NVL(ACTIVE_START_DATE, SYSDATE - 1) < SYSDATE AND
4685: NVL(ACTIVE_END_DATE, SYSDATE + 1) > SYSDATE