AR Import and Match Remittance Lines

Description

Categories
BI Publisher
Application
Receivables
Source
Import and Match Remittance Lines Report
Short Name
ARIRLPT
DB package
AR_IMP_MATCH_REMITTANCE_LINES

SQL 3 lines

        select ROWNUM LINE_NO,DOC_NUMBER ,substr(CUSTOMER_NAME,1,20) CUSTOMER_NAME,REMIT_AMOUNT,CURRENCY ,RECEIPT_NUMBER,trunc(RECEIPT_DATE) RECEIPT_DATE  from ar_interface_remit_lines where status = 'UNMATCHED'
		&p_query_where

Parameters 2

ParameterTypeList of values SQL
Request IdNumber
Org IdNumber