SQL-016: Read CL_CLOSURE_TYPE_OF_ORDER_CODE

This SQL document describes how Criteria uses an inline Oracle query to support claim-domain read behavior.

Classification

Field	Value
SQL ID	SQL-016
Operation type	Read
Execution method	Inline
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	Criteria
Criteria property	retrievesql
Lifecycle method	Criteria read

Parameters

This SQL statement exposes no explicit input parameters in the analyzed source.

Tables

Table	Access	Columns used
CL_CLOSURE_TYPE_OF_ORDER_CODE	SELECT	See sample SQL for referenced columns.

Sample SQL

Select
    CL_CLOSURE_TYPE_OF_ORDER_CODE.CODE as Code,
    CL_CLOSURE_TYPE_OF_ORDER_CODE.CODE_DESCR as Description,
    CL_CLOSURE_TYPE_OF_ORDER_CODE.TEMPLATE_1644_TEXT as Template1644Text,
    CL_CLOSURE_TYPE_OF_ORDER_CODE.SORT_ORDER_NUM as SortOrderNum,
    CL_CLOSURE_TYPE_OF_ORDER_CODE.UPDATE_DATE as UpdateDate,
    CL_CLOSURE_TYPE_OF_ORDER_CODE.UPDATE_NUM as UpdateNum,
    CL_CLOSURE_TYPE_OF_ORDER_CODE.UPDATE_USER as UpdateUser
From CL_CLOSURE_TYPE_OF_ORDER_CODE
ORDER BY CL_CLOSURE_TYPE_OF_ORDER_CODE.SORT_ORDER_NUM

Operations and processes

• Reference code retrieval

Sources

• Business\SAIF.Business.View.Claim\clsClosureTypeOfOrderCodeCollection.vb