VIEW: OZF.OZF_MC_TRANSACTIONS_ALL#

Source

View Text - Preformatted

select MC_RECORD_ID MC_RECORD_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, CREATED_FROM CREATED_FROM, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, SOURCE_OBJECT_NAME SOURCE_OBJECT_NAME, SOURCE_OBJECT_ID SOURCE_OBJECT_ID, CURRENCY_CODE CURRENCY_CODE, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE, EXCHANGE_RATE_DATE EXCHANGE_RATE_DATE, EXCHANGE_RATE EXCHANGE_RATE, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, SET_OF_BOOKS_TYPE SET_OF_BOOKS_TYPE, AMOUNT_COLUMN1 AMOUNT_COLUMN1, AMOUNT_COLUMN2 AMOUNT_COLUMN2, AMOUNT_COLUMN3 AMOUNT_COLUMN3, AMOUNT_COLUMN4 AMOUNT_COLUMN4, AMOUNT_COLUMN5 AMOUNT_COLUMN5, AMOUNT_COLUMN6 AMOUNT_COLUMN6, AMOUNT_COLUMN7 AMOUNT_COLUMN7, AMOUNT_COLUMN8 AMOUNT_COLUMN8, AMOUNT_COLUMN9 AMOUNT_COLUMN9, AMOUNT_COLUMN10 AMOUNT_COLUMN10, POSTING_CONTROL_ID POSTING_CONTROL_ID, GL_POSTED_DATE GL_POSTED_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ORG_ID ORG_ID, ORIGINAL_BUDGET ORIGINAL_BUDGET, TRANSFERRED_IN_AMT TRANSFERRED_IN_AMT, TRANSFERRED_OUT_AMT TRANSFERRED_OUT_AMT, HOLDBACK_AMT HOLDBACK_AMT, PLANNED_AMT PLANNED_AMT, COMMITTED_AMT COMMITTED_AMT, EARNED_AMT EARNED_AMT, PAID_AMT PAID_AMT, SECURITY_GROUP_ID SECURITY_GROUP_ID from "OZF"."OZF_MC_TRANSACTIONS_ALL"

View Text - HTML Formatted

SELECT MC_RECORD_ID MC_RECORD_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, CREATED_FROM CREATED_FROM
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, SOURCE_OBJECT_NAME SOURCE_OBJECT_NAME
, SOURCE_OBJECT_ID SOURCE_OBJECT_ID
, CURRENCY_CODE CURRENCY_CODE
, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE
, EXCHANGE_RATE_DATE EXCHANGE_RATE_DATE
, EXCHANGE_RATE EXCHANGE_RATE
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, SET_OF_BOOKS_TYPE SET_OF_BOOKS_TYPE
, AMOUNT_COLUMN1 AMOUNT_COLUMN1
, AMOUNT_COLUMN2 AMOUNT_COLUMN2
, AMOUNT_COLUMN3 AMOUNT_COLUMN3
, AMOUNT_COLUMN4 AMOUNT_COLUMN4
, AMOUNT_COLUMN5 AMOUNT_COLUMN5
, AMOUNT_COLUMN6 AMOUNT_COLUMN6
, AMOUNT_COLUMN7 AMOUNT_COLUMN7
, AMOUNT_COLUMN8 AMOUNT_COLUMN8
, AMOUNT_COLUMN9 AMOUNT_COLUMN9
, AMOUNT_COLUMN10 AMOUNT_COLUMN10
, POSTING_CONTROL_ID POSTING_CONTROL_ID
, GL_POSTED_DATE GL_POSTED_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ORG_ID ORG_ID
, ORIGINAL_BUDGET ORIGINAL_BUDGET
, TRANSFERRED_IN_AMT TRANSFERRED_IN_AMT
, TRANSFERRED_OUT_AMT TRANSFERRED_OUT_AMT
, HOLDBACK_AMT HOLDBACK_AMT
, PLANNED_AMT PLANNED_AMT
, COMMITTED_AMT COMMITTED_AMT
, EARNED_AMT EARNED_AMT
, PAID_AMT PAID_AMT
, SECURITY_GROUP_ID SECURITY_GROUP_ID
FROM "OZF"."OZF_MC_TRANSACTIONS_ALL"