FUN_USER_BO_DATA_ASSIGNMENTS

Details

Schema: FUSION
Object owner: FUN
Object type: VIEW

Columns

Name
USER_ROLE_DATA_ASSIGNMENT_ID USERNAME BOSS_BUSINESS_OBJECT ALLOWED_ACTIONS DATASEC_CONTEXT_TYPE_CODE DATASEC_CONTEXT_VALUE1 DATASEC_CONTEXT_VALUE2 DATASEC_CONTEXT_VALUE3 DATASEC_CONTEXT_VALUE4 CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY ROLE_NAME FNDDS_OBJECT_NAME FNDDS_PRIVILEGE INSTANCE_SET_NAME GRANT_GUID BUSINESS_OBJECT_MAPPING_ID

Name

USER_ROLE_DATA_ASSIGNMENT_ID

USERNAME

BOSS_BUSINESS_OBJECT

ALLOWED_ACTIONS

DATASEC_CONTEXT_TYPE_CODE

DATASEC_CONTEXT_VALUE1

DATASEC_CONTEXT_VALUE2

DATASEC_CONTEXT_VALUE3

DATASEC_CONTEXT_VALUE4

CREATION_DATE

CREATED_BY

LAST_UPDATE_DATE

LAST_UPDATED_BY

ROLE_NAME

FNDDS_OBJECT_NAME

FNDDS_PRIVILEGE

INSTANCE_SET_NAME

GRANT_GUID

BUSINESS_OBJECT_MAPPING_ID

Query

SQL_Statement
select asgn.user_role_data_assignment_id , asgn.username , grants.boss_business_object , grants.allowed_actions , asgn.datasec_context_type_code , asgn.datasec_context_value1 , asgn.datasec_context_value2 , asgn.datasec_context_value3 , asgn.datasec_context_value4 , asgn.creation_date , asgn.created_by , asgn.last_update_date , asgn.last_updated_by , grants.role_name , grants.fndds_object_name , grants.fndds_privilege , grants.instance_set_name , grants.grant_guid , grants.business_object_mapping_id from ( select bomap.fndds_object_name , bomap.fndds_privilege , g.grant_guid , g.role_name , ois.instance_set_name , bomap.business_object_mapping_id , bomap.boss_business_object , bomap.allowed_actions from fnd_grants g , fnd_objects o , fnd_object_instance_sets ois , fnd_menu_entries me , fnd_form_functions ff , fun_business_object_mapping bomap where o.object_id = g.object_id and ois.instance_set_id = g.instance_set_id and ois.created_by = 'SEED_DATA_FROM_APPLICATION' and upper(ois.predicate) like '%FUN_USER_ROLE_DATA_ASGNMNTS%' and me.menu_id = g.menu_id and ff.function_id = me.function_id and o.object_id = ff.object_id and o.obj_name = bomap.fndds_object_name and ff.function_name = bomap.fndds_privilege ) grants , ( select asg.user_role_data_assignment_id , users.username , asg.role_name , asg.datasec_context_type_code , asg.object_name , datasec_context_value1 , datasec_context_value2 , datasec_context_value3 , datasec_context_value4 , asg.creation_date , asg.created_by , asg.last_update_date , asg.last_updated_by from ( select user_role_data_assignment_id , user_guid , role_name , start_date_active , end_date_active , active_flag , record_type_code , created_by , creation_date , last_updated_by , last_update_date , last_update_login , ( case when org_id is not null then 'ORA_BU_ID' when ledger_id is not null then 'ORA_LEDGER_ID' when book_id is not null then 'ORA_BOOK_CONTROL_ID' when set_id is not null then 'ORA_SET_ID' when inv_organization_id is not null then 'ORA_ORGANIZATION_ID' when cst_organization_id is not null then 'ORA_COST_ORG_ID' when access_set_id is not null then 'ORA_ACCESS_SET_ID' when control_budget_id is not null then 'ORA_CONTROL_BUDGET_ID' when interco_org_id is not null then 'ORA_INTERCO_ORG_ID' when prj_organization_id is not null then 'ORA_PRJ_ORGANIZATION_ID' when mfg_organization_id is not null then 'ORA_MFG_ORGANIZATION_ID' when datasec_context_type_code = 'GMS_AWARD_HEADERS_B' then 'ORA_PRJ_AWARD_ORG_HIER_ID' else datasec_context_type_code end ) datasec_context_type_code ,( case when org_id is not null then 'FUN_ALL_BUSINESS_UNITS_V' when ledger_id is not null then 'GL_LEDGERS' when book_id is not null then 'FA_BOOK_CONTROLS' when set_id is not null then 'FND_SETID_SETS_VL' when inv_organization_id is not null then 'INV_ORG_PARAMETERS' when cst_organization_id is not null then 'CST_COST_ORGS_V' when access_set_id is not null then 'GL_ACCESS_SETS' when control_budget_id is not null then 'XCC_CONTROL_BUDGETS' when interco_org_id is not null then 'FUN_INTERCO_ORGANIZATIONS' when prj_organization_id is not null then 'HR_ORG_UNIT_CLASSIFICATIONS_F' when mfg_organization_id is not null then 'RCS_MFG_PARAMETERS' when datasec_context_type_code = 'ORA_CAMPUS_ID' then 'GMS_AWARD_HEADERS_B' when datasec_context_type_code = 'ORA_PRJ_AWARD_ORG_HIER_ID' then 'GMS_AWARD_HEADERS_B' else datasec_context_type_code end ) object_name , coalesce( datasec_context_value1 , to_char(org_id) , to_char(ledger_id) , to_char(book_id) , to_char(set_id) , to_char(inv_organization_id) , to_char(cst_organization_id) , to_char(itm_organization_id) , to_char(access_set_id) , to_char(control_budget_id) , to_char(interco_org_id) , to_char(prj_organization_id) , to_char(mfg_organization_id) , to_char(collaboration_doc_id) ) datasec_context_value1 , datasec_context_value2 , datasec_context_value3 , datasec_context_value4 from fun_user_role_data_asgnmnts ) asg , per_users users , per_roles_dn_vl roles where asg.active_flag = 'Y' and users.user_guid = asg.user_guid and users.active_flag = 'Y' and roles.role_common_name = asg.role_name and roles.active_flag = 'Y') asgn where grants.role_name = asgn.role_name and grants.fndds_object_name = asgn.object_name

