ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F4D33869E053B46B63588994Y SELECT m1.period_set_name period_set_dg, m1.period_type period_type_dg, m2.period_name before_per_dg, m3.period_name after_per_dg, m1.accounting_date gap_start_date_dg, m3.accounting_date-1 gap_end_date_dg FROM gl_date_period_map m1, gl_date_period_map m2, gl_date_period_map m3 WHERE m1.accounting_date between :date_low and :date_high AND m1.period_name = 'NOT ASSIGNED' AND m2.period_set_name = :periodset AND m2.period_type = :periodtype AND m2.accounting_date+0 between :date_low and :date_high AND m2.accounting_date = m1.accounting_date-1 AND m2.period_name != 'NOT ASSIGNED' AND m3.period_set_name = :periodset AND m3.period_type = :periodtype AND m3.accounting_date = ( SELECT min(m4.accounting_date) FROM gl_date_period_map m4 WHERE m4.period_set_name = :periodset AND m4.period_type = :periodtype AND m4.accounting_date between m1.accounting_date and :date_high AND m4.period_name != 'NOT ASSIGNED' ) and m1.period_set_name=:periodset and m1.period_type=:periodtype ORDER BY m1.accounting_date SQLGL GLXCLVAL_XML AR GL أخرى - تقرير مراجعة التقويم (بتنسيق XML) Application: الأستاذ العام Source: أخرى - تقرير مراجعة التقويم (بتنسيق XML) Short Name: GLXCLVAL_XML DB package: GL_GLXCLVAL_XMLP_PKG D GL Sonstiges - Kalendervalidierung Application: Rechnungswesen Source: Sonstiges - Kalendervalidierung (XML) Short Name: GLXCLVAL_XML DB package: GL_GLXCLVAL_XMLP_PKG F GL Autres - Etat de validation du calendrier Application: General Ledger Source: Autres - Etat de validation du calendrier (XML) Short Name: GLXCLVAL_XML DB package: GL_GLXCLVAL_XMLP_PKG US GL Other - Calendar Validation Application: General Ledger Source: Other - Calendar Validation Report (XML) Short Name: GLXCLVAL_XML DB package: GL_GLXCLVAL_XMLP_PKG ZHS GL 其它 - 日历验证报表 Application: 总帐管理系统 Source: 其它 - 日历验证报表 (XML) Short Name: GLXCLVAL_XML DB package: GL_GLXCLVAL_XMLP_PKG BI Publisher :date_high :date_low :p_conc_request_id :p_end_year :p_period_set :p_period_type :p_start_year :periodset :periodtype :prev_ps :prev_pt :total_violations :user_period_type 1 10 :p_period_set LOV Oracle GL_SRS_CALENDAR_VAL_SET Y select period_set_code id, period_set_name value, null description from gl_srs_clval_period_set_v order by period_set_name select meaning from gl_lookups where lookup_type='LITERAL' and lookup_code='ALL' Y AR التقويم D Kalender F Calendrier US Calendar ZHS 日历 2 20 :p_period_type LOV Oracle GL_SRS_CALENDAR_PERIOD_TYPE Y select period_type id, user_period_type value, null description from gl_period_types where :$flex$.gl_srs_calendar_val_set='ALL' or ( period_type in (select period_type from gl_periods p where p.period_set_name= :$flex$.gl_srs_calendar_val_set)) order by value,description AR نوع الفترة D Periodenart F Type de période US Period Type ZHS 期间类型 3 30 :p_start_year Number AR من سنة D Von Jahr F Année - De US Year From ZHS 起始年度 4 40 :p_end_year Number AR إلى سنة D Bis Jahr F Année - A US Year To ZHS 终止年度