DBA Data[Home] [Help] [Dependency Information]


VIEW: HR.PQH_RULE_SETS#

Object Details
Object Name: PQH_RULE_SETS#
Object Type: VIEW
Owner: HR
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
RULE_SET_ID NUMBER (10) Yes
RULE_SET_NAME VARCHAR2 (100) Yes
SHORT_NAME VARCHAR2 (30) Yes
REFERENCED_RULE_SET_ID NUMBER (10)
ORGANIZATION_STRUCTURE_ID NUMBER (15)
ORGANIZATION_ID NUMBER (15)
BUSINESS_GROUP_ID NUMBER (15)
RULE_LEVEL_CD VARCHAR2 (10)
OBJECT_VERSION_NUMBER NUMBER (9) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE

RULE_APPLICABILITY VARCHAR2 (30)
RULE_CATEGORY VARCHAR2 (30)
STARTING_ORGANIZATION_ID NUMBER (15)
SEEDED_RULE_FLAG VARCHAR2 (10)
STATUS VARCHAR2 (10)
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT RULE_SET_ID
,      RULE_SET_NAME
,      SHORT_NAME
,      REFERENCED_RULE_SET_ID
,      ORGANIZATION_STRUCTURE_ID
,      ORGANIZATION_ID
,      BUSINESS_GROUP_ID
,      RULE_LEVEL_CD
,      OBJECT_VERSION_NUMBER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      RULE_APPLICABILITY
,      RULE_CATEGORY
,      STARTING_ORGANIZATION_ID
,      SEEDED_RULE_FLAG
,      STATUS
,      ZD_EDITION_NAME
FROM HR.PQH_RULE_SETS#;

Dependencies

[top of page]

HR.PQH_RULE_SETS# references the following:

SchemaHR
TablePQH_RULE_SETS
HR.PQH_RULE_SETS# is referenced by following:

SchemaAPPS
SynonymPQH_RULE_SETS
TriggerPQH_RULE_SETS+
TriggerPQH_RULE_SETS_WHO