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


TABLE: EGO.EGO_GTIN_SETUP

Object Details
Object Name: EGO_GTIN_SETUP
Object Type: TABLE
Owner: EGO
FND Design Data: TableEGO.EGO_GTIN_SETUP
Subobject Name:
Status: VALID


This table stores the GTIN generation method.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
EGO_GTIN_SETUP_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnCUSTOMER_ID
Columns
Name Datatype Length Mandatory Comments
GTIN_NUM_GEN_METHOD VARCHAR2 (30) Yes GTIN generation method
CREATED_BY NUMBER
Yes User id of Person who created record
CREATION_DATE DATE
Yes Date record was created
LAST_UPDATED_BY NUMBER
Yes User id of last person modifying the record
LAST_UPDATE_DATE DATE
Yes Date record was last modified
LAST_UPDATE_LOGIN NUMBER

Login of last person who updated record
CUSTOMER_ID NUMBER

Foreign key to HZ_PARTIES
GTIN_NUM_ACTION_ID NUMBER

Unique identifier to action associated
Query Text

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


SELECT GTIN_NUM_GEN_METHOD
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CUSTOMER_ID
,      GTIN_NUM_ACTION_ID
FROM EGO.EGO_GTIN_SETUP;

Dependencies

[top of page]

EGO.EGO_GTIN_SETUP does not reference any database object

EGO.EGO_GTIN_SETUP is referenced by following:

SchemaAPPS
SynonymEGO_GTIN_SETUP