AR Israeli Receipt Print

➜ Back to Library
Description
Categories: BI Publisher
Application: Receivables
Source: Israeli Receipt Print
Short Name: ARCRPRRPT
DB package: AR_CASH_RECEIPT_PRINT_PKG

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 
	      aicrg.cash_receipt_id    CASH_RECEIPT_ID
         ,aicrg.receipt_number     RECEIPT_NUMBER
		 ,aicrg.receipt_date       RECEIPT_DATE
		 ,aicrg.receipt_status     RECEIPT_STATUS
		 ,aicrg.document_number    DOCUMENT_NUMBER
		 ,aicrg.receipt_amount     RECEIPT_AMOUNT
		 ,aicrg.currency           CURRENCY
		 ,aicrg.credit_card_no     CREDIT_CARD_NO
		 ,aicrg.credit_card_type   CREDIT_CARD_TYPE
		 ,aicrg.maturity_date      MATURITY_DATE
		 ,aicrg.method_name        METHOD_NAME
		 ,aicrg.bank_account       BANK_ACCOUNT
		 ,aicrg.bank_name          BANK_NAME
		 ,aicrg.bank_branch_name   BANK_BRANCH_NAME
		 ,aicrg.customer_name      CUSTOMER_NAME
		 ,aicrg.customer_number    CUSTOMER_NUMBER
		 ,aicrg.tax_registration_number TAX_REGISTRATION_NUMBER
		 ,aicrg.name               NAME
	     ,aicrg.cust_account_id    CUST_ACCOUNT_ID
		 ,aicrg.cust_acct_site_id  CUST_ACCT_SITE_ID
		 ,aicrg.address_line1      ADDRESS_LINE1
		 ,aicrg.address_line2      ADDRESS_LINE2
		 ,aicrg.city               CITY
		 ,aicrg.postal_code        POSTAL_CODE
		 ,aicrg.copy_or_original   COPY_OR_ORIGINAL
		 ,aicrg.user_name          USER_NAME
		 ,aicrg.cust_tax_registration_num CUST_TAX_REGISTRATION_NUMBER
	FROM AR_IL_CASH_RECEIPTS2_GT aicrg
Parameter Name SQL text Validation
Print Copy or Original 
 
 LOV Oracle
From Date 
 
 Date
To Date 
 
 Date
Receipt Number From 
 
 LOV Oracle
Receipt Number To 
 
 LOV Oracle
Document Number From 
 
 LOV Oracle
Document Number To 
 
 LOV Oracle
Customer 
 
 LOV Oracle
Download
 
Related Blitz Reports
JE Portuguese Customers Recapitulative CE General Ledger Reconciliation CE Bank Statement Import Diagnostics CE Cleared Transactions JE Italian Annual Customer Listing CE Bank Statement and Reconciliation CE Bank Statement Import Execution CE AutoReconciliation Execution - draft JA Cash Flow Statement Program - Cash Flow Detail
Blitz Report™

Blitz Report™ provides multiple benefits: