eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: PQH_ROUTING_LIST_MEMBERS_V

Product:	PQH - Public Sector HR
Description:
Implementation/DBA Data:	APPS.PQH_ROUTING_LIST_MEMBERS_V

View Text

SELECT RLM.ROUTING_LIST_MEMBER_ID
, RLM.SEQ_NO
, RLM.APPROVER_FLAG
, RLM.ROUTING_LIST_ID
, RLM.ROLE_ID
, RLS.ROLE_NAME
, RLM.USER_ID
, USR.USER_NAME
, RLM.ENABLE_FLAG
, RLS.ENABLE_FLAG ROLE_ENABLE_FLAG
, RLM.LAST_UPDATE_DATE
, RLM.LAST_UPDATED_BY
, RLM.LAST_UPDATE_LOGIN
, RLM.CREATED_BY
, RLM.CREATION_DATE
, RLM.OBJECT_VERSION_NUMBER
FROM PQH_ROUTING_LIST_MEMBERS RLM
, PQH_ROLES RLS
, FND_USER USR
WHERE RLM.ROLE_ID=RLS.ROLE_ID
AND RLM.USER_ID=USR.USER_ID(+)

Columns

Name
ROUTING_LIST_MEMBER_ID
SEQ_NO
APPROVER_FLAG
ROUTING_LIST_ID
ROLE_ID
ROLE_NAME
USER_ID
USER_NAME
ENABLE_FLAG
ROLE_ENABLE_FLAG
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER