FND Design Data [Home] [Help]

View: OKL_FE_EO_TERM_VERS_V

Product: OKL - Lease and Finance Management
Description: End of Term Option versions view
Implementation/DBA Data: ViewAPPS.OKL_FE_EO_TERM_VERS_V
View Text

SELECT VER.END_OF_TERM_VER_ID
, VER.OBJECT_VERSION_NUMBER
, VER.VERSION_NUMBER
, VER.END_OF_TERM_ID
, VER.STS_CODE
, VER.EFFECTIVE_FROM_DATE
, VER.EFFECTIVE_TO_DATE
, HDR.CURRENCY_CODE
, HDR.EOT_TYPE_CODE
, HDR.PRODUCT_ID
, HDR.CATEGORY_TYPE_CODE
, HDR.ORIG_END_OF_TERM_ID
, HDR.STS_CODE HDR_STS_CODE
, HDR.EFFECTIVE_FROM_DATE HDR_EFFECTIVE_FROM_DATE
, HDR.EFFECTIVE_TO_DATE HDR_EFFECTIVE_TO_DATE
, HDR.END_OF_TERM_NAME
, HDR.END_OF_TERM_DESC
FROM OKL_FE_EO_TERM_VERS VER
, OKL_FE_EO_TERMS_V HDR
WHERE HDR.END_OF_TERM_ID= VER.END_OF_TERM_ID

Columns

Name
END_OF_TERM_VER_ID
OBJECT_VERSION_NUMBER
VERSION_NUMBER
END_OF_TERM_ID
STS_CODE
EFFECTIVE_FROM_DATE
EFFECTIVE_TO_DATE
CURRENCY_CODE
EOT_TYPE_CODE
PRODUCT_ID
CATEGORY_TYPE_CODE
ORIG_END_OF_TERM_ID
HDR_STS_CODE
HDR_EFFECTIVE_FROM_DATE
HDR_EFFECTIVE_TO_DATE
END_OF_TERM_NAME
END_OF_TERM_DESC