|Oracle Receivables User Guide|
Part Number E13522-04
Use the Receivables Transaction Printing Views with Oracle Applications or any third party SQL-based system to collect Receivables transaction information and print it in a format you define. The Transaction Printing Views cannot be accessed from any Receivables window or program. Your system administrator or Oracle consultant must write custom SQL scripts to extract the transaction data that you need from the views. You can then use Oracle Reports 2.5 or later (or a similar SQL-based report generator) to format and print the data according to your needs.
While the Transaction Printing Views and the Receivables Print Invoice program are somewhat similar, you use each differently and for different purposes. The Receivables Print Invoices program prints selected transactions based on a series of runtime parameters that you specify, such as transaction class, transaction type, or a range of transaction numbers. Transaction Printing Views select all Receivables transaction information from the database. Your system administrator or Oracle consultant extracts the transaction information needed from the views by entering parameters in the WHERE clause for each SQL statement. A list of valid parameters is included with each view.
Note: The Transaction Printing Views also provide several functions to extract complex data that cannot be accessed using SQL select statements. These functions are for select purposes only and cannot update the database due to pragma restrictions, compiler directives that indicate which kinds of SQL statements can be used in a PL/SQL function. These restrictions are declared in the package specification for each function. The Pragma Restrict-Reference is located in the package header with the specification for the function.
Note: When you print your reports, you will want to update the transaction header indicating when the transaction was successfully printed. This is done by calling the Oracle Receivables API, ARTPSQB.pls. Select the "updated_customer_trx" function. This API updates the following columns: PRINTING_COUNT, PRINTING_LAST_PRINTED, PRINTING_ORIGINAL_DATE, and LAST_PRINTED_SEQUENCE_NUM.
The following modules create the view structure for the transaction printing procedure. You must run these modules in the order in which they appear, because dependencies exist between some of the files.
ARTPSQS.pls is the package specification for view functions
ARTPSQBS.pls is the package body for view functions
arvpinvv.sql is the other views creation script
arvphdrv.sql is the header view creation script
arvpadjv.sql is the adjustment view creation script
arvplinv.sql is the lines view creation script
Receivables provides the following Transaction Printing Views you can use to select transaction data.
AR_INVOICE_HEADER_V is the main view. It retrieves the header information of the report. It has two parts, one for adjustments and one for nonadjustments.
AR_INVOICE_ADJ_V retrieves the details for an adjustment.
AR_INVOICE_LINES_V retrieves the line items of each transaction retrieved by AR_INVOICE_HEADER_V.
AR_INVOICE_TAX_SUMMARY_V retrieves tax summary information for a transaction.
AR_INVOICE_COMMITMENT_INFO_V retrieves commitment information for a transaction.
AR_INVOICE_TOTALS_V retrieves the total amounts for all lines and associated charges for a transaction (for example, lines, freight, and tax).
AR_INVOICE_INSTALLMENTS_V retrieves installment information for transactions with multiple installments.
AR_INVOICE_COUNT_TERMS_V retrieves the number of terms for a transaction (that is, transactions assigned to split payment terms).
For more information about these views and the tables and columns from which they select data, refer to the Oracle eBusiness Suite Electronic Technical Reference Manual (eTRM) on My Oracle Support.
See: Printing Transactions.
Copyright © 1988, 2010, Oracle and/or its affiliates. All rights reserved.