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
| Parameter | Type | List of values SQL |
|---|---|---|
| Request Id | Number | |
| Org Id | Number |