CMP_BUDGET_POOLS

Details

Schema: FUSION
Object owner: CMP
Object type: VIEW

Columns

Name
POOL_ID PLAN_ID SYSTEM_ORDER_NUM ORDER_NUM PRIMARY_COMPONENT_ID NON_MONETARY_UOM BUDGETING_STYLE AUTO_ISSUE_FLAG PREVENT_OVER_BUDGET_FLAG PREVENT_OVER_ALLOCATE_FLAG RESET_BDGT_ON_WITHDRAW_FLAG POOL_NAME PLAN_ID2 OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OVER_ALLOCATE_TOLERANCE OVER_BUDGET_TOLERANCE BUSINESS_GROUP_ID HIDE_FROM_MANAGERS_FLAG ENABLE_SCOREBOARD_VIEW_FLAG ENFORCE_BDGT_BY_GRP_FLAG MAX_PCT_OVER_ALLOCATE GROUPING_COLUMN_CODE OVER_BUDGET_SEVERITY_CODE OVER_BUDGET_GROUP_SEV_CODE NULL_BUDGET_SEVERITY_CODE UNDER_BUDGET_SEVERITY_CODE

Name

POOL_ID

PLAN_ID

SYSTEM_ORDER_NUM

ORDER_NUM

PRIMARY_COMPONENT_ID

NON_MONETARY_UOM

BUDGETING_STYLE

AUTO_ISSUE_FLAG

PREVENT_OVER_BUDGET_FLAG

PREVENT_OVER_ALLOCATE_FLAG

RESET_BDGT_ON_WITHDRAW_FLAG

POOL_NAME

PLAN_ID2

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OVER_ALLOCATE_TOLERANCE

OVER_BUDGET_TOLERANCE

BUSINESS_GROUP_ID

HIDE_FROM_MANAGERS_FLAG

ENABLE_SCOREBOARD_VIEW_FLAG

ENFORCE_BDGT_BY_GRP_FLAG

MAX_PCT_OVER_ALLOCATE

GROUPING_COLUMN_CODE

OVER_BUDGET_SEVERITY_CODE

OVER_BUDGET_GROUP_SEV_CODE

NULL_BUDGET_SEVERITY_CODE

UNDER_BUDGET_SEVERITY_CODE

Query

SQL_Statement
SELECT CMP_BUDGET_POOLS_B.POOL_ID POOL_ID, CMP_BUDGET_POOLS_B.PLAN_ID PLAN_ID, CMP_BUDGET_POOLS_B.SYSTEM_ORDER_NUM SYSTEM_ORDER_NUM, CMP_BUDGET_POOLS_B.ORDER_NUM ORDER_NUM, CMP_BUDGET_POOLS_B.PRIMARY_COMPONENT_ID PRIMARY_COMPONENT_ID, CMP_BUDGET_POOLS_B.NON_MONETARY_UOM NON_MONETARY_UOM, CMP_BUDGET_POOLS_B.BUDGETING_STYLE BUDGETING_STYLE, CMP_BUDGET_POOLS_B.AUTO_ISSUE_FLAG AUTO_ISSUE_FLAG, CMP_BUDGET_POOLS_B.PREVENT_OVER_BUDGET_FLAG PREVENT_OVER_BUDGET_FLAG, CMP_BUDGET_POOLS_B.PREVENT_OVER_ALLOCATE_FLAG PREVENT_OVER_ALLOCATE_FLAG, CMP_BUDGET_POOLS_B.RESET_BDGT_ON_WITHDRAW_FLAG RESET_BDGT_ON_WITHDRAW_FLAG, CMP_BUDGET_POOLS_TL.POOL_NAME POOL_NAME, CMP_BUDGET_POOLS_TL.PLAN_ID PLAN_ID2, CMP_BUDGET_POOLS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CMP_BUDGET_POOLS_B.CREATED_BY CREATED_BY, CMP_BUDGET_POOLS_B.CREATION_DATE CREATION_DATE, CMP_BUDGET_POOLS_B.LAST_UPDATED_BY LAST_UPDATED_BY, CMP_BUDGET_POOLS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, CMP_BUDGET_POOLS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CMP_BUDGET_POOLS_B.OVER_ALLOCATE_TOLERANCE OVER_ALLOCATE_TOLERANCE, CMP_BUDGET_POOLS_B.OVER_BUDGET_TOLERANCE OVER_BUDGET_TOLERANCE, CMP_BUDGET_POOLS_B.BUSINESS_GROUP_ID BUSINESS_GROUP_ID, CMP_BUDGET_POOLS_B.HIDE_FROM_MANAGERS_FLAG HIDE_FROM_MANAGERS_FLAG, CMP_BUDGET_POOLS_B.ENABLE_SCOREBOARD_VIEW_FLAG ENABLE_SCOREBOARD_VIEW_FLAG, CMP_BUDGET_POOLS_B.ENFORCE_BDGT_BY_GRP_FLAG ENFORCE_BDGT_BY_GRP_FLAG, CMP_BUDGET_POOLS_B.MAX_PCT_OVER_ALLOCATE MAX_PCT_OVER_ALLOCATE, CMP_BUDGET_POOLS_B.GROUPING_COLUMN_CODE GROUPING_COLUMN_CODE, CMP_BUDGET_POOLS_B.OVER_BUDGET_SEVERITY_CODE OVER_BUDGET_SEVERITY_CODE, CMP_BUDGET_POOLS_B.OVER_BUDGET_GROUP_SEV_CODE OVER_BUDGET_GROUP_SEV_CODE, CMP_BUDGET_POOLS_B.NULL_BUDGET_SEVERITY_CODE NULL_BUDGET_SEVERITY_CODE, CMP_BUDGET_POOLS_B.UNDER_BUDGET_SEVERITY_CODE UNDER_BUDGET_SEVERITY_CODE FROM CMP_BUDGET_POOLS_B, CMP_BUDGET_POOLS_TL WHERE CMP_BUDGET_POOLS_B.POOL_ID = CMP_BUDGET_POOLS_TL.POOL_ID AND CMP_BUDGET_POOLS_TL.LANGUAGE = USERENV('LANG') AND CMP_BUDGET_POOLS_TL.PLAN_ID = CMP_BUDGET_POOLS_B.PLAN_ID AND CMP_BUDGET_POOLS_B.BUSINESS_GROUP_ID = CMP_BUDGET_POOLS_TL.BUSINESS_GROUP_ID

