eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:	EGO.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:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	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:

EGO: EGO_PAGE_ENTRIES_INTERFACE#