JE Norwegian GEI Print Messages - draft

Description
Categories: BI Publisher
Columns: Receipt Type, Period Start, Period End, Order Number, Header O Num ...
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
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
Ledger ID
 
Number
Period
 
LOV Oracle
Report Type
 
LOV Oracle