SELECT fu.user_name "User", atr.attribute_code "Attribute",
fa.application_name "Application", number_value "Value",
fuc.user_name "Added By", ful.user_name "Updated By"
FROM ak_web_user_sec_attr_values atr,
fnd_user fu,
fnd_application_tl fa,
fnd_user fuc,
fnd_user ful
WHERE fu.user_id = atr.web_user_id
AND atr.attribute_application_id = fa.application_id
AND atr.created_by = fuc.user_id
AND atr.last_updated_by = ful.user_id
AND fu.user_name = UPPER (:user_name);
fa.application_name "Application", number_value "Value",
fuc.user_name "Added By", ful.user_name "Updated By"
FROM ak_web_user_sec_attr_values atr,
fnd_user fu,
fnd_application_tl fa,
fnd_user fuc,
fnd_user ful
WHERE fu.user_id = atr.web_user_id
AND atr.attribute_application_id = fa.application_id
AND atr.created_by = fuc.user_id
AND atr.last_updated_by = ful.user_id
AND fu.user_name = UPPER (:user_name);
No comments:
Post a Comment