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

TABLE: EGO.EGO_MASSUPDATE_ORG_TMP

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


This table holds the Organization 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
ORG_SELECTED_FLAG VARCHAR2 (1)
Indicates whether this organization is selected
ORGANIZATION_ID_PARENT NUMBER

Parent Organization Id
ORGANIZATION_ID_CHILD NUMBER

Organization Id
CHILD_NAME VARCHAR2 (240)
Organization Name
ORGANIZATION_CODE VARCHAR2 (3)
Organization Code
ACCESS_RESTRICTED VARCHAR2 (1)
Indicates whether the user has access to this organization
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
Query Text

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


SELECT USER_ID
,      BATCH_ID
,      ORG_SELECTED_FLAG
,      ORGANIZATION_ID_PARENT
,      ORGANIZATION_ID_CHILD
,      CHILD_NAME
,      ORGANIZATION_CODE
,      ACCESS_RESTRICTED
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM EGO.EGO_MASSUPDATE_ORG_TMP;

Dependencies

[top of page]

EGO.EGO_MASSUPDATE_ORG_TMP does not reference any database object

EGO.EGO_MASSUPDATE_ORG_TMP is referenced by following:

SchemaAPPS
SynonymEGO_MASSUPDATE_ORG_TMP