View: OKL_AM_RESTRUCTURE_LINES_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_AM_RESTRUCTURE_LINES_UV

View Text

SELECT OTQ.ID QTE_ID
, OTQ.KHR_ID
, OTQ.QUOTE_NUMBER
, OTQ.QTP_CODE
, FL2.MEANING QUOTE_TYPE
, OTQ.QST_CODE
, FL1.MEANING QUOTE_STATUS
, OTQ.DATE_EFFECTIVE_FROM
, OTQ.DATE_EFFECTIVE_TO
, OTQ.RENT_AMOUNT
, OKF.START_DATE
, OKF.END_DATE
, OTQ.ACCEPTED_YN
, OTQ.APPROVED_YN
, OTQ.QRS_CODE
, FL3.MEANING QUOTE_REASON
, OTQ.TERM
, OTQ.YIELD
, OTQ.COMMENTS
, OKF.CONTRACT_NUMBER
, OTQ.CONSOLIDATED_QTE_ID CONSOLIDATED_QTE_ID
, OTQ.CONSOLIDATED_YN CONSOLIDATED_YN
, OTQ.PURCHASE_AMOUNT PURCHASE_AMOUNT
, OTQ.PURCHASE_FORMULA PURCHASE_FORMULA
, QTL.ID ID
, QTL.START_DATE LINE_START_DATE
, QTL.PERIOD PERIOD
, QTL.NUMBER_OF_PERIODS NUMBER_OF_PERIODS
, QTL.LOCK_LEVEL_STEP LOCK_LEVEL_STEP
, QTL.ADVANCE_OR_ARREARS ADVANCE_OR_ARREARS
, QTL.YIELD_NAME YIELD_NAME
, QTL.YIELD_VALUE YIELD_VALUE
, QTL.IMPLICIT_INTEREST_RATE IMPLICIT_INTEREST_RATE
, QTL.AMOUNT AMOUNT
, QTL.QLT_CODE QLT_CODE
, FL4.MEANING QUOTE_LINE_TYPE
, QTL.LINE_NUMBER LINE_NUMBER
, OTQ.DATE_RESTRUCTURE_START DATE_RESTRUCTURE_START
, OTQ.DATE_RESTRUCTURE_END DATE_RESTRUCTURE_END
FROM OKL_TRX_QUOTES_V OTQ
, OKC_K_HEADERS_B OKF
, OKL_TXL_QUOTE_LINES_V QTL
, FND_LOOKUPS FL1
, FND_LOOKUPS FL2
, FND_LOOKUPS FL3
, FND_LOOKUPS FL4
WHERE FL1.LOOKUP_TYPE = 'OKL_QUOTE_STATUS'
AND FL2.LOOKUP_TYPE = 'OKL_QUOTE_TYPE'
AND FL3.LOOKUP_TYPE = 'OKL_QUOTE_REASON'
AND FL4.LOOKUP_TYPE= 'OKL_QUOTE_LINE_TYPE'
AND FL1.LOOKUP_CODE = OTQ.QST_CODE
AND FL2.LOOKUP_CODE = OTQ.QTP_CODE
AND FL3.LOOKUP_CODE = OTQ.QRS_CODE
AND FL4.LOOKUP_CODE = QTL.QLT_CODE
AND OTQ.QTP_CODE LIKE 'RES%'
AND OTQ.KHR_ID = OKF.ID (+)
AND OTQ.ID = QTL.QTE_ID

Columns