CN_SRP_IMPORT_RULE_SETS_ALL_VL
Details
-
Schema: FUSION
-
Object owner: CN
-
Object type: VIEW
Columns
Name |
---|
SRP_IMPORT_RULE_SET_ID USAGE_TYPE NAME ORG_ID PARTICIPANT_TYPE CRITERIA_OPERATOR CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER |
Query
SQL_Statement |
---|
SELECT CN_SRP_IMPORT_RULE_SETS_ALL_B.SRP_IMPORT_RULE_SET_ID SRP_IMPORT_RULE_SET_ID, CN_SRP_IMPORT_RULE_SETS_ALL_B.USAGE_TYPE USAGE_TYPE, CN_SRP_IMPORT_RULE_SETS_ALL_TL.NAME NAME, CN_SRP_IMPORT_RULE_SETS_ALL_B.ORG_ID ORG_ID, CN_SRP_IMPORT_RULE_SETS_ALL_B.PARTICIPANT_TYPE PARTICIPANT_TYPE, CN_SRP_IMPORT_RULE_SETS_ALL_B.CRITERIA_OPERATOR CRITERIA_OPERATOR, CN_SRP_IMPORT_RULE_SETS_ALL_B.CREATED_BY CREATED_BY, CN_SRP_IMPORT_RULE_SETS_ALL_B.CREATION_DATE CREATION_DATE, CN_SRP_IMPORT_RULE_SETS_ALL_B.LAST_UPDATED_BY LAST_UPDATED_BY, CN_SRP_IMPORT_RULE_SETS_ALL_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, CN_SRP_IMPORT_RULE_SETS_ALL_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CN_SRP_IMPORT_RULE_SETS_ALL_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER FROM CN_SRP_IMPORT_RULE_SETS_ALL_B, CN_SRP_IMPORT_RULE_SETS_ALL_TL WHERE CN_SRP_IMPORT_RULE_SETS_ALL_B.SRP_IMPORT_RULE_SET_ID = CN_SRP_IMPORT_RULE_SETS_ALL_TL.SRP_IMPORT_RULE_SET_ID AND CN_SRP_IMPORT_RULE_SETS_ALL_TL.LANGUAGE = USERENV('LANG') |