VIEW: APPS.OKL_AE_TMPT_SETS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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