View: OKL_INS_PRODUCTS_V

Product:	OKL - Lease and Finance Management
Description:	Lease and optional insurance products
Implementation/DBA Data:	APPS.OKL_INS_PRODUCTS_V

View Text

SELECT IPTB.ROWID ROW_ID
, 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
, IPTT.FACTOR_NAME 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
, IPTB.FACTOR_AMOUNT_YN
FROM OKL_INS_PRODUCTS_B IPTB
, OKL_INS_PRODUCTS_TL IPTT
WHERE IPTB.ID = IPTT.ID
AND IPTT.LANGUAGE = USERENV('LANG')

Columns