View: OKL_PRODUCTS_UV

Product:	OKL - Lease and Finance Management
Description:	This view contains all the products information. This is the base view for the Products screen.
Implementation/DBA Data:	APPS.OKL_PRODUCTS_UV

View Text

SELECT PDT.ID ID
, PDT.NAME NAME
, PDT.PTL_ID PTL_ID
, PDT.VERSION VERSION
, PDT.DESCRIPTION DESCTIPTION
, 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 PRODUCT_YN
, PDT.REPORTING_PDT_ID REPORTING_PDT_ID
, PDT_1.NAME REPORTING_PRODUCT
, PDT.LEGACY_PRODUCT_YN LEGACY_PRODUCT_YN
, PDT.PRODUCT_STATUS_CODE PRODUCT_STATUS_CODE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_PRODUCT_STATUS'
, PDT.PRODUCT_STATUS_CODE) PRODUCT_STATUS_MEANING
, PDT.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, PDT.ATTRIBUTE1 ATTRIBUTE1
, PDT.ATTRIBUTE2 ATTRIBUTE2
, PDT.ATTRIBUTE3 ATTRIBUTE3
, PDT.ATTRIBUTE4 ATTRIBUTE4
, PDT.ATTRIBUTE5 ATTRIBUTE5
, PDT.ATTRIBUTE6 ATTRIBUTE6
, PDT.ATTRIBUTE7 ATTRIBUTE7
, PDT.ATTRIBUTE8 ATTRIBUTE8
, PDT.ATTRIBUTE9 ATTRIBUTE9
, PDT.ATTRIBUTE10 ATTRIBUTE10
, PDT.ATTRIBUTE11 ATTRIBUTE11
, PDT.ATTRIBUTE12 ATTRIBUTE12
, PDT.ATTRIBUTE13 ATTRIBUTE13
, PDT.ATTRIBUTE14 ATTRIBUTE14
, PDT.ATTRIBUTE15 ATTRIBUTE15
, PDT.CREATED_BY CREATED_BY
, PDT.CREATION_DATE CREATION_DATE
, PDT.LAST_UPDATED_BY LAST_UPDATED_BY
, PDT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PDT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKL_PRODUCTS_V PDT
, OKL_PRODUCTS_V PDT_1
WHERE PDT.REPORTING_PDT_ID = PDT_1.ID(+)

Columns