INV Physical inventory accuracy analysis

Description

Categories
Enginatics
Application
Inventory
Source
Physical inventory accuracy analysis (XML)
Short Name
INVARPIA_XML
DB package
INV_INVARPIA_XMLP_PKG
Repository
GitHub
Imported from BI Publisher
Physical inventory accuracy analysis

SQL 38 lines

Parameters 6

ParameterTypeList of values SQL
Organization CodeLOV
ood.organization_code=:organization_code
Physical InventoryLOV Oracle
mpacv.physical_inventory_id=:phys_inv_id
Category Set 1LOV
select xxen_util.item_category_columns(p_category_set_name=>'<parameter_value>') sql_text from dual
Category Set 2LOV
select xxen_util.item_category_columns(p_category_set_name=>'<parameter_value>') sql_text from dual
Category Set 3LOV
select xxen_util.item_category_columns(p_category_set_name=>'<parameter_value>') sql_text from dual
Exclude Rejected ItemsLOV
nvl(mpacv.approval_status,1)<>2