GL Data Access Sets
Description
Categories: Enginatics, Kcapps
Repository: Github
Repository: Github
Master data report showing ledger security.
Listing of all GL data access sets and the ledgers or ledger sets that each access set can access.
Listing of all GL data access sets and the ledgers or ledger sets that each access set can access.
select gasv.name access_set, gasv.description, gasv.chart_of_accounts_name chart_of_accounts, gasv.period_set_name calendar, gasv.user_period_type period_type, decode(gasv.security_segment_code,'F','Full Ledger','B','Balancing Segment Value','M','Management Segment Value') access_set_type, gasv.default_ledger_name default_ledger, gasna.indent||gl.name ledger_name, decode(gl.ledger_category_code,'NONE',xxen_util.meaning('S','LEDGERS',101),xxen_util.meaning(gl.ledger_category_code,'GL_ASF_LEDGER_CATEGORY',101)) ledger_category, xxen_util.meaning(gasna.all_segment_value_flag,'YES_NO',0) all_values, gasna.segment_value specific_value, decode(gasna.access_privilege_code,'B','Read and Write','R','Read Only') privilege, xxen_util.user_name(gasna.created_by) created_by, xxen_util.client_time(gasna.creation_date) creation_date, xxen_util.user_name(gasna.last_updated_by) last_updated_by, xxen_util.client_time(gasna.last_update_date) last_update_date, gasv.access_set_id from gl_access_sets_v gasv, ( select gasna.ledger_id ledger_id_, null indent, gasna.* from gl_access_set_norm_assign gasna union select glsnav.ledger_id ledger_id_, ' ' indent, gasna.* from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.ledger_id=glsnav.ledger_set_id ) gasna, gl_ledgers gl where 1=1 and gasv.access_set_id=gasna.access_set_id(+) and gasna.ledger_id_=gl.ledger_id(+) and nvl(gasna.status_code,'x') not in ('D','I') order by gasv.name, gasna.ledger_id, gl.object_type_code desc, gl.name |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Access Set |
|
LOV |