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

TABLE: EGO.EGO_PAGES_INTERFACE

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

EGO_PAGES_INTERFACE temporarily stores the definitions for
Item Catalog Category Pages 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
DISPLAY_NAME VARCHAR2 (240)
Page display name
INTERNAL_NAME VARCHAR2 (150)
Internal name identifier for the page
DESCRIPTION VARCHAR2 (240)
Description
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.
DATA_LEVEL VARCHAR2 (30)
Lookup indicating the level of granularity at which the Page is to be associated to the Object. Eg. ITEM_LEVEL
SEQUENCE NUMBER

Display sequence for the pages
TRANSACTION_ID NUMBER

Row identifier
PROCESS_STATUS NUMBER

Row Status
TRANSACTION_TYPE VARCHAR2 (10)
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
CREATED_BY NUMBER

standard "WHO" column.
CREATION_DATE DATE

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
,      DISPLAY_NAME
,      INTERNAL_NAME
,      DESCRIPTION
,      CLASSIFICATION_CODE
,      CLASSIFICATION_NAME
,      DATA_LEVEL
,      SEQUENCE
,      TRANSACTION_ID
,      PROCESS_STATUS
,      TRANSACTION_TYPE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM EGO.EGO_PAGES_INTERFACE;

Dependencies

[top of page]

EGO.EGO_PAGES_INTERFACE does not reference any database object

EGO.EGO_PAGES_INTERFACE is referenced by following:

SchemaEGO
ViewEGO_PAGES_INTERFACE#