VIEW: APPS.IGS_FI_CRDT_TRNSCTNS

Source

View Text - Preformatted

SELECT FC.PARTY_ID, FCT.SUBACCOUNT_ID, FCH.STATUS, FCH.CREDIT_ACTIVITY_ID, FC.EFFECTIVE_DATE, FC.CREDIT_NUMBER, FCT.CREDIT_TYPE_NAME, DECODE(FCH.STATUS, 'CLEARED', FC.DESCRIPTION, 'REVERSED', LV.MEANING, FC.DESCRIPTION), FCH.AMOUNT From IGS_FI_CR_ACTIVITIES FCH, IGS_FI_CREDITS FC, IGS_FI_CR_TYPES FCT, IGS_LOOKUP_VALUES LV WHERE FC.CREDIT_TYPE_ID = FCT.CREDIT_TYPE_ID And FCH.CREDIT_ID = FC.CREDIT_ID And LV.LOOKUP_CODE (+) = FC.REVERSAL_REASON_CODE And LV.LOOKUP_TYPE (+) = 'IGS_FI_REVERSAL_REASON' AND FCT.CREDIT_CLASS NOT IN ('OTHDEPOSIT','ENRDEPOSIT')

View Text - HTML Formatted

SELECT FC.PARTY_ID
, FCT.SUBACCOUNT_ID
, FCH.STATUS
, FCH.CREDIT_ACTIVITY_ID
, FC.EFFECTIVE_DATE
, FC.CREDIT_NUMBER
, FCT.CREDIT_TYPE_NAME
, DECODE(FCH.STATUS
, 'CLEARED'
, FC.DESCRIPTION
, 'REVERSED'
, LV.MEANING
, FC.DESCRIPTION)
, FCH.AMOUNT
FROM IGS_FI_CR_ACTIVITIES FCH
, IGS_FI_CREDITS FC
, IGS_FI_CR_TYPES FCT
, IGS_LOOKUP_VALUES LV
WHERE FC.CREDIT_TYPE_ID = FCT.CREDIT_TYPE_ID
AND FCH.CREDIT_ID = FC.CREDIT_ID
AND LV.LOOKUP_CODE (+) = FC.REVERSAL_REASON_CODE
AND LV.LOOKUP_TYPE (+) = 'IGS_FI_REVERSAL_REASON'
AND FCT.CREDIT_CLASS NOT IN ('OTHDEPOSIT'
, 'ENRDEPOSIT')