INV Organization Access

Description
Categories: Enginatics, Kcapps, Toolkit - Operations, Toolkit - Setup & Support
Repository: Github
Master data report for Inventory orgs, with org code, application, responsibility and creation information. Allows BR100 creation.
Run INV Organization Access and other Oracle EBS reports with Blitz Report™ on our demo environment
select
oav.organization_code,
oav.organization_name,
oav.application_name application,
oav.responsibility_name responsibility,
oav.comments,
xxen_util.user_name(oav.created_by) created_by,
xxen_util.client_time(oav.creation_date) creation_date,
xxen_util.user_name(oav.last_updated_by) last_updated_by,
xxen_util.client_time(oav.last_update_date) last_update_date
from
org_access_v oav
where
1=1
order by
oav.organization_code,
oav.organization_name,
oav.application_name,
oav.responsibility_name
Parameter Name SQL text Validation
Organization Code
oav.organization_code=:organization_code
LOV
Application Name
oav.application_name=:application_name
LOV
Responsibility Name
oav.responsibility_name=:responsibility
LOV