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: RRS.RRS_ATTR_PAGE_SETTINGS

Object Details

Object Name:	RRS_ATTR_PAGE_SETTINGS
Object Type:	TABLE
Owner:	RRS
Subobject Name:
Status:	VALID

This table is used for storing the Attribute Pages in new Hierarchy flash UI. This table stores whether the Attribute Page is for Hierarchy or for Site. It also stores the Hierarchy Purpose or Store Purpose depending on the Categorization Object.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
WHERE_USED	VARCHAR2	(30)	Yes	This column indicates where this Attribute Page is used. For example : 'MAP' or 'HIERARCHY'
OBJECT_TYPE	VARCHAR2	(30)	Yes	This column indicates Object_type for Hierarchy could be 'SITE' or 'HIERARCHY' and for Map it could be 'SITE'
CATEGORIZATION_OBJECT1	VARCHAR2	(30)	Yes	First level object , for Hierarchy it should be 'HIERARCHY' and for Map it should be either 'SITE' or 'LOCATION' or 'TRADEAREA'
CLASSIFICATION_CODE1	VARCHAR2	(30)	Yes	First level identifying code , for Hierarchy it should be Hierarchy purpose. For Map it should be either Site Purpose or Country Code or TAG
CATEGORIZATION_OBJECT2	VARCHAR2	(30)		Second level object for Hierarchy or Site
CLASSIFICATION_CODE2	VARCHAR2	(30)		Second level identifying code such as Site Purpose
ATTRIBUTE_PAGE_ID	NUMBER			Attribute Page identifier from EGO_PAGES_B ( PAGE_ID )
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATED_BY	NUMBER		Yes	Standard WHO Column
CREATION_DATE	DATE		Yes	Standard WHO Column
CREATED_BY	NUMBER		Yes	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER			Standard WHO Column

Query Text

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


SELECT WHERE_USED
,      OBJECT_TYPE
,      CATEGORIZATION_OBJECT1
,      CLASSIFICATION_CODE1
,      CATEGORIZATION_OBJECT2
,      CLASSIFICATION_CODE2
,      ATTRIBUTE_PAGE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM RRS.RRS_ATTR_PAGE_SETTINGS;

Dependencies

[top of page]

RRS.RRS_ATTR_PAGE_SETTINGS does not reference any database object

RRS.RRS_ATTR_PAGE_SETTINGS is referenced by following:

RRS: RRS_ATTR_PAGE_SETTINGS#