INV Movement Statistics Exception
Description
- Categories
- BI Publisher
- Application
- Inventory
- Source
- Movement Statistics Exception Report (XML)
- Short Name
- INVMVTEX_XML
- DB package
- INV_INVMVTEX_XMLP_PKG
SQL 19 lines
SELECT error_type error_type5 , error_name error_name5 , movement_id movement_id5 , column_name column_name5, --INV_INVMVTEX_XMLP_PKG.cf_action_text5formula() CF_action_text5, INV_INVMVTEX_XMLP_PKG.cf_action_text5formula() CP_action_text5, --INV_INVMVTEX_XMLP_PKG.cf_error_text5formula() CF_error_text5, INV_INVMVTEX_XMLP_PKG.cf_error_text5formula() CP_error_text5, --INV_INVMVTEX_XMLP_PKG.CP_action_text5_p CP_action_text5, --INV_INVMVTEX_XMLP_PKG.CP_error_text5_p CP_error_text5, 'x' dummy FROM inv_mvt_excep_rep_temp WHERE error_name='INV_MGD_MVT_INVAL_VAL' ORDER BY 1 ASC,2 ASC,3 ASC |
Parameters 7
| Parameter | Type | List of values SQL |
|---|---|---|
| Legal Entity | LOV Oracle | |
| Economic Zone | LOV Oracle | |
| Usage Type | LOV Oracle | |
| Statistical Type | LOV Oracle | |
| Period Name | LOV Oracle | |
| Document Source Type | LOV Oracle | |
| Display Warnings | LOV Oracle |