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


TABLE: EGO.EGO_PAGE_ENTRIES_INTERFACE

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

EGO_PAGES_ENTRIES_INTERFACE temporarily stores the definitions for
Item Catalog Category Page Entries before loading this information into
Oracle Advanced Product Catalog.
This table contains user friendly columns which allow you to easily
enter your data as well as their corresponding foreign keys. Oracle
Advanced Product Catalog will default column values you do not enter, after
performing the proper validation. For example, you enter the
INTERNAL_NAME, and Oracle Advanced Product Catalog will fill in the corresponding
PAGE_ID for you.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
SET_PROCESS_ID NUMBER

Unique identifier for the subset of data. Each of the lines that are newly uploaded in the interface table, need to be given a unique ID, that will be used during the Concurrent program request submission. It is suggested to retrieve the values from EGO_IPI_DATASET_ID_S.
PAGE_ID NUMBER

Sequence Generated unique id
INTERNAL_NAME VARCHAR2 (150)
Page display name
OLD_ASSOCIATION_ID NUMBER

Internal name identifier for the page
NEW_ASSOCIATION_ID NUMBER

Description
OLD_ATTR_GROUP_ID NUMBER

Classification Code for the objects. Example - Item Catalog Group ID
NEW_ATTR_GROUP_ID NUMBER

Concatenated classification name for the object. Eg. Concatenated Item Catalog Category.
OLD_ATTR_GROUP_NAME VARCHAR2 (30)
Lookup indicating the level of granularity at which the Page is to be associated to the Object. Eg. ITEM_LEVEL
NEW_ATTR_GROUP_NAME VARCHAR2 (30)
Display sequence for the pages
SEQUENCE NUMBER

Row identifier
CLASSIFICATION_CODE VARCHAR2 (150)
Classification Code for the objects. Example - Item Catalog Group ID
CLASSIFICATION_NAME VARCHAR2 (700)
Concatenated classification name for the object. Eg. Concatenated Item Catalog Category.
TRANSACTION_ID NUMBER

Concurrent WHO Columns
PROCESS_STATUS NUMBER

Row Status
TRANSACTION_TYPE VARCHAR2 (10)
Transaction Type
REQUEST_ID NUMBER

Concurrent WHO Columns
PROGRAM_APPLICATION_ID NUMBER

Concurrent WHO Columns
PROGRAM_ID NUMBER

Concurrent WHO Columns
PROGRAM_UPDATE_DATE DATE

Concurrent WHO Columns
CREATION_DATE DATE

standard "WHO" column.
CREATED_BY NUMBER

standard "WHO" column.
LAST_UPDATED_BY NUMBER

standard "WHO" column.
LAST_UPDATE_DATE DATE

standard "WHO" column.
LAST_UPDATE_LOGIN NUMBER

standard "WHO" column.
Query Text

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


SELECT SET_PROCESS_ID
,      PAGE_ID
,      INTERNAL_NAME
,      OLD_ASSOCIATION_ID
,      NEW_ASSOCIATION_ID
,      OLD_ATTR_GROUP_ID
,      NEW_ATTR_GROUP_ID
,      OLD_ATTR_GROUP_NAME
,      NEW_ATTR_GROUP_NAME
,      SEQUENCE
,      CLASSIFICATION_CODE
,      CLASSIFICATION_NAME
,      TRANSACTION_ID
,      PROCESS_STATUS
,      TRANSACTION_TYPE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM EGO.EGO_PAGE_ENTRIES_INTERFACE;

Dependencies

[top of page]

EGO.EGO_PAGE_ENTRIES_INTERFACE does not reference any database object

EGO.EGO_PAGE_ENTRIES_INTERFACE is referenced by following:

SchemaEGO
ViewEGO_PAGE_ENTRIES_INTERFACE#