ONT Transaction Types Listing

Description

Categories
Enginatics
Application
Order Management
Source
Transaction Types Listing Report (XML)
Short Name
OEXORDTP_XML
DB package
ONT_OEXORDTP_XMLP_PKG
Repository
GitHub
Imported Oracle standard Order Management transaction types listing, enhanced to show the setup across all operating units
Transaction Types Listing Report

SQL 92 lines

Parameters 3

ParameterTypeList of values SQL
Operating UnitLOV
haouv.name=:operating_unit
Transaction Type CodeLOV Oracle
otta.transaction_type_code=:trx_type_code
Order Category CodeLOV Oracle
otta.order_category_code='RETURN'