JE Norwegian GEI Print Messages- Not Supported: Reserved For Future Use
Description
- Categories
- BI Publisher
- 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
Imported from BI Publisher
Norwegian GEI Print Messages
Norwegian GEI Print Messages
SQL 10 lines
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 |
Parameters 2
| Parameter | Type | List of values SQL |
|---|---|---|
| Report Type | LOV Oracle | |
| Period | LOV Oracle |