VIEW: APPS.OKL_ACC_TRX_TYPES_UV

Source

View Text - Preformatted

SELECT TRY.ID ID, TRY.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, TRY.SFWT_FLAG SFWT_FLAG, TRY.AEP_CODE AEP_CODE, TRY.ILC_ID ILC_ID, TRY.TRY_ID TRY_ID, TRY.TRY_ID_FOR TRY_ID_FOR, TRY.TRY_TYPE TRY_TYPE, TRY.NAME NAME, TRY.DESCRIPTION DESCRIPTION, TRY.CONTRACT_HEADER_LINE_FLAG CONTRACT_HEADER_LINE_FLAG, TRY.TRANSACTION_HEADER_LINE_DETAIL TRANSACTION_HEADER_LINE_DETAIL, TRY.TRX_TYPE_CLASS TRX_TYPE_CLASS, TRY.ORG_ID ORG_ID, TRY.CREATED_BY CREATED_BY, TRY.CREATION_DATE CREATION_DATE, TRY.LAST_UPDATED_BY LAST_UPDATED_BY, TRY.LAST_UPDATE_DATE LAST_UPDATE_DATE, TRY.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM OKL_TRX_TYPES_V TRY WHERE TRY.AEP_CODE IS NOT NULL

View Text - HTML Formatted

SELECT TRY.ID ID
, TRY.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, TRY.SFWT_FLAG SFWT_FLAG
, TRY.AEP_CODE AEP_CODE
, TRY.ILC_ID ILC_ID
, TRY.TRY_ID TRY_ID
, TRY.TRY_ID_FOR TRY_ID_FOR
, TRY.TRY_TYPE TRY_TYPE
, TRY.NAME NAME
, TRY.DESCRIPTION DESCRIPTION
, TRY.CONTRACT_HEADER_LINE_FLAG CONTRACT_HEADER_LINE_FLAG
, TRY.TRANSACTION_HEADER_LINE_DETAIL TRANSACTION_HEADER_LINE_DETAIL
, TRY.TRX_TYPE_CLASS TRX_TYPE_CLASS
, TRY.ORG_ID ORG_ID
, TRY.CREATED_BY CREATED_BY
, TRY.CREATION_DATE CREATION_DATE
, TRY.LAST_UPDATED_BY LAST_UPDATED_BY
, TRY.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TRY.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKL_TRX_TYPES_V TRY
WHERE TRY.AEP_CODE IS NOT NULL