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

VIEW: AMS.AMS_IBA_PS_RULES#

Object Details
Object Name: AMS_IBA_PS_RULES#
Object Type: VIEW
Owner: AMS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
SECURITY_GROUP_ID NUMBER (15)
OBJECT_VERSION_NUMBER NUMBER

RULE_ID NUMBER
Yes
RULEGROUP_ID NUMBER (15) Yes
POSTING_ID NUMBER
Yes
STRATEGY_ID NUMBER

EXEC_PRIORITY NUMBER

BUS_PRIORITY_CODE VARCHAR2 (30)
BUS_PRIORITY_DISP_ORDER VARCHAR2 (30)
CLAUSEVALUE1 VARCHAR2 (30)
CLAUSEVALUE2 NUMBER (15)
CLAUSEVALUE3 VARCHAR2 (30)
CLAUSEVALUE4 VARCHAR2 (30)
CLAUSEVALUE5 NUMBER (15)
CLAUSEVALUE6 VARCHAR2 (30)
USE_CLAUSE6 VARCHAR2 (1)
CLAUSEVALUE7 VARCHAR2 (30)
USE_CLAUSE7 VARCHAR2 (1)
CLAUSEVALUE8 VARCHAR2 (30)
USE_CLAUSE8 VARCHAR2 (1)
CLAUSEVALUE9 VARCHAR2 (30)
USE_CLAUSE9 VARCHAR2 (1)
CLAUSEVALUE10 VARCHAR2 (30)
USE_CLAUSE10 VARCHAR2 (1)
Query Text

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


SELECT CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
,      RULE_ID
,      RULEGROUP_ID
,      POSTING_ID
,      STRATEGY_ID
,      EXEC_PRIORITY
,      BUS_PRIORITY_CODE
,      BUS_PRIORITY_DISP_ORDER
,      CLAUSEVALUE1
,      CLAUSEVALUE2
,      CLAUSEVALUE3
,      CLAUSEVALUE4
,      CLAUSEVALUE5
,      CLAUSEVALUE6
,      USE_CLAUSE6
,      CLAUSEVALUE7
,      USE_CLAUSE7
,      CLAUSEVALUE8
,      USE_CLAUSE8
,      CLAUSEVALUE9
,      USE_CLAUSE9
,      CLAUSEVALUE10
,      USE_CLAUSE10
FROM AMS.AMS_IBA_PS_RULES#;

Dependencies

[top of page]

AMS.AMS_IBA_PS_RULES# references the following:

SchemaAMS
TableAMS_IBA_PS_RULES
AMS.AMS_IBA_PS_RULES# is referenced by following:

SchemaAPPS
SynonymAMS_IBA_PS_RULES