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


VIEW: APPS.AR_XML_INVOICE_LINE_V

Object Details
Object Name: AR_XML_INVOICE_LINE_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAR.AR_XML_INVOICE_LINE_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
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)
Query Text

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;

Dependencies

[top of page]

APPS.AR_XML_INVOICE_LINE_V references the following:

SchemaAPPS
ViewAR_MEMO_LINES_VL
PL/SQL PackageAR_XML_VIEW_FUNCTIONS - show dependent code
PL/SQL PackageFA_RX_FLEX_PKG - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
PL/SQL PackageMO_GLOBAL - show dependent code
SynonymMTL_SYSTEM_ITEMS
SynonymOE_SYSTEM_PARAMETERS
PL/SQL PackageOE_SYS_PARAMETERS - show dependent code
SynonymRA_CUSTOMER_TRX_LINES

APPS.AR_XML_INVOICE_LINE_V is not referenced by any database object