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
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 |