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

TABLE: ENG.ENG_AUTO_NUMBER_ECN

Object Details
Object Name: ENG_AUTO_NUMBER_ECN
Object Type: TABLE
Owner: ENG
FND Design Data: TableENG.ENG_AUTO_NUMBER_ECN
Subobject Name:
Status: VALID


ENG_AUTO_NUMBER_ECN stores prefixes used for autonumbering engineering
change orders. This table stores the prefix, the next available
number, and possibly an organization id and a user id. Prefixes can
be defined at 4 levels:
.
- A specific user, for a specific organization
(both USER_ID and ORGANIZATION_ID are filled in)
- A specific user, across all organizations
(USER_ID is filled in, ORGANIZATION_ID is null)
- A specific organization, across all users
(USER_ID is null, ORGANIZATION_ID filled in)
- Across all users and all organizations
(USER_ID is null, ORGANIZATION_ID is null)
.
When defining an engineering change order, the user can choose to use
the autonumber functionality to fill in the ECO number. The
appropriate prefix concatenated with the next available number becomes
the ECO number.
.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ENG_AUTO_NUMBER_ECN_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnUSER_ID
ColumnORGANIZATION_ID
ENG_AUTO_NUMBER_ECN_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnAUTO_NUMBER_ECN_ID
ENG_AUTO_NUMBER_ECN_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnCHANGE_TYPE_ID
Columns
Name Datatype Length Mandatory Comments
USER_ID VARCHAR2 (22)
User identifier
ORGANIZATION_ID NUMBER

Organization identifier
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
ALPHA_PREFIX VARCHAR2 (9)
Autonumbering prefix
NEXT_AVAILABLE_NUMBER NUMBER

Next available number
REQUEST_ID NUMBER

Concurrent Who column
PROGRAM_APPLICATION_ID NUMBER

Concurrent Who column
PROGRAM_ID NUMBER

Concurrent Who column
PROGRAM_UPDATE_DATE DATE

Concurrent Who column
AUTO_NUMBER_ECN_ID NUMBER

Auto Number Ecn Id
CHANGE_TYPE_ID NUMBER

Change Type Id
ACTION_ID NUMBER

Action Id to identify APC Ext Fwk Action for Number Generation
Query Text

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


SELECT USER_ID
,      ORGANIZATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ALPHA_PREFIX
,      NEXT_AVAILABLE_NUMBER
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      AUTO_NUMBER_ECN_ID
,      CHANGE_TYPE_ID
,      ACTION_ID
FROM ENG.ENG_AUTO_NUMBER_ECN;

Dependencies

[top of page]

ENG.ENG_AUTO_NUMBER_ECN does not reference any database object

ENG.ENG_AUTO_NUMBER_ECN is referenced by following:

SchemaAPPS
SynonymENG_AUTO_NUMBER_ECN