FND Data Groups

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
select
fdg.data_group_name,
fdg.description data_group_description,
fav.application_name application,
fou.oracle_username,
xxen_util.user_name(fdgu.created_by) created_by,
xxen_util.client_time(fdgu.creation_date) creation_date,
xxen_util.user_name(fdgu.last_updated_by) last_updated_by,
xxen_util.client_time(fdgu.last_update_date) last_update_date,
fdg.data_group_id
from
fnd_data_groups fdg,
fnd_data_group_units fdgu,
fnd_application_vl fav,
fnd_oracle_userid fou
where
1=1 and
fdg.data_group_id=fdgu.data_group_id and
fdgu.application_id=fav.application_id and
fdgu.oracle_id=fou.oracle_id
order by
fdg.data_group_name,
fdg.description,
fav.application_name
Parameter NameSQL textValidation
Data Group Name
fdg.data_group_name=:data_group_name
LOV
Download
Related Blitz Reports
FND Applications CAC Inventory and Intransit Value (Period-End) - Discrete/OPM FND Audit Setup CAC WIP Material Usage Variance CAC WIP Resource Efficiency CAC ICP PII WIP Material Usage Variance CAC Inventory Lot and Locator OPM Value (Period-End) PON Solicitation data template FND Responsibility Access
Blitz Report™