APPS.CSE_GL_INTERFACE_PKG dependencies on CSI_ITEM_INSTANCES

Line 56: ,csi_item_instances cii

52: -- Assets expired as of txn date or less would not be reversed
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

Line 491: FROM csi_item_instances_h ciih ,

487: INTO
488: l_ciih_old_quantity ,
489: l_ciih_new_quantity ,
490: l_cii_inventory_item_id
491: FROM csi_item_instances_h ciih ,
492: csi_item_instances cii
493: WHERE ciih.transaction_id = csi_pending_txn_rec.transaction_id
494: AND ciih.instance_id = cii.instance_id
495: AND cii.inventory_item_id = l_mmt_inventory_item_id

Line 492: csi_item_instances cii

488: l_ciih_old_quantity ,
489: l_ciih_new_quantity ,
490: l_cii_inventory_item_id
491: FROM csi_item_instances_h ciih ,
492: csi_item_instances cii
493: WHERE ciih.transaction_id = csi_pending_txn_rec.transaction_id
494: AND ciih.instance_id = cii.instance_id
495: AND cii.inventory_item_id = l_mmt_inventory_item_id
496: GROUP BY cii.inventory_item_id , ciih.transaction_id ;

Line 602: FROM csi_item_instances cii,

598: AND nvl(cia.active_end_date, citd.transaction_date+ 1) >= citd.transaction_date ;
599: /*
600: SELECT sum(cia.asset_quantity)
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

Line 604: csi_item_instances_h ciih ,

600: SELECT sum(cia.asset_quantity)
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