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.CSE_GL_INTERFACE_PKG dependencies on CSI_INST_TXN_DETAILS_V

Line 260: FROM csi_inst_txn_details_v citd

256: IS
257: SELECT citd.serial_number,
258: citd.inventory_item_id ,
259: citd.transaction_date
260: FROM csi_inst_txn_details_v citd
261: ,csi_i_assets cia
262: WHERE citd.transaction_id = c_csi_transaction_id
263: AND citd.instance_id = cia.instance_id
264: AND cia.creation_date <= citd.transaction_date

Line 272: FROM csi_inst_txn_details_v csitd

268:
269: /*
270: CURSOR c_expired_cia_cur IS
271: SELECT 'N'
272: FROM csi_inst_txn_details_v csitd
273: ,csi_i_assets cia
274: WHERE csitd.transaction_id = csi_pending_txn_rec.transaction_id
275: AND csitd.instance_id = cia.instance_id
276: AND nvl(cia.active_end_date, sysdate) <= sysdate ;

Line 549: FROM csi_inst_txn_details_v citd

545: l_expired_qty := 0 ;
546:
547: -- get tot expired qty before the current txn date , note the <
548: SELECT sum(nvl(cia.asset_quantity, 0)) into l_expired_qty
549: FROM csi_inst_txn_details_v citd
550: ,csi_i_assets cia
551: WHERE citd.transaction_id = csi_pending_txn_rec.transaction_id
552: AND citd.instance_id = cia.instance_id
553: AND cia.creation_date <= citd.transaction_date

Line 593: FROM csi_inst_txn_details_v citd

589: -- active_end_date can't be future dated , chk for performance
590: -- # of active assets at the time of txn date
591: SELECT sum(cia.asset_quantity)
592: INTO l_no_of_fa_items
593: FROM csi_inst_txn_details_v citd
594: ,csi_i_assets cia
595: WHERE citd.transaction_id = csi_pending_txn_rec.transaction_id
596: AND citd.instance_id = cia.instance_id
597: --AND cia.creation_date <= citd.transaction_date --Commented for bug 8435411