DBA Data[Home] [Help]

VIEW: APPS.FND_OAM_DS_ALGOS_VL

Source

View Text - Preformatted

SELECT
B.ROWID ROW_ID,
B.ALGO_ID,
T.DISPLAY_NAME,
T.DESCRIPTION,
B.START_DATE,
B.END_DATE,
B.USE_ALGO_ID,
B.DEFAULT_FOR_DATATYPE_FLAG,
B.DATATYPE,
B.ALGO_TEXT,
B.WEIGHT_MODIFIER,
B.CREATED_BY,
B.CREATION_DATE,
B.LAST_UPDATED_BY,
B.LAST_UPDATE_DATE,
B.LAST_UPDATE_LOGIN
FROM	FND_OAM_DS_ALGOS_B B, FND_OAM_DS_ALGOS_TL T
WHERE	B.ALGO_ID = T.ALGO_ID
AND	T.LANGUAGE = userenv('LANG')
   
View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.ALGO_ID
, T.DISPLAY_NAME
, T.DESCRIPTION
, B.START_DATE
, B.END_DATE
, B.USE_ALGO_ID
, B.DEFAULT_FOR_DATATYPE_FLAG
, B.DATATYPE
, B.ALGO_TEXT
, B.WEIGHT_MODIFIER
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN FROM FND_OAM_DS_ALGOS_B B
, FND_OAM_DS_ALGOS_TL T WHERE B.ALGO_ID = T.ALGO_ID AND T.LANGUAGE = USERENV('LANG')