VIEW: APPS.OKL_AM_PRODUCTS_UV

Source

View Text - Preformatted

SELECT pdt.id ID, pdt.name NAME, pqy.name PRODUCT_SUBCLASS, qve.value DEAL_TYPE, qve1.value TAX_OWNER, 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, fnd.meaning DEAL_TYPE_MEANING, fnd1.meaning TAX_OWNER_MEANING 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,FND_LOOKUPS FND,FND_LOOKUPS FND1 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' AND qve.value = fnd.lookup_code AND fnd.lookup_type = 'OKL_BOOK_CLASS' AND qve1.value = fnd1.lookup_code AND fnd1.lookup_type = 'OKL_TAX_OWNER'

View Text - HTML Formatted

SELECT PDT.ID ID
, PDT.NAME NAME
, PQY.NAME PRODUCT_SUBCLASS
, QVE.VALUE DEAL_TYPE
, QVE1.VALUE TAX_OWNER
, 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
, FND.MEANING DEAL_TYPE_MEANING
, FND1.MEANING TAX_OWNER_MEANING
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
, FND_LOOKUPS FND
, FND_LOOKUPS FND1
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'
AND QVE.VALUE = FND.LOOKUP_CODE
AND FND.LOOKUP_TYPE = 'OKL_BOOK_CLASS'
AND QVE1.VALUE = FND1.LOOKUP_CODE
AND FND1.LOOKUP_TYPE = 'OKL_TAX_OWNER'