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

MATERIALIZED VIEW: APPS.CN_SCA_RULE_COND_VALS_MV

Object Details
Object Name: CN_SCA_RULE_COND_VALS_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: CN_SCA_RULE_COND_VALS_MV
Updatable: N
Rewrite Enabled: N
Rewrite Capability: GENERAL
Refresh Mode: DEMAND
Refresh Method: FORCE
Build Mode: DEFERRED
Fast Refreshable: DIRLOAD_DML
MV Log Dependencies:

CN_SCA_CONDITIONS_ALL
CN_SCA_COND_DETAILS_ALL
CN_SCA_DENORM_RULES_ALL

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
RULE_ROWID ROWID (10)
COND_ROWID ROWID (10)
COND_DETAIL_ROWID ROWID (10)
SCA_CREDIT_RULE_ID NUMBER (15) Yes
CALCULATED_RANK NUMBER

ANCESTOR_RULE_ID NUMBER (15)
START_DATE DATE
Yes
END_DATE DATE

TRANSACTION_SOURCE VARCHAR2 (30) Yes
SCA_CONDITION_ID NUMBER (15) Yes
SCA_RULE_ATTRIBUTE_ID NUMBER (15) Yes
SCA_COND_DETAIL_ID NUMBER (15) Yes
OPERATOR_ID VARCHAR2 (30) Yes
VALUE_CHAR_MIN VARCHAR2 (240)
VALUE_CHAR_MAX VARCHAR2 (240)
VALUE_NUM_MIN NUMBER

VALUE_NUM_MAX NUMBER

VALUE_DATE_MIN DATE

VALUE_DATE_MAX DATE

Query Text

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


SELECT RULE_ROWID
,      COND_ROWID
,      COND_DETAIL_ROWID
,      SCA_CREDIT_RULE_ID
,      CALCULATED_RANK
,      ANCESTOR_RULE_ID
,      START_DATE
,      END_DATE
,      TRANSACTION_SOURCE
,      SCA_CONDITION_ID
,      SCA_RULE_ATTRIBUTE_ID
,      SCA_COND_DETAIL_ID
,      OPERATOR_ID
,      VALUE_CHAR_MIN
,      VALUE_CHAR_MAX
,      VALUE_NUM_MIN
,      VALUE_NUM_MAX
,      VALUE_DATE_MIN
,      VALUE_DATE_MAX
FROM APPS.CN_SCA_RULE_COND_VALS_MV;

Dependencies

[top of page]

APPS.CN_SCA_RULE_COND_VALS_MV references the following:

SchemaAPPS
TableCN_SCA_RULE_COND_VALS_MV
SchemaCN
TableCN_SCA_CONDITIONS_ALL
TableCN_SCA_COND_DETAILS_ALL
TableCN_SCA_DENORM_RULES_ALL

APPS.CN_SCA_RULE_COND_VALS_MV is not referenced by any database object