VIEW: JA.JA_CN_CFS_ACTIVITIES_ALL#

Source

View Text - Preformatted

select CFS_ACTIVITY_ID CFS_ACTIVITY_ID, LEGAL_ENTITY_ID LEGAL_ENTITY_ID, LEDGER_ID LEDGER_ID, ORG_ID ORG_ID, TRX_ID TRX_ID, TRX_NUMBER TRX_NUMBER, TRX_LINE_ID TRX_LINE_ID, TRANSACTION_TYPE TRANSACTION_TYPE, DOCUMENT_SEQUENCE_NUMBER DOCUMENT_SEQUENCE_NUMBER, TRANSACTION_DATE TRANSACTION_DATE, GL_DATE GL_DATE, PERIOD_NAME PERIOD_NAME, FUNC_CURR_CODE FUNC_CURR_CODE, FUNC_AMOUNT FUNC_AMOUNT, ORIGINAL_CURR_CODE ORIGINAL_CURR_CODE, ORIGINAL_AMOUNT ORIGINAL_AMOUNT, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE, DESCRIPTION DESCRIPTION, DETAILED_CFS_ITEM DETAILED_CFS_ITEM, INTERCOMPANY_FLAG INTERCOMPANY_FLAG, REFERENCE_NUMBER REFERENCE_NUMBER, THIRD_PARTY_NAME THIRD_PARTY_NAME, THIRD_PARTY_NUMBER THIRD_PARTY_NUMBER, EVENT_CLASS_CODE EVENT_CLASS_CODE, SOURCE_APPLICATION_ID SOURCE_APPLICATION_ID, ANALYTICAL_CRITERION_CODE ANALYTICAL_CRITERION_CODE, SOURCE_VALUE SOURCE_VALUE, CASH_ITEM_DESC CASH_ITEM_DESC, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, SOURCE SOURCE, UPGRADE_FLAG UPGRADE_FLAG, BALANCING_SEGMENT BALANCING_SEGMENT, CASH_TRX_ID CASH_TRX_ID, CASH_TRX_LINE_ID CASH_TRX_LINE_ID, JE_HEADER_ID JE_HEADER_ID, JE_LINE_NUM JE_LINE_NUM, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5 from "JA"."JA_CN_CFS_ACTIVITIES_ALL"

View Text - HTML Formatted

SELECT CFS_ACTIVITY_ID CFS_ACTIVITY_ID
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, LEDGER_ID LEDGER_ID
, ORG_ID ORG_ID
, TRX_ID TRX_ID
, TRX_NUMBER TRX_NUMBER
, TRX_LINE_ID TRX_LINE_ID
, TRANSACTION_TYPE TRANSACTION_TYPE
, DOCUMENT_SEQUENCE_NUMBER DOCUMENT_SEQUENCE_NUMBER
, TRANSACTION_DATE TRANSACTION_DATE
, GL_DATE GL_DATE
, PERIOD_NAME PERIOD_NAME
, FUNC_CURR_CODE FUNC_CURR_CODE
, FUNC_AMOUNT FUNC_AMOUNT
, ORIGINAL_CURR_CODE ORIGINAL_CURR_CODE
, ORIGINAL_AMOUNT ORIGINAL_AMOUNT
, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, DESCRIPTION DESCRIPTION
, DETAILED_CFS_ITEM DETAILED_CFS_ITEM
, INTERCOMPANY_FLAG INTERCOMPANY_FLAG
, REFERENCE_NUMBER REFERENCE_NUMBER
, THIRD_PARTY_NAME THIRD_PARTY_NAME
, THIRD_PARTY_NUMBER THIRD_PARTY_NUMBER
, EVENT_CLASS_CODE EVENT_CLASS_CODE
, SOURCE_APPLICATION_ID SOURCE_APPLICATION_ID
, ANALYTICAL_CRITERION_CODE ANALYTICAL_CRITERION_CODE
, SOURCE_VALUE SOURCE_VALUE
, CASH_ITEM_DESC CASH_ITEM_DESC
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SOURCE SOURCE
, UPGRADE_FLAG UPGRADE_FLAG
, BALANCING_SEGMENT BALANCING_SEGMENT
, CASH_TRX_ID CASH_TRX_ID
, CASH_TRX_LINE_ID CASH_TRX_LINE_ID
, JE_HEADER_ID JE_HEADER_ID
, JE_LINE_NUM JE_LINE_NUM
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
FROM "JA"."JA_CN_CFS_ACTIVITIES_ALL"