VIEW: OKL.OKL_TRX_QUOTES_ALL_B#

Source

View Text - Preformatted

select ID ID, QRS_CODE QRS_CODE, QST_CODE QST_CODE, CONSOLIDATED_QTE_ID CONSOLIDATED_QTE_ID, KHR_ID KHR_ID, ART_ID ART_ID, QTP_CODE QTP_CODE, TRN_CODE TRN_CODE, POP_CODE_END POP_CODE_END, POP_CODE_EARLY POP_CODE_EARLY, PDT_ID PDT_ID, DATE_EFFECTIVE_FROM DATE_EFFECTIVE_FROM, QUOTE_NUMBER QUOTE_NUMBER, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PURCHASE_PERCENT PURCHASE_PERCENT, TERM TERM, DATE_RESTRUCTURE_START DATE_RESTRUCTURE_START, DATE_DUE DATE_DUE, DATE_APPROVED DATE_APPROVED, DATE_RESTRUCTURE_END DATE_RESTRUCTURE_END, REMAINING_PAYMENTS REMAINING_PAYMENTS, RENT_AMOUNT RENT_AMOUNT, YIELD YIELD, RESIDUAL_AMOUNT RESIDUAL_AMOUNT, PRINCIPAL_PAYDOWN_AMOUNT PRINCIPAL_PAYDOWN_AMOUNT, PAYMENT_FREQUENCY PAYMENT_FREQUENCY, EARLY_TERMINATION_YN EARLY_TERMINATION_YN, PARTIAL_YN PARTIAL_YN, PREPROCEEDS_YN PREPROCEEDS_YN, SUMMARY_FORMAT_YN SUMMARY_FORMAT_YN, CONSOLIDATED_YN CONSOLIDATED_YN, DATE_REQUESTED DATE_REQUESTED, DATE_PROPOSAL DATE_PROPOSAL, DATE_EFFECTIVE_TO DATE_EFFECTIVE_TO, DATE_ACCEPTED DATE_ACCEPTED, PAYMENT_RECEIVED_YN PAYMENT_RECEIVED_YN, REQUESTED_BY REQUESTED_BY, APPROVED_YN APPROVED_YN, ACCEPTED_YN ACCEPTED_YN, DATE_PAYMENT_RECEIVED DATE_PAYMENT_RECEIVED, APPROVED_BY APPROVED_BY, ORG_ID ORG_ID, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PURCHASE_AMOUNT PURCHASE_AMOUNT, PURCHASE_FORMULA PURCHASE_FORMULA, ASSET_VALUE ASSET_VALUE, RESIDUAL_VALUE RESIDUAL_VALUE, UNBILLED_RECEIVABLES UNBILLED_RECEIVABLES, GAIN_LOSS GAIN_LOSS, CURRENCY_CODE CURRENCY_CODE, CURRENCY_CONVERSION_CODE CURRENCY_CONVERSION_CODE, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE, PERDIEM_AMOUNT PERDIEM_AMOUNT, LEGAL_ENTITY_ID LEGAL_ENTITY_ID, REPO_QUOTE_INDICATOR_YN REPO_QUOTE_INDICATOR_YN from "OKL"."OKL_TRX_QUOTES_ALL_B"

View Text - HTML Formatted

SELECT ID ID
, QRS_CODE QRS_CODE
, QST_CODE QST_CODE
, CONSOLIDATED_QTE_ID CONSOLIDATED_QTE_ID
, KHR_ID KHR_ID
, ART_ID ART_ID
, QTP_CODE QTP_CODE
, TRN_CODE TRN_CODE
, POP_CODE_END POP_CODE_END
, POP_CODE_EARLY POP_CODE_EARLY
, PDT_ID PDT_ID
, DATE_EFFECTIVE_FROM DATE_EFFECTIVE_FROM
, QUOTE_NUMBER QUOTE_NUMBER
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, PURCHASE_PERCENT PURCHASE_PERCENT
, TERM TERM
, DATE_RESTRUCTURE_START DATE_RESTRUCTURE_START
, DATE_DUE DATE_DUE
, DATE_APPROVED DATE_APPROVED
, DATE_RESTRUCTURE_END DATE_RESTRUCTURE_END
, REMAINING_PAYMENTS REMAINING_PAYMENTS
, RENT_AMOUNT RENT_AMOUNT
, YIELD YIELD
, RESIDUAL_AMOUNT RESIDUAL_AMOUNT
, PRINCIPAL_PAYDOWN_AMOUNT PRINCIPAL_PAYDOWN_AMOUNT
, PAYMENT_FREQUENCY PAYMENT_FREQUENCY
, EARLY_TERMINATION_YN EARLY_TERMINATION_YN
, PARTIAL_YN PARTIAL_YN
, PREPROCEEDS_YN PREPROCEEDS_YN
, SUMMARY_FORMAT_YN SUMMARY_FORMAT_YN
, CONSOLIDATED_YN CONSOLIDATED_YN
, DATE_REQUESTED DATE_REQUESTED
, DATE_PROPOSAL DATE_PROPOSAL
, DATE_EFFECTIVE_TO DATE_EFFECTIVE_TO
, DATE_ACCEPTED DATE_ACCEPTED
, PAYMENT_RECEIVED_YN PAYMENT_RECEIVED_YN
, REQUESTED_BY REQUESTED_BY
, APPROVED_YN APPROVED_YN
, ACCEPTED_YN ACCEPTED_YN
, DATE_PAYMENT_RECEIVED DATE_PAYMENT_RECEIVED
, APPROVED_BY APPROVED_BY
, ORG_ID ORG_ID
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PURCHASE_AMOUNT PURCHASE_AMOUNT
, PURCHASE_FORMULA PURCHASE_FORMULA
, ASSET_VALUE ASSET_VALUE
, RESIDUAL_VALUE RESIDUAL_VALUE
, UNBILLED_RECEIVABLES UNBILLED_RECEIVABLES
, GAIN_LOSS GAIN_LOSS
, CURRENCY_CODE CURRENCY_CODE
, CURRENCY_CONVERSION_CODE CURRENCY_CONVERSION_CODE
, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, PERDIEM_AMOUNT PERDIEM_AMOUNT
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, REPO_QUOTE_INDICATOR_YN REPO_QUOTE_INDICATOR_YN
FROM "OKL"."OKL_TRX_QUOTES_ALL_B"