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

VIEW: APPS.RA_CUST_TRX_LINE_V

Object Details
Object Name: RA_CUST_TRX_LINE_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGMF.RA_CUST_TRX_LINE_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


Customer transaction line view


[View Source]

Columns
Name Datatype Length Mandatory Comments
CUSTOMER_TRX_ID NUMBER (15) Yes Customer Trx Id
TRX_NUMBER VARCHAR2 (20) Yes Trx Number
TRX_DATE DATE

Trx Date
INVOICE_TYPE VARCHAR2 (20)
Invoice Type
UNIT_OF_MEASURE VARCHAR2 (25)
Unit Of Measure
QUANTITY_CREDITED NUMBER

Quantity Credited
QUANTITY_INVOICED NUMBER

Quantity Invoiced
INVENTORY_ITEM_ID NUMBER (15)
Inventory Item Id
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield
Query Text

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


SELECT CUSTOMER_TRX_ID
,      TRX_NUMBER
,      TRX_DATE
,      INVOICE_TYPE
,      UNIT_OF_MEASURE
,      QUANTITY_CREDITED
,      QUANTITY_INVOICED
,      INVENTORY_ITEM_ID
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE1
,      ATTRIBUTE5
,      ATTRIBUTE15
FROM APPS.RA_CUST_TRX_LINE_V;

Dependencies

[top of page]

APPS.RA_CUST_TRX_LINE_V references the following:

SchemaAPPS
SynonymMTL_SYSTEM_ITEMS
SynonymMTL_UNITS_OF_MEASURE
SynonymRA_CUSTOMER_TRX_ALL
SynonymRA_CUSTOMER_TRX_LINES_ALL
SynonymRA_CUST_TRX_LINE_GL_DIST_ALL
SynonymRA_CUST_TRX_TYPES_ALL
SynonymSY_UOMS_MST

APPS.RA_CUST_TRX_LINE_V is not referenced by any database object