View: OKL_AM_QUOTE_HEADER_UV

Product:	OKL - Lease and Finance Management
Description:	Quote header details
Implementation/DBA Data:	APPS.OKL_AM_QUOTE_HEADER_UV

View Text

SELECT QTE.ID ID
, QTE.QUOTE_NUMBER QUOTE_NUMBER
, QTE.QTP_CODE QUOTE_TYPE
, FND2.MEANING QUOTE_TYPE_DESCRIPTION
, QTE.QST_CODE QUOTE_STATUS
, FND1.MEANING QUOTE_STATUS_DESCRIPTION
, QTE.DATE_EFFECTIVE_TO DATE_EFFECTIVE_TO
, KHR.ID KHR_ID
, CHR.CONTRACT_NUMBER CONTRACT_NUMBER
, HZ.PARTY_NAME CUSTOMER
, PROGRAM.CONTRACT_NUMBER PROGRAM
, OKL_AM_UTIL_PVT.GET_PARTY_NAME(KHR.ID
, 'PRIVATE_LABEL'
, NULL) PRIVATE_LABEL
, QTE.ORG_ID QUOTE_ORG_ID
, QTE.ASSET_VALUE TOTAL_ASSET_VALUE
, QTE.RESIDUAL_VALUE TOTAL_RESIDUAL_VALUE
, QTE.UNBILLED_RECEIVABLES TOTAL_UNBILLED_RECEIVABLES
, QTE.GAIN_LOSS GAIN_LOSS
, OKL_AM_UTIL_PVT.GET_QUOTE_AMOUNT (QTE.ID) AMOUNT
, QTE.DATE_EFFECTIVE_FROM DATE_EFFECTIVE_FROM
, QTE.CREATION_DATE QUOTE_CREATION_DATE
, QTE.DATE_ACCEPTED DATE_ACCEPTED
, OKL_AM_UTIL_PVT.GET_ANTICIPATED_BILL(QTE.ID) ANTICIPATED_BILL_AMOUNT
FROM OKL_TRX_QUOTES_ALL_B QTE
, OKC_K_HEADERS_ALL_B PROGRAM
, FND_LOOKUPS FND1
, FND_LOOKUPS FND2
, HZ_PARTIES HZ
, OKC_K_PARTY_ROLES_B KPR
, OKC_K_HEADERS_B CHR
, OKL_K_HEADERS KHR
WHERE CHR.ID=KHR.ID
AND PROGRAM.ID (+) = KHR.KHR_ID
AND QTE.KHR_ID = KHR.ID
AND FND1.LOOKUP_TYPE = 'OKL_QUOTE_STATUS'
AND FND2.LOOKUP_TYPE = 'OKL_QUOTE_TYPE'
AND FND1.LOOKUP_CODE = QTE.QST_CODE
AND FND2.LOOKUP_CODE = QTE.QTP_CODE
AND HZ.PARTY_ID = KPR.OBJECT1_ID1
AND KPR.CHR_ID = KHR.ID
AND KPR.JTOT_OBJECT1_CODE = 'OKX_PARTY'
AND KPR.RLE_CODE = 'LESSEE'

Columns