ِAsset Calendar and Periods SQL Query


select
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