VIEW: FA.FA_MASS_TRANSFERS#

Source

View Text - Preformatted

select MASS_TRANSFER_ID MASS_TRANSFER_ID, BOOK_TYPE_CODE BOOK_TYPE_CODE, TRANSACTION_DATE_ENTERED TRANSACTION_DATE_ENTERED, DATE_EFFECTIVE DATE_EFFECTIVE, CONCURRENT_REQUEST_ID CONCURRENT_REQUEST_ID, FROM_LOCATION_ID FROM_LOCATION_ID, TO_LOCATION_ID TO_LOCATION_ID, FROM_GL_CCID FROM_GL_CCID, TO_GL_CCID TO_GL_CCID, FROM_EMPLOYEE_ID FROM_EMPLOYEE_ID, TO_EMPLOYEE_ID TO_EMPLOYEE_ID, DESCRIPTION DESCRIPTION, 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, SEGMENT1_LOW SEGMENT1_LOW, SEGMENT2_LOW SEGMENT2_LOW, SEGMENT3_LOW SEGMENT3_LOW, SEGMENT4_LOW SEGMENT4_LOW, SEGMENT5_LOW SEGMENT5_LOW, SEGMENT6_LOW SEGMENT6_LOW, SEGMENT7_LOW SEGMENT7_LOW, SEGMENT8_LOW SEGMENT8_LOW, SEGMENT9_LOW SEGMENT9_LOW, SEGMENT10_LOW SEGMENT10_LOW, SEGMENT11_LOW SEGMENT11_LOW, SEGMENT12_LOW SEGMENT12_LOW, SEGMENT13_LOW SEGMENT13_LOW, SEGMENT14_LOW SEGMENT14_LOW, SEGMENT15_LOW SEGMENT15_LOW, SEGMENT16_LOW SEGMENT16_LOW, SEGMENT17_LOW SEGMENT17_LOW, SEGMENT18_LOW SEGMENT18_LOW, SEGMENT19_LOW SEGMENT19_LOW, SEGMENT20_LOW SEGMENT20_LOW, SEGMENT21_LOW SEGMENT21_LOW, SEGMENT22_LOW SEGMENT22_LOW, SEGMENT23_LOW SEGMENT23_LOW, SEGMENT24_LOW SEGMENT24_LOW, SEGMENT25_LOW SEGMENT25_LOW, SEGMENT26_LOW SEGMENT26_LOW, SEGMENT27_LOW SEGMENT27_LOW, SEGMENT28_LOW SEGMENT28_LOW, SEGMENT29_LOW SEGMENT29_LOW, SEGMENT30_LOW SEGMENT30_LOW, SEGMENT1_HIGH SEGMENT1_HIGH, SEGMENT2_HIGH SEGMENT2_HIGH, SEGMENT3_HIGH SEGMENT3_HIGH, SEGMENT4_HIGH SEGMENT4_HIGH, SEGMENT5_HIGH SEGMENT5_HIGH, SEGMENT6_HIGH SEGMENT6_HIGH, SEGMENT7_HIGH SEGMENT7_HIGH, SEGMENT8_HIGH SEGMENT8_HIGH, SEGMENT9_HIGH SEGMENT9_HIGH, SEGMENT10_HIGH SEGMENT10_HIGH, SEGMENT11_HIGH SEGMENT11_HIGH, SEGMENT12_HIGH SEGMENT12_HIGH, SEGMENT13_HIGH SEGMENT13_HIGH, SEGMENT14_HIGH SEGMENT14_HIGH, SEGMENT15_HIGH SEGMENT15_HIGH, SEGMENT16_HIGH SEGMENT16_HIGH, SEGMENT17_HIGH SEGMENT17_HIGH, SEGMENT18_HIGH SEGMENT18_HIGH, SEGMENT19_HIGH SEGMENT19_HIGH, SEGMENT20_HIGH SEGMENT20_HIGH, SEGMENT21_HIGH SEGMENT21_HIGH, SEGMENT22_HIGH SEGMENT22_HIGH, SEGMENT23_HIGH SEGMENT23_HIGH, SEGMENT24_HIGH SEGMENT24_HIGH, SEGMENT25_HIGH SEGMENT25_HIGH, SEGMENT26_HIGH SEGMENT26_HIGH, SEGMENT27_HIGH SEGMENT27_HIGH, SEGMENT28_HIGH SEGMENT28_HIGH, SEGMENT29_HIGH SEGMENT29_HIGH, SEGMENT30_HIGH SEGMENT30_HIGH, SEGMENT1 SEGMENT1, SEGMENT2 SEGMENT2, SEGMENT3 SEGMENT3, SEGMENT4 SEGMENT4, SEGMENT5 SEGMENT5, SEGMENT6 SEGMENT6, SEGMENT7 SEGMENT7, SEGMENT8 SEGMENT8, SEGMENT9 SEGMENT9, SEGMENT10 SEGMENT10, SEGMENT11 SEGMENT11, SEGMENT12 SEGMENT12, SEGMENT13 SEGMENT13, SEGMENT14 SEGMENT14, SEGMENT15 SEGMENT15, SEGMENT16 SEGMENT16, SEGMENT17 SEGMENT17, SEGMENT18 SEGMENT18, SEGMENT19 SEGMENT19, SEGMENT20 SEGMENT20, SEGMENT21 SEGMENT21, SEGMENT22 SEGMENT22, SEGMENT23 SEGMENT23, SEGMENT24 SEGMENT24, SEGMENT25 SEGMENT25, SEGMENT26 SEGMENT26, SEGMENT27 SEGMENT27, SEGMENT28 SEGMENT28, SEGMENT29 SEGMENT29, SEGMENT30 SEGMENT30, CATEGORY_ID CATEGORY_ID from "FA"."FA_MASS_TRANSFERS"

