[Home] [Help]
[Dependency Information]
| Object Name: | AR_XML_INVOICE_LINE_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | AR.AR_XML_INVOICE_LINE_V
|
| 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_MEMO_LINES_VL
AR_XML_VIEW_FUNCTIONS
- show dependent code
FA_RX_FLEX_PKG
- show dependent code
HR_GENERAL
- show dependent code
HR_SECURITY
- show dependent code
MO_GLOBAL
- show dependent code
MTL_SYSTEM_ITEMS
OE_SYSTEM_PARAMETERS
OE_SYS_PARAMETERS
- show dependent code
RA_CUSTOMER_TRX_LINES
APPS.AR_XML_INVOICE_LINE_V is not referenced by any database object
|
|
|
|