fct.calendar_type "calendar type",
fct.description "calendar description",
fct.number_per_fiscal_year "periods per fiscal year",
fct.fiscal_year_name "fiscal year name",
fcp.start_date "start date",
fcp.end_date "end date",
fcp.period_num "period number",
fuc.user_name "created by",
fcp.creation_date "creation date",
fuu.user_name "last updated by",
fuu.last_update_date "last update date"
from
fa_calendar_types fct,
fa_calendar_periods fcp,
fnd_user fuc,
fnd_user fuu
where
fct.created_by=fuc.user_id and
fct.last_updated_by=fuu.user_id
No comments:
Post a Comment