Reports2017-11-18T12:27:27+00:00

INV Organization Access

Description
Categories: Enginatics, Logistics, Setup
Organization access setup

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
Application Name
oav.application_name=:application_name
LOV
Responsibility Name
oav.responsibility_name=:responsibility
LOV
Organization Code
oav.organization_code=:organization_code
LOV

By continuing to use the site, you agree to the use of cookies. Accept