INV Cycle count listing

Description

Categories
Enginatics
Source
Cycle count listing (XML)
Short Name
INVARCLI_XML
DB package
INV_INVARCLI_XMLP_PKG
Repository
GitHub
Imported Oracle standard cycle count listing report

SQL 85 lines

Parameters 7

ParameterTypeList of values SQL
Organization CodeLOV
ood.organization_code=:organization_code
Cycle Count NameLOV
mcch.cycle_count_header_name=:cycle_count_header_name
Due Date FromDate
mcce.count_due_date>=:due_date_from
Due Date ToDate
mcce.count_due_date<:due_date_to+1
Include Recounts OnlyLOV Oracle
(mcce.entry_status_code=1 and :p_recountonly<>1 or mcce.entry_status_code=3)
SubinventoryLOV
mcce.subinventory=:p_subinventory
Items to includeLOV Oracle
(nvl(:p_export_display,1)=1 or :p_export_display=2 and nvl(mcce.export_flag, 2)=2 or :p_export_display=3 and mcce.export_flag=1)