SELECT U.user_id user_id,
       wura.role_orig_system_id RESPONSIBILITY_ID,
       (SELECT application_id
          FROM fnd_application
         WHERE application_short_name =/* Val between 1st and 2nd separator */
                 REPLACE(
                   SUBSTR(WURA.ROLE_NAME,
                        INSTR(WURA.ROLE_NAME, '|', 1, 1)+1,
                             ( INSTR(WURA.ROLE_NAME, '|', 1, 2)
                              -INSTR(WURA.ROLE_NAME, '|', 1, 1)-1)
                        )
                   ,'%col', ':')
       ) RESPONSIBILITY_APPLICATION_ID,
       (SELECT security_group_id
          FROM fnd_security_groups
         WHERE security_group_key =/* Val after 3rd separator */
                 REPLACE(
                   SUBSTR(WURA.ROLE_NAME,
                          INSTR(WURA.ROLE_NAME, '|', 1, 3)+1
                        )
                   ,'%col', ':')
       ) SECURITY_GROUP_ID,
       fnd_date.canonical_to_date('1000/01/01') START_DATE,
       TO_DATE(NULL) END_DATE,
       TO_CHAR( NULL) DESCRIPTION,
       TO_NUMBER(NULL) CREATED_BY,
       TO_DATE(  NULL) CREATION_DATE,
       TO_NUMBER(NULL) LAST_UPDATED_BY,
       TO_DATE(  NULL) LAST_UPDATE_DATE,
       TO_NUMBER(NULL) LAST_UPDATE_LOGIN
FROM fnd_user u,
     wf_user_role_assignments_v wura
WHERE wura.user_name = u.user_name
  AND wura.role_orig_system = 'FND_RESP'
  AND wura.partition_id IN (2,13)