CN_SRP_IMPORT_RULE_SETS_ALL

詳細

スキーマ: FUSION
オブジェクト所有者: CN
オブジェクト・タイプ: VIEW

列

名前
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

名前

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

問合せ

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')

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')