VIEW: APPS.IGS_FI_BILL_DPSTS_V

Source

View Text - Preformatted

SELECT BDP.ROWID, BDP.BILL_ID, BDP.CREDIT_ACTIVITY_ID, CRA.TRANSACTION_DATE, CRD.CREDIT_NUMBER, CRT.CREDIT_CLASS, LKV.MEANING, CRD.CREDIT_TYPE_ID, CRT.CREDIT_TYPE_NAME, CRA.AMOUNT, BDP.CREATED_BY, BDP.CREATION_DATE, BDP.LAST_UPDATED_BY, BDP.LAST_UPDATE_DATE, BDP.LAST_UPDATE_LOGIN FROM IGS_FI_BILL_DPSTS BDP, IGS_FI_CR_ACTIVITIES CRA, IGS_FI_CREDITS CRD, IGS_FI_CR_TYPES CRT, IGS_LOOKUP_VALUES LKV WHERE BDP.CREDIT_ACTIVITY_ID = CRA.CREDIT_ACTIVITY_ID AND CRA.CREDIT_ID = CRD.CREDIT_ID AND CRD.CREDIT_TYPE_ID = CRT.CREDIT_TYPE_ID AND CRT.CREDIT_CLASS= LKV.LOOKUP_CODE AND LKV.LOOKUP_TYPE = 'IGS_FI_CREDIT_CLASS'

View Text - HTML Formatted

SELECT BDP.ROWID
, BDP.BILL_ID
, BDP.CREDIT_ACTIVITY_ID
, CRA.TRANSACTION_DATE
, CRD.CREDIT_NUMBER
, CRT.CREDIT_CLASS
, LKV.MEANING
, CRD.CREDIT_TYPE_ID
, CRT.CREDIT_TYPE_NAME
, CRA.AMOUNT
, BDP.CREATED_BY
, BDP.CREATION_DATE
, BDP.LAST_UPDATED_BY
, BDP.LAST_UPDATE_DATE
, BDP.LAST_UPDATE_LOGIN
FROM IGS_FI_BILL_DPSTS BDP
, IGS_FI_CR_ACTIVITIES CRA
, IGS_FI_CREDITS CRD
, IGS_FI_CR_TYPES CRT
, IGS_LOOKUP_VALUES LKV
WHERE BDP.CREDIT_ACTIVITY_ID = CRA.CREDIT_ACTIVITY_ID
AND CRA.CREDIT_ID = CRD.CREDIT_ID
AND CRD.CREDIT_TYPE_ID = CRT.CREDIT_TYPE_ID
AND CRT.CREDIT_CLASS= LKV.LOOKUP_CODE
AND LKV.LOOKUP_TYPE = 'IGS_FI_CREDIT_CLASS'