ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F1223869E053B46B63588994Y SELECT 'Z20' TYPE_OF_ROW ,jesr.authority_type PARTY_QUALIFIER ,jesr.account_number ACCOUNT_NUMBER ,to_char(round(sum(nvl(jesr.balance,0)), :P_PRECISION), 'S99999999999999999D00') AMOUNT ,jesr.natural_account NATURAL_ACCOUNT ,jesr.segment_desc ACCOUNT_DESCRIPTION FROM je_no_gei_sreport_v jesr WHERE (:P_PERIOD_NUM > 12 and jesr.period_num = :P_PERIOD_NUM) AND jesr.period_year = :P_PERIOD_YEAR AND nvl(jesr.balance,0) <> 0 AND jesr.template_id = :P_TEMPLATE_ID AND jesr.actual_flag = 'A' GROUP BY jesr.authority_type, jesr.account_number, jesr.natural_account, jesr.segment_desc having round(sum(nvl(jesr.balance,0)), :P_PRECISION) <>0 UNION SELECT 'Z20' TYPE_OF_ROW ,jesr.authority_type PARTY_QUALIFIER ,jesr.account_number ACCOUNT_NUMBER ,TO_CHAR(ROUND(SUM(NVL(jesr.balance,0)), :P_PRECISION), 'S99999999999999999D00') AMOUNT ,jesr.natural_account NATURAL_ACCOUNT ,jesr.segment_desc ACCOUNT_DESCRIPTION FROM je_no_gei_sreport_v jesr WHERE (:P_PERIOD_NUM <= 12 AND jesr.period_num <= :P_PERIOD_NUM) AND jesr.period_year = :P_PERIOD_YEAR AND nvl(jesr.balance,0) <> 0 AND jesr.template_id = :P_TEMPLATE_ID AND jesr.actual_flag = 'A' GROUP BY jesr.authority_type, jesr.account_number, jesr.natural_account, jesr.segment_desc having ROUND(SUM(NVL(jesr.balance,0)), :P_PRECISION) <>0 JE JENOGEIS_XMLP AR JE Norwegian GEI S-Report (بتنسيق XML) Application: المحليات الأوروبية Source: Norwegian GEI S-Report (بتنسيق XML) Short Name: JENOGEIS_XMLP DB package: JE_NO_SREPORT_PKG D JE GEI S-Auswertung Application: Europäische Lokalisierungen Source: Norwegen: GEI S-Auswertung (XML) Short Name: JENOGEIS_XMLP DB package: JE_NO_SREPORT_PKG F JE Norvège - Etat S GEI Application: European Localizations Source: Norvège - Etat S GEI (XML) Short Name: JENOGEIS_XMLP DB package: JE_NO_SREPORT_PKG US JE Norwegian GEI S- Application: European Localizations Source: Norwegian GEI S-Report (XML) Short Name: JENOGEIS_XMLP DB package: JE_NO_SREPORT_PKG BI Publisher :gn_return_code :p_closing_status :p_coa_id :p_flex_value_set_id :p_functcurr :p_gei_acc_central :p_gei_account_desc_seg :p_gei_account_seg :p_gei_accountant :p_gei_aut_type :p_gei_exp_account :p_gei_inc_account :p_gei_nat_account_seg :p_gei_test_indicator :p_ledger_id :p_period_name :p_period_num :p_period_year :p_precision :p_sobname :p_template_id 1 10 :p_ledger_id LOV Oracle JENO_GEI_LEDGER Y select l.ledger_id id, l.name value, l.description description from gl_access_set_ledgers ac,gl_ledgers_public_v l where ac.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and l.ledger_id=ac.ledger_id order by name select fnd_profile.value('GL_SET_OF_BKS_NAME') from dual Y AR دفتر الأستاذ D Buch F Livre US Ledger 2 20 :p_template_id LOV Oracle JENO_GEI_SUMMARY_TEMPLATE Y select template_id id, template_name value, null description from gl_summary_templates where ledger_id=:$flex$.jeno_gei_ledger order by template_name Y AR نموذج الإجمالي D Summierungsschema F Combinaison de synthèse US Summary Template 3 30 :p_period_name LOV Oracle JENO_GEI_CLOSED_PERIODS Y select period_name id, period_name value, null description from gl_period_statuses where (closing_status in ('C')) and ledger_id=:$flex$.jeno_gei_ledger and application_id=101 order by period_year desc,period_num desc Y AR الفترة D Periode F Période US Period