VIEW: APPS.JTF_RS_GROUPS_AUD_VL

Source

View Text - Preformatted

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, B.NEW_TIME_ZONE, B.OLD_TIME_ZONE 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')

View Text - HTML Formatted

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
, B.NEW_TIME_ZONE
, B.OLD_TIME_ZONE
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')