AR Israeli Receipt Print
Description
Categories: BI Publisher
Application: Receivables
Source: Israeli Receipt Print
Short Name: ARCRPRRPT
DB package: AR_CASH_RECEIPT_PRINT_PKG
Source: Israeli Receipt Print
Short Name: ARCRPRRPT
DB package: AR_CASH_RECEIPT_PRINT_PKG
Run
AR Israeli Receipt Print and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |