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
Source: Import and Match Remittance Lines Report
Short Name: ARIRLPT
DB package: AR_IMP_MATCH_REMITTANCE_LINES
Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS
Contact us to schedule a demo or if you need help with the installation
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 |
| Parameter Name | SQL text | Validation | |
|---|---|---|---|
| Request Id |
|
Number | |
| Org Id |
|
Number |
