VIEW: FA.FA_MASS_EXTERNAL_TRANSFERS#

Source

View Text - Preformatted

select BATCH_NAME BATCH_NAME, MASS_EXTERNAL_TRANSFER_ID MASS_EXTERNAL_TRANSFER_ID, EXTERNAL_REFERENCE_NUM EXTERNAL_REFERENCE_NUM, TRANSACTION_REFERENCE_NUM TRANSACTION_REFERENCE_NUM, TRANSACTION_TYPE TRANSACTION_TYPE, FROM_ASSET_ID FROM_ASSET_ID, TO_ASSET_ID TO_ASSET_ID, BOOK_TYPE_CODE BOOK_TYPE_CODE, TRANSACTION_STATUS TRANSACTION_STATUS, TRANSACTION_DATE_ENTERED TRANSACTION_DATE_ENTERED, FROM_DISTRIBUTION_ID FROM_DISTRIBUTION_ID, FROM_LOCATION_ID FROM_LOCATION_ID, FROM_GL_CCID FROM_GL_CCID, FROM_EMPLOYEE_ID FROM_EMPLOYEE_ID, TO_DISTRIBUTION_ID TO_DISTRIBUTION_ID, TO_LOCATION_ID TO_LOCATION_ID, TO_GL_CCID TO_GL_CCID, TO_EMPLOYEE_ID TO_EMPLOYEE_ID, DESCRIPTION DESCRIPTION, TRANSFER_UNITS TRANSFER_UNITS, TRANSFER_AMOUNT TRANSFER_AMOUNT, SOURCE_LINE_ID SOURCE_LINE_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATED_DATE LAST_UPDATED_DATE, TRX_ATTRIBUTE1 TRX_ATTRIBUTE1, TRX_ATTRIBUTE2 TRX_ATTRIBUTE2, TRX_ATTRIBUTE3 TRX_ATTRIBUTE3, TRX_ATTRIBUTE4 TRX_ATTRIBUTE4, TRX_ATTRIBUTE5 TRX_ATTRIBUTE5, TRX_ATTRIBUTE6 TRX_ATTRIBUTE6, TRX_ATTRIBUTE7 TRX_ATTRIBUTE7, TRX_ATTRIBUTE8 TRX_ATTRIBUTE8, TRX_ATTRIBUTE9 TRX_ATTRIBUTE9, TRX_ATTRIBUTE10 TRX_ATTRIBUTE10, TRX_ATTRIBUTE11 TRX_ATTRIBUTE11, TRX_ATTRIBUTE12 TRX_ATTRIBUTE12, TRX_ATTRIBUTE13 TRX_ATTRIBUTE13, TRX_ATTRIBUTE14 TRX_ATTRIBUTE14, TRX_ATTRIBUTE15 TRX_ATTRIBUTE15, TRX_ATTRIBUTE_CATEGORY_CODE TRX_ATTRIBUTE_CATEGORY_CODE, POST_BATCH_ID POST_BATCH_ID, TH_ATTRIBUTE_CATEGORY TH_ATTRIBUTE_CATEGORY, TH_ATTRIBUTE1 TH_ATTRIBUTE1, TH_ATTRIBUTE2 TH_ATTRIBUTE2, TH_ATTRIBUTE3 TH_ATTRIBUTE3, TH_ATTRIBUTE4 TH_ATTRIBUTE4, TH_ATTRIBUTE5 TH_ATTRIBUTE5, TH_ATTRIBUTE6 TH_ATTRIBUTE6, TH_ATTRIBUTE7 TH_ATTRIBUTE7, TH_ATTRIBUTE8 TH_ATTRIBUTE8, TH_ATTRIBUTE9 TH_ATTRIBUTE9, TH_ATTRIBUTE10 TH_ATTRIBUTE10, TH_ATTRIBUTE11 TH_ATTRIBUTE11, TH_ATTRIBUTE12 TH_ATTRIBUTE12, TH_ATTRIBUTE13 TH_ATTRIBUTE13, TH_ATTRIBUTE14 TH_ATTRIBUTE14, TH_ATTRIBUTE15 TH_ATTRIBUTE15, 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, ATTRIBUTE_CATEGORY_CODE ATTRIBUTE_CATEGORY_CODE, WORKER_ID WORKER_ID, FROM_GROUP_ASSET_ID FROM_GROUP_ASSET_ID, TO_GROUP_ASSET_ID TO_GROUP_ASSET_ID from "FA"."FA_MASS_EXTERNAL_TRANSFERS"

View Text - HTML Formatted

