VIEW: APPS.OKL_TRX_TYPES_V

Source

View Text - Preformatted

SELECT TRYB.rowid ROW_ID, TRYB.ID ID, TRYB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, TRYT.SFWT_FLAG SFWT_FLAG, TRYB.AEP_CODE AEP_CODE, TRYB.ILC_ID ILC_ID, TRYB.TRY_ID TRY_ID, TRYB.TRY_ID_FOR TRY_ID_FOR, TRYB.TRY_TYPE TRY_TYPE, 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, 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, TRYB.TAX_UPFRONT_YN TAX_UPFRONT_YN, TRYB.TAX_INVOICE_YN TAX_INVOICE_YN, TRYB.TAX_SCHEDULE_YN TAX_SCHEDULE_YN, TRYB.ACCOUNTING_EVENT_CLASS_CODE ACCOUNTING_EVENT_CLASS_CODE, TRYB.FORMULA_YN FORMULA_YN 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.ROWID ROW_ID
, TRYB.ID ID
, TRYB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, TRYT.SFWT_FLAG SFWT_FLAG
, TRYB.AEP_CODE AEP_CODE
, TRYB.ILC_ID ILC_ID
, TRYB.TRY_ID TRY_ID
, TRYB.TRY_ID_FOR TRY_ID_FOR
, TRYB.TRY_TYPE TRY_TYPE
, 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
, 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
, TRYB.TAX_UPFRONT_YN TAX_UPFRONT_YN
, TRYB.TAX_INVOICE_YN TAX_INVOICE_YN
, TRYB.TAX_SCHEDULE_YN TAX_SCHEDULE_YN
, TRYB.ACCOUNTING_EVENT_CLASS_CODE ACCOUNTING_EVENT_CLASS_CODE
, TRYB.FORMULA_YN FORMULA_YN
FROM OKL_TRX_TYPES_B TRYB
, OKL_TRX_TYPES_TL TRYT
WHERE TRYB.ID = TRYT.ID
AND TRYT.LANGUAGE = USERENV('LANG')