SELECT
B.ROWID ROW_ID,
B.RUN_ID,
T.DISPLAY_NAME,
T.DESCRIPTION,
B.RUN_STATUS,
B.RUN_MODE,
B.TARGET_DBNAME,
B.CONFIG_INSTANCE_ID,
B.WEIGHT,
B.LAST_RUN_STAT_ID,
B.VALID_CHECK_INTERVAL,
B.STATS_FINISHED,
B.CREATED_BY,
B.CREATION_DATE,
B.LAST_UPDATED_BY,
B.LAST_UPDATE_DATE,
B.LAST_UPDATE_LOGIN
FROM FND_OAM_DSCRAM_RUNS_B B, FND_OAM_DSCRAM_RUNS_TL T
WHERE B.RUN_ID = T.RUN_ID
AND T.LANGUAGE = userenv('LANG')
SELECT
B.ROWID ROW_ID
,
B.RUN_ID
,
T.DISPLAY_NAME
,
T.DESCRIPTION
,
B.RUN_STATUS
,
B.RUN_MODE
,
B.TARGET_DBNAME
,
B.CONFIG_INSTANCE_ID
,
B.WEIGHT
,
B.LAST_RUN_STAT_ID
,
B.VALID_CHECK_INTERVAL
,
B.STATS_FINISHED
,
B.CREATED_BY
,
B.CREATION_DATE
,
B.LAST_UPDATED_BY
,
B.LAST_UPDATE_DATE
,
B.LAST_UPDATE_LOGIN
FROM FND_OAM_DSCRAM_RUNS_B B
, FND_OAM_DSCRAM_RUNS_TL T
WHERE B.RUN_ID = T.RUN_ID
AND T.LANGUAGE = USERENV('LANG')
|
|
|