SQL_Statement

select asgn.user_role_data_assignment_id

, asgn.username

, grants.boss_business_object

, grants.allowed_actions

, asgn.datasec_context_type_code

, asgn.datasec_context_value1

, asgn.datasec_context_value2

, asgn.datasec_context_value3

, asgn.datasec_context_value4

, asgn.creation_date

, asgn.created_by

, asgn.last_update_date

, asgn.last_updated_by

, grants.role_name

, grants.fndds_object_name

, grants.fndds_privilege

, grants.instance_set_name

, grants.grant_guid

, grants.business_object_mapping_id

from ( select bomap.fndds_object_name

, bomap.fndds_privilege

, g.grant_guid

, g.role_name

, ois.instance_set_name

, bomap.business_object_mapping_id

, bomap.boss_business_object

, bomap.allowed_actions

from fnd_grants g

, fnd_objects o

, fnd_object_instance_sets ois

, fnd_menu_entries me

, fnd_form_functions ff

, fun_business_object_mapping bomap

where o.object_id = g.object_id

and ois.instance_set_id = g.instance_set_id

and ois.created_by = 'SEED_DATA_FROM_APPLICATION'

and upper(ois.predicate) like '%FUN_USER_ROLE_DATA_ASGNMNTS%'

and me.menu_id = g.menu_id

and ff.function_id = me.function_id

and o.object_id = ff.object_id

and o.obj_name = bomap.fndds_object_name

and ff.function_name = bomap.fndds_privilege ) grants

, ( select asg.user_role_data_assignment_id

, users.username

, asg.role_name

, asg.datasec_context_type_code

, asg.object_name

, datasec_context_value1

, datasec_context_value2

, datasec_context_value3

, datasec_context_value4

, asg.creation_date

, asg.created_by

, asg.last_update_date

, asg.last_updated_by

from ( select user_role_data_assignment_id

, user_guid

, role_name

, start_date_active

, end_date_active

, active_flag

, record_type_code

, created_by

, creation_date

, last_updated_by

, last_update_date

, last_update_login

, ( case

when org_id is not null then 'ORA_BU_ID'

when ledger_id is not null then 'ORA_LEDGER_ID'

when book_id is not null then 'ORA_BOOK_CONTROL_ID'

when set_id is not null then 'ORA_SET_ID'

when inv_organization_id is not null then 'ORA_ORGANIZATION_ID'

when cst_organization_id is not null then 'ORA_COST_ORG_ID'

when access_set_id is not null then 'ORA_ACCESS_SET_ID'

when control_budget_id is not null then 'ORA_CONTROL_BUDGET_ID'

when interco_org_id is not null then 'ORA_INTERCO_ORG_ID'

when prj_organization_id is not null then 'ORA_PRJ_ORGANIZATION_ID'

when mfg_organization_id is not null then 'ORA_MFG_ORGANIZATION_ID'

when datasec_context_type_code = 'GMS_AWARD_HEADERS_B' then 'ORA_PRJ_AWARD_ORG_HIER_ID'

else datasec_context_type_code

end ) datasec_context_type_code

,( case

when org_id is not null then 'FUN_ALL_BUSINESS_UNITS_V'

when ledger_id is not null then 'GL_LEDGERS'

when book_id is not null then 'FA_BOOK_CONTROLS'

when set_id is not null then 'FND_SETID_SETS_VL'

when inv_organization_id is not null then 'INV_ORG_PARAMETERS'

when cst_organization_id is not null then 'CST_COST_ORGS_V'

when access_set_id is not null then 'GL_ACCESS_SETS'

when control_budget_id is not null then 'XCC_CONTROL_BUDGETS'

when interco_org_id is not null then 'FUN_INTERCO_ORGANIZATIONS'

when prj_organization_id is not null then 'HR_ORG_UNIT_CLASSIFICATIONS_F'

when mfg_organization_id is not null then 'RCS_MFG_PARAMETERS'

when datasec_context_type_code = 'ORA_CAMPUS_ID' then 'GMS_AWARD_HEADERS_B'

when datasec_context_type_code = 'ORA_PRJ_AWARD_ORG_HIER_ID' then 'GMS_AWARD_HEADERS_B'

else datasec_context_type_code

end ) object_name

, coalesce( datasec_context_value1

, to_char(org_id)

, to_char(ledger_id)

, to_char(book_id)

, to_char(set_id)

, to_char(inv_organization_id)

, to_char(cst_organization_id)

, to_char(itm_organization_id)

, to_char(access_set_id)

, to_char(control_budget_id)

, to_char(interco_org_id)

, to_char(prj_organization_id)

, to_char(mfg_organization_id)

, to_char(collaboration_doc_id) ) datasec_context_value1

, datasec_context_value2

, datasec_context_value3

, datasec_context_value4

from fun_user_role_data_asgnmnts ) asg

, per_users users

, per_roles_dn_vl roles

where asg.active_flag = 'Y'

and users.user_guid = asg.user_guid

and users.active_flag = 'Y'

and roles.role_common_name = asg.role_name

and roles.active_flag = 'Y') asgn

where grants.role_name = asgn.role_name

and grants.fndds_object_name = asgn.object_name