VIEW: APPS.OKL_TRX_QUOTES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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