ONT Credit Check Processor

Description

Categories
BI Publisher
Application
Order Management
Source
Credit Check Processor (XML)
Short Name
OEXAUCRC_XML
DB package
ONT_OEXAUCRC_XMLP_PKG

SQL 12 lines

SELECT	  party_name
	, account_number
	, transaction_type_name
	, order_number
	, credit_status
FROM	OE_CC_PROCESSOR_TEMP
ORDER BY	  party_name
	, account_number
	, credit_status_sort
	, transaction_type_name
	, order_number

Parameters 10

ParameterTypeList of values SQL
Operating UnitLOV Oracle
Customer Profile Classes FromLOV Oracle
ToLOV Oracle
ToLOV Oracle
ToDate
ToLOV Oracle
Customer Names FromLOV Oracle
Customer Numbers FromLOV Oracle
Order Dates FromDate
Order SequenceLOV Oracle