SELECT
B.ROWID ROW_ID,
B.POLICY_ID,
T.POLICY_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_POLICIES_B B, FND_OAM_DS_POLICIES_TL T
WHERE B.POLICY_ID = T.POLICY_ID
AND T.LANGUAGE = USERENV('LANG')
SELECT
B.ROWID ROW_ID
,
B.POLICY_ID
,
T.POLICY_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_POLICIES_B B
, FND_OAM_DS_POLICIES_TL T
WHERE B.POLICY_ID = T.POLICY_ID
AND T.LANGUAGE = USERENV('LANG')
|
|
|