Product: | OKL - Lease and Finance Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OKL_AM_RESTRUCTURE_QUOTES_UV |
SELECT OTQ.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
, OTQ.DATE_RESTRUCTURE_START DATE_RESTRUCTURE_START
, OTQ.DATE_RESTRUCTURE_END DATE_RESTRUCTURE_END
, OTQ.ORG_ID ORG_ID
, OTQ.POP_CODE_END POP_CODE_END
, FL4.MEANING ACCEPTED_YN_MEANING
FROM OKL_TRX_QUOTES_V OTQ
, OKC_K_HEADERS_ALL_B OKF
, 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 FL1.LOOKUP_CODE = OTQ.QST_CODE
AND FL2.LOOKUP_CODE = OTQ.QTP_CODE
AND FL3.LOOKUP_CODE = OTQ.QRS_CODE
AND OTQ.QTP_CODE LIKE 'RES%'
AND OTQ.KHR_ID = OKF.ID (+)
AND FL4.LOOKUP_TYPE = 'OKL_YES_NO'
AND FL4.LOOKUP_CODE = NVL(OTQ.ACCEPTED_YN
, 'N')