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 3272: ' from csi_i_assets a, csi_i_assets_h b where a.instance_asset_id = b.instance_asset_id '||

3268: l_union_stmt VARCHAR2(2000) := ' select instance_id from csi_item_instances_h '||
3269: ' where transaction_id = :p_transaction_id UNION select a.instance_id '||
3270: ' from csi_i_parties a, csi_i_parties_h b where a.instance_party_id = b.instance_party_id '||
3271: ' and b.transaction_id = :p_transaction_id UNION select a.instance_id '||
3272: ' from csi_i_assets a, csi_i_assets_h b where a.instance_asset_id = b.instance_asset_id '||
3273: ' and transaction_id = :p_transaction_id UNION '||
3274: ' select a.instance_id from csi_i_parties a, csi_ip_accounts b, '||
3275: ' csi_ip_accounts_h c where a.instance_party_id = b.instance_party_id '||
3276: ' and b.ip_account_id = c.ip_account_id and c.transaction_id = :p_transaction_id UNION '||

Line 11017: FROM CSI_I_ASSETS_H CIAAH, CSI_I_ASSETS CIAA

11013: AND INSTANCE_ID=p_ins_id AND TRANSACTION_ID<>p_txn_id
11014: UNION ALL
11015:
11016: SELECT CIAAH.TRANSACTION_ID TRANSACTION_ID, CIAA.INSTANCE_ID INSTANCE_ID
11017: FROM CSI_I_ASSETS_H CIAAH, CSI_I_ASSETS CIAA
11018: WHERE CIAAH.INSTANCE_ASSET_ID = CIAA.INSTANCE_ASSET_ID
11019: AND INSTANCE_ID=p_ins_id AND TRANSACTION_ID<>p_txn_id
11020: UNION ALL
11021: