[Home] [Help]
[Dependency Information]
Object Name: | AR_XML_INVOICE_LINE_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CUSTOMER_TRX_ID | NUMBER | (15) | Yes | |
CUSTOMER_TRX_LINE_ID | NUMBER | (15) | Yes | |
LINE_TYPE | VARCHAR2 | (20) | Yes | |
LINE_NUMBER | NUMBER | Yes | ||
LINE_AMOUNT | NUMBER | Yes | ||
UNIT_SELLING_PRICE | NUMBER | |||
QUANTITY | NUMBER | |||
DESCRIPTION | VARCHAR2 | (240) | ||
UOM | VARCHAR2 | (3) | ||
ITEM | VARCHAR2 | (4000) | ||
ITEM_DESCRIPTION | VARCHAR2 | (240) | ||
REFERENCE_NUMBER | VARCHAR2 | (82) | ||
USER1 | VARCHAR2 | (4000) | ||
USER2 | VARCHAR2 | (4000) | ||
USER3 | VARCHAR2 | (4000) | ||
USER4 | VARCHAR2 | (4000) | ||
USER5 | VARCHAR2 | (4000) | ||
USER6 | VARCHAR2 | (4000) | ||
USER7 | VARCHAR2 | (4000) | ||
USER8 | VARCHAR2 | (4000) | ||
USER9 | VARCHAR2 | (4000) | ||
USER10 | VARCHAR2 | (4000) |
Cut, paste (and edit) the following text to query this object:
SELECT CUSTOMER_TRX_ID
, CUSTOMER_TRX_LINE_ID
, LINE_TYPE
, LINE_NUMBER
, LINE_AMOUNT
, UNIT_SELLING_PRICE
, QUANTITY
, DESCRIPTION
, UOM
, ITEM
, ITEM_DESCRIPTION
, REFERENCE_NUMBER
, USER1
, USER2
, USER3
, USER4
, USER5
, USER6
, USER7
, USER8
, USER9
, USER10
FROM APPS.AR_XML_INVOICE_LINE_V;
APPS.AR_XML_INVOICE_LINE_V is not referenced by any database object
|
|
|