SELECT fat.application_name, frt.RESPONSIBILITY_NAME, hou.name operating_unit
FROM fnd_responsibility_tl frt,
fnd_application_tl fat,
fnd_profile_options_vl fpo,
fnd_profile_option_values fpov,
hr_operating_units hou
WHERE frt.language = fat.language
AND frt.language = USERENV ('LANG')
AND frt.application_id = fat.application_id
AND fat.application_name IN ('Payables',
'Receivables',
'Cash Management',
'General Ledger',
'Assets',
'Cost Management',
'Order Management')
AND profile_option_name = 'ORG_ID'
AND fpo.profile_option_id = fpov.profile_option_id
AND fpov.level_value = frt.responsibility_id
AND TO_CHAR (hou.organization_id) = fpov.profile_option_value
ORDER BY hou.name, fat.application_name
FROM fnd_responsibility_tl frt,
fnd_application_tl fat,
fnd_profile_options_vl fpo,
fnd_profile_option_values fpov,
hr_operating_units hou
WHERE frt.language = fat.language
AND frt.language = USERENV ('LANG')
AND frt.application_id = fat.application_id
AND fat.application_name IN ('Payables',
'Receivables',
'Cash Management',
'General Ledger',
'Assets',
'Cost Management',
'Order Management')
AND profile_option_name = 'ORG_ID'
AND fpo.profile_option_id = fpov.profile_option_id
AND fpov.level_value = frt.responsibility_id
AND TO_CHAR (hou.organization_id) = fpov.profile_option_value
ORDER BY hou.name, fat.application_name
No comments:
Post a Comment