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')
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')
|
|
|