VIEW: APPS.CSM_JTF_GROUP_MEMBERS_V

Source

View Text - Preformatted

SELECT ACC.ACCESS_ID , B.GROUP_MEMBER_ID , B.GROUP_ID , B.RESOURCE_ID , B.PERSON_ID FROM CSM_JTF_GROUP_MEMBERS_ACC ACC , JTF_RS_GROUP_MEMBERS B WHERE ACC.GROUP_MEMBER_ID = B.GROUP_MEMBER_ID AND ACC.USER_ID = ASG_BASE.GET_USER_ID AND NVL(B.DELETE_FLAG, 'N') <> 'Y'

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, B.GROUP_MEMBER_ID
, B.GROUP_ID
, B.RESOURCE_ID
, B.PERSON_ID
FROM CSM_JTF_GROUP_MEMBERS_ACC ACC
, JTF_RS_GROUP_MEMBERS B
WHERE ACC.GROUP_MEMBER_ID = B.GROUP_MEMBER_ID
AND ACC.USER_ID = ASG_BASE.GET_USER_ID
AND NVL(B.DELETE_FLAG
, 'N') <> 'Y'