VIEW: APPS.ASG_USER_PUBLICATION_ITEM_V

Source

View Text - Preformatted

SELECT usr.resource_id, usr.user_id, usr.user_name, pubi.item_id, pubi.name publication_item_name, pub.pub_id publication_id, pubi.pub_name publication_name from asg_user usr, fnd_user_resp_groups grp, asg_pub_responsibility pr, asg_pub pub, asg_pub_item pubi WHERE usr.user_id = grp.user_id and grp.responsibility_id = pr.responsibility_id and pr.pub_id = pub.pub_id and pub.name = pubi.pub_name

View Text - HTML Formatted

SELECT USR.RESOURCE_ID
, USR.USER_ID
, USR.USER_NAME
, PUBI.ITEM_ID
, PUBI.NAME PUBLICATION_ITEM_NAME
, PUB.PUB_ID PUBLICATION_ID
, PUBI.PUB_NAME PUBLICATION_NAME
FROM ASG_USER USR
, FND_USER_RESP_GROUPS GRP
, ASG_PUB_RESPONSIBILITY PR
, ASG_PUB PUB
, ASG_PUB_ITEM PUBI
WHERE USR.USER_ID = GRP.USER_ID
AND GRP.RESPONSIBILITY_ID = PR.RESPONSIBILITY_ID
AND PR.PUB_ID = PUB.PUB_ID
AND PUB.NAME = PUBI.PUB_NAME