VIEW: APPS.IGS_FI_CR_ACTIVITIES_V

Source

View Text - Preformatted

SELECT CRA.ROWID, CRA.CREDIT_ACTIVITY_ID, CRA.CREDIT_ID, CRA.STATUS, LKV.MEANING, CRA.TRANSACTION_DATE, CRA.AMOUNT, CRA.DR_ACCOUNT_CD, ACC1.DESCRIPTION, CRA.CR_ACCOUNT_CD, ACC2.DESCRIPTION, CRA.DR_GL_CCID, CRA.CR_GL_CCID, CRA.BILL_ID, CRA.BILL_NUMBER, CRA.BILL_DATE, CRA.POSTING_ID, CRA.CREATED_BY, CRA.CREATION_DATE, CRA.LAST_UPDATED_BY, CRA.LAST_UPDATE_DATE, CRA.LAST_UPDATE_LOGIN, CRA.GL_DATE, CRA.GL_POSTED_DATE, CRA.POSTING_CONTROL_ID FROM IGS_FI_CR_ACTIVITIES CRA, IGS_FI_ACC ACC1, IGS_FI_ACC ACC2, IGS_LOOKUP_VALUES LKV WHERE CRA.DR_ACCOUNT_CD = ACC1.ACCOUNT_CD (+) AND CRA.CR_ACCOUNT_CD = ACC2.ACCOUNT_CD (+) AND CRA.STATUS = LKV.LOOKUP_CODE AND LKV.LOOKUP_TYPE = 'IGS_FI_CREDIT_STATUS'

View Text - HTML Formatted

SELECT CRA.ROWID
, CRA.CREDIT_ACTIVITY_ID
, CRA.CREDIT_ID
, CRA.STATUS
, LKV.MEANING
, CRA.TRANSACTION_DATE
, CRA.AMOUNT
, CRA.DR_ACCOUNT_CD
, ACC1.DESCRIPTION
, CRA.CR_ACCOUNT_CD
, ACC2.DESCRIPTION
, CRA.DR_GL_CCID
, CRA.CR_GL_CCID
, CRA.BILL_ID
, CRA.BILL_NUMBER
, CRA.BILL_DATE
, CRA.POSTING_ID
, CRA.CREATED_BY
, CRA.CREATION_DATE
, CRA.LAST_UPDATED_BY
, CRA.LAST_UPDATE_DATE
, CRA.LAST_UPDATE_LOGIN
, CRA.GL_DATE
, CRA.GL_POSTED_DATE
, CRA.POSTING_CONTROL_ID
FROM IGS_FI_CR_ACTIVITIES CRA
, IGS_FI_ACC ACC1
, IGS_FI_ACC ACC2
, IGS_LOOKUP_VALUES LKV
WHERE CRA.DR_ACCOUNT_CD = ACC1.ACCOUNT_CD (+)
AND CRA.CR_ACCOUNT_CD = ACC2.ACCOUNT_CD (+)
AND CRA.STATUS = LKV.LOOKUP_CODE
AND LKV.LOOKUP_TYPE = 'IGS_FI_CREDIT_STATUS'