ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4708151A9E05362FB09050512 select receipt_type , period_start , period_end , to_number(substr(order_number,2,35)) order_number ,order_number header_o_num FROM JE_NO_GEI_MESSAGES where substr(order_number,1,1) = decode(:P_REPORT_TYPE,'S',1,2) and ((to_number(period_start) <= to_number(:P_PERIOD) and to_number(:P_PERIOD) <= to_number(period_end)) or to_number(:P_PERIOD)=to_number(period_start)) order by receipt_type,period_start,period_end,order_number,header_o_num Y JE JENOGEIM_XML US JE Norwegian GEI Print Messages- Not Supported: Reserved For Future Use Imported from BI Publisher Description: Norwegian GEI Print Messages Application: European Localizations Source: Norwegian GEI Print Messages (XML) - Not Supported: Reserved For Future Use Short Name: JENOGEIM_XML DB package: JE_JENOGEIM_XMLP_PKG BI Publisher :func_currency :orderby_acct :p_conc_request_id :p_errors :p_filename :p_ledger_id :p_period :p_report_type :precision :select_all :set_of_books_name :struct_num :where_flex 1 -20 :p_ledger_id Number fnd_profile.value('GL_SET_OF_BKS_ID') US Ledger ID Ledger ID 2 10 :p_report_type LOV Oracle JENO_GEI_REPORT_TYPE Y select ffvv.flex_value id, ffvv.flex_value value, ffvv.flex_value_meaning||nvl2(ffvv.description,': '||ffvv.description,null) description from fnd_flex_values_vl ffvv where ffvv.flex_value_set_id=1021403 order by ffvv.flex_value Y US Report Type Report Type 3 20 :p_period LOV Oracle JENO_GEI_MSG_PERIODS Y select period_year||lpad(period_num,2,0) id, period_year||lpad(period_num,2,0) value, period_name description from gl_period_statuses where ledger_id=fnd_profile.value('GL_SET_OF_BKS_ID') and application_id=101 order by period_year desc,period_num desc Y US Period Period