Product: | OKL - Lease and Finance Management |
---|---|
Description: | End of Term Option versions view |
Implementation/DBA Data: | APPS.OKL_FE_EO_TERM_VERS_V |
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