ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8143175C7BEA161EE0530100007FF604 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 Y AR GL Data Access Sets تقرير بيانات رئيسي يوضح الوصول إلى أمان حساب GL عبر دفاتر الأستاذ المتعددة. D GL Data Access Sets Stammdatenbericht mit Anzeige des GL-Konto-Sicherheitszugriffs über mehrere Ledger hinweg. E GL Data Access Sets Informe de datos maestros que muestra el acceso a la seguridad de la cuenta del libro mayor en varios libros. F GL Data Access Sets Rapport sur les données de base montrant l'accès à la sécurité des comptes de GL dans plusieurs grands livres. I GL Data Access Sets Rapporto dei dati principali che mostra l'accesso di sicurezza del conto GL su più libri mastri. JA GL Data Access Sets 複数の台帳にまたがるGLアカウントのセキュリティアクセスを示すマスターデータレポート。 KO GL Data Access Sets 여러 원장에 대한 GL 계정 보안 액세스를 보여주는 마스터 데이터 보고서. PTB GL Data Access Sets Relatório de dados mestre mostrando o acesso de segurança da conta GL em vários ledgers. RU GL Data Access Sets Отчет об основных данных, показывающий безопасный доступ к учетным записям GL по нескольким бухгалтерским записям. S GL Data Access Sets Huvuddatarapport som visar GL-kontos säkerhetsåtkomst över flera huvudböcker. TR GL Data Access Sets Birden çok defterde GL hesabı güvenlik erişimini gösteren ana veri raporu. US GL Data Access Sets 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. ZHS GL Data Access Sets 主数据报告显示多个分类账的GL账户安全访问。 Enginatics R12 only 1=1 1 10 1=1 gasv.name=:access_set LOV custom Y select gasv.name value, gasv.description from gl_access_sets_v gasv order by gasv.name fnd_profile.value('GL_ACCESS_SET_ID') US Access Set