VIEW: APPS.OKL_OPERANDS_V

Source

View Text - Preformatted

SELECT OPDB.rowid ROW_ID, OPDB.ID ID, OPDB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, OPDT.SFWT_FLAG SFWT_FLAG, OPDB.FMA_ID FMA_ID, OPDB.DSF_ID DSF_ID, OPDB.NAME NAME, OPDT.DESCRIPTION DESCRIPTION, OPDB.VERSION VERSION, OPDB.START_DATE START_DATE, OPDB.END_DATE END_DATE, OPDB.SOURCE SOURCE, OPDB.OPD_TYPE OPD_TYPE, OPDB.ORG_ID ORG_ID, OPDB.CREATED_BY CREATED_BY, OPDB.CREATION_DATE CREATION_DATE, OPDB.LAST_UPDATED_BY LAST_UPDATED_BY, OPDB.LAST_UPDATE_DATE LAST_UPDATE_DATE, OPDB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM OKL_OPERANDS_B OPDB,OKL_OPERANDS_TL OPDT WHERE OPDB.ID = OPDT.ID and OPDT.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT OPDB.ROWID ROW_ID
, OPDB.ID ID
, OPDB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, OPDT.SFWT_FLAG SFWT_FLAG
, OPDB.FMA_ID FMA_ID
, OPDB.DSF_ID DSF_ID
, OPDB.NAME NAME
, OPDT.DESCRIPTION DESCRIPTION
, OPDB.VERSION VERSION
, OPDB.START_DATE START_DATE
, OPDB.END_DATE END_DATE
, OPDB.SOURCE SOURCE
, OPDB.OPD_TYPE OPD_TYPE
, OPDB.ORG_ID ORG_ID
, OPDB.CREATED_BY CREATED_BY
, OPDB.CREATION_DATE CREATION_DATE
, OPDB.LAST_UPDATED_BY LAST_UPDATED_BY
, OPDB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, OPDB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKL_OPERANDS_B OPDB
, OKL_OPERANDS_TL OPDT
WHERE OPDB.ID = OPDT.ID
AND OPDT.LANGUAGE = USERENV('LANG')