SELECT frt.responsibility_name,
frg.request_group_name,
frgu.request_unit_type,
frgu.request_unit_id,
fcpt.user_request_set_name,
fr.responsibility_id,
fr.application_id
FROM apps.fnd_Responsibility fr,
apps.fnd_responsibility_tl frt,
apps.fnd_request_groups frg,
apps.fnd_request_group_units frgu,
apps.fnd_request_Sets_tl fcpt
WHERE frt.responsibility_id = fr.responsibility_id
AND frg.request_group_id = fr.request_group_id
AND frgu.request_group_id = frg.request_group_id
AND fcpt.request_set_id = frgu.request_unit_id
AND fcpt.user_request_set_name = 'Import Item Organization Assignment';
frg.request_group_name,
frgu.request_unit_type,
frgu.request_unit_id,
fcpt.user_request_set_name,
fr.responsibility_id,
fr.application_id
FROM apps.fnd_Responsibility fr,
apps.fnd_responsibility_tl frt,
apps.fnd_request_groups frg,
apps.fnd_request_group_units frgu,
apps.fnd_request_Sets_tl fcpt
WHERE frt.responsibility_id = fr.responsibility_id
AND frg.request_group_id = fr.request_group_id
AND frgu.request_group_id = frg.request_group_id
AND fcpt.request_set_id = frgu.request_unit_id
AND fcpt.user_request_set_name = 'Import Item Organization Assignment';
No comments:
Post a Comment