VIEW: APPS.OKL_PRODUCT_PARAMETERS_ALL_V

Source

View Text - Preformatted

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, qve.DESCRIPTION Deal_Type_description, qve1.VALUE Tax_Owner, Okl_Accounting_Util.Get_Lookup_Meaning('OKL_TAX_OWNER', qve1.VALUE) Tax_owner_meaning, qve1.DESCRIPTION Tax_Owner_description, 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, aes.name aes_name, aes.org_id aes_org_id, pdt.object_version_number OBJECT_VERSION_NUMBER, 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, qve2.VALUE Revenue_Recognition_Method, Okl_Accounting_Util.Get_Lookup_Meaning('OKL_REVENUE_RECOGNITION_METHOD', qve2.VALUE) Revenue_Recognition_meaning, qve3.VALUE Interest_Calculation_Basis, Okl_Accounting_Util.Get_Lookup_Meaning('OKL_INTEREST_CALCULATION_BASIS', qve3.VALUE) Interest_Calculation_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, 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_ALL 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 pdt.id = pqv3.pdt_id AND pqv3.qve_id = qve3.id AND qve3.pqy_id = pqy3.id AND pqy3.name = 'INTEREST_CALCULATION_BASIS' UNION SELECT pdt.id ID, pdt.name NAME, pqy.name PRODUCT_SUBCLASS, qve.VALUE Deal_Type, Okl_Accounting_Util.Get_Lookup_Meaning('OKL_SECURITIZATION_TYPE', qve.VALUE) Deal_Type_meaning, qve.DESCRIPTION Deal_Type_description, NULL Tax_Owner, NULL Tax_Owner_meaning, NULL Tax_Owner_description, 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, aes.name aes_name, aes.org_id aes_org_id, pdt.object_version_number OBJECT_VERSION_NUMBER, 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, NULL Revenue_Recognition_Method, NULL Revenue_Recognition_meaning, NULL Interest_Calculation_Basis, NULL Interest_Calculation_meaning FROM OKL_PRODUCTS PDT, okl_ae_tmpt_sets_all aes, OKL_PRODUCTS PDT1, OKL_PDT_PQY_VALS PQV, OKL_PQY_VALUES QVE, OKL_PDT_QUALITYS PQY 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 = 'INVESTOR'

View Text - HTML Formatted

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
, QVE.DESCRIPTION DEAL_TYPE_DESCRIPTION
, QVE1.VALUE TAX_OWNER
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_TAX_OWNER'
, QVE1.VALUE) TAX_OWNER_MEANING
, QVE1.DESCRIPTION TAX_OWNER_DESCRIPTION
, 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
, AES.NAME AES_NAME
, AES.ORG_ID AES_ORG_ID
, PDT.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, 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
, QVE2.VALUE REVENUE_RECOGNITION_METHOD
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_REVENUE_RECOGNITION_METHOD'
, QVE2.VALUE) REVENUE_RECOGNITION_MEANING
, QVE3.VALUE INTEREST_CALCULATION_BASIS
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_INTEREST_CALCULATION_BASIS'
, QVE3.VALUE) INTEREST_CALCULATION_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
, 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_ALL 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 PDT.ID = PQV3.PDT_ID
AND PQV3.QVE_ID = QVE3.ID
AND QVE3.PQY_ID = PQY3.ID
AND PQY3.NAME = 'INTEREST_CALCULATION_BASIS' UNION SELECT PDT.ID ID
, PDT.NAME NAME
, PQY.NAME PRODUCT_SUBCLASS
, QVE.VALUE DEAL_TYPE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_SECURITIZATION_TYPE'
, QVE.VALUE) DEAL_TYPE_MEANING
, QVE.DESCRIPTION DEAL_TYPE_DESCRIPTION
, NULL TAX_OWNER
, NULL TAX_OWNER_MEANING
, NULL TAX_OWNER_DESCRIPTION
, 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
, AES.NAME AES_NAME
, AES.ORG_ID AES_ORG_ID
, PDT.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, 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
, NULL REVENUE_RECOGNITION_METHOD
, NULL REVENUE_RECOGNITION_MEANING
, NULL INTEREST_CALCULATION_BASIS
, NULL INTEREST_CALCULATION_MEANING
FROM OKL_PRODUCTS PDT
, OKL_AE_TMPT_SETS_ALL AES
, OKL_PRODUCTS PDT1
, OKL_PDT_PQY_VALS PQV
, OKL_PQY_VALUES QVE
, OKL_PDT_QUALITYS PQY
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 = 'INVESTOR'