SELECT
B.ROWID ROW_ID,
B.POLICYSET_ID,
T.POLICYSET_NAME,
B.START_DATE,
B.END_DATE,
T.DESCRIPTION,
B.CREATED_BY,
B.CREATION_DATE,
B.LAST_UPDATED_BY,
B.LAST_UPDATE_DATE,
B.LAST_UPDATE_LOGIN
FROM FND_OAM_DS_PSETS_B B, FND_OAM_DS_PSETS_TL T
WHERE B.POLICYSET_ID = T.POLICYSET_ID
AND T.LANGUAGE = USERENV('LANG')
SELECT
B.ROWID ROW_ID
,
B.POLICYSET_ID
,
T.POLICYSET_NAME
,
B.START_DATE
,
B.END_DATE
,
T.DESCRIPTION
,
B.CREATED_BY
,
B.CREATION_DATE
,
B.LAST_UPDATED_BY
,
B.LAST_UPDATE_DATE
,
B.LAST_UPDATE_LOGIN
FROM FND_OAM_DS_PSETS_B B
, FND_OAM_DS_PSETS_TL T
WHERE B.POLICYSET_ID = T.POLICYSET_ID
AND T.LANGUAGE = USERENV('LANG')
|
|
|