Product: | JTF - CRM Foundation |
---|---|
Description: | MLS View forJTF_RS_GROUPS_AUD_B andJTF_RS_GROUPS_AUD_TL. |
Implementation/DBA Data: | APPS.JTF_RS_GROUPS_AUD_VL |
SELECT B.ROWID ROW_ID
, B.GROUP_AUDIT_ID
, B.GROUP_ID
, B.NEW_GROUP_NUMBER
, B.OLD_GROUP_NUMBER
, B.NEW_EMAIL_ADDRESS
, B.OLD_EMAIL_ADDRESS
, B.NEW_EXCLUSIVE_FLAG
, B.OLD_EXCLUSIVE_FLAG
, B.NEW_START_DATE_ACTIVE
, B.OLD_START_DATE_ACTIVE
, B.NEW_END_DATE_ACTIVE
, B.OLD_END_DATE_ACTIVE
, B.NEW_ACCOUNTING_CODE
, B.OLD_ACCOUNTING_CODE
, B.NEW_OBJECT_VERSION_NUMBER
, B.OLD_OBJECT_VERSION_NUMBER
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, T.NEW_GROUP_NAME
, T.OLD_GROUP_NAME
, T.NEW_GROUP_DESC
, T.OLD_GROUP_DESC
FROM JTF_RS_GROUPS_AUD_TL T
, JTF_RS_GROUPS_AUD_B B
WHERE B.GROUP_AUDIT_ID = T.GROUP_AUDIT_ID
AND T.LANGUAGE = USERENV('LANG')