DBA Data[Home] [Help]

VIEW: APPS.IGS_FI_IMPCHGS_LINES_V

Source

View Text - Preformatted

SELECT A.ROWID ROW_ID, A.IMPCHG_LINES_ID, A.IMPORT_CHARGES_ID, A.TRANSACTION_DT, A.EFFECTIVE_DT, A.TRANSACTION_AMOUNT, A.CURRENCY_CD, A.EXCHANGE_RATE, A.CHG_RATE, A.CHG_ELEMENTS, A.COMMENTS, A.OVERRIDE_DR_REC_ACCOUNT_CD, A.OVERRIDE_DR_REC_CCID, A.OVERRIDE_CR_REV_ACCOUNT_CD, A.OVERRIDE_CR_REV_CCID, A.ANCILLARY_ATTRIBUTE1, A.ANCILLARY_ATTRIBUTE2, A.ANCILLARY_ATTRIBUTE3, A.ANCILLARY_ATTRIBUTE4, A.ANCILLARY_ATTRIBUTE5, A.ANCILLARY_ATTRIBUTE6, A.ANCILLARY_ATTRIBUTE7, A.ANCILLARY_ATTRIBUTE8, A.ANCILLARY_ATTRIBUTE9, A.ANCILLARY_ATTRIBUTE10, A.ANCILLARY_ATTRIBUTE11, A.ANCILLARY_ATTRIBUTE12, A.ANCILLARY_ATTRIBUTE13, A.ANCILLARY_ATTRIBUTE14, A.ANCILLARY_ATTRIBUTE15, A.ATTRIBUTE_CATEGORY, A.ATTRIBUTE1, A.ATTRIBUTE2, A.ATTRIBUTE3, A.ATTRIBUTE4, A.ATTRIBUTE5, A.ATTRIBUTE6, A.ATTRIBUTE7, A.ATTRIBUTE8, A.ATTRIBUTE9, A.ATTRIBUTE10, A.ATTRIBUTE11, A.ATTRIBUTE12, A.ATTRIBUTE13, A.ATTRIBUTE14, A.ATTRIBUTE15, A.ATTRIBUTE16, A.ATTRIBUTE17, A.ATTRIBUTE18, A.ATTRIBUTE19, A.ATTRIBUTE20, A.EXT_ATTRIBUTE_CATEGORY, A.EXT_ATTRIBUTE1, A.EXT_ATTRIBUTE2, A.EXT_ATTRIBUTE3, A.EXT_ATTRIBUTE4, A.EXT_ATTRIBUTE5, A.EXT_ATTRIBUTE6, A.EXT_ATTRIBUTE7, A.EXT_ATTRIBUTE8, A.EXT_ATTRIBUTE9, A.EXT_ATTRIBUTE10, A.EXT_ATTRIBUTE11, A.EXT_ATTRIBUTE12, A.EXT_ATTRIBUTE13, A.EXT_ATTRIBUTE14, A.EXT_ATTRIBUTE15, A.EXT_ATTRIBUTE16, A.EXT_ATTRIBUTE17, A.EXT_ATTRIBUTE18, A.EXT_ATTRIBUTE19, A.EXT_ATTRIBUTE20, A.REQUEST_ID, A.PROGRAM_ID, A.PROGRAM_APPLICATION_ID, A.PROGRAM_UPDATE_DATE, A.CREATED_BY, A.CREATION_DATE, A.LAST_UPDATED_BY, A.LAST_UPDATE_DATE, A.LAST_UPDATE_LOGIN FROM IGS_FI_IMPCHGS_LINES A
View Text - HTML Formatted

SELECT A.ROWID ROW_ID
, A.IMPCHG_LINES_ID
, A.IMPORT_CHARGES_ID
, A.TRANSACTION_DT
, A.EFFECTIVE_DT
, A.TRANSACTION_AMOUNT
, A.CURRENCY_CD
, A.EXCHANGE_RATE
, A.CHG_RATE
, A.CHG_ELEMENTS
, A.COMMENTS
, A.OVERRIDE_DR_REC_ACCOUNT_CD
, A.OVERRIDE_DR_REC_CCID
, A.OVERRIDE_CR_REV_ACCOUNT_CD
, A.OVERRIDE_CR_REV_CCID
, A.ANCILLARY_ATTRIBUTE1
, A.ANCILLARY_ATTRIBUTE2
, A.ANCILLARY_ATTRIBUTE3
, A.ANCILLARY_ATTRIBUTE4
, A.ANCILLARY_ATTRIBUTE5
, A.ANCILLARY_ATTRIBUTE6
, A.ANCILLARY_ATTRIBUTE7
, A.ANCILLARY_ATTRIBUTE8
, A.ANCILLARY_ATTRIBUTE9
, A.ANCILLARY_ATTRIBUTE10
, A.ANCILLARY_ATTRIBUTE11
, A.ANCILLARY_ATTRIBUTE12
, A.ANCILLARY_ATTRIBUTE13
, A.ANCILLARY_ATTRIBUTE14
, A.ANCILLARY_ATTRIBUTE15
, A.ATTRIBUTE_CATEGORY
, A.ATTRIBUTE1
, A.ATTRIBUTE2
, A.ATTRIBUTE3
, A.ATTRIBUTE4
, A.ATTRIBUTE5
, A.ATTRIBUTE6
, A.ATTRIBUTE7
, A.ATTRIBUTE8
, A.ATTRIBUTE9
, A.ATTRIBUTE10
, A.ATTRIBUTE11
, A.ATTRIBUTE12
, A.ATTRIBUTE13
, A.ATTRIBUTE14
, A.ATTRIBUTE15
, A.ATTRIBUTE16
, A.ATTRIBUTE17
, A.ATTRIBUTE18
, A.ATTRIBUTE19
, A.ATTRIBUTE20
, A.EXT_ATTRIBUTE_CATEGORY
, A.EXT_ATTRIBUTE1
, A.EXT_ATTRIBUTE2
, A.EXT_ATTRIBUTE3
, A.EXT_ATTRIBUTE4
, A.EXT_ATTRIBUTE5
, A.EXT_ATTRIBUTE6
, A.EXT_ATTRIBUTE7
, A.EXT_ATTRIBUTE8
, A.EXT_ATTRIBUTE9
, A.EXT_ATTRIBUTE10
, A.EXT_ATTRIBUTE11
, A.EXT_ATTRIBUTE12
, A.EXT_ATTRIBUTE13
, A.EXT_ATTRIBUTE14
, A.EXT_ATTRIBUTE15
, A.EXT_ATTRIBUTE16
, A.EXT_ATTRIBUTE17
, A.EXT_ATTRIBUTE18
, A.EXT_ATTRIBUTE19
, A.EXT_ATTRIBUTE20
, A.REQUEST_ID
, A.PROGRAM_ID
, A.PROGRAM_APPLICATION_ID
, A.PROGRAM_UPDATE_DATE
, A.CREATED_BY
, A.CREATION_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_DATE
, A.LAST_UPDATE_LOGIN
FROM IGS_FI_IMPCHGS_LINES A