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]

VIEW: APPS.RRS_SECURED_OBJECTS_V

Object Details

Object Name:	RRS_SECURED_OBJECTS_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view displays Lookup_code , Meaning and Description of all Brand names, Site Status , Site Types, Site Purpose and Hierarchy Purpose on which security can be enabled. These objects can be secured via Role Based Access Control.

[View Source]

Columns

Name	Datatype	Length	Comments
PK_ID	VARCHAR2	(30)	Lookup Code for various types from Lookups ( i.e Brand name , Site Status , Site Type , Site Purpose and Hierarchy Purpose )
PK_NAME	VARCHAR2	(80)	Meaning for various types from Lookups ( i.e Brand name , Site Status , Site Type , Site Purpose and Hierarchy Purpose )
PK_DESC	VARCHAR2	(240)	Description for various types from Lookups ( i.e Brand name , Site Status , Site Type , Site Purpose and Hierarchy Purpose )
PK_TYPE	CHAR	(2)	SB for Brand Name , SS for Site Status , ST for Site Type, SP for Site Purpose and HP for Hierarchy Purpose

Query Text

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


SELECT PK_ID
,      PK_NAME
,      PK_DESC
,      PK_TYPE
FROM APPS.RRS_SECURED_OBJECTS_V;

Dependencies

[top of page]

APPS.RRS_SECURED_OBJECTS_V references the following:

APPS: AR_LOOKUPS; RRS_LOOKUPS_V

APPS.RRS_SECURED_OBJECTS_V is not referenced by any database object