INV Movement Statistics Exception

➜ Back to Library
Description
Categories: BI Publisher
Application: Inventory
Source: Movement Statistics Exception Report (XML)
Short Name: INVMVTEX_XML
DB package: INV_INVMVTEX_XMLP_PKG
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
Parameter NameSQL textValidation
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
Download
Related Blitz Reports
INV Movement Statistics CST All Inventories Value (2) INV Move Order Pick Slip AR Potential Reconciling Items CST All Inventories Value Report - by Cost Group CST All Inventories Value CST Margin Analysis Report with Order Management CAC Interface Error Summary CST All Inventories Value (1)
Blitz Report™