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: OKS.OKS_RULE_ERROR#

Object Details

Object Name:	OKS_RULE_ERROR#
Object Type:	VIEW
Owner:	OKS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
ROW_NUM	NUMBER
ID	NUMBER
RGP_ID	NUMBER
CHR_ID	NUMBER
CLE_ID	NUMBER
CONTRACT_NUMBER	VARCHAR2	(120)
CONTRACT_NUMBER_MODIFIER	VARCHAR2	(120)
MAJOR_VERSION	NUMBER
LINE_NUMBER	VARCHAR2	(150)
SCRIPT_NAME	VARCHAR2	(10)
PROCESS	VARCHAR2	(1)
FLAG	VARCHAR2	(1)
RULE_INFORMATION_CATEGORY	VARCHAR2	(5)
COLUMN_NAME	VARCHAR2	(100)
ATTRIBUTE_NAME	VARCHAR2	(100)
ATTRIBUTE_VALUE	VARCHAR2	(450)
NEW_VALUE	NUMBER
ERROR_MSG	VARCHAR2	(2000)
CC_EXPIRY_DATE	DATE
ALLOW_UPDATE_FLAG	VARCHAR2	(3)

Query Text

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


SELECT ROW_NUM
,      ID
,      RGP_ID
,      CHR_ID
,      CLE_ID
,      CONTRACT_NUMBER
,      CONTRACT_NUMBER_MODIFIER
,      MAJOR_VERSION
,      LINE_NUMBER
,      SCRIPT_NAME
,      PROCESS
,      FLAG
,      RULE_INFORMATION_CATEGORY
,      COLUMN_NAME
,      ATTRIBUTE_NAME
,      ATTRIBUTE_VALUE
,      NEW_VALUE
,      ERROR_MSG
,      CC_EXPIRY_DATE
,      ALLOW_UPDATE_FLAG
FROM OKS.OKS_RULE_ERROR#;

Dependencies

[top of page]

OKS.OKS_RULE_ERROR# references the following:

OKS: OKS_RULE_ERROR

OKS.OKS_RULE_ERROR# is referenced by following:

APPS: OKS_RULE_ERROR