VIEW: JA.JAI_MTL_TRX_JRNLS#

Source

View Text - Preformatted

select STATUS STATUS, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, USER_JE_CATEGORY_NAME USER_JE_CATEGORY_NAME, USER_JE_SOURCE_NAME USER_JE_SOURCE_NAME, ACCOUNTING_DATE ACCOUNTING_DATE, CURRENCY_CODE CURRENCY_CODE, DATE_CREATED DATE_CREATED, CREATED_BY CREATED_BY, ENTERED_DR ENTERED_DR, ENTERED_CR ENTERED_CR, TRANSACTION_DATE TRANSACTION_DATE, CODE_COMBINATION_ID CODE_COMBINATION_ID, JOURNAL_ENTRY_ID JOURNAL_ENTRY_ID, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE, USER_CURRENCY_CONVERSION_TYPE USER_CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE, REFERENCE1 REFERENCE1, REFERENCE10 REFERENCE10, REFERENCE23 REFERENCE23, REFERENCE24 REFERENCE24, REFERENCE25 REFERENCE25, REFERENCE26 REFERENCE26, REFERENCE27 REFERENCE27, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, TRANSACTION_TEMP_ID TRANSACTION_TEMP_ID from "JA"."JAI_MTL_TRX_JRNLS"

View Text - HTML Formatted

SELECT STATUS STATUS
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, USER_JE_CATEGORY_NAME USER_JE_CATEGORY_NAME
, USER_JE_SOURCE_NAME USER_JE_SOURCE_NAME
, ACCOUNTING_DATE ACCOUNTING_DATE
, CURRENCY_CODE CURRENCY_CODE
, DATE_CREATED DATE_CREATED
, CREATED_BY CREATED_BY
, ENTERED_DR ENTERED_DR
, ENTERED_CR ENTERED_CR
, TRANSACTION_DATE TRANSACTION_DATE
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, JOURNAL_ENTRY_ID JOURNAL_ENTRY_ID
, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, USER_CURRENCY_CONVERSION_TYPE USER_CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, REFERENCE1 REFERENCE1
, REFERENCE10 REFERENCE10
, REFERENCE23 REFERENCE23
, REFERENCE24 REFERENCE24
, REFERENCE25 REFERENCE25
, REFERENCE26 REFERENCE26
, REFERENCE27 REFERENCE27
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TRANSACTION_TEMP_ID TRANSACTION_TEMP_ID
FROM "JA"."JAI_MTL_TRX_JRNLS"