Product: | IGS - Student System |
---|---|
Description: | The view contains information on the charges(of type external) that are created at the time of receipt creation. |
Implementation/DBA Data: | APPS.IGS_FI_OTC_CHARGES_V |
SELECT INV.ROWID
, OINV.OTC_CHARGE_ID
, OINV.CREDIT_ID
, INV.INVOICE_ID
, INVLN.GL_DATE
, INV.PERSON_ID
, INV.SPONSOR_CD
, INV.FEE_TYPE
, INV.FEE_CAT
, INV.FEE_CAL_TYPE
, INV.FEE_CI_SEQUENCE_NUMBER
, INV.COURSE_CD
, INV.ATTENDANCE_MODE
, INV.ATTENDANCE_TYPE
, INV.INVOICE_AMOUNT_DUE
, INV.INVOICE_CREATION_DATE
, INV.INVOICE_DESC
, INV.TRANSACTION_TYPE
, INV.CURRENCY_CD
, INV.ACCOUNT_ID
, INV.TERM_ID
, INV.STATUS
, INV.ATTRIBUTE_CATEGORY
, INV.ATTRIBUTE1
, INV.ATTRIBUTE2
, INV.ATTRIBUTE3
, INV.ATTRIBUTE4
, INV.ATTRIBUTE5
, INV.ATTRIBUTE6
, INV.ATTRIBUTE7
, INV.ATTRIBUTE8
, INV.ATTRIBUTE9
, INV.ATTRIBUTE10
, INV.ORG_ID
, INV.MERCHANT_ID
, INV.CREDIT_CARD_CODE
, INV.CREDIT_CARD_HOLDER_NAME
, INV.CREDIT_CARD_EXPIRATION_DATE
, INV.CREDIT_CARD_APPROVAL_CODE
, INV.CREDIT_CARD_APPROVAL_DATE
, INV.PAYMENT_SERVER_ORDER_NUMBER
, INV.PAYMENT_SERVER_TXN_DATE
, INV.PAYMENT_SERVER_TXN_STATUS
, INV.PAYMENT_SERVER_ERROR_CODE
, INV.PAYMENT_SERVER_ERROR_MSG
, INV.BEP_ERROR_CODE
, INV.BEP_ERROR_MSG
, INV.ERROR_LOCATION
, INV.AUTHORIZED_AMOUNT
, INV.RECEIPT_METHOD_ID
, INV.RECEIPT_METHOD_NAME
, INV.CUSTOMER_BANK_ACCOUNT_ID
, INV.CUSTOMER_BANK_ACCOUNT_NAME
, INV.PROCESSED_IN_SSA
, INV.PAYMENT_METHOD
, INV.PAYMENT_STATUS
, INV.SUBACCOUNT_ID
, INV.INVOICE_AMOUNT
, INV.BILL_ID
, INV.BILL_NUMBER
, INV.BILL_DATE
, INV.WAIVER_FLAG
, NULL
, INV.WAIVER_REASON
, INV.EFFECTIVE_DATE
, INV.INVOICE_NUMBER
, INV.BILL_PAYMENT_DUE_DATE
, INV.SOURCE_TRANSACTION_ID
, INVLN.REC_ACCOUNT_CD
, AC1.DESCRIPTION
, INVLN.REV_ACCOUNT_CD
, AC2.DESCRIPTION
, INVLN.REC_GL_CCID
, INVLN.REV_GL_CCID
, INVLN.POSTING_ID
, INVLN.POSTING_CONTROL_ID
, INV.LAST_UPDATE_DATE
, INV.LAST_UPDATED_BY
, INV.CREATION_DATE
, INV.CREATED_BY
, INV.LAST_UPDATE_LOGIN
, INV.REQUEST_ID
, INV.PROGRAM_APPLICATION_ID
, INV.PROGRAM_ID
, INV.PROGRAM_UPDATE_DATE
FROM IGS_FI_INV_INT INV
, IGS_FI_OTC_CHARGES OINV
, IGS_FI_INVLN_INT INVLN
, IGS_FI_ACC AC1
, IGS_FI_ACC AC2
WHERE INV.INVOICE_ID = OINV.INVOICE_ID
AND INV.INVOICE_ID = INVLN.INVOICE_ID
AND INVLN.REC_ACCOUNT_CD = AC1.ACCOUNT_CD (+)
AND INVLN.REV_ACCOUNT_CD = AC2.ACCOUNT_CD (+)