SELECT * --fpov.profile_option_value
FROM applsys.fnd_profile_option_values fpov
, applsys.fnd_profile_options fpo
, applsys.fnd_profile_options_tl fpot
, applsys.fnd_responsibility_tl fr
WHERE 1 = 1
AND fpo.profile_option_name = fpot.profile_option_name
AND fpo.profile_option_id = fpov.profile_option_id
AND fr.responsibility_id(+) = fpov.level_value
-- AND fr.responsibility_id = :$PROFILES$.RESP_ID
AND fpot.profile_option_name = 'ORG_ID'
and fpov.profile_option_value='11'
and fr.responsibility_name like '%Payables%Super%User%';
FROM applsys.fnd_profile_option_values fpov
, applsys.fnd_profile_options fpo
, applsys.fnd_profile_options_tl fpot
, applsys.fnd_responsibility_tl fr
WHERE 1 = 1
AND fpo.profile_option_name = fpot.profile_option_name
AND fpo.profile_option_id = fpov.profile_option_id
AND fr.responsibility_id(+) = fpov.level_value
-- AND fr.responsibility_id = :$PROFILES$.RESP_ID
AND fpot.profile_option_name = 'ORG_ID'
and fpov.profile_option_value='11'
and fr.responsibility_name like '%Payables%Super%User%';
We believe the best way to pull the org_id associated to a responsibility is by checking the MO:Security Profile attached to the Responsibilityl... Get the operating Unit name form there and query the same in hr_operating_units table/view to get the Org_id.. Oracle Apps Online Training | Oracle Apps Technical Training
ReplyDelete