SELECT
fpov.profile_option_name ,
fpov.user_profile_option_name,
DECODE (TO_CHAR (fpo.level_id), '10001', 'SITE', '10002', 'APP', '10003',
'RESP', '10005', 'SERVER', '10006', 'ORG', '10004', 'USER', 'NA' )
profile_Level,
DECODE (TO_CHAR (fpo.level_id), '10001', '', '10002',
fa.application_short_name, '10003', fr.responsibility_key, '10005',
fn.node_name, '10006', hou.NAME, '10004', fu.user_name, 'NA' ) Context_value,
fpo.profile_option_value value,
fr.RESPONSIBILITY_KEY,
fr.RESPONSIBILITY_NAME
FROM
apps.fnd_profile_options_vl fpov,
apps.fnd_profile_option_values fpo,
apps.fnd_user fu,
apps.fnd_application fa,
apps.fnd_responsibility_vl fr,
apps.fnd_nodes fn,
apps.hr_operating_units hou
WHERE
1 = 1
AND fpo.application_id = fpov.application_id
AND fpo.profile_option_id = fpov.profile_option_id
AND fu.user_id(+) = fpo.level_value
AND fr.application_id(+) = fpo.level_value_application_id
AND fr.responsibility_id(+) = fpo.level_value
AND fa.application_id(+) = fpo.level_value
AND fn.node_id(+) = fpo.level_value
AND hou.organization_id(+) = fpo.level_value
AND fpov.user_profile_option_name LIKE 'GL: Data Access Set%' ;
fpov.profile_option_name ,
fpov.user_profile_option_name,
DECODE (TO_CHAR (fpo.level_id), '10001', 'SITE', '10002', 'APP', '10003',
'RESP', '10005', 'SERVER', '10006', 'ORG', '10004', 'USER', 'NA' )
profile_Level,
DECODE (TO_CHAR (fpo.level_id), '10001', '', '10002',
fa.application_short_name, '10003', fr.responsibility_key, '10005',
fn.node_name, '10006', hou.NAME, '10004', fu.user_name, 'NA' ) Context_value,
fpo.profile_option_value value,
fr.RESPONSIBILITY_KEY,
fr.RESPONSIBILITY_NAME
FROM
apps.fnd_profile_options_vl fpov,
apps.fnd_profile_option_values fpo,
apps.fnd_user fu,
apps.fnd_application fa,
apps.fnd_responsibility_vl fr,
apps.fnd_nodes fn,
apps.hr_operating_units hou
WHERE
1 = 1
AND fpo.application_id = fpov.application_id
AND fpo.profile_option_id = fpov.profile_option_id
AND fu.user_id(+) = fpo.level_value
AND fr.application_id(+) = fpo.level_value_application_id
AND fr.responsibility_id(+) = fpo.level_value
AND fa.application_id(+) = fpo.level_value
AND fn.node_id(+) = fpo.level_value
AND hou.organization_id(+) = fpo.level_value
AND fpov.user_profile_option_name LIKE 'GL: Data Access Set%' ;
No comments:
Post a Comment