eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.AP_INVOICE_PRICE_VAR_V

Object Details

Object Name:	AP_INVOICE_PRICE_VAR_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	SQLAP.AP_INVOICE_PRICE_VAR_V
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
INVOICE_NUM	VARCHAR2	(50)
INVOICE_DATE	DATE
QUANTITY_INVOICED	NUMBER
INVOICE_RATE	NUMBER
INVOICE_AMOUNT	NUMBER
INVOICE_BASE_AMOUNT	NUMBER
INVOICE_PRICE	NUMBER
INVOICE_CURRENCY	VARCHAR2	(15)
INVOICE_PRICE_VARIANCE	NUMBER
BASE_INV_PRICE_VAR	NUMBER
EX_RATE_VARI	NUMBER
PO_DISTRIBUTION_ID	NUMBER	(15)
RCV_TRANSACTION_ID	NUMBER	(15)
ACCOUNTING_DATE	DATE

Query Text

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


SELECT INVOICE_NUM
,      INVOICE_DATE
,      QUANTITY_INVOICED
,      INVOICE_RATE
,      INVOICE_AMOUNT
,      INVOICE_BASE_AMOUNT
,      INVOICE_PRICE
,      INVOICE_CURRENCY
,      INVOICE_PRICE_VARIANCE
,      BASE_INV_PRICE_VAR
,      EX_RATE_VARI
,      PO_DISTRIBUTION_ID
,      RCV_TRANSACTION_ID
,      ACCOUNTING_DATE
FROM APPS.AP_INVOICE_PRICE_VAR_V;

Dependencies

[top of page]

APPS.AP_INVOICE_PRICE_VAR_V references the following:

APPS: AP_INVOICES; AP_INVOICE_DISTRIBUTIONS

APPS.AP_INVOICE_PRICE_VAR_V is not referenced by any database object