View: OKL_INS_PRODUCTS_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_INS_PRODUCTS_UV

View Text

SELECT FND.MEANING MEANING
, FND.LOOKUP_CODE LOOKUP_CODE
, IPTB.ID ID
, IPTB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, IPTT.SFWT_FLAG SFWT_FLAG
, IPTB.ISU_ID ISU_ID
, IPTB.IPD_ID IPD_ID
, IPTB.POLICY_SYMBOL POLICY_SYMBOL
, IPTB.IPT_TYPE IPT_TYPE
, IPTT.NAME NAME
, IPTB.FACTOR_MAX FACTOR_MAX
, IPTB.DATE_FROM DATE_FROM
, IPTB.FACTOR_MIN FACTOR_MIN
, IPTB.DATE_TO DATE_TO
, FIFC.MEANING FACTOR_NAME
, IPTB.FACTOR_CODE FACTOR_CODE
, IPTB.COVERAGE_MIN COVERAGE_MIN
, IPTB.COVERAGE_MAX COVERAGE_MAX
, IPTB.DEAL_MONTHS_MIN DEAL_MONTHS_MIN
, IPTB.DEAL_MONTHS_MAX DEAL_MONTHS_MAX
, IPTB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, IPTB.ATTRIBUTE1 ATTRIBUTE1
, IPTB.ATTRIBUTE2 ATTRIBUTE2
, IPTB.ATTRIBUTE3 ATTRIBUTE3
, IPTB.ATTRIBUTE4 ATTRIBUTE4
, IPTB.ATTRIBUTE5 ATTRIBUTE5
, IPTB.ATTRIBUTE6 ATTRIBUTE6
, IPTB.ATTRIBUTE7 ATTRIBUTE7
, IPTB.ATTRIBUTE8 ATTRIBUTE8
, IPTB.ATTRIBUTE9 ATTRIBUTE9
, IPTB.ATTRIBUTE10 ATTRIBUTE10
, IPTB.ATTRIBUTE11 ATTRIBUTE11
, IPTB.ATTRIBUTE12 ATTRIBUTE12
, IPTB.ATTRIBUTE13 ATTRIBUTE13
, IPTB.ATTRIBUTE14 ATTRIBUTE14
, IPTB.ATTRIBUTE15 ATTRIBUTE15
, IPTB.CREATED_BY CREATED_BY
, IPTB.CREATION_DATE CREATION_DATE
, IPTB.LAST_UPDATED_BY LAST_UPDATED_BY
, IPTB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, IPTB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OI.PARTY_NAME PARTY_NAME
, OI.PARTY_ID PARTY_ID
, OSI.ITEM_TYPE ITEM_TYPE
, OSI.ID1 ID1
, OSI.ID2 INVENTORY_ORG_ID
, OSI.NAME MTLNAME
, DECODE(NVL(IPTB.DATE_TO
, NULL)
, NULL
, 'ACTIVE'
, DECODE(SIGN(MONTHS_BETWEEN(IPTB.DATE_TO
, SYSDATE))
, 1
, 'ACTIVE'
, 'INACTIVE')) STATUS
, IPTB.FACTOR_AMOUNT_YN
, OSI.ORGANIZATION_ID ORG_ID
FROM FND_LOOKUPS FIFC
, OKL_INS_PRODUCTS_TL IPTT
, OKL_INS_PRODUCTS_B IPTB
, FND_LOOKUPS FND
, OKX_INS_PROVIDER_V OI
, OKX_SYSTEM_ITEMS_V OSI
WHERE IPTB.ID = IPTT.ID
AND IPTT.LANGUAGE = USERENV('LANG')
AND IPTB.IPT_TYPE = FND.LOOKUP_CODE
AND FND.LOOKUP_TYPE = 'OKL_INSURANCE_PRODUCT_TYPE'
AND IPTB.ISU_ID = OI.PARTY_ID
AND IPTB.IPD_ID = OSI.ID1
AND IPTB.FACTOR_CODE = FIFC.LOOKUP_CODE
AND FIFC.LOOKUP_TYPE = 'OKL_INSURANCE_FACTOR'

Columns