View: OKL_REPORTING_PRODUCTS_UV

Product:	OKL - Lease and Finance Management
Description:	This view contains the reporting products for a given local product. This view is used as a lookup in the Products screen.
Implementation/DBA Data:	APPS.OKL_REPORTING_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 LEGACY_PRODUCT_YN
, PDT.REPORTING_PDT_ID REPORTING_PDT_ID
, PDT1.NAME REPORTING_PRODUCT
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
, OKL_PDT_PQY_VALS PQV2
, OKL_PQY_VALUES_V QVE2
, OKL_PDT_QUALITYS PQY2
, OKL_PDT_PQY_VALS PQV3
, OKL_PQY_VALUES_V QVE3
, OKL_PDT_QUALITYS PQY3
, OKL_AE_TMPT_SETS AES
WHERE PDT.REPORTING_PDT_ID = PDT1.ID(+)
AND PDT.AES_ID = AES.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'AND PDT.ID = PQV2.PDT_ID
AND PQV2.QVE_ID = QVE2.ID
AND QVE2.PQY_ID = PQY2.ID
AND PQY2.NAME = 'REVENUE_RECOGNITION_METHOD'
AND QVE2.VALUE NOT IN ('ESTIMATED_AND_BILLED'
, 'FLOAT_FACTORS'
, 'CATCHUP/CLEANUP'
, 'ACTUAL')
AND PDT.ID = PQV3.PDT_ID
AND PQV3.QVE_ID = QVE3.ID
AND QVE3.PQY_ID = PQY3.ID
AND PQY3.NAME = 'INTEREST_CALCULATION_BASIS'

Columns