VIEW: APPS.OKL_TRX_TYPES_UV

Source

View Text - Preformatted

SELECT TRYB.ID ID , TRYB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER , TRYT.SFWT_FLAG SFWT_FLAG , TRYB.AEP_CODE AEP_CODE , OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_ACCOUNTING_EVENT_TYPE', TRYB.AEP_CODE) AEP_CODE_DESC , TRYB.ILC_ID ILC_ID , TRYB.TRY_ID TRY_ID , TO_CHAR(NULL) TRY_ID_NAME , TRYB.TRY_ID_FOR TRY_ID_FOR , TO_CHAR(NULL) TRY_ID_FOR_NAME , TRYB.TRY_TYPE TRY_TYPE , OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_TRANSACTION_TYPE_CATEGORY', TRYB.TRY_TYPE ) TRY_TYPE_DESC , TRYT.NAME NAME , TRYT.DESCRIPTION DESCRIPTION , TRYT.CONTRACT_HEADER_LINE_FLAG CONTRACT_HEADER_LINE_FLAG , TRYT.TRANSACTION_HEADER_LINE_DETAIL TRANSACTION_HEADER_LINE_DETAIL , TRYB.TRX_TYPE_CLASS TRX_TYPE_CLASS , OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_TRANSACTION_TYPE_CLASS', TRYB.TRX_TYPE_CLASS) TRX_TYPE_CLASS_DESC , TRYB.ORG_ID ORG_ID , TRYB.CREATED_BY CREATED_BY , TRYB.CREATION_DATE CREATION_DATE , TRYB.LAST_UPDATED_BY LAST_UPDATED_BY , TRYB.LAST_UPDATE_DATE LAST_UPDATE_DATE , TRYB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM OKL_TRX_TYPES_B TRYB,OKL_TRX_TYPES_TL TRYT WHERE TRYB.ID = TRYT.ID AND TRYT.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT TRYB.ID ID
, TRYB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, TRYT.SFWT_FLAG SFWT_FLAG
, TRYB.AEP_CODE AEP_CODE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_ACCOUNTING_EVENT_TYPE'
, TRYB.AEP_CODE) AEP_CODE_DESC
, TRYB.ILC_ID ILC_ID
, TRYB.TRY_ID TRY_ID
, TO_CHAR(NULL) TRY_ID_NAME
, TRYB.TRY_ID_FOR TRY_ID_FOR
, TO_CHAR(NULL) TRY_ID_FOR_NAME
, TRYB.TRY_TYPE TRY_TYPE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_TRANSACTION_TYPE_CATEGORY'
, TRYB.TRY_TYPE ) TRY_TYPE_DESC
, TRYT.NAME NAME
, TRYT.DESCRIPTION DESCRIPTION
, TRYT.CONTRACT_HEADER_LINE_FLAG CONTRACT_HEADER_LINE_FLAG
, TRYT.TRANSACTION_HEADER_LINE_DETAIL TRANSACTION_HEADER_LINE_DETAIL
, TRYB.TRX_TYPE_CLASS TRX_TYPE_CLASS
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_TRANSACTION_TYPE_CLASS'
, TRYB.TRX_TYPE_CLASS) TRX_TYPE_CLASS_DESC
, TRYB.ORG_ID ORG_ID
, TRYB.CREATED_BY CREATED_BY
, TRYB.CREATION_DATE CREATION_DATE
, TRYB.LAST_UPDATED_BY LAST_UPDATED_BY
, TRYB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TRYB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKL_TRX_TYPES_B TRYB
, OKL_TRX_TYPES_TL TRYT
WHERE TRYB.ID = TRYT.ID
AND TRYT.LANGUAGE = USERENV('LANG')