Product: | OKL - Leasing and Finance Management |
---|---|
Description: | Accounting template sets |
Implementation/DBA Data: | APPS.OKL_AE_TMPT_SETS_V |
SELECT AESB.ROWID ROW_ID
, AESB.ID ID
, AESB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, AESB.NAME NAME
, AESB.DESCRIPTION DESCRIPTION
, AESB.VERSION VERSION
, AESB.START_DATE START_DATE
, AESB.END_DATE END_DATE
, AESB.GTS_ID GTS_ID
, GTS.NAME STREAM_TEMPLATE
, AESB.ORG_ID ORG_ID
, AESB.CREATED_BY CREATED_BY
, AESB.CREATION_DATE CREATION_DATE
, AESB.LAST_UPDATED_BY LAST_UPDATED_BY
, AESB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AESB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OU.NAME OPERATING_UNIT
FROM OKL_AE_TMPT_SETS AESB
, OKL_ST_GEN_TMPT_SETS_ALL GTS
, HR_OPERATING_UNITS OU
WHERE AESB.GTS_ID = GTS.ID (+)
AND AESB.ORG_ID = OU.ORGANIZATION_ID