APPS.CSI_RMA_FULFILL_PUB dependencies on CSI_ITEM_INSTANCES_H

Line 961: FROM csi_item_instances_h cih, csi_transactions ct2

957: SELECT ct.TRANSACTION_TYPE_ID
958: INTO l_last_txn_type_id
959: FROM csi_transactions ct
960: WHERE ct.TRANSACTION_ID = (SELECT Max(ct2.TRANSACTION_ID)
961: FROM csi_item_instances_h cih, csi_transactions ct2
962: WHERE cih.transaction_id = ct2.transaction_id
963: AND cih.instance_id = l_instance_rec.instance_id
964: AND ct2.transaction_type_id = 53
965: AND ct2.source_header_ref_id = p_rma_line_rec.header_id);