[Home] [Help]
View: PSB_NON_FTE_RULES_V
| Product: | PSB - Public Sector Budgeting (Obsolete) |
|---|
| Description: | |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
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 |