[Home] [Help] [Dependency Information]

VIEW: APPS.AR_INVOICE_TOTALS_V

Object Details

Object Name:	AR_INVOICE_TOTALS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AR.AR_INVOICE_TOTALS_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

The AR_INVOICE_TOTALS_V view, which is one of eight transaction printing views that Oracle Receivables provides, collects the total amount for all lines, tax, and freight charges that are associated with a transaction. A system administrator or Oracle consultant can use transaction printing views to extract transaction information from Receivables and then print the data in a custom format using Oracle Reports or a similar, SQL-based report generator.

[View Source]

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT TOTAL_TAX_AMOUNT
,      TOTAL_FREIGHT_AMOUNT
,      TOTAL_LINE_AMOUNT
,      TOTAL_AMOUNT
,      CUSTOMER_TRX_ID
FROM APPS.AR_INVOICE_TOTALS_V;

Dependencies

[top of page]

APPS

RA_CUSTOMER_TRX

RA_CUSTOMER_TRX_LINES

RA_CUST_TRX_TYPES

APPS.AR_INVOICE_TOTALS_V is not referenced by any database object