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_PVT dependencies on CSI_I_ASSETS_H

Line 3253: ' from csi_i_assets a, csi_i_assets_h b where a.instance_asset_id = b.instance_asset_id '||

3249: l_union_stmt VARCHAR2(2000) := ' select instance_id from csi_item_instances_h '||
3250: ' where transaction_id = :p_transaction_id UNION select a.instance_id '||
3251: ' from csi_i_parties a, csi_i_parties_h b where a.instance_party_id = b.instance_party_id '||
3252: ' and b.transaction_id = :p_transaction_id UNION select a.instance_id '||
3253: ' from csi_i_assets a, csi_i_assets_h b where a.instance_asset_id = b.instance_asset_id '||
3254: ' and transaction_id = :p_transaction_id UNION '||
3255: ' select a.instance_id from csi_i_parties a, csi_ip_accounts b, '||
3256: ' csi_ip_accounts_h c where a.instance_party_id = b.instance_party_id '||
3257: ' and b.ip_account_id = c.ip_account_id and c.transaction_id = :p_transaction_id UNION '||

Line 10766: FROM CSI_I_ASSETS_H CIAAH, CSI_I_ASSETS CIAA

10762: AND INSTANCE_ID=p_ins_id AND TRANSACTION_ID<>p_txn_id
10763: UNION ALL
10764:
10765: SELECT CIAAH.TRANSACTION_ID TRANSACTION_ID, CIAA.INSTANCE_ID INSTANCE_ID
10766: FROM CSI_I_ASSETS_H CIAAH, CSI_I_ASSETS CIAA
10767: WHERE CIAAH.INSTANCE_ASSET_ID = CIAA.INSTANCE_ASSET_ID
10768: AND INSTANCE_ID=p_ins_id AND TRANSACTION_ID<>p_txn_id
10769: UNION ALL
10770: