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

VIEW: APPS.ARBV_REVENUES

Object Details
Object Name: ARBV_REVENUES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAR.ARBV_REVENUES
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
TRANSACTION_LINE_ID NUMBER (15) Yes
AMOUNT NUMBER
Yes
_LA:REASON CHAR (55)
ITEM_DESCRIPTION VARCHAR2 (240)
QUANTITY_ORDERED NUMBER

QUANTITY_INVOICED NUMBER

UNIT_PRICE NUMBER

SALES_ORDER_NUMBER VARCHAR2 (50)
SALES_ORDER_LINE VARCHAR2 (30)
SALES_ORDER_DATE DATE

ACCOUNTING_RULE_DURATION NUMBER (15)
CUSTOMER_TRX_ID NUMBER (15) Yes
PREVIOUS_CUSTOMER_TRX_ID NUMBER (15)
PREVIOUS_CUSTOMER_TRX_LINE_ID NUMBER (15)
INITIAL_CUSTOMER_TRX_LINE_ID NUMBER (15)
INVENTORY_ITEM_ID NUMBER (15)
MEMO_LINE_ID NUMBER (15)
UOM_CODE VARCHAR2 (3)
ACCOUNTING_RULE_ID NUMBER (15)
ORG_ID NUMBER (15)
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
Query Text

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


SELECT TRANSACTION_LINE_ID
,      AMOUNT
,      _LA:REASON
,      ITEM_DESCRIPTION
,      QUANTITY_ORDERED
,      QUANTITY_INVOICED
,      UNIT_PRICE
,      SALES_ORDER_NUMBER
,      SALES_ORDER_LINE
,      SALES_ORDER_DATE
,      ACCOUNTING_RULE_DURATION
,      CUSTOMER_TRX_ID
,      PREVIOUS_CUSTOMER_TRX_ID
,      PREVIOUS_CUSTOMER_TRX_LINE_ID
,      INITIAL_CUSTOMER_TRX_LINE_ID
,      INVENTORY_ITEM_ID
,      MEMO_LINE_ID
,      UOM_CODE
,      ACCOUNTING_RULE_ID
,      ORG_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
FROM APPS.ARBV_REVENUES;

Dependencies

[top of page]

APPS.ARBV_REVENUES references the following:

SchemaAPPS
SynonymRA_CUSTOMER_TRX_LINES

APPS.ARBV_REVENUES is not referenced by any database object