View: OKL_AM_ASSET_QUOTES_UV

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

View Text

SELECT OTQ.ID ID
, OTQ.QUOTE_NUMBER QUOTE_NUMBER
, OTQ.QTP_CODE QUOTE_TYPE
, FL2.MEANING QUOTE_TYPE_DESCRIPTION
, OTQ.QST_CODE QUOTE_STATUS
, FL1.MEANING QUOTE_STATUS_DESCRIPTION
, OTQ.QRS_CODE QUOTE_REASON
, FL3.MEANING QUOTE_REASON_DESCRIPTION
, OTQ.DATE_EFFECTIVE_FROM DATE_EFFECTIVE_FROM
, OTQ.DATE_EFFECTIVE_TO DATE_EFFECTIVE_TO
, OTQ.EARLY_TERMINATION_YN EARLY_TERMINATION_YN
, OTQ.APPROVED_YN APPROVED_YN
, OTQ.ACCEPTED_YN ACCEPTED_YN
, OTQ.SUMMARY_FORMAT_YN SUMMARY_FORMAT_YN
, OTQ.PREPROCEEDS_YN PREPROCEEDS_YN
, OTQ.PAYMENT_RECEIVED_YN PAYMENT_RECEIVED_YN
, OTQ.COMMENTS COMMENTS
, OKF.ID KHR_ID
, TO_NUMBER(NULL) PRODUCT_TYPE_ID
, OKF.CONTRACT_NUMBER CONTRACT_NUMBER
, OKF.START_DATE CONTRACT_START_DATE
, OKF.END_DATE CONTRACT_END_DATE
, OKF.STS_CODE CONTRACT_STATUS_CODE
, OSV.MEANING CONTRACT_STATUS_MEANING
, KLE.ID KLE_ID
, KLE.NAME ASSET_NUMBER
, KLE.ITEM_DESCRIPTION ASSET_DESCRIPTION
, QPT.ID QUOTE_PARTY_ID
, QPT.QPT_CODE QUOTE_PARTY_ROLE
, FL4.MEANING QUOTE_PARTY_DESCRIPTION
, QPT.DATE_SENT DATE_SENT
, KPR.ID CONTRACT_PARTY_ID
, KPR.RLE_CODE CONTRACT_PARTY_ROLE
, FL5.MEANING CONTRACT_PARTY_DESCRIPTION
, NVL2 (QPT.CPL_ID
, KPR.OBJECT1_ID1
, QPT.PARTY_OBJECT1_ID1) RECIPIENT_ID
, NVL2 (QPT.CPL_ID
, OKL_AM_UTIL_PVT.GET_JTF_OBJECT_NAME (KPR.JTOT_OBJECT1_CODE
, KPR.OBJECT1_ID1
, KPR.OBJECT1_ID2)
, OKL_AM_UTIL_PVT.GET_JTF_OBJECT_NAME (QPT.PARTY_JTOT_OBJECT1_CODE
, QPT.PARTY_OBJECT1_ID1
, QPT.PARTY_OBJECT1_ID2)) RECIPIENT_NAME
, NVL2 (QPT.CPL_ID
, OKL_AM_UTIL_PVT.GET_JTF_OBJECT_COLUMN ('PARTY_NUMBER'
, KPR.JTOT_OBJECT1_CODE
, KPR.OBJECT1_ID1
, KPR.OBJECT1_ID2)
, OKL_AM_UTIL_PVT.GET_JTF_OBJECT_COLUMN ('PARTY_NUMBER'
, QPT.PARTY_JTOT_OBJECT1_CODE
, QPT.PARTY_OBJECT1_ID1
, QPT.PARTY_OBJECT1_ID2)) RECIPIENT_NUMBER
, OKL_AM_UTIL_PVT.GET_TRX_MSGS_YN ('OKL_TRX_QUOTES_V'
, OTQ.ID) MESSAGES_YN
, OKL_AM_UTIL_PVT.GET_QUOTE_AMOUNT (OTQ.ID) AMOUNT
, OTQ.CONSOLIDATED_QTE_ID CONSOLIDATED_QTE_ID
, OTQ.CONSOLIDATED_YN CONSOLIDATED_YN
, OTQ.ORG_ID QUOTE_ORG_ID
, OTQ.CURRENCY_CODE CURRENCY_CODE
, OTQ.CURRENCY_CONVERSION_CODE CURRENCY_CONVERSION_CODE
, OTQ.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, OTQ.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, OTQ.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
FROM OKL_TRX_QUOTES_V OTQ
, OKC_K_HEADERS_B OKF
, OKC_STATUSES_V OSV
, OKL_QUOTE_PARTIES QPT
, OKC_K_PARTY_ROLES_B KPR
, OKL_TXL_QTE_LINES_ALL_B QTL
, OKC_K_LINES_TL KLE
, FND_LOOKUPS FL1
, FND_LOOKUPS FL2
, FND_LOOKUPS FL3
, FND_LOOKUPS FL4
, FND_LOOKUPS FL5
WHERE OTQ.KHR_ID = OKF.ID
AND OKF.STS_CODE = OSV.CODE
AND OTQ.ID = QPT.QTE_ID(+)
AND QPT.QPT_CODE(+) = 'RECIPIENT'
AND QPT.CPL_ID = KPR.ID(+)
AND OTQ.ID = QTL.QTE_ID
AND QTL.QLT_CODE = 'AMCFIA'
AND QTL.KLE_ID = KLE.ID
AND KLE.LANGUAGE = USERENV('LANG')
AND 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_PARTY_TYPE'
AND FL5.LOOKUP_TYPE(+) = 'OKC_ROLE'
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(+) = QPT.QPT_CODE
AND FL5.LOOKUP_CODE(+) = KPR.RLE_CODE

Columns