VIEW: PA.PA_ALLOC_RULES_ALL#

Source

View Text - Preformatted

select RULE_ID RULE_ID, RULE_NAME RULE_NAME, ALLOCATION_METHOD ALLOCATION_METHOD, TARGET_EXP_TYPE_CLASS TARGET_EXP_TYPE_CLASS, TARGET_EXP_ORG_ID TARGET_EXP_ORG_ID, TARGET_EXP_TYPE TARGET_EXP_TYPE, TARGET_COST_TYPE TARGET_COST_TYPE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, DESCRIPTION DESCRIPTION, POOL_PERCENT POOL_PERCENT, PERIOD_TYPE PERIOD_TYPE, SOURCE_AMOUNT_TYPE SOURCE_AMOUNT_TYPE, SOURCE_BALANCE_CATEGORY SOURCE_BALANCE_CATEGORY, SOURCE_BALANCE_TYPE SOURCE_BALANCE_TYPE, ALLOC_RESOURCE_LIST_ID ALLOC_RESOURCE_LIST_ID, AUTO_RELEASE_FLAG AUTO_RELEASE_FLAG, IMP_WITH_EXCEPTION IMP_WITH_EXCEPTION, DUP_TARGETS_FLAG DUP_TARGETS_FLAG, OFFSET_EXP_TYPE_CLASS OFFSET_EXP_TYPE_CLASS, OFFSET_EXP_ORG_ID OFFSET_EXP_ORG_ID, OFFSET_EXP_TYPE OFFSET_EXP_TYPE, OFFSET_COST_TYPE OFFSET_COST_TYPE, OFFSET_METHOD OFFSET_METHOD, OFFSET_PROJECT_ID OFFSET_PROJECT_ID, OFFSET_TASK_ID OFFSET_TASK_ID, BASIS_METHOD BASIS_METHOD, BASIS_RELATIVE_PERIOD BASIS_RELATIVE_PERIOD, BASIS_AMOUNT_TYPE BASIS_AMOUNT_TYPE, BASIS_BALANCE_CATEGORY BASIS_BALANCE_CATEGORY, BASIS_BUDGET_TYPE_CODE BASIS_BUDGET_TYPE_CODE, BASIS_BUDGET_ENTRY_METHOD_CODE BASIS_BUDGET_ENTRY_METHOD_CODE, BASIS_BALANCE_TYPE BASIS_BALANCE_TYPE, BASIS_RESOURCE_LIST_ID BASIS_RESOURCE_LIST_ID, SOURCE_EXTN_FLAG SOURCE_EXTN_FLAG, TARGET_EXTN_FLAG TARGET_EXTN_FLAG, FIXED_AMOUNT FIXED_AMOUNT, START_DATE_ACTIVE START_DATE_ACTIVE, END_DATE_ACTIVE END_DATE_ACTIVE, ORG_ID ORG_ID, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, LIMIT_TARGET_PROJECTS_CODE LIMIT_TARGET_PROJECTS_CODE, BASIS_FIN_PLAN_TYPE_ID BASIS_FIN_PLAN_TYPE_ID, ALLOC_RESOURCE_STRUCT_TYPE ALLOC_RESOURCE_STRUCT_TYPE, BASIS_RESOURCE_STRUCT_TYPE BASIS_RESOURCE_STRUCT_TYPE, ALLOC_RBS_VERSION ALLOC_RBS_VERSION, BASIS_RBS_VERSION BASIS_RBS_VERSION from "PA"."PA_ALLOC_RULES_ALL"

View Text - HTML Formatted

SELECT RULE_ID RULE_ID
, RULE_NAME RULE_NAME
, ALLOCATION_METHOD ALLOCATION_METHOD
, TARGET_EXP_TYPE_CLASS TARGET_EXP_TYPE_CLASS
, TARGET_EXP_ORG_ID TARGET_EXP_ORG_ID
, TARGET_EXP_TYPE TARGET_EXP_TYPE
, TARGET_COST_TYPE TARGET_COST_TYPE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, DESCRIPTION DESCRIPTION
, POOL_PERCENT POOL_PERCENT
, PERIOD_TYPE PERIOD_TYPE
, SOURCE_AMOUNT_TYPE SOURCE_AMOUNT_TYPE
, SOURCE_BALANCE_CATEGORY SOURCE_BALANCE_CATEGORY
, SOURCE_BALANCE_TYPE SOURCE_BALANCE_TYPE
, ALLOC_RESOURCE_LIST_ID ALLOC_RESOURCE_LIST_ID
, AUTO_RELEASE_FLAG AUTO_RELEASE_FLAG
, IMP_WITH_EXCEPTION IMP_WITH_EXCEPTION
, DUP_TARGETS_FLAG DUP_TARGETS_FLAG
, OFFSET_EXP_TYPE_CLASS OFFSET_EXP_TYPE_CLASS
, OFFSET_EXP_ORG_ID OFFSET_EXP_ORG_ID
, OFFSET_EXP_TYPE OFFSET_EXP_TYPE
, OFFSET_COST_TYPE OFFSET_COST_TYPE
, OFFSET_METHOD OFFSET_METHOD
, OFFSET_PROJECT_ID OFFSET_PROJECT_ID
, OFFSET_TASK_ID OFFSET_TASK_ID
, BASIS_METHOD BASIS_METHOD
, BASIS_RELATIVE_PERIOD BASIS_RELATIVE_PERIOD
, BASIS_AMOUNT_TYPE BASIS_AMOUNT_TYPE
, BASIS_BALANCE_CATEGORY BASIS_BALANCE_CATEGORY
, BASIS_BUDGET_TYPE_CODE BASIS_BUDGET_TYPE_CODE
, BASIS_BUDGET_ENTRY_METHOD_CODE BASIS_BUDGET_ENTRY_METHOD_CODE
, BASIS_BALANCE_TYPE BASIS_BALANCE_TYPE
, BASIS_RESOURCE_LIST_ID BASIS_RESOURCE_LIST_ID
, SOURCE_EXTN_FLAG SOURCE_EXTN_FLAG
, TARGET_EXTN_FLAG TARGET_EXTN_FLAG
, FIXED_AMOUNT FIXED_AMOUNT
, START_DATE_ACTIVE START_DATE_ACTIVE
, END_DATE_ACTIVE END_DATE_ACTIVE
, ORG_ID ORG_ID
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, LIMIT_TARGET_PROJECTS_CODE LIMIT_TARGET_PROJECTS_CODE
, BASIS_FIN_PLAN_TYPE_ID BASIS_FIN_PLAN_TYPE_ID
, ALLOC_RESOURCE_STRUCT_TYPE ALLOC_RESOURCE_STRUCT_TYPE
, BASIS_RESOURCE_STRUCT_TYPE BASIS_RESOURCE_STRUCT_TYPE
, ALLOC_RBS_VERSION ALLOC_RBS_VERSION
, BASIS_RBS_VERSION BASIS_RBS_VERSION
FROM "PA"."PA_ALLOC_RULES_ALL"