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

TABLE: EGO.EGO_MASSUPDATE_ITEM_TMP

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


This table holds the Item data for Mass Update flows


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
USER_ID NUMBER
Yes User Id
BATCH_ID NUMBER
Yes Batch Id
INVENTORY_ITEM_ID NUMBER

Inventory item identifier.Foreign key to MTL_SYSTEM_ITEMS_B
ORGANIZATION_ID NUMBER

Organization identifier.Foreign key to MTL_SYSTEM_ITEMS_B
ITEM_CATALOG_GROUP_ID NUMBER

Item catalog group identifier.Foreign key to MTL_ITEM_CATALOG_GROUPS_B
REVISION_ID NUMBER

Item Revision Id.Foreign key to MTL_ITEM_REVISIONS_B
CATEGORY_ID NUMBER

Id of the Catalog Category to which Item is assigned
SELECTED_FLAG VARCHAR2 (1)
Item selected flag
ORGANIZATION_CODE VARCHAR2 (3)
Organization Code
REVISION_CODE VARCHAR2 (3)
Revision Code
REVISION_LABEL VARCHAR2 (80)
Revision Label
CATEGORY_NAME VARCHAR2 (250)
Name of the Catalog Category to which Item is assigned
ITEM_NUMBER VARCHAR2 (250)
Item Number
DESCRIPTION VARCHAR2 (250)
Item Description
LAST_UPDATE_DATE DATE

Date record was last modified
LAST_UPDATED_BY NUMBER

User id of last person modifying the record
CREATION_DATE DATE

Date record was created
CREATED_BY NUMBER

User id of Person who created record
LAST_UPDATE_LOGIN NUMBER

Login of last person who updated record
C_ATTR_1 VARCHAR2 (250)
varchar column
C_ATTR_2 VARCHAR2 (250)
varchar column
C_ATTR_3 VARCHAR2 (250)
varchar column
C_ATTR_4 VARCHAR2 (250)
varchar column
C_ATTR_5 VARCHAR2 (250)
varchar column
C_ATTR_6 VARCHAR2 (250)
varchar column
C_ATTR_7 VARCHAR2 (250)
varchar column
C_ATTR_8 VARCHAR2 (250)
varchar column
C_ATTR_9 VARCHAR2 (250)
varchar column
C_ATTR_10 VARCHAR2 (250)
varchar column
C_ATTR_11 VARCHAR2 (250)
varchar column
C_ATTR_12 VARCHAR2 (250)
varchar column
C_ATTR_13 VARCHAR2 (250)
varchar column
C_ATTR_14 VARCHAR2 (250)
varchar column
C_ATTR_15 VARCHAR2 (250)
varchar column
C_ATTR_16 VARCHAR2 (250)
varchar column
C_ATTR_17 VARCHAR2 (250)
varchar column
C_ATTR_18 VARCHAR2 (250)
varchar column
C_ATTR_19 VARCHAR2 (250)
varchar column
C_ATTR_20 VARCHAR2 (250)
varchar column
C_ATTR_21 VARCHAR2 (250)
varchar column
C_ATTR_22 VARCHAR2 (250)
varchar column
C_ATTR_23 VARCHAR2 (250)
varchar column
C_ATTR_24 VARCHAR2 (250)
varchar column
C_ATTR_25 VARCHAR2 (250)
varchar column
C_ATTR_26 VARCHAR2 (250)
varchar column
C_ATTR_27 VARCHAR2 (250)
varchar column
C_ATTR_28 VARCHAR2 (250)
varchar column
C_ATTR_29 VARCHAR2 (250)
varchar column
C_ATTR_30 VARCHAR2 (250)
varchar column
C_ATTR_31 VARCHAR2 (250)
varchar column
C_ATTR_32 VARCHAR2 (250)
varchar column
C_ATTR_33 VARCHAR2 (250)
varchar column
C_ATTR_34 VARCHAR2 (250)
varchar column
C_ATTR_35 VARCHAR2 (250)
varchar column
C_ATTR_36 VARCHAR2 (250)
varchar column
C_ATTR_37 VARCHAR2 (250)
varchar column
C_ATTR_38 VARCHAR2 (250)
varchar column
C_ATTR_39 VARCHAR2 (250)
varchar column
C_ATTR_40 VARCHAR2 (250)
varchar column
STYLE_ITEM_ID NUMBER

Style Item Id
SUPPLIER_ID NUMBER

Supplier Id
SUPPLIER_NAME VARCHAR2 (240)
Supplier Name
SUPPLIER_SITE VARCHAR2 (150)
Supplier Site Name
SUPPLIER_SITE_ID NUMBER

Supplier Site Id
Query Text

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


SELECT USER_ID
,      BATCH_ID
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      ITEM_CATALOG_GROUP_ID
,      REVISION_ID
,      CATEGORY_ID
,      SELECTED_FLAG
,      ORGANIZATION_CODE
,      REVISION_CODE
,      REVISION_LABEL
,      CATEGORY_NAME
,      ITEM_NUMBER
,      DESCRIPTION
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      C_ATTR_1
,      C_ATTR_2
,      C_ATTR_3
,      C_ATTR_4
,      C_ATTR_5
,      C_ATTR_6
,      C_ATTR_7
,      C_ATTR_8
,      C_ATTR_9
,      C_ATTR_10
,      C_ATTR_11
,      C_ATTR_12
,      C_ATTR_13
,      C_ATTR_14
,      C_ATTR_15
,      C_ATTR_16
,      C_ATTR_17
,      C_ATTR_18
,      C_ATTR_19
,      C_ATTR_20
,      C_ATTR_21
,      C_ATTR_22
,      C_ATTR_23
,      C_ATTR_24
,      C_ATTR_25
,      C_ATTR_26
,      C_ATTR_27
,      C_ATTR_28
,      C_ATTR_29
,      C_ATTR_30
,      C_ATTR_31
,      C_ATTR_32
,      C_ATTR_33
,      C_ATTR_34
,      C_ATTR_35
,      C_ATTR_36
,      C_ATTR_37
,      C_ATTR_38
,      C_ATTR_39
,      C_ATTR_40
,      STYLE_ITEM_ID
,      SUPPLIER_ID
,      SUPPLIER_NAME
,      SUPPLIER_SITE
,      SUPPLIER_SITE_ID
FROM EGO.EGO_MASSUPDATE_ITEM_TMP;

Dependencies

[top of page]

EGO.EGO_MASSUPDATE_ITEM_TMP does not reference any database object

EGO.EGO_MASSUPDATE_ITEM_TMP is referenced by following:

SchemaEGO
ViewEGO_MASSUPDATE_ITEM_TMP#