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

TABLE: OPI.OPI_EDW_OPMINV_DAILY_STAT_INC

Object Details
Object Name: OPI_EDW_OPMINV_DAILY_STAT_INC
Object Type: TABLE
Owner: OPI
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.

Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
PRIMARY_KEY VARCHAR2 (4)
Company Code
PRIMARY_KEY1 VARCHAR2 (4)
Organization Code
PRIMARY_KEY2 VARCHAR2 (4)
Warehouse Code
PRIMARY_KEY3 VARCHAR2 (16)
Location
PRIMARY_KEY4 NUMBER

Item Id
PRIMARY_KEY5 NUMBER

Lot Id
PRIMARY_KEY6 DATE

Transaction Date
SEQ_ID NUMBER

Incremental Sequence Id
VIEW_ID NUMBER

Represents View Type
Query Text

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


SELECT PRIMARY_KEY
,      PRIMARY_KEY1
,      PRIMARY_KEY2
,      PRIMARY_KEY3
,      PRIMARY_KEY4
,      PRIMARY_KEY5
,      PRIMARY_KEY6
,      SEQ_ID
,      VIEW_ID
FROM OPI.OPI_EDW_OPMINV_DAILY_STAT_INC;

Dependencies

[top of page]

OPI.OPI_EDW_OPMINV_DAILY_STAT_INC does not reference any database object

OPI.OPI_EDW_OPMINV_DAILY_STAT_INC is referenced by following:

SchemaAPPS
SynonymOPI_EDW_OPMINV_DAILY_STAT_INC