VIEW: APPS.IGS_FI_ACCT_V

Source

View Text - Preformatted

SELECT INV.PERSON_ID, INV.SUBACCOUNT_ID, INV.INVOICE_ID, INV.INVOICE_NUMBER, INV.INVOICE_CREATION_DATE, INV.INVOICE_AMOUNT, INV.BILL_NUMBER, INV.BILL_DATE, INV.FEE_TYPE, NULL CREDIT_TYPE_NAME, INV.INVOICE_DESC, INV.ORG_ID, INV.LAST_UPDATED_BY, INV.LAST_UPDATE_DATE, INV.LAST_UPDATE_LOGIN, INV.CREATED_BY, INV.CREATION_DATE FROM IGS_FI_INV_INT INV UNION ALL SELECT CRD.PARTY_ID, CRD.SUBACCOUNT_ID, CRDA.CREDIT_ACTIVITY_ID, CRD.CREDIT_NUMBER, CRDA.TRANSACTION_DATE, -(CRDA.AMOUNT), CRDA.BILL_NUMBER, CRDA.BILL_DATE, NULL FEE_TYPE, CRD.CREDIT_TYPE_NAME, CRD.DESCRIPTION, CRD.ORG_ID, CRDA.LAST_UPDATED_BY, CRDA.LAST_UPDATE_DATE, CRDA.LAST_UPDATE_LOGIN, CRDA.CREATED_BY, CRDA.CREATION_DATE FROM IGS_FI_CREDITS_V CRD, IGS_FI_CR_ACTIVITIES CRDA, IGS_FI_CR_TYPES CRT WHERE CRD.CREDIT_ID = CRDA.CREDIT_ID AND CRD.CREDIT_TYPE_ID = CRT.CREDIT_TYPE_ID AND CRT.CREDIT_CLASS NOT IN ('ENRDEPOSIT','OTHDEPOSIT')

View Text - HTML Formatted

SELECT INV.PERSON_ID
, INV.SUBACCOUNT_ID
, INV.INVOICE_ID
, INV.INVOICE_NUMBER
, INV.INVOICE_CREATION_DATE
, INV.INVOICE_AMOUNT
, INV.BILL_NUMBER
, INV.BILL_DATE
, INV.FEE_TYPE
, NULL CREDIT_TYPE_NAME
, INV.INVOICE_DESC
, INV.ORG_ID
, INV.LAST_UPDATED_BY
, INV.LAST_UPDATE_DATE
, INV.LAST_UPDATE_LOGIN
, INV.CREATED_BY
, INV.CREATION_DATE
FROM IGS_FI_INV_INT INV UNION ALL SELECT CRD.PARTY_ID
, CRD.SUBACCOUNT_ID
, CRDA.CREDIT_ACTIVITY_ID
, CRD.CREDIT_NUMBER
, CRDA.TRANSACTION_DATE
, -(CRDA.AMOUNT)
, CRDA.BILL_NUMBER
, CRDA.BILL_DATE
, NULL FEE_TYPE
, CRD.CREDIT_TYPE_NAME
, CRD.DESCRIPTION
, CRD.ORG_ID
, CRDA.LAST_UPDATED_BY
, CRDA.LAST_UPDATE_DATE
, CRDA.LAST_UPDATE_LOGIN
, CRDA.CREATED_BY
, CRDA.CREATION_DATE
FROM IGS_FI_CREDITS_V CRD
, IGS_FI_CR_ACTIVITIES CRDA
, IGS_FI_CR_TYPES CRT
WHERE CRD.CREDIT_ID = CRDA.CREDIT_ID
AND CRD.CREDIT_TYPE_ID = CRT.CREDIT_TYPE_ID
AND CRT.CREDIT_CLASS NOT IN ('ENRDEPOSIT'
, 'OTHDEPOSIT')