View Text - HTML Formatted

SELECT MASS_TRANSFER_ID MASS_TRANSFER_ID
, BOOK_TYPE_CODE BOOK_TYPE_CODE
, TRANSACTION_DATE_ENTERED TRANSACTION_DATE_ENTERED
, DATE_EFFECTIVE DATE_EFFECTIVE
, CONCURRENT_REQUEST_ID CONCURRENT_REQUEST_ID
, FROM_LOCATION_ID FROM_LOCATION_ID
, TO_LOCATION_ID TO_LOCATION_ID
, FROM_GL_CCID FROM_GL_CCID
, TO_GL_CCID TO_GL_CCID
, FROM_EMPLOYEE_ID FROM_EMPLOYEE_ID
, TO_EMPLOYEE_ID TO_EMPLOYEE_ID
, DESCRIPTION DESCRIPTION
, 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
, SEGMENT1_LOW SEGMENT1_LOW
, SEGMENT2_LOW SEGMENT2_LOW
, SEGMENT3_LOW SEGMENT3_LOW
, SEGMENT4_LOW SEGMENT4_LOW
, SEGMENT5_LOW SEGMENT5_LOW
, SEGMENT6_LOW SEGMENT6_LOW
, SEGMENT7_LOW SEGMENT7_LOW
, SEGMENT8_LOW SEGMENT8_LOW
, SEGMENT9_LOW SEGMENT9_LOW
, SEGMENT10_LOW SEGMENT10_LOW
, SEGMENT11_LOW SEGMENT11_LOW
, SEGMENT12_LOW SEGMENT12_LOW
, SEGMENT13_LOW SEGMENT13_LOW
, SEGMENT14_LOW SEGMENT14_LOW
, SEGMENT15_LOW SEGMENT15_LOW
, SEGMENT16_LOW SEGMENT16_LOW
, SEGMENT17_LOW SEGMENT17_LOW
, SEGMENT18_LOW SEGMENT18_LOW
, SEGMENT19_LOW SEGMENT19_LOW
, SEGMENT20_LOW SEGMENT20_LOW
, SEGMENT21_LOW SEGMENT21_LOW
, SEGMENT22_LOW SEGMENT22_LOW
, SEGMENT23_LOW SEGMENT23_LOW
, SEGMENT24_LOW SEGMENT24_LOW
, SEGMENT25_LOW SEGMENT25_LOW
, SEGMENT26_LOW SEGMENT26_LOW
, SEGMENT27_LOW SEGMENT27_LOW
, SEGMENT28_LOW SEGMENT28_LOW
, SEGMENT29_LOW SEGMENT29_LOW
, SEGMENT30_LOW SEGMENT30_LOW
, SEGMENT1_HIGH SEGMENT1_HIGH
, SEGMENT2_HIGH SEGMENT2_HIGH
, SEGMENT3_HIGH SEGMENT3_HIGH
, SEGMENT4_HIGH SEGMENT4_HIGH
, SEGMENT5_HIGH SEGMENT5_HIGH
, SEGMENT6_HIGH SEGMENT6_HIGH
, SEGMENT7_HIGH SEGMENT7_HIGH
, SEGMENT8_HIGH SEGMENT8_HIGH
, SEGMENT9_HIGH SEGMENT9_HIGH
, SEGMENT10_HIGH SEGMENT10_HIGH
, SEGMENT11_HIGH SEGMENT11_HIGH
, SEGMENT12_HIGH SEGMENT12_HIGH
, SEGMENT13_HIGH SEGMENT13_HIGH
, SEGMENT14_HIGH SEGMENT14_HIGH
, SEGMENT15_HIGH SEGMENT15_HIGH
, SEGMENT16_HIGH SEGMENT16_HIGH
, SEGMENT17_HIGH SEGMENT17_HIGH
, SEGMENT18_HIGH SEGMENT18_HIGH
, SEGMENT19_HIGH SEGMENT19_HIGH
, SEGMENT20_HIGH SEGMENT20_HIGH
, SEGMENT21_HIGH SEGMENT21_HIGH
, SEGMENT22_HIGH SEGMENT22_HIGH
, SEGMENT23_HIGH SEGMENT23_HIGH
, SEGMENT24_HIGH SEGMENT24_HIGH
, SEGMENT25_HIGH SEGMENT25_HIGH
, SEGMENT26_HIGH SEGMENT26_HIGH
, SEGMENT27_HIGH SEGMENT27_HIGH
, SEGMENT28_HIGH SEGMENT28_HIGH
, SEGMENT29_HIGH SEGMENT29_HIGH
, SEGMENT30_HIGH SEGMENT30_HIGH
, SEGMENT1 SEGMENT1
, SEGMENT2 SEGMENT2
, SEGMENT3 SEGMENT3
, SEGMENT4 SEGMENT4
, SEGMENT5 SEGMENT5
, SEGMENT6 SEGMENT6
, SEGMENT7 SEGMENT7
, SEGMENT8 SEGMENT8
, SEGMENT9 SEGMENT9
, SEGMENT10 SEGMENT10
, SEGMENT11 SEGMENT11
, SEGMENT12 SEGMENT12
, SEGMENT13 SEGMENT13
, SEGMENT14 SEGMENT14
, SEGMENT15 SEGMENT15
, SEGMENT16 SEGMENT16
, SEGMENT17 SEGMENT17
, SEGMENT18 SEGMENT18
, SEGMENT19 SEGMENT19
, SEGMENT20 SEGMENT20
, SEGMENT21 SEGMENT21
, SEGMENT22 SEGMENT22
, SEGMENT23 SEGMENT23
, SEGMENT24 SEGMENT24
, SEGMENT25 SEGMENT25
, SEGMENT26 SEGMENT26
, SEGMENT27 SEGMENT27
, SEGMENT28 SEGMENT28
, SEGMENT29 SEGMENT29
, SEGMENT30 SEGMENT30
, CATEGORY_ID CATEGORY_ID
FROM "FA"."FA_MASS_TRANSFERS"