[Home] [Help]
2715: ctt.source_transaction_type,
2716: ct.inv_material_transaction_id
2717: FROM csi_item_instances_h ciih,
2718: csi_transactions ct,
2719: csi_txn_types ctt
2720: WHERE ciih.instance_id = p_inst_id
2721: AND ct.transaction_id = ciih.transaction_id
2722: AND ctt.transaction_type_id = ct.transaction_type_id
2723: ORDER BY ct.source_transaction_date desc;