VIEW: APPS.IGS_FI_ANC_INT

Source

View Text - Preformatted

SELECT ROWID ROW_ID, ANCILLARY_INT_ID ANCILLARY_INT_ID, PERSON_ID PERSON_ID, PERSON_ID_TYPE PERSON_ID_TYPE, API_PERSON_ID API_PERSON_ID, STATUS STATUS, FEE_TYPE FEE_TYPE, FEE_CAL_TYPE FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER FEE_CI_SEQUENCE_NUMBER, OVERRIDE_DR_REC_ACCOUNT_CD OVERRIDE_DR_REC_ACCOUNT_CD, OVERRIDE_DR_REC_CCID OVERRIDE_DR_REC_CCID, OVERRIDE_CR_REV_ACCOUNT_CD OVERRIDE_CR_REV_ACCOUNT_CD, OVERRIDE_CR_REV_CCID OVERRIDE_CR_REV_CCID, ANCILLARY_ATTRIBUTE1 ANCILLARY_ATTRIBUTE1, ANCILLARY_ATTRIBUTE2 ANCILLARY_ATTRIBUTE2, ANCILLARY_ATTRIBUTE3 ANCILLARY_ATTRIBUTE3, ANCILLARY_ATTRIBUTE4 ANCILLARY_ATTRIBUTE4, ANCILLARY_ATTRIBUTE5 ANCILLARY_ATTRIBUTE5, ANCILLARY_ATTRIBUTE6 ANCILLARY_ATTRIBUTE6, ANCILLARY_ATTRIBUTE7 ANCILLARY_ATTRIBUTE7, ANCILLARY_ATTRIBUTE8 ANCILLARY_ATTRIBUTE8, ANCILLARY_ATTRIBUTE9 ANCILLARY_ATTRIBUTE9, ANCILLARY_ATTRIBUTE10 ANCILLARY_ATTRIBUTE10, ANCILLARY_ATTRIBUTE11 ANCILLARY_ATTRIBUTE11, ANCILLARY_ATTRIBUTE12 ANCILLARY_ATTRIBUTE12, ANCILLARY_ATTRIBUTE13 ANCILLARY_ATTRIBUTE13, ANCILLARY_ATTRIBUTE14 ANCILLARY_ATTRIBUTE14, ANCILLARY_ATTRIBUTE15 ANCILLARY_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, ATTRIBUTE16 ATTRIBUTE16, ATTRIBUTE17 ATTRIBUTE17, ATTRIBUTE18 ATTRIBUTE18, ATTRIBUTE19 ATTRIBUTE19, ATTRIBUTE20 ATTRIBUTE20, EFFECTIVE_DT EFFECTIVE_DT, TRANSACTION_DT TRANSACTION_DT, ORG_ID ORG_ID, ERROR_MSG ERROR_MSG, VALIDATION_FLAG VALIDATION_FLAG, REQUEST_ID REQUEST_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, 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 FROM IGS_FI_ANC_INT_ALL A

View Text - HTML Formatted

SELECT ROWID ROW_ID
, ANCILLARY_INT_ID ANCILLARY_INT_ID
, PERSON_ID PERSON_ID
, PERSON_ID_TYPE PERSON_ID_TYPE
, API_PERSON_ID API_PERSON_ID
, STATUS STATUS
, FEE_TYPE FEE_TYPE
, FEE_CAL_TYPE FEE_CAL_TYPE
, FEE_CI_SEQUENCE_NUMBER FEE_CI_SEQUENCE_NUMBER
, OVERRIDE_DR_REC_ACCOUNT_CD OVERRIDE_DR_REC_ACCOUNT_CD
, OVERRIDE_DR_REC_CCID OVERRIDE_DR_REC_CCID
, OVERRIDE_CR_REV_ACCOUNT_CD OVERRIDE_CR_REV_ACCOUNT_CD
, OVERRIDE_CR_REV_CCID OVERRIDE_CR_REV_CCID
, ANCILLARY_ATTRIBUTE1 ANCILLARY_ATTRIBUTE1
, ANCILLARY_ATTRIBUTE2 ANCILLARY_ATTRIBUTE2
, ANCILLARY_ATTRIBUTE3 ANCILLARY_ATTRIBUTE3
, ANCILLARY_ATTRIBUTE4 ANCILLARY_ATTRIBUTE4
, ANCILLARY_ATTRIBUTE5 ANCILLARY_ATTRIBUTE5
, ANCILLARY_ATTRIBUTE6 ANCILLARY_ATTRIBUTE6
, ANCILLARY_ATTRIBUTE7 ANCILLARY_ATTRIBUTE7
, ANCILLARY_ATTRIBUTE8 ANCILLARY_ATTRIBUTE8
, ANCILLARY_ATTRIBUTE9 ANCILLARY_ATTRIBUTE9
, ANCILLARY_ATTRIBUTE10 ANCILLARY_ATTRIBUTE10
, ANCILLARY_ATTRIBUTE11 ANCILLARY_ATTRIBUTE11
, ANCILLARY_ATTRIBUTE12 ANCILLARY_ATTRIBUTE12
, ANCILLARY_ATTRIBUTE13 ANCILLARY_ATTRIBUTE13
, ANCILLARY_ATTRIBUTE14 ANCILLARY_ATTRIBUTE14
, ANCILLARY_ATTRIBUTE15 ANCILLARY_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
, ATTRIBUTE16 ATTRIBUTE16
, ATTRIBUTE17 ATTRIBUTE17
, ATTRIBUTE18 ATTRIBUTE18
, ATTRIBUTE19 ATTRIBUTE19
, ATTRIBUTE20 ATTRIBUTE20
, EFFECTIVE_DT EFFECTIVE_DT
, TRANSACTION_DT TRANSACTION_DT
, ORG_ID ORG_ID
, ERROR_MSG ERROR_MSG
, VALIDATION_FLAG VALIDATION_FLAG
, REQUEST_ID REQUEST_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, 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
FROM IGS_FI_ANC_INT_ALL A