View: OKL_LEASE_PRODUCTS_UV

Product:	OKL - Lease and Finance Management
Description:	User interface view for lease products and product parameters
Implementation/DBA Data:	APPS.OKL_LEASE_PRODUCTS_UV

View Text

SELECT PDT.ID ID
, PDT.NAME NAME
, PQY.NAME PRODUCT_SUBCLASS
, QVE.VALUE DEAL_TYPE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_BOOK_CLASS'
, QVE.VALUE) DEAL_TYPE_MEANING
, QVE1.VALUE TAX_OWNER
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_TAX_OWNER'
, QVE1.VALUE) TAX_OWNER_MEANING
, PDT.REPORTING_PDT_ID REPORTING_PDT_ID
, PDT1.NAME REPORTING_PRODUCT
, PDT.PTL_ID PTL_ID
, PDT.VERSION VERSION
, PDT.DESCRIPTION DESCRIPTION
, PDT.FROM_DATE FROM_DATE
, PDT.TO_DATE TO_DATE
, PDT.AES_ID AES_ID
, PDT.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, PDT.LEGACY_PRODUCT_YN LEGACY_PRODUCT_YN
FROM OKL_PRODUCTS PDT
, OKL_PRODUCTS PDT1
, OKL_PDT_PQY_VALS PQV
, OKL_PDT_PQY_VALS PQV1
, OKL_PDT_QUALITYS PQY
, OKL_PDT_QUALITYS PQY1
, OKL_PQY_VALUES QVE
, OKL_PQY_VALUES QVE1
WHERE PDT.REPORTING_PDT_ID = PDT1.ID(+)
AND PDT.ID = PQV.PDT_ID(+)
AND PQV.QVE_ID = QVE.ID(+)
AND QVE.PQY_ID = PQY.ID(+)
AND PQY.NAME = 'LEASE'
AND PDT.ID = PQV1.PDT_ID(+)
AND PQV1.QVE_ID = QVE1.ID(+)
AND QVE1.PQY_ID = PQY1.ID(+)
AND PQY1.NAME = 'TAXOWNER'

Columns