VIEW: PA.PA_ALLOC_RUNS_ALL#

Source

View Text - Preformatted

select RUN_ID RUN_ID, RULE_ID RULE_ID, RUN_PERIOD RUN_PERIOD, EXPND_ITEM_DATE EXPND_ITEM_DATE, DENOM_CURRENCY_CODE DENOM_CURRENCY_CODE, 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, FIXED_AMOUNT FIXED_AMOUNT, 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, ALLOCATION_METHOD ALLOCATION_METHOD, IMP_WITH_EXCEPTION IMP_WITH_EXCEPTION, DUP_TARGETS_FLAG DUP_TARGETS_FLAG, 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, 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, RUN_STATUS RUN_STATUS, 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, FISCAL_YEAR FISCAL_YEAR, QUARTER QUARTER, PERIOD_NUM PERIOD_NUM, TARGET_EXP_GROUP TARGET_EXP_GROUP, REV_TARGET_EXP_GROUP REV_TARGET_EXP_GROUP, OFFSET_EXP_GROUP OFFSET_EXP_GROUP, REV_OFFSET_EXP_GROUP REV_OFFSET_EXP_GROUP, TOTAL_POOL_AMOUNT TOTAL_POOL_AMOUNT, ALLOCATED_AMOUNT ALLOCATED_AMOUNT, TOTAL_ALLOCATED_AMOUNT TOTAL_ALLOCATED_AMOUNT, TOTAL_OFFSETTED_AMOUNT TOTAL_OFFSETTED_AMOUNT, MISSING_SOURCE_PROJ_AMT MISSING_SOURCE_PROJ_AMT, MISSING_TARGET_PROJ_AMT MISSING_TARGET_PROJ_AMT, MISSING_OFFSET_PROJ_AMT MISSING_OFFSET_PROJ_AMT, REVERSAL_DATE REVERSAL_DATE, DRAFT_REQUEST_ID DRAFT_REQUEST_ID, DRAFT_REQUEST_DATE DRAFT_REQUEST_DATE, RELEASE_REQUEST_ID RELEASE_REQUEST_ID, RELEASE_REQUEST_DATE RELEASE_REQUEST_DATE, ORG_ID ORG_ID, LIMIT_TARGET_PROJECTS_CODE LIMIT_TARGET_PROJECTS_CODE, BASIS_FIN_PLAN_TYPE_ID BASIS_FIN_PLAN_TYPE_ID, CINT_RATE_NAME CINT_RATE_NAME, 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_RUNS_ALL"

View Text - HTML Formatted

SELECT RUN_ID RUN_ID
, RULE_ID RULE_ID
, RUN_PERIOD RUN_PERIOD
, EXPND_ITEM_DATE EXPND_ITEM_DATE
, DENOM_CURRENCY_CODE DENOM_CURRENCY_CODE
, 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
, FIXED_AMOUNT FIXED_AMOUNT
, 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
, ALLOCATION_METHOD ALLOCATION_METHOD
, IMP_WITH_EXCEPTION IMP_WITH_EXCEPTION
, DUP_TARGETS_FLAG DUP_TARGETS_FLAG
, 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
, 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
, RUN_STATUS RUN_STATUS
, 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
, FISCAL_YEAR FISCAL_YEAR
, QUARTER QUARTER
, PERIOD_NUM PERIOD_NUM
, TARGET_EXP_GROUP TARGET_EXP_GROUP
, REV_TARGET_EXP_GROUP REV_TARGET_EXP_GROUP
, OFFSET_EXP_GROUP OFFSET_EXP_GROUP
, REV_OFFSET_EXP_GROUP REV_OFFSET_EXP_GROUP
, TOTAL_POOL_AMOUNT TOTAL_POOL_AMOUNT
, ALLOCATED_AMOUNT ALLOCATED_AMOUNT
, TOTAL_ALLOCATED_AMOUNT TOTAL_ALLOCATED_AMOUNT
, TOTAL_OFFSETTED_AMOUNT TOTAL_OFFSETTED_AMOUNT
, MISSING_SOURCE_PROJ_AMT MISSING_SOURCE_PROJ_AMT
, MISSING_TARGET_PROJ_AMT MISSING_TARGET_PROJ_AMT
, MISSING_OFFSET_PROJ_AMT MISSING_OFFSET_PROJ_AMT
, REVERSAL_DATE REVERSAL_DATE
, DRAFT_REQUEST_ID DRAFT_REQUEST_ID
, DRAFT_REQUEST_DATE DRAFT_REQUEST_DATE
, RELEASE_REQUEST_ID RELEASE_REQUEST_ID
, RELEASE_REQUEST_DATE RELEASE_REQUEST_DATE
, ORG_ID ORG_ID
, LIMIT_TARGET_PROJECTS_CODE LIMIT_TARGET_PROJECTS_CODE
, BASIS_FIN_PLAN_TYPE_ID BASIS_FIN_PLAN_TYPE_ID
, CINT_RATE_NAME CINT_RATE_NAME
, 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_RUNS_ALL"