VIEW: APPS.PQH_ROUTING_HISTORY_V

Source

View Text - Preformatted

SELECT routing_history_id routing_history_id, approval_cd approval_cd, comments comments, pqh_wf.get_person_name(rht.forwarded_by_user_id,rht.forwarded_by_assignment_id) person_name_by , rls_by.role_name role_name_by , hr_general.decode_position(forwarded_by_position_id) position_name_by , usr_by.user_name user_name_by , pqh_wf.get_person_name (rht.forwarded_to_user_id,rht.forwarded_to_assignment_id) person_name_to, rls_to.role_name role_name_to , hr_general.decode_position(forwarded_to_position_id) position_name_to , usr_to.user_name user_name_to , notification_date notification_date, pos_structure_version_id pos_structure_version_id, routing_category_id routing_category_id, transaction_category_id transaction_category_id, transaction_id transaction_id, user_action_cd user_action_cd, rht.forwarded_by_user_id forwarded_by_user_id, rht.forwarded_by_assignment_id forwarded_by_assignment_id, rht.forwarded_by_position_id forwarded_by_position_id, rht.forwarded_by_member_id forwarded_by_member_id, rht.forwarded_to_user_id forwarded_to_user_id, rht.forwarded_to_assignment_id forwarded_to_assignment_id, rht.forwarded_to_position_id forwarded_to_position_id, rht.forwarded_to_member_id forwarded_to_member_id from pqh_routing_history rht , pqh_routing_list_members rlm_to , pqh_routing_list_members rlm_by , pqh_roles rls_to , pqh_roles rls_by , fnd_user usr_to , fnd_user usr_by WHERE rht.forwarded_to_member_id = rlm_to.routing_list_member_id(+) and rht.forwarded_by_member_id = rlm_by.routing_list_member_id(+) and rht.forwarded_to_role_id = rls_to.role_id (+) and rht.forwarded_by_role_id = rls_by.role_id (+) and rht.forwarded_to_user_id = usr_to.user_id (+) and rht.forwarded_by_user_id = usr_by.user_id (+)

View Text - HTML Formatted

SELECT ROUTING_HISTORY_ID ROUTING_HISTORY_ID
, APPROVAL_CD APPROVAL_CD
, COMMENTS COMMENTS
, PQH_WF.GET_PERSON_NAME(RHT.FORWARDED_BY_USER_ID
, RHT.FORWARDED_BY_ASSIGNMENT_ID) PERSON_NAME_BY
, RLS_BY.ROLE_NAME ROLE_NAME_BY
, HR_GENERAL.DECODE_POSITION(FORWARDED_BY_POSITION_ID) POSITION_NAME_BY
, USR_BY.USER_NAME USER_NAME_BY
, PQH_WF.GET_PERSON_NAME (RHT.FORWARDED_TO_USER_ID
, RHT.FORWARDED_TO_ASSIGNMENT_ID) PERSON_NAME_TO
, RLS_TO.ROLE_NAME ROLE_NAME_TO
, HR_GENERAL.DECODE_POSITION(FORWARDED_TO_POSITION_ID) POSITION_NAME_TO
, USR_TO.USER_NAME USER_NAME_TO
, NOTIFICATION_DATE NOTIFICATION_DATE
, POS_STRUCTURE_VERSION_ID POS_STRUCTURE_VERSION_ID
, ROUTING_CATEGORY_ID ROUTING_CATEGORY_ID
, TRANSACTION_CATEGORY_ID TRANSACTION_CATEGORY_ID
, TRANSACTION_ID TRANSACTION_ID
, USER_ACTION_CD USER_ACTION_CD
, RHT.FORWARDED_BY_USER_ID FORWARDED_BY_USER_ID
, RHT.FORWARDED_BY_ASSIGNMENT_ID FORWARDED_BY_ASSIGNMENT_ID
, RHT.FORWARDED_BY_POSITION_ID FORWARDED_BY_POSITION_ID
, RHT.FORWARDED_BY_MEMBER_ID FORWARDED_BY_MEMBER_ID
, RHT.FORWARDED_TO_USER_ID FORWARDED_TO_USER_ID
, RHT.FORWARDED_TO_ASSIGNMENT_ID FORWARDED_TO_ASSIGNMENT_ID
, RHT.FORWARDED_TO_POSITION_ID FORWARDED_TO_POSITION_ID
, RHT.FORWARDED_TO_MEMBER_ID FORWARDED_TO_MEMBER_ID
FROM PQH_ROUTING_HISTORY RHT
, PQH_ROUTING_LIST_MEMBERS RLM_TO
, PQH_ROUTING_LIST_MEMBERS RLM_BY
, PQH_ROLES RLS_TO
, PQH_ROLES RLS_BY
, FND_USER USR_TO
, FND_USER USR_BY
WHERE RHT.FORWARDED_TO_MEMBER_ID = RLM_TO.ROUTING_LIST_MEMBER_ID(+)
AND RHT.FORWARDED_BY_MEMBER_ID = RLM_BY.ROUTING_LIST_MEMBER_ID(+)
AND RHT.FORWARDED_TO_ROLE_ID = RLS_TO.ROLE_ID (+)
AND RHT.FORWARDED_BY_ROLE_ID = RLS_BY.ROLE_ID (+)
AND RHT.FORWARDED_TO_USER_ID = USR_TO.USER_ID (+)
AND RHT.FORWARDED_BY_USER_ID = USR_BY.USER_ID (+)