VIEW: APPS.PQH_ROUTING_LIST_MEMBERS_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)