ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F4D83869E053B46B63588994Y SELECT &NAME_COLUMN DEFINITION_NAME, MAX(decode(FGV.FUNCTION_NAME, FGV.OBJ_NAME || '_U', 'X', NULL )) USE_PRIVILEGE, MAX(decode(FGV.FUNCTION_NAME, FGV.OBJ_NAME || '_V', 'X', NULL )) VIEW_PRIVILEGE, MAX(decode(FGV.FUNCTION_NAME, FGV.OBJ_NAME || '_M', 'X', NULL )) MODIFY_PRIVILEGE FROM &TABLE_NAME DEF, FND_GRANTS_VIEW FGV &WHERE_DEFAS AND FGV.user_name = :P_USER_NAME AND FGV.OBJ_NAME = :P_DEFINITION_TYPE AND FGV.INSTANCE_PK1_VALUE = &ID_COLUMN1 AND FGV.INSTANCE_PK2_VALUE = '*NULL*' AND FGV.INSTANCE_PK3_VALUE = '*NULL*' AND FGV.INSTANCE_PK4_VALUE = '*NULL*' AND FGV.INSTANCE_PK5_VALUE = '*NULL*' GROUP BY &NAME_COLUMN ORDER BY DEFINITION_NAME SQLGL GLXDFUSR_XML AR GL أخرى - صلاحية الوصول للتعريف بواسطة المستخدم (بتنسيق XML) Application: الأستاذ العام Source: أخرى - صلاحية الوصول للتعريف بواسطة المستخدم (بتنسيق XML) Short Name: GLXDFUSR_XML DB package: GL_GLXDFUSR_XMLP_PKG D GL Sonstiges - Definitionszugriff nach Benutzer Application: Rechnungswesen Source: Sonstiges - Definitionszugriff nach Benutzer (XML) Short Name: GLXDFUSR_XML DB package: GL_GLXDFUSR_XMLP_PKG F GL Autre - Accès aux définitions par utilisateur Application: General Ledger Source: Autre - Accès aux définitions par utilisateur (XML) Short Name: GLXDFUSR_XML DB package: GL_GLXDFUSR_XMLP_PKG US GL Other - Definition Access By User Application: General Ledger Source: Other - Definition Access By User (XML) Short Name: GLXDFUSR_XML DB package: GL_GLXDFUSR_XMLP_PKG ZHS GL 其它 - 按用户列出的定义访问权限 Application: 总帐管理系统 Source: 其它 - 按用户列出的定义访问权限 (XML) Short Name: GLXDFUSR_XML DB package: GL_GLXDFUSR_XMLP_PKG BI Publisher &id_column1 &name_column &table_name &where_defas :definition_type :id_column1 :id_columns :name_column :p_conc_request_id :p_definition_type :p_user_name :row_count :table_name :where_defas 1 10 :p_user_name LOV Oracle GL_SRS_USER Y select user_name id, user_name value, null description from fnd_user order by value,description select fnd_profile.value('USERNAME') from dual Y AR اسم المستخدم D Benutzername F Nom utilisateur US User Name ZHS 用户名 2 20 :p_definition_type LOV Oracle GL_SRS_DEFINITION_TYPES Y select obj_name id, display_name value, null description from fnd_objects_vl where application_id=101 order by value,description Y AR نوع التعريف D Definitionsart F Type de définition US Definition Type ZHS 定义类型