[Home] [Help]
View: PSB_FTE_RULES_V
View Text
SELECT A.ROWID
, A.DEFAULT_RULE_ID
, A.NAME
, A.GLOBAL_DEFAULT_FLAG
, 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_ALLOCRULE_PERCENTS B
WHERE A.ENTITY_ID = B.ALLOCATION_RULE_ID)
Columns
| Name |
| ROW_ID |
| DEFAULT_RULE_ID |
| NAME |
| GLOBAL_DEFAULT_FLAG |
| DATA_EXTRACT_ID |
| BUSINESS_GROUP_ID |
| ENTITY_ID |
| PRIORITY |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_LOGIN |
| CREATED_BY |
| CREATION_DATE |
APPS.PSB_FTE_RULES_V