DBA Data[Home] [Help]

APPS.CSE_GL_INTERFACE_PKG dependencies on CSI_ITEM_INSTANCES_H

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 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