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

TABLE: JA.JAI_INV_SUBINV_DTLS

Object Details
Object Name: JAI_INV_SUBINV_DTLS
Object Type: TABLE
Owner: JA
FND Design Data: TableJA.JAI_INV_SUBINV_DTLS
Subobject Name:
Status: VALID


Stores information of sub inventories belonging to an organization and location.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JAI_INV_SUBINV_DTLS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
ColumnLOCATION_ID
ColumnSUB_INVENTORY_NAME
Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER (15) Yes Indicates the Inventory Organization from where the shipment is done.
LOCATION_ID NUMBER (15) Yes Indicates the location identifier.
SUB_INVENTORY_NAME VARCHAR2 (10) Yes Indicates the Sub inventory name.
BONDED VARCHAR2 (2)
Indicates whether the sub inventory is bonded.
CREATED_BY NUMBER (15)
Standard Who column
CREATION_DATE DATE

Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
TRADING VARCHAR2 (2)
Indicates whether this sub inventory is a Trading Sub inventory.
OBJECT_VERSION_NUMBER NUMBER

Object version number
Query Text

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


SELECT ORGANIZATION_ID
,      LOCATION_ID
,      SUB_INVENTORY_NAME
,      BONDED
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      TRADING
,      OBJECT_VERSION_NUMBER
FROM JA.JAI_INV_SUBINV_DTLS;

Dependencies

[top of page]

JA.JAI_INV_SUBINV_DTLS does not reference any database object

JA.JAI_INV_SUBINV_DTLS is referenced by following:

SchemaJA
ViewJAI_INV_SUBINV_DTLS#