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

TABLE: AX.AX_VARIANCE_STATUSES

Object Details
Object Name: AX_VARIANCE_STATUSES
Object Type: TABLE
Owner: AX
FND Design Data: TableAX.AX_VARIANCE_STATUSES
Subobject Name:
Status: VALID


This table stores the absorption information. It contains a row for
each Inventory organization, accounting period, and variance type.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: AX_VARIANCE_STATUSES_PK
  1. ColumnORGANIZATION_ID
  2. ColumnACCOUNTING_PERIOD_ID
  3. ColumnVARIANCE_TYPE
Indexes
Index Type Uniqueness Tablespace Column
AX_VARIANCE_STATUSES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
ColumnACCOUNTING_PERIOD_ID
ColumnVARIANCE_TYPE
Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER
Yes Inventory organization identifier
ACCOUNTING_PERIOD_ID NUMBER
Yes Accounting period identifier
VARIANCE_TYPE NUMBER
Yes Variance type (1 - PPV, 2 - IPV, 3 - EPV)
LAST_UPDATE_DATE DATE

Standard Who column
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER

Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
ABSORBTION_FLAG NUMBER

To be absorbed flag
ABSORBTION_DATE DATE

Beginning date of the absorption period
PERIOD_YEAR NUMBER

Period year
Query Text

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


SELECT ORGANIZATION_ID
,      ACCOUNTING_PERIOD_ID
,      VARIANCE_TYPE
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ABSORBTION_FLAG
,      ABSORBTION_DATE
,      PERIOD_YEAR
FROM AX.AX_VARIANCE_STATUSES;

Dependencies

[top of page]

AX.AX_VARIANCE_STATUSES does not reference any database object

AX.AX_VARIANCE_STATUSES is referenced by following:

SchemaAPPS
SynonymAX_VARIANCE_STATUSES