VIEW: APPS.IGS_FI_INV_INT_V

Source

View Text - Preformatted

SELECT INV.ROWID, INV.INVOICE_ID, INV.PERSON_ID, INV.SPONSOR_CD, INV.FEE_TYPE, INV.FEE_CAT, INV.FEE_CAL_TYPE, 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.EXCHANGE_RATE, 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, LKV.MEANING, INV.WAIVER_REASON, INV.EFFECTIVE_DATE, INV.INVOICE_NUMBER, INV.BILL_PAYMENT_DUE_DATE, INV.SOURCE_TRANSACTION_ID, INV.OPTIONAL_FEE_FLAG, 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, INV.REVERSAL_GL_DATE, INV.TAX_YEAR_CODE, INV.WAIVER_NAME FROM IGS_FI_INV_INT INV, IGS_LOOKUP_VALUES LKV WHERE INV.WAIVER_REASON = LKV.LOOKUP_CODE (+) AND LKV.LOOKUP_TYPE (+) = 'IGS_FI_WAIVER_REASON'

View Text - HTML Formatted

SELECT INV.ROWID
, INV.INVOICE_ID
, INV.PERSON_ID
, INV.SPONSOR_CD
, INV.FEE_TYPE
, INV.FEE_CAT
, INV.FEE_CAL_TYPE
, 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.EXCHANGE_RATE
, 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
, LKV.MEANING
, INV.WAIVER_REASON
, INV.EFFECTIVE_DATE
, INV.INVOICE_NUMBER
, INV.BILL_PAYMENT_DUE_DATE
, INV.SOURCE_TRANSACTION_ID
, INV.OPTIONAL_FEE_FLAG
, 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
, INV.REVERSAL_GL_DATE
, INV.TAX_YEAR_CODE
, INV.WAIVER_NAME
FROM IGS_FI_INV_INT INV
, IGS_LOOKUP_VALUES LKV
WHERE INV.WAIVER_REASON = LKV.LOOKUP_CODE (+)
AND LKV.LOOKUP_TYPE (+) = 'IGS_FI_WAIVER_REASON'