VIEW: APPS.IGS_FI_EXT_CHGS_V

Source

View Text - Preformatted

SELECT CHG.ROWID, CHG.PERSON_ID, HZ.PARTY_NUMBER, CHG.INVOICE_ID, LN.INVOICE_LINES_ID, CHG.FEE_TYPE, CHG.FEE_CAL_TYPE, CHG.FEE_CI_SEQUENCE_NUMBER, CI.START_DT, CI.END_DT, CHG.INVOICE_NUMBER, CHG.INVOICE_CREATION_DATE, CHG.EFFECTIVE_DATE, CHG.INVOICE_AMOUNT, CHG.INVOICE_AMOUNT_DUE, LN.GL_DATE, LN.REC_ACCOUNT_CD, LN.REV_ACCOUNT_CD, LN.REC_GL_CCID, LN.REV_GL_CCID, CHG.WAIVER_FLAG, LN.ATTRIBUTE_CATEGORY, LN.ATTRIBUTE1, LN.ATTRIBUTE2, LN.ATTRIBUTE3, LN.ATTRIBUTE4, LN.ATTRIBUTE5, LN.ATTRIBUTE6, LN.ATTRIBUTE7, LN.ATTRIBUTE8, LN.ATTRIBUTE9, LN.ATTRIBUTE10, LN.ATTRIBUTE11, LN.ATTRIBUTE12, LN.ATTRIBUTE13, LN.ATTRIBUTE14, LN.ATTRIBUTE15, LN.ATTRIBUTE16, LN.ATTRIBUTE17, LN.ATTRIBUTE18, LN.ATTRIBUTE19, LN.ATTRIBUTE20, LN.POSTING_ID, LN.POSTING_CONTROL_ID, CHG.CREATED_BY, CHG.CREATION_DATE, CHG.LAST_UPDATED_BY, CHG.LAST_UPDATE_DATE, CHG.LAST_UPDATE_LOGIN FROM IGS_FI_INV_INT_ALL CHG, IGS_FI_INVLN_INT_ALL LN, HZ_PARTIES HZ, IGS_CA_INST CI WHERE CHG.TRANSACTION_TYPE = 'EXTERNAL' AND CHG.INVOICE_ID = LN.INVOICE_ID AND CHG.PERSON_ID = HZ.PARTY_ID AND CHG.FEE_CAL_TYPE = CI.CAL_TYPE AND CHG.FEE_CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER

View Text - HTML Formatted

SELECT CHG.ROWID
, CHG.PERSON_ID
, HZ.PARTY_NUMBER
, CHG.INVOICE_ID
, LN.INVOICE_LINES_ID
, CHG.FEE_TYPE
, CHG.FEE_CAL_TYPE
, CHG.FEE_CI_SEQUENCE_NUMBER
, CI.START_DT
, CI.END_DT
, CHG.INVOICE_NUMBER
, CHG.INVOICE_CREATION_DATE
, CHG.EFFECTIVE_DATE
, CHG.INVOICE_AMOUNT
, CHG.INVOICE_AMOUNT_DUE
, LN.GL_DATE
, LN.REC_ACCOUNT_CD
, LN.REV_ACCOUNT_CD
, LN.REC_GL_CCID
, LN.REV_GL_CCID
, CHG.WAIVER_FLAG
, LN.ATTRIBUTE_CATEGORY
, LN.ATTRIBUTE1
, LN.ATTRIBUTE2
, LN.ATTRIBUTE3
, LN.ATTRIBUTE4
, LN.ATTRIBUTE5
, LN.ATTRIBUTE6
, LN.ATTRIBUTE7
, LN.ATTRIBUTE8
, LN.ATTRIBUTE9
, LN.ATTRIBUTE10
, LN.ATTRIBUTE11
, LN.ATTRIBUTE12
, LN.ATTRIBUTE13
, LN.ATTRIBUTE14
, LN.ATTRIBUTE15
, LN.ATTRIBUTE16
, LN.ATTRIBUTE17
, LN.ATTRIBUTE18
, LN.ATTRIBUTE19
, LN.ATTRIBUTE20
, LN.POSTING_ID
, LN.POSTING_CONTROL_ID
, CHG.CREATED_BY
, CHG.CREATION_DATE
, CHG.LAST_UPDATED_BY
, CHG.LAST_UPDATE_DATE
, CHG.LAST_UPDATE_LOGIN
FROM IGS_FI_INV_INT_ALL CHG
, IGS_FI_INVLN_INT_ALL LN
, HZ_PARTIES HZ
, IGS_CA_INST CI
WHERE CHG.TRANSACTION_TYPE = 'EXTERNAL'
AND CHG.INVOICE_ID = LN.INVOICE_ID
AND CHG.PERSON_ID = HZ.PARTY_ID
AND CHG.FEE_CAL_TYPE = CI.CAL_TYPE
AND CHG.FEE_CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER