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_PARTIES_H

Line 3270: ' from csi_i_parties a, csi_i_parties_h b where a.instance_party_id = b.instance_party_id '||

3266: --End Addition
3267:
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, '||

Line 11011: FROM CSI_I_PARTIES_H CIPH, CSI_I_PARTIES CIP

11007: AND object_ID=p_ins_id AND TRANSACTION_ID<>p_txn_id
11008: UNION ALL
11009:
11010: SELECT CIPH.TRANSACTION_ID TRANSACTION_ID, CIP.INSTANCE_ID INSTANCE_ID
11011: FROM CSI_I_PARTIES_H CIPH, CSI_I_PARTIES CIP
11012: WHERE CIPH.INSTANCE_PARTY_ID = CIP.INSTANCE_PARTY_ID
11013: AND INSTANCE_ID=p_ins_id AND TRANSACTION_ID<>p_txn_id
11014: UNION ALL
11015: