Product: | OKL - Leasing and Finance Management |
---|---|
Description: | Associates a number of counters together for leveling, averaging purposes |
Implementation/DBA Data: | APPS.OKL_CNTR_LVLNG_GRPS_V |
SELECT CLGB.ROWID ROW_ID
, CLGB.ORG_ID ORG_ID
, CLGB.ID ID
, CLGB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CLGT.SFWT_FLAG SFWT_FLAG
, CLGB.INF_ID INF_ID
, CLGB.ICA_ID ICA_ID
, CLGB.IBT_ID IBT_ID
, CLGB.CURRENCY_CODE CURRENCY_CODE
, CLGB.IRM_ID IRM_ID
, CLGB.IUV_ID IUV_ID
, CLGT.NAME NAME
, CLGB.IPL_ID IPL_ID
, CLGB.EFFECTIVE_DATE_FROM EFFECTIVE_DATE_FROM
, CLGB.EFFECTIVE_DATE_TO EFFECTIVE_DATE_TO
, CLGT.DESCRIPTION DESCRIPTION
, CLGT.PRIVATE_LABEL_LOGO_URL PRIVATE_LABEL_LOGO_URL
, CLGB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CLGB.ATTRIBUTE1 ATTRIBUTE1
, CLGB.ATTRIBUTE2 ATTRIBUTE2
, CLGB.ATTRIBUTE3 ATTRIBUTE3
, CLGB.ATTRIBUTE4 ATTRIBUTE4
, CLGB.ATTRIBUTE5 ATTRIBUTE5
, CLGB.ATTRIBUTE6 ATTRIBUTE6
, CLGB.ATTRIBUTE7 ATTRIBUTE7
, CLGB.ATTRIBUTE8 ATTRIBUTE8
, CLGB.ATTRIBUTE9 ATTRIBUTE9
, CLGB.ATTRIBUTE10 ATTRIBUTE10
, CLGB.ATTRIBUTE11 ATTRIBUTE11
, CLGB.ATTRIBUTE12 ATTRIBUTE12
, CLGB.ATTRIBUTE13 ATTRIBUTE13
, CLGB.ATTRIBUTE14 ATTRIBUTE14
, CLGB.ATTRIBUTE15 ATTRIBUTE15
, CLGB.CREATED_BY CREATED_BY
, CLGB.CREATION_DATE CREATION_DATE
, CLGB.LAST_UPDATED_BY LAST_UPDATED_BY
, CLGB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CLGB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN_UPDATE_LOGIN
, CLGB.LEGAL_ENTITY_ID
FROM OKL_CNTR_LVLNG_GRPS_B CLGB
, OKL_CNTR_LVLNG_GRPS_TL CLGT
WHERE CLGB.ID = CLGT.ID
AND CLGT.LANGUAGE = USERENV('LANG')