Product: | OKL - Lease and Finance Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OKL_AM_REPURCHASE_ASSET_HDR_UV |
SELECT OTQ.ID QUOTE_ID
, OTQ.QUOTE_NUMBER QUOTE_NUMBER
, OTQ.DATE_EFFECTIVE_FROM DATE_EFFECTIVE_FROM
, OTQ.DATE_EFFECTIVE_TO DATE_EFFECTIVE_TO
, OTQ.APPROVED_YN APPROVED_YN
, OTQ.ACCEPTED_YN ACCEPTED_YN
, OTQ.COMMENTS COMMENTS
, OKC.CONTRACT_NUMBER CONTRACT_NUMBER
, OKC.END_DATE END_DATE
, OKC.ID KHR_ID
, KLE.NAME ASSET_NUMBER
, KLE.ITEM_DESCRIPTION ASSET_DESCRIPTION
, KLE.ID KLE_ID
, OAR.ID ART_ID
, OAR.REPURCHASE_AGMT_YN
, OAR.FLOOR_PRICE
, FL.MEANING STATUS
, TO_CHAR(NULL)
, OKL_AM_UTIL_PVT.GET_PROGRAM_PARTNER (OKC.ID)
, STS.CODE LINE_STS_CODE
, STS.MEANING LINE_STATUS
, OAR.ORG_ID ORG_ID
FROM OKL_TRX_QUOTES_V OTQ
, OKC_K_LINES_V KLE
, OKC_K_HEADERS_B OKC
, OKL_ASSET_RETURNS_V OAR
, FND_LOOKUPS FL
, OKC_STATUSES_V STS
WHERE OTQ.ART_ID (+) = OAR.ID
AND OKC.ID = KLE.CHR_ID
AND OAR.KLE_ID = KLE.ID
AND FL.LOOKUP_TYPE (+) = 'OKL_QUOTE_STATUS'
AND FL.LOOKUP_CODE (+) = OTQ.QST_CODE
AND KLE.STS_CODE = STS.CODE