VIEW: APPS.ASG_USER_APPLICATION_V

Source

View Text - Preformatted

SELECT usr.resource_id, usr.user_id, usr.user_name, app.application_id, app.application_name, resl.responsibility_id, resl.responsibility_name, pr.pub_id PUBLICATION_ID, pub.name PUBLICATION_NAME from asg_user usr, fnd_user_resp_groups grp, fnd_application_tl app, fnd_responsibility_tl resl, asg_pub_responsibility pr, asg_pub pub WHERE usr.user_id = grp.user_id and grp.responsibility_application_id = app.application_id and grp.responsibility_id = resl.responsibility_id and grp.responsibility_id = pr.responsibility_id and pr.pub_id = pub.pub_id

View Text - HTML Formatted

SELECT USR.RESOURCE_ID
, USR.USER_ID
, USR.USER_NAME
, APP.APPLICATION_ID
, APP.APPLICATION_NAME
, RESL.RESPONSIBILITY_ID
, RESL.RESPONSIBILITY_NAME
, PR.PUB_ID PUBLICATION_ID
, PUB.NAME PUBLICATION_NAME
FROM ASG_USER USR
, FND_USER_RESP_GROUPS GRP
, FND_APPLICATION_TL APP
, FND_RESPONSIBILITY_TL RESL
, ASG_PUB_RESPONSIBILITY PR
, ASG_PUB PUB
WHERE USR.USER_ID = GRP.USER_ID
AND GRP.RESPONSIBILITY_APPLICATION_ID = APP.APPLICATION_ID
AND GRP.RESPONSIBILITY_ID = RESL.RESPONSIBILITY_ID
AND GRP.RESPONSIBILITY_ID = PR.RESPONSIBILITY_ID
AND PR.PUB_ID = PUB.PUB_ID