VIEW: APPS.ZPB_DEFAULT_CONTROLLER_V

Source

View Text - Preformatted

SELECT user_id from zpb_account_states where resp_id = (select responsibility_id from fnd_responsibility where responsibility_key = 'ZPB_CONTROLLER_RESP') order by creation_date

View Text - HTML Formatted

SELECT USER_ID
FROM ZPB_ACCOUNT_STATES
WHERE RESP_ID = (SELECT RESPONSIBILITY_ID
FROM FND_RESPONSIBILITY
WHERE RESPONSIBILITY_KEY = 'ZPB_CONTROLLER_RESP') ORDER BY CREATION_DATE