| Operation Details |  |
| Description: | Search for all clauses. |
| Sterotype: | nsmulti |
| SQL | |
SELECT ClauseContractText.clauseContractTextID, ClauseContractText.clauseName, ClauseContractText.categoryCode, ContractText.languageCode, ContractText.recordStatus INTO :clauseContractTextID, :clauseName, :categoryCode, :languageCode, :recordStatusCode FROM ClauseContractText, ContractText WHERE ClauseContractText.contractTextID = ContractText.contractTextID |