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_I_ASSETS

Line 57: ,csi_i_assets cia

53: Cursor mtl_srl_cur IS
54: SELECT 'Y'
55: FROM mtl_unit_transactions mut
56: ,csi_item_instances cii
57: ,csi_i_assets cia
58: ,csi_transactions ct
59: WHERE mut.transaction_id = p_mtl_txn_id
60: AND cii.inventory_item_id = mut.inventory_item_id
61: AND cii.instance_id = cia.instance_id

Line 261: ,csi_i_assets cia

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
265: AND nvl(cia.active_end_date, citd.transaction_date + 1) > citd.transaction_date ;

Line 273: ,csi_i_assets cia

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 ;
277: */

Line 550: ,csi_i_assets cia

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
554: AND nvl(cia.active_end_date, citd.transaction_date+ 1) < citd.transaction_date ;

Line 594: ,csi_i_assets cia

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
598: AND nvl(cia.active_end_date, citd.transaction_date+ 1) >= citd.transaction_date ;

Line 605: csi_i_assets cia

601: INTO l_no_of_fa_items
602: FROM csi_item_instances cii,
603: csi_transactions ct ,
604: csi_item_instances_h ciih ,
605: csi_i_assets cia
606: WHERE cii.instance_id = ciih.instance_id
607: AND ct.transaction_id = ciih.transaction_id
608: AND ct.transaction_id = csi_pending_txn_rec.transaction_id
609: AND cia.instance_id = cii.instance_id