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.ZPB_SECURITY_RULE_DEFINITION_V

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
RULE_NAME	VARCHAR2	(80)	Yes
RULE_TYPE	VARCHAR2	(32)	Yes
SEQUENCE_ID	NUMBER		Yes
SELECTION_TYPE	VARCHAR2	(32)
ACTION	VARCHAR2	(32)
OPERATOR	VARCHAR2	(16)
BUSINESS_AREA	NUMBER
USER_ID	NUMBER		Yes
DIMENSION_ID	NUMBER
HIERARCHY_ID	NUMBER
LEVEL_ID	NUMBER
ATTRIBUTE_ID	NUMBER
MEMBER_ID	VARCHAR2	(64)
ADMIN_USER_NAME	VARCHAR2	(100)
LAST_APPLY_DATE	DATE
STATUS	VARCHAR2	(16)
ERROR	VARCHAR2	(256)
SELECTION_NAME	VARCHAR2	(80)
INCLUDE_VALUE	NUMBER	(1)

Query Text

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


SELECT RULE_NAME
,      RULE_TYPE
,      SEQUENCE_ID
,      SELECTION_TYPE
,      ACTION
,      OPERATOR
,      BUSINESS_AREA
,      USER_ID
,      DIMENSION_ID
,      HIERARCHY_ID
,      LEVEL_ID
,      ATTRIBUTE_ID
,      MEMBER_ID
,      ADMIN_USER_NAME
,      LAST_APPLY_DATE
,      STATUS
,      ERROR
,      SELECTION_NAME
,      INCLUDE_VALUE
FROM APPS.ZPB_SECURITY_RULE_DEFINITION_V;

Dependencies

[top of page]

APPS.ZPB_SECURITY_RULE_DEFINITION_V references the following:

APPS: ZPB_SECURITY_RULE_DEFINITION_T

APPS.ZPB_SECURITY_RULE_DEFINITION_V is not referenced by any database object