DBA Data[Home] [Help]

APPS.PQH_WF dependencies on WF_ROLES

Line 647: , wf_roles wfr

643: SELECT '2-POS'
644: , rht.routing_history_id
645: , wfr.name
646: FROM pqh_routing_history rht
647: , wf_roles wfr
648: WHERE wfr.orig_system = 'POS'
649: AND wfr.orig_system_id = rht.forwarded_by_position_id
650: AND rht.forwarded_to_user_id IS NULL
651: AND transaction_category_id = p_transaction_category_id

Line 659: , wf_roles wfr

655: SELECT '3-RLS'
656: , rht.routing_history_id
657: , wfr.name
658: FROM pqh_routing_history rht
659: , wf_roles wfr
660: , pqh_routing_list_members rlm
661: WHERE wfr.orig_system = 'PQH_ROLE'
662: AND rlm.routing_list_member_id = rht.forwarded_by_member_id
663: AND wfr.orig_system_id = rlm.role_id