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

TABLE: AR.AR_LINE_REV_ADJ_GT

Object Details
Object Name: AR_LINE_REV_ADJ_GT
Object Type: TABLE
Owner: AR
Subobject Name:
Status: VALID


The AR_LINE_REV_ADJ_GT table is used by Revenue Accounting to track revenue adjustment amounts at the line level.


Temporary Table Details

AR.AR_LINE_REV_ADJ_GT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Columns
Name Datatype Length Mandatory Comments
CUSTOMER_TRX_ID NUMBER

Invoice Identifier
CUSTOMER_TRX_LINE_ID NUMBER

Invoice Line Identifier
REVENUE_ADJUSTMENT_ID NUMBER

Revenue Adjustment ID
AMOUNT NUMBER

Amount
PERCENT NUMBER

Percent
Query Text

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


SELECT CUSTOMER_TRX_ID
,      CUSTOMER_TRX_LINE_ID
,      REVENUE_ADJUSTMENT_ID
,      AMOUNT
,      PERCENT
FROM AR.AR_LINE_REV_ADJ_GT;

Dependencies

[top of page]

AR.AR_LINE_REV_ADJ_GT does not reference any database object

AR.AR_LINE_REV_ADJ_GT is referenced by following:

SchemaAPPS
SynonymAR_LINE_REV_ADJ_GT