SELECT BATCH_NAME BATCH_NAME
, MASS_EXTERNAL_TRANSFER_ID MASS_EXTERNAL_TRANSFER_ID
, EXTERNAL_REFERENCE_NUM EXTERNAL_REFERENCE_NUM
, TRANSACTION_REFERENCE_NUM TRANSACTION_REFERENCE_NUM
, TRANSACTION_TYPE TRANSACTION_TYPE
, FROM_ASSET_ID FROM_ASSET_ID
, TO_ASSET_ID TO_ASSET_ID
, BOOK_TYPE_CODE BOOK_TYPE_CODE
, TRANSACTION_STATUS TRANSACTION_STATUS
, TRANSACTION_DATE_ENTERED TRANSACTION_DATE_ENTERED
, FROM_DISTRIBUTION_ID FROM_DISTRIBUTION_ID
, FROM_LOCATION_ID FROM_LOCATION_ID
, FROM_GL_CCID FROM_GL_CCID
, FROM_EMPLOYEE_ID FROM_EMPLOYEE_ID
, TO_DISTRIBUTION_ID TO_DISTRIBUTION_ID
, TO_LOCATION_ID TO_LOCATION_ID
, TO_GL_CCID TO_GL_CCID
, TO_EMPLOYEE_ID TO_EMPLOYEE_ID
, DESCRIPTION DESCRIPTION
, TRANSFER_UNITS TRANSFER_UNITS
, TRANSFER_AMOUNT TRANSFER_AMOUNT
, SOURCE_LINE_ID SOURCE_LINE_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATED_DATE LAST_UPDATED_DATE
, TRX_ATTRIBUTE1 TRX_ATTRIBUTE1
, TRX_ATTRIBUTE2 TRX_ATTRIBUTE2
, TRX_ATTRIBUTE3 TRX_ATTRIBUTE3
, TRX_ATTRIBUTE4 TRX_ATTRIBUTE4
, TRX_ATTRIBUTE5 TRX_ATTRIBUTE5
, TRX_ATTRIBUTE6 TRX_ATTRIBUTE6
, TRX_ATTRIBUTE7 TRX_ATTRIBUTE7
, TRX_ATTRIBUTE8 TRX_ATTRIBUTE8
, TRX_ATTRIBUTE9 TRX_ATTRIBUTE9
, TRX_ATTRIBUTE10 TRX_ATTRIBUTE10
, TRX_ATTRIBUTE11 TRX_ATTRIBUTE11
, TRX_ATTRIBUTE12 TRX_ATTRIBUTE12
, TRX_ATTRIBUTE13 TRX_ATTRIBUTE13
, TRX_ATTRIBUTE14 TRX_ATTRIBUTE14
, TRX_ATTRIBUTE15 TRX_ATTRIBUTE15
, TRX_ATTRIBUTE_CATEGORY_CODE TRX_ATTRIBUTE_CATEGORY_CODE
, POST_BATCH_ID POST_BATCH_ID
, TH_ATTRIBUTE_CATEGORY TH_ATTRIBUTE_CATEGORY
, TH_ATTRIBUTE1 TH_ATTRIBUTE1
, TH_ATTRIBUTE2 TH_ATTRIBUTE2
, TH_ATTRIBUTE3 TH_ATTRIBUTE3
, TH_ATTRIBUTE4 TH_ATTRIBUTE4
, TH_ATTRIBUTE5 TH_ATTRIBUTE5
, TH_ATTRIBUTE6 TH_ATTRIBUTE6
, TH_ATTRIBUTE7 TH_ATTRIBUTE7
, TH_ATTRIBUTE8 TH_ATTRIBUTE8
, TH_ATTRIBUTE9 TH_ATTRIBUTE9
, TH_ATTRIBUTE10 TH_ATTRIBUTE10
, TH_ATTRIBUTE11 TH_ATTRIBUTE11
, TH_ATTRIBUTE12 TH_ATTRIBUTE12
, TH_ATTRIBUTE13 TH_ATTRIBUTE13
, TH_ATTRIBUTE14 TH_ATTRIBUTE14
, TH_ATTRIBUTE15 TH_ATTRIBUTE15
, 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
, ATTRIBUTE_CATEGORY_CODE ATTRIBUTE_CATEGORY_CODE
, WORKER_ID WORKER_ID
, FROM_GROUP_ASSET_ID FROM_GROUP_ASSET_ID
, TO_GROUP_ASSET_ID TO_GROUP_ASSET_ID
FROM "FA"."FA_MASS_EXTERNAL_TRANSFERS"