CN_RS_USAGES_ALL_VL

Details

• Schema: FUSION

• Object owner: CN

• Object type: VIEW

Columns

Name

USAGE_ID OBJECT_VERSION_NUMBER ORG_ID ENABLED_FLAG RELATED_USAGE_ID1 RELATED_USAGE_ID2 RELATED_USAGE_ID3 RELATED_USAGE_ID4 DENORM_ATTR_VAL_TBL_NAME PARAM_PASSING_MECHANISM REAL_TIME_ENABLED_FLAG REAL_TIME_MATCH_SQL INDEX_EXTN BATCH_ENABLED_FLAG MULTI_LEVEL_WINNING_FLAG REAL_TIME_TRANS_TABLE_NAME BATCH_TRANS_TABLE_NAME BATCH_NM_TRANS_TABLE_NAME BATCH_MATCH_TABLE_NAME BATCH_U_MATCH_TABLE_NAME BATCH_WINNER_TABLE_NAME BATCH_U_WINNER_TABLE_NAME BATCH_L1_WINNER_TABLE_NAME BATCH_L2_WINNER_TABLE_NAME BATCH_L3_WINNER_TABLE_NAME BATCH_L4_WINNER_TABLE_NAME BATCH_L5_WINNER_TABLE_NAME BATCH_WT_WINNER_TABLE_NAME BATCH_MP_WINNER_TABLE_NAME BATCH_DMC_WINNER_TABLE_NAME CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 MODULE_ID NAME DESCRIPTION RTIME_MATCH_TABLE_NAME RTIME_L1_WINNER_TABLE_NAME RTIME_L2_WINNER_TABLE_NAME RTIME_L3_WINNER_TABLE_NAME RTIME_L4_WINNER_TABLE_NAME RTIME_L5_WINNER_TABLE_NAME RTIME_WT_WINNER_TABLE_NAME RTIME_WINNER_TABLE_NAME

Query

SQL_Statement

SELECT B.USAGE_ID, B.OBJECT_VERSION_NUMBER, B.ORG_ID, B.ENABLED_FLAG, B.RELATED_USAGE_ID1, B.RELATED_USAGE_ID2, B.RELATED_USAGE_ID3, B.RELATED_USAGE_ID4, B.DENORM_ATTR_VAL_TBL_NAME, B.PARAM_PASSING_MECHANISM, B.REAL_TIME_ENABLED_FLAG, B.REAL_TIME_MATCH_SQL, B.INDEX_EXTN, B.BATCH_ENABLED_FLAG, B.MULTI_LEVEL_WINNING_FLAG, B.REAL_TIME_TRANS_TABLE_NAME, B.BATCH_TRANS_TABLE_NAME, B.BATCH_NM_TRANS_TABLE_NAME, B.BATCH_MATCH_TABLE_NAME, B.BATCH_U_MATCH_TABLE_NAME, B.BATCH_WINNER_TABLE_NAME, B.BATCH_U_WINNER_TABLE_NAME, B.BATCH_L1_WINNER_TABLE_NAME, B.BATCH_L2_WINNER_TABLE_NAME, B.BATCH_L3_WINNER_TABLE_NAME, B.BATCH_L4_WINNER_TABLE_NAME, B.BATCH_L5_WINNER_TABLE_NAME, B.BATCH_WT_WINNER_TABLE_NAME, B.BATCH_MP_WINNER_TABLE_NAME, B.BATCH_DMC_WINNER_TABLE_NAME, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.ATTRIBUTE_CATEGORY, B.ATTRIBUTE1, B.ATTRIBUTE2, B.ATTRIBUTE3, B.ATTRIBUTE4, B.ATTRIBUTE5, B.ATTRIBUTE6, B.ATTRIBUTE7, B.ATTRIBUTE8, B.ATTRIBUTE9, B.ATTRIBUTE10, B.ATTRIBUTE11, B.ATTRIBUTE12, B.ATTRIBUTE13, B.ATTRIBUTE14, B.ATTRIBUTE15, B.MODULE_ID, TL.NAME, TL.DESCRIPTION, B.RTIME_MATCH_TABLE_NAME, B.RTIME_L1_WINNER_TABLE_NAME, B.RTIME_L2_WINNER_TABLE_NAME, B.RTIME_L3_WINNER_TABLE_NAME, B.RTIME_L4_WINNER_TABLE_NAME, B.RTIME_L5_WINNER_TABLE_NAME, B.RTIME_WT_WINNER_TABLE_NAME, B.RTIME_WINNER_TABLE_NAME FROM CN_RS_USAGES_ALL_B B, CN_RS_USAGES_ALL_TL TL WHERE B.USAGE_ID = TL.USAGE_ID AND B.ORG_ID = TL.ORG_ID AND TL.LANGUAGE = USERENV('LANG')