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: ZPB.ZPB_SECURITY_RULE_DEFINITION_T

Object Details

Object Name:	ZPB_SECURITY_RULE_DEFINITION_T
Object Type:	TABLE
Owner:	ZPB
Subobject Name:
Status:	VALID

This table stores user-defined security rule definitions that will be read by the security maintenance batch procedure.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ZPB_SECURITY_RULE_DEF_U1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RULE_NAME RULE_TYPE SEQUENCE USER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
RULE_NAME	VARCHAR2	(80)	Yes	Rule name
RULE_TYPE	VARCHAR2	(32)	Yes	Rule type
SEQUENCE	NUMBER		Yes	Rule step sequence number
SELECTION_TYPE	VARCHAR2	(32)		Rule step selection type
ACTION	VARCHAR2	(32)		Rule step selection action
OPERATOR	VARCHAR2	(16)		Rule step operator
BUSINESS_AREA	NUMBER			Business area identifier
USER_ID	NUMBER		Yes	User identifier
DIMENSION_ID	NUMBER			Dimension identifier
HIERARCHY_ID	NUMBER			Hierarchy identifier
LEVEL_ID	NUMBER			Level identifier
ATTRIBUTE_ID	NUMBER			Attribute identifier
MEMBER_ID	VARCHAR2	(64)		Member identifier
ADMIN_USER_NAME	VARCHAR2	(100)		Admin user
LAST_APPLY_DATE	DATE			Last application date
STATUS	VARCHAR2	(16)		Rule step status
ERROR	VARCHAR2	(256)		Rule step error message
SELECTION_NAME	VARCHAR2	(80)		Rule step selection name
INCLUDE_VALUE	NUMBER	(1)		Include value flag for metadata rule steps
ATTR_DIMENSION_ID	NUMBER

Query Text

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


SELECT RULE_NAME
,      RULE_TYPE
,      SEQUENCE
,      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
,      ATTR_DIMENSION_ID
FROM ZPB.ZPB_SECURITY_RULE_DEFINITION_T;

Dependencies

[top of page]

ZPB.ZPB_SECURITY_RULE_DEFINITION_T does not reference any database object

ZPB.ZPB_SECURITY_RULE_DEFINITION_T is referenced by following:

APPS: ZPB_SECURITY_RULE_DEFINITION_T