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 2186: (SELECT 'X' FROM CSI_II_RELATIONSHIPS CIR

2182: SELECT 1
2183: FROM CSI_ITEM_INSTANCES CII
2184: WHERE CII.INSTANCE_ID = p_csi_ii_id AND
2185: NOT EXISTS
2186: (SELECT 'X' FROM CSI_II_RELATIONSHIPS CIR
2187: WHERE CIR.SUBJECT_ID = CII.INSTANCE_ID AND
2188: CIR.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF' AND
2189: NVL(CIR.ACTIVE_START_DATE, SYSDATE - 1) < SYSDATE AND
2190: NVL(CIR.ACTIVE_END_DATE, SYSDATE + 1) > SYSDATE);

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

4722: CURSOR val_exg_instance_id_csr(p_instance_id IN NUMBER) IS
4723: SELECT 'x' FROM csi_item_instances csi
4724: WHERE instance_id = p_instance_id
4725: AND nvl(csi.active_end_date, sysdate + 1) > sysdate
4726: AND NOT EXISTS (select subject_id from csi_ii_relationships where
4727: subject_id = p_instance_id and
4728: relationship_type_code = 'COMPONENT-OF' and
4729: NVL(ACTIVE_START_DATE, SYSDATE - 1) < SYSDATE AND
4730: NVL(ACTIVE_END_DATE, SYSDATE + 1) > SYSDATE