[Home] [Help]
View: PSB_NON_FTE_RULES_V
View Text
SELECT A.ROWID
, A.DEFAULT_RULE_ID
, A.NAME
, A.GLOBAL_DEFAULT_FLAG
, A.OVERWRITE
, A.DATA_EXTRACT_ID
, A.BUSINESS_GROUP_ID
, A.ENTITY_ID
, A.PRIORITY
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_LOGIN
, A.CREATED_BY
, A.CREATION_DATE
FROM PSB_DEFAULTS A
WHERE EXISTS (SELECT 1
FROM PSB_DEFAULT_ASSIGNMENTS B
WHERE A.DEFAULT_RULE_ID = B.DEFAULT_RULE_ID) OR EXISTS (SELECT 1
FROM PSB_DEFAULT_ACCOUNT_DISTRS C
WHERE A.DEFAULT_RULE_ID = C.DEFAULT_RULE_ID)
Columns
Name |
ROW_ID |
DEFAULT_RULE_ID |
NAME |
GLOBAL_DEFAULT_FLAG |
OVERWRITE |
DATA_EXTRACT_ID |
BUSINESS_GROUP_ID |
ENTITY_ID |
PRIORITY |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
CREATED_BY |
CREATION_DATE |