INV Print Cycle Count Entries Open Interface data

Description

Categories
Enginatics
Source
Print Cycle Count Entries Open Interface data (XML)
Short Name
INVCCIER_XML
DB package
INV_INVCCIER_XMLP_PKG
Repository
GitHub
Imported Oracle standard Print Cycle Count Entries Open Interface data report

SQL 49 lines

Parameters 6

ParameterTypeList of values SQL
Organization CodeLOV
ood.organization_code=:organization_code
Cycle Count NameLOV
mceiv.cycle_count_header_name=:cycle_count_header_name
Request IdLOV
mceiv.request_id=:p_request_id
Action CodeLOV
ml.meaning=:p_action_code
Count Date FromDate
mceiv.count_date>=:p_count_date_low
Count Date ToDate
mceiv.count_date<:p_count_date_high+1