[Home] [Help] [Dependency Information]
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 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 |
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;
APPS.AP_INVOICE_PRICE_VAR_V is not referenced by any database object
|
|
|