JE Norwegian GEI Print Messages- Not Supported: Reserved For Future Use

Description
Categories: BI Publisher
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
Run JE Norwegian GEI Print Messages- Not Supported: Reserved For Future Use and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Parameter Name SQL text Validation
Report Type
 
LOV Oracle
Period
 
LOV Oracle
Blitz Report™