SQL_Statement

SELECT

CMP_BUDGET_POOLS_B.POOL_ID POOL_ID,

CMP_BUDGET_POOLS_B.PLAN_ID PLAN_ID,

CMP_BUDGET_POOLS_B.SYSTEM_ORDER_NUM SYSTEM_ORDER_NUM,

CMP_BUDGET_POOLS_B.ORDER_NUM ORDER_NUM,

CMP_BUDGET_POOLS_B.PRIMARY_COMPONENT_ID PRIMARY_COMPONENT_ID,

CMP_BUDGET_POOLS_B.NON_MONETARY_UOM NON_MONETARY_UOM,

CMP_BUDGET_POOLS_B.BUDGETING_STYLE BUDGETING_STYLE,

CMP_BUDGET_POOLS_B.AUTO_ISSUE_FLAG AUTO_ISSUE_FLAG,

CMP_BUDGET_POOLS_B.PREVENT_OVER_BUDGET_FLAG PREVENT_OVER_BUDGET_FLAG,

CMP_BUDGET_POOLS_B.PREVENT_OVER_ALLOCATE_FLAG PREVENT_OVER_ALLOCATE_FLAG,

CMP_BUDGET_POOLS_B.RESET_BDGT_ON_WITHDRAW_FLAG RESET_BDGT_ON_WITHDRAW_FLAG,

CMP_BUDGET_POOLS_TL.POOL_NAME POOL_NAME,

CMP_BUDGET_POOLS_TL.PLAN_ID PLAN_ID2,

CMP_BUDGET_POOLS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

CMP_BUDGET_POOLS_B.CREATED_BY CREATED_BY,

CMP_BUDGET_POOLS_B.CREATION_DATE CREATION_DATE,

CMP_BUDGET_POOLS_B.LAST_UPDATED_BY LAST_UPDATED_BY,

CMP_BUDGET_POOLS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

CMP_BUDGET_POOLS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

CMP_BUDGET_POOLS_B.OVER_ALLOCATE_TOLERANCE OVER_ALLOCATE_TOLERANCE,

CMP_BUDGET_POOLS_B.OVER_BUDGET_TOLERANCE OVER_BUDGET_TOLERANCE,

CMP_BUDGET_POOLS_B.BUSINESS_GROUP_ID BUSINESS_GROUP_ID,

CMP_BUDGET_POOLS_B.HIDE_FROM_MANAGERS_FLAG HIDE_FROM_MANAGERS_FLAG,

CMP_BUDGET_POOLS_B.ENABLE_SCOREBOARD_VIEW_FLAG ENABLE_SCOREBOARD_VIEW_FLAG,

CMP_BUDGET_POOLS_B.ENFORCE_BDGT_BY_GRP_FLAG ENFORCE_BDGT_BY_GRP_FLAG,

CMP_BUDGET_POOLS_B.MAX_PCT_OVER_ALLOCATE MAX_PCT_OVER_ALLOCATE,

CMP_BUDGET_POOLS_B.GROUPING_COLUMN_CODE GROUPING_COLUMN_CODE,

CMP_BUDGET_POOLS_B.OVER_BUDGET_SEVERITY_CODE OVER_BUDGET_SEVERITY_CODE,

CMP_BUDGET_POOLS_B.OVER_BUDGET_GROUP_SEV_CODE OVER_BUDGET_GROUP_SEV_CODE,

CMP_BUDGET_POOLS_B.NULL_BUDGET_SEVERITY_CODE NULL_BUDGET_SEVERITY_CODE,

CMP_BUDGET_POOLS_B.UNDER_BUDGET_SEVERITY_CODE UNDER_BUDGET_SEVERITY_CODE

FROM

CMP_BUDGET_POOLS_B,

CMP_BUDGET_POOLS_TL

WHERE

CMP_BUDGET_POOLS_B.POOL_ID = CMP_BUDGET_POOLS_TL.POOL_ID AND CMP_BUDGET_POOLS_TL.LANGUAGE = USERENV('LANG') AND CMP_BUDGET_POOLS_TL.PLAN_ID = CMP_BUDGET_POOLS_B.PLAN_ID AND CMP_BUDGET_POOLS_B.BUSINESS_GROUP_ID = CMP_BUDGET_POOLS_TL.BUSINESS_GROUP_ID