VIEW: APPS.IGS_FI_INV_IGF_V

Source

View Text - Preformatted

SELECT a.ROWID, a.INVOICE_ID, a.PERSON_ID, a.SPONSOR_CD, a.FEE_TYPE, a.FEE_CAT, a.FEE_CAL_TYPE, a.FEE_CI_SEQUENCE_NUMBER, a.COURSE_CD, a.ATTENDANCE_MODE, a.ATTENDANCE_TYPE, a.INVOICE_AMOUNT_DUE, a.INVOICE_CREATION_DATE, a.INVOICE_DESC, a.TRANSACTION_TYPE, a.CURRENCY_CD, a.EXCHANGE_RATE, a.ACCOUNT_ID, a.TERM_ID, a.STATUS, a.ATTRIBUTE_CATEGORY, a.ATTRIBUTE1, a.ATTRIBUTE2, a.ATTRIBUTE3, a.ATTRIBUTE4, a.ATTRIBUTE5, a.ATTRIBUTE6, a.ATTRIBUTE7, a.ATTRIBUTE8, a.ATTRIBUTE9, a.ATTRIBUTE10, a.ORG_ID, a.MERCHANT_ID, a.CREDIT_CARD_CODE, a.CREDIT_CARD_HOLDER_NAME, a.CREDIT_CARD_EXPIRATION_DATE , a.CREDIT_CARD_APPROVAL_CODE, a.CREDIT_CARD_APPROVAL_DATE, a.PAYMENT_SERVER_ORDER_NUMBER, a.PAYMENT_SERVER_TXN_DATE, a.PAYMENT_SERVER_TXN_STATUS, a.PAYMENT_SERVER_ERROR_CODE, a.PAYMENT_SERVER_ERROR_MSG, a.BEP_ERROR_CODE, a.BEP_ERROR_MSG, a.ERROR_LOCATION, a.AUTHORIZED_AMOUNT, a.RECEIPT_METHOD_ID, a.RECEIPT_METHOD_NAME, a.CUSTOMER_BANK_ACCOUNT_ID, a.CUSTOMER_BANK_ACCOUNT_NAME, a.PROCESSED_IN_SSA, a.PAYMENT_METHOD, a.PAYMENT_STATUS, a.SUBACCOUNT_ID, a.INVOICE_AMOUNT, a.BILL_ID, a.BILL_NUMBER, a.BILL_DATE, a.WAIVER_FLAG, a.WAIVER_REASON, a.EFFECTIVE_DATE, a.INVOICE_NUMBER, a.BILL_PAYMENT_DUE_DATE, a.SOURCE_TRANSACTION_ID, a.OPTIONAL_FEE_FLAG, b.FEE_CLASS, a.LAST_UPDATE_DATE, a.LAST_UPDATED_BY, a.CREATION_DATE, a.CREATED_BY, a.LAST_UPDATE_LOGIN, a.REQUEST_ID, a.PROGRAM_APPLICATION_ID, a.PROGRAM_ID, a.PROGRAM_UPDATE_DATE FROM IGS_FI_INV_INT a, IGS_FI_FEE_TYPE b WHERE a.FEE_TYPE = b.FEE_TYPE

View Text - HTML Formatted

SELECT A.ROWID
, A.INVOICE_ID
, A.PERSON_ID
, A.SPONSOR_CD
, A.FEE_TYPE
, A.FEE_CAT
, A.FEE_CAL_TYPE
, A.FEE_CI_SEQUENCE_NUMBER
, A.COURSE_CD
, A.ATTENDANCE_MODE
, A.ATTENDANCE_TYPE
, A.INVOICE_AMOUNT_DUE
, A.INVOICE_CREATION_DATE
, A.INVOICE_DESC
, A.TRANSACTION_TYPE
, A.CURRENCY_CD
, A.EXCHANGE_RATE
, A.ACCOUNT_ID
, A.TERM_ID
, A.STATUS
, A.ATTRIBUTE_CATEGORY
, A.ATTRIBUTE1
, A.ATTRIBUTE2
, A.ATTRIBUTE3
, A.ATTRIBUTE4
, A.ATTRIBUTE5
, A.ATTRIBUTE6
, A.ATTRIBUTE7
, A.ATTRIBUTE8
, A.ATTRIBUTE9
, A.ATTRIBUTE10
, A.ORG_ID
, A.MERCHANT_ID
, A.CREDIT_CARD_CODE
, A.CREDIT_CARD_HOLDER_NAME
, A.CREDIT_CARD_EXPIRATION_DATE
, A.CREDIT_CARD_APPROVAL_CODE
, A.CREDIT_CARD_APPROVAL_DATE
, A.PAYMENT_SERVER_ORDER_NUMBER
, A.PAYMENT_SERVER_TXN_DATE
, A.PAYMENT_SERVER_TXN_STATUS
, A.PAYMENT_SERVER_ERROR_CODE
, A.PAYMENT_SERVER_ERROR_MSG
, A.BEP_ERROR_CODE
, A.BEP_ERROR_MSG
, A.ERROR_LOCATION
, A.AUTHORIZED_AMOUNT
, A.RECEIPT_METHOD_ID
, A.RECEIPT_METHOD_NAME
, A.CUSTOMER_BANK_ACCOUNT_ID
, A.CUSTOMER_BANK_ACCOUNT_NAME
, A.PROCESSED_IN_SSA
, A.PAYMENT_METHOD
, A.PAYMENT_STATUS
, A.SUBACCOUNT_ID
, A.INVOICE_AMOUNT
, A.BILL_ID
, A.BILL_NUMBER
, A.BILL_DATE
, A.WAIVER_FLAG
, A.WAIVER_REASON
, A.EFFECTIVE_DATE
, A.INVOICE_NUMBER
, A.BILL_PAYMENT_DUE_DATE
, A.SOURCE_TRANSACTION_ID
, A.OPTIONAL_FEE_FLAG
, B.FEE_CLASS
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATE_LOGIN
, A.REQUEST_ID
, A.PROGRAM_APPLICATION_ID
, A.PROGRAM_ID
, A.PROGRAM_UPDATE_DATE
FROM IGS_FI_INV_INT A
, IGS_FI_FEE_TYPE B
WHERE A.FEE_TYPE = B.FEE_TYPE