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
Run
AR Import and Match Remittance Lines and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |
