INV Cycle counts pending approval

Description

Categories
Enginatics
Source
Cycle counts pending approval report (XML)
Short Name
INVARCPA_XML
DB package
INV_INVARCPA_XMLP_PKG
Repository
GitHub
Imported Oracle standard Cycle counts pending approval report

SQL 79 lines

Parameters 6

ParameterTypeList of values SQL
Organization CodeLOV
ood.organization_code=:organization_code
Cycle Count NameLOV
mcch.cycle_count_header_name=:cycle_count_header_name
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
Sort ByLOV Oracle