VIEW: APPS.OKL_AM_RESTRUCTURE_LINES_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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