VIEW: APPS.CSF_GROUP_MEMBER_ROLES_V

Source

View Text - Preformatted

SELECT GrpMbr.GROUP_MEMBER_ID, GrpMbr.GROUP_ID, GrpMbr.RESOURCE_ID, GrpMbr.OBJECT_VERSION_NUMBER, RoleRel.ROLE_RELATE_ID, RoleRel.ROLE_RESOURCE_ID, RoleRel.ROLE_ID, RoleRel.START_DATE_ACTIVE, RoleRel.END_DATE_ACTIVE, RoleRel.OBJECT_VERSION_NUMBER AS OBJECT_VERSION_NUMBER1, RoleRel.ATTRIBUTE1, RoleRel.ATTRIBUTE2, RoleRel.ATTRIBUTE3, RoleRel.ATTRIBUTE4, RoleRel.ATTRIBUTE5, RoleRel.ATTRIBUTE6, RoleRel.ATTRIBUTE7, RoleRel.ATTRIBUTE8, RoleRel.ATTRIBUTE9, RoleRel.ATTRIBUTE10, RoleRel.ATTRIBUTE11, RoleRel.ATTRIBUTE12, RoleRel.ATTRIBUTE13, RoleRel.ATTRIBUTE14, RoleRel.ATTRIBUTE15, RoleRel.ATTRIBUTE_CATEGORY, RoleRel.CREATION_DATE, RoleRel.CREATED_BY, RoleRel.LAST_UPDATED_BY, RoleRel.LAST_UPDATE_DATE, RoleRel.LAST_UPDATE_LOGIN, D.ROLE_NAME, G.GROUP_NAME FROM JTF_RS_GROUP_MEMBERS GrpMbr, JTF_RS_ROLE_RELATIONS RoleRel, JTF_RS_ROLES_VL D, JTF_RS_GROUPS_VL G WHERE GrpMbr.GROUP_MEMBER_ID = RoleRel.ROLE_RESOURCE_ID(+) AND GrpMbr.GROUP_ID = G.GROUP_ID AND NVL(GrpMbr.DELETE_FLAG, 'N') <> 'Y' AND RoleRel.ROLE_RESOURCE_TYPE(+) = 'RS_GROUP_MEMBER' AND NVL(RoleRel.DELETE_FLAG(+), 'N') <> 'Y' AND D.ROLE_ID(+) = RoleRel.ROLE_ID

View Text - HTML Formatted

SELECT GRPMBR.GROUP_MEMBER_ID
, GRPMBR.GROUP_ID
, GRPMBR.RESOURCE_ID
, GRPMBR.OBJECT_VERSION_NUMBER
, ROLEREL.ROLE_RELATE_ID
, ROLEREL.ROLE_RESOURCE_ID
, ROLEREL.ROLE_ID
, ROLEREL.START_DATE_ACTIVE
, ROLEREL.END_DATE_ACTIVE
, ROLEREL.OBJECT_VERSION_NUMBER AS OBJECT_VERSION_NUMBER1
, ROLEREL.ATTRIBUTE1
, ROLEREL.ATTRIBUTE2
, ROLEREL.ATTRIBUTE3
, ROLEREL.ATTRIBUTE4
, ROLEREL.ATTRIBUTE5
, ROLEREL.ATTRIBUTE6
, ROLEREL.ATTRIBUTE7
, ROLEREL.ATTRIBUTE8
, ROLEREL.ATTRIBUTE9
, ROLEREL.ATTRIBUTE10
, ROLEREL.ATTRIBUTE11
, ROLEREL.ATTRIBUTE12
, ROLEREL.ATTRIBUTE13
, ROLEREL.ATTRIBUTE14
, ROLEREL.ATTRIBUTE15
, ROLEREL.ATTRIBUTE_CATEGORY
, ROLEREL.CREATION_DATE
, ROLEREL.CREATED_BY
, ROLEREL.LAST_UPDATED_BY
, ROLEREL.LAST_UPDATE_DATE
, ROLEREL.LAST_UPDATE_LOGIN
, D.ROLE_NAME
, G.GROUP_NAME
FROM JTF_RS_GROUP_MEMBERS GRPMBR
, JTF_RS_ROLE_RELATIONS ROLEREL
, JTF_RS_ROLES_VL D
, JTF_RS_GROUPS_VL G
WHERE GRPMBR.GROUP_MEMBER_ID = ROLEREL.ROLE_RESOURCE_ID(+)
AND GRPMBR.GROUP_ID = G.GROUP_ID
AND NVL(GRPMBR.DELETE_FLAG
, 'N') <> 'Y'
AND ROLEREL.ROLE_RESOURCE_TYPE(+) = 'RS_GROUP_MEMBER'
AND NVL(ROLEREL.DELETE_FLAG(+)
, 'N') <> 'Y'
AND D.ROLE_ID(+) = ROLEREL.ROLE_ID