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

TABLE: AX.AX_SECONDARY_INVENTORY

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


This table stores numeric identifiers for Inventory suborganizations.
It contains a row for every Inventory suborganization.
Each row contains the suborganization name and the numeric
identifier. Numeric identifiers are used to make the Inventory suborganization
identifiers consistent with those of Payables and Receivables suborganizations.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: AX_SECONDARY_INVENTORY_PK
  1. ColumnSECONDARY_INVENTORY_ID
Indexes
Index Type Uniqueness Tablespace Column
AX_SECONDARY_INVENTORY_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSECONDARY_INVENTORY_ID
Columns
Name Datatype Length Mandatory Comments
SECONDARY_INVENTORY_ID NUMBER (15) Yes Secondary inventory identifier
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
ORGANIZATION_ID NUMBER (15) Yes Inventory organization identifier
SECONDARY_INVENTORY_NAME VARCHAR2 (10) Yes Secondary inventory name
Query Text

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


SELECT SECONDARY_INVENTORY_ID
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      ORGANIZATION_ID
,      SECONDARY_INVENTORY_NAME
FROM AX.AX_SECONDARY_INVENTORY;

Dependencies

[top of page]

AX.AX_SECONDARY_INVENTORY does not reference any database object

AX.AX_SECONDARY_INVENTORY is referenced by following:

SchemaAPPS
SynonymAX_SECONDARY_INVENTORY