View: OKL_AM_QUOTE_PARTIES_UV

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

View Text

SELECT TQ.ID QUOTE_ID
, TQ.KHR_ID CONTRACT_ID
, QP.ID QP_PARTY_ID
, QP.QPT_CODE QP_ROLE_CODE
, LQ.MEANING QP_PARTY_ROLE
, QP.DATE_SENT QP_DATE_SENT
, TO_CHAR(NULL) QP_DATE_HOLD
, QP.DELAY_DAYS QP_DELAY_DAYS
, QP.ALLOCATION_PERCENTAGE QP_ALLOCATION_PERCENTAGE
, QP.EMAIL_ADDRESS QP_EMAIL_ADDRESS
, QP.PARTY_JTOT_OBJECT1_CODE QP_PARTY_OBJECT
, QP.PARTY_OBJECT1_ID1 QP_PARTY_ID1
, QP.PARTY_OBJECT1_ID2 QP_PARTY_ID2
, QP.CONTACT_JTOT_OBJECT1_CODE QP_CONTACT_OBJECT
, QP.CONTACT_OBJECT1_ID1 QP_CONTACT_ID1
, QP.CONTACT_OBJECT1_ID2 QP_CONTACT_ID2
, QP.CREATED_BY QP_CREATED_BY
, QP.CREATION_DATE QP_CREATION_DATE
, QP.LAST_UPDATED_BY QP_LAST_UPDATED_BY
, QP.LAST_UPDATE_DATE QP_LAST_UPDATE_DATE
, QP.LAST_UPDATE_LOGIN QP_LAST_UPDATE_LOGIN
, PR.ID KP_PARTY_ID
, PR.RLE_CODE KP_ROLE_CODE
, LK.MEANING KP_PARTY_ROLE
, PR.JTOT_OBJECT1_CODE PO_PARTY_OBJECT
, PR.OBJECT1_ID1 PO_PARTY_ID1
, PR.OBJECT1_ID2 PO_PARTY_ID2
, NVL2 (QP.CPL_ID
, OKL_AM_UTIL_PVT.GET_JTF_OBJECT_NAME (PR.JTOT_OBJECT1_CODE
, PR.OBJECT1_ID1
, PR.OBJECT1_ID2)
, OKL_AM_UTIL_PVT.GET_JTF_OBJECT_NAME (QP.PARTY_JTOT_OBJECT1_CODE
, QP.PARTY_OBJECT1_ID1
, QP.PARTY_OBJECT1_ID2)) PARTY_NAME
, NVL2 (QP.CONTACT_JTOT_OBJECT1_CODE
, OKL_AM_UTIL_PVT.GET_JTF_OBJECT_NAME (QP.CONTACT_JTOT_OBJECT1_CODE
, QP.CONTACT_OBJECT1_ID1
, QP.CONTACT_OBJECT1_ID2)
, NULL) CONTACT_NAME
FROM OKL_TRX_QUOTES_B TQ
, OKL_QUOTE_PARTIES_V QP
, OKC_K_PARTY_ROLES_V PR
, FND_LOOKUPS LQ
, FND_LOOKUPS LK
WHERE QP.QTE_ID = TQ.ID
AND PR.ID (+) = QP.CPL_ID
AND LQ.LOOKUP_CODE (+) = QP.QPT_CODE
AND LQ.LOOKUP_TYPE (+) = 'OKL_QUOTE_PARTY_TYPE'
AND LK.LOOKUP_CODE (+) = PR.RLE_CODE
AND LK.LOOKUP_TYPE (+) = 'OKC_ROLE'

Columns