VIEW: APPS.IGS_FI_ANC_INT_V

Source

View Text - Preformatted

SELECT FA.ROWID ROW_ID, FA.ANCILLARY_INT_ID, FA.PERSON_ID, HZ.PARTY_NUMBER PERSON_NUMBER, FA.PERSON_ID_TYPE, FA.API_PERSON_ID, FA.STATUS, FA.FEE_TYPE, FA.FEE_CAL_TYPE, FA.FEE_CI_SEQUENCE_NUMBER, FA.OVERRIDE_DR_REC_ACCOUNT_CD, FA.OVERRIDE_DR_REC_CCID, FA.OVERRIDE_CR_REV_ACCOUNT_CD, FA.OVERRIDE_CR_REV_CCID, FA.ANCILLARY_ATTRIBUTE1, FA.ANCILLARY_ATTRIBUTE2, FA.ANCILLARY_ATTRIBUTE3, FA.ANCILLARY_ATTRIBUTE4, FA.ANCILLARY_ATTRIBUTE5, FA.ANCILLARY_ATTRIBUTE6, FA.ANCILLARY_ATTRIBUTE7, FA.ANCILLARY_ATTRIBUTE8, FA.ANCILLARY_ATTRIBUTE9, FA.ANCILLARY_ATTRIBUTE10, FA.ANCILLARY_ATTRIBUTE11, FA.ANCILLARY_ATTRIBUTE12, FA.ANCILLARY_ATTRIBUTE13, FA.ANCILLARY_ATTRIBUTE14, FA.ANCILLARY_ATTRIBUTE15, FA.ATTRIBUTE_CATEGORY, FA.ATTRIBUTE1, FA.ATTRIBUTE2, FA.ATTRIBUTE3, FA.ATTRIBUTE4, FA.ATTRIBUTE5, FA.ATTRIBUTE6, FA.ATTRIBUTE7, FA.ATTRIBUTE8, FA.ATTRIBUTE9, FA.ATTRIBUTE10, FA.ATTRIBUTE11, FA.ATTRIBUTE12, FA.ATTRIBUTE13, FA.ATTRIBUTE14, FA.ATTRIBUTE15, FA.ATTRIBUTE16, FA.ATTRIBUTE17, FA.ATTRIBUTE18, FA.ATTRIBUTE19, FA.ATTRIBUTE20, FA.EFFECTIVE_DT, FA.TRANSACTION_DT, FA.ORG_ID, FA.ERROR_MSG, FA.VALIDATION_FLAG, FA.REQUEST_ID, FA.PROGRAM_ID, FA.PROGRAM_APPLICATION_ID, FA.PROGRAM_UPDATE_DATE, FA.CREATED_BY, FA.CREATION_DATE, FA.LAST_UPDATED_BY, FA.LAST_UPDATE_DATE, FA.LAST_UPDATE_LOGIN FROM IGS_FI_ANC_INT FA, HZ_PARTIES HZ WHERE HZ.PARTY_ID (+) = FA.PERSON_ID

View Text - HTML Formatted

SELECT FA.ROWID ROW_ID
, FA.ANCILLARY_INT_ID
, FA.PERSON_ID
, HZ.PARTY_NUMBER PERSON_NUMBER
, FA.PERSON_ID_TYPE
, FA.API_PERSON_ID
, FA.STATUS
, FA.FEE_TYPE
, FA.FEE_CAL_TYPE
, FA.FEE_CI_SEQUENCE_NUMBER
, FA.OVERRIDE_DR_REC_ACCOUNT_CD
, FA.OVERRIDE_DR_REC_CCID
, FA.OVERRIDE_CR_REV_ACCOUNT_CD
, FA.OVERRIDE_CR_REV_CCID
, FA.ANCILLARY_ATTRIBUTE1
, FA.ANCILLARY_ATTRIBUTE2
, FA.ANCILLARY_ATTRIBUTE3
, FA.ANCILLARY_ATTRIBUTE4
, FA.ANCILLARY_ATTRIBUTE5
, FA.ANCILLARY_ATTRIBUTE6
, FA.ANCILLARY_ATTRIBUTE7
, FA.ANCILLARY_ATTRIBUTE8
, FA.ANCILLARY_ATTRIBUTE9
, FA.ANCILLARY_ATTRIBUTE10
, FA.ANCILLARY_ATTRIBUTE11
, FA.ANCILLARY_ATTRIBUTE12
, FA.ANCILLARY_ATTRIBUTE13
, FA.ANCILLARY_ATTRIBUTE14
, FA.ANCILLARY_ATTRIBUTE15
, FA.ATTRIBUTE_CATEGORY
, FA.ATTRIBUTE1
, FA.ATTRIBUTE2
, FA.ATTRIBUTE3
, FA.ATTRIBUTE4
, FA.ATTRIBUTE5
, FA.ATTRIBUTE6
, FA.ATTRIBUTE7
, FA.ATTRIBUTE8
, FA.ATTRIBUTE9
, FA.ATTRIBUTE10
, FA.ATTRIBUTE11
, FA.ATTRIBUTE12
, FA.ATTRIBUTE13
, FA.ATTRIBUTE14
, FA.ATTRIBUTE15
, FA.ATTRIBUTE16
, FA.ATTRIBUTE17
, FA.ATTRIBUTE18
, FA.ATTRIBUTE19
, FA.ATTRIBUTE20
, FA.EFFECTIVE_DT
, FA.TRANSACTION_DT
, FA.ORG_ID
, FA.ERROR_MSG
, FA.VALIDATION_FLAG
, FA.REQUEST_ID
, FA.PROGRAM_ID
, FA.PROGRAM_APPLICATION_ID
, FA.PROGRAM_UPDATE_DATE
, FA.CREATED_BY
, FA.CREATION_DATE
, FA.LAST_UPDATED_BY
, FA.LAST_UPDATE_DATE
, FA.LAST_UPDATE_LOGIN
FROM IGS_FI_ANC_INT FA
, HZ_PARTIES HZ
WHERE HZ.PARTY_ID (+) = FA.PERSON_ID