VIEW: APPS.IGS_FI_OTC_CHARGES_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)