VIEW: PA.PA_FIN_PLAN_TYPES_B#

Source

View Text - Preformatted

select FIN_PLAN_TYPE_ID FIN_PLAN_TYPE_ID, FIN_PLAN_TYPE_CODE FIN_PLAN_TYPE_CODE, PRE_DEFINED_FLAG PRE_DEFINED_FLAG, GENERATED_FLAG GENERATED_FLAG, EDIT_GENERATED_AMT_FLAG EDIT_GENERATED_AMT_FLAG, USED_IN_BILLING_FLAG USED_IN_BILLING_FLAG, ENABLE_WF_FLAG ENABLE_WF_FLAG, START_DATE_ACTIVE START_DATE_ACTIVE, END_DATE_ACTIVE END_DATE_ACTIVE, RECORD_VERSION_NUMBER RECORD_VERSION_NUMBER, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PLAN_CLASS_CODE PLAN_CLASS_CODE, APPROVED_COST_PLAN_TYPE_FLAG APPROVED_COST_PLAN_TYPE_FLAG, APPROVED_REV_PLAN_TYPE_FLAG APPROVED_REV_PLAN_TYPE_FLAG, PROJFUNC_COST_RATE_TYPE PROJFUNC_COST_RATE_TYPE, PROJFUNC_COST_RATE_DATE_TYPE PROJFUNC_COST_RATE_DATE_TYPE, PROJFUNC_COST_RATE_DATE PROJFUNC_COST_RATE_DATE, PROJFUNC_REV_RATE_TYPE PROJFUNC_REV_RATE_TYPE, PROJFUNC_REV_RATE_DATE_TYPE PROJFUNC_REV_RATE_DATE_TYPE, PROJFUNC_REV_RATE_DATE PROJFUNC_REV_RATE_DATE, PROJECT_COST_RATE_TYPE PROJECT_COST_RATE_TYPE, PROJECT_COST_RATE_DATE_TYPE PROJECT_COST_RATE_DATE_TYPE, PROJECT_COST_RATE_DATE PROJECT_COST_RATE_DATE, PROJECT_REV_RATE_TYPE PROJECT_REV_RATE_TYPE, PROJECT_REV_RATE_DATE_TYPE PROJECT_REV_RATE_DATE_TYPE, PROJECT_REV_RATE_DATE PROJECT_REV_RATE_DATE, 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, MIGRATED_FRM_BDGT_TYP_CODE MIGRATED_FRM_BDGT_TYP_CODE, ENABLE_PARTIAL_IMPL_FLAG ENABLE_PARTIAL_IMPL_FLAG, PRIMARY_COST_FORECAST_FLAG PRIMARY_COST_FORECAST_FLAG, PRIMARY_REV_FORECAST_FLAG PRIMARY_REV_FORECAST_FLAG, EDIT_AFTER_BASELINE_FLAG EDIT_AFTER_BASELINE_FLAG, USE_FOR_WORKPLAN_FLAG USE_FOR_WORKPLAN_FLAG, ZD_EDITION_NAME ZD_EDITION_NAME from "PA"."PA_FIN_PLAN_TYPES_B"

View Text - HTML Formatted

SELECT FIN_PLAN_TYPE_ID FIN_PLAN_TYPE_ID
, FIN_PLAN_TYPE_CODE FIN_PLAN_TYPE_CODE
, PRE_DEFINED_FLAG PRE_DEFINED_FLAG
, GENERATED_FLAG GENERATED_FLAG
, EDIT_GENERATED_AMT_FLAG EDIT_GENERATED_AMT_FLAG
, USED_IN_BILLING_FLAG USED_IN_BILLING_FLAG
, ENABLE_WF_FLAG ENABLE_WF_FLAG
, START_DATE_ACTIVE START_DATE_ACTIVE
, END_DATE_ACTIVE END_DATE_ACTIVE
, RECORD_VERSION_NUMBER RECORD_VERSION_NUMBER
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PLAN_CLASS_CODE PLAN_CLASS_CODE
, APPROVED_COST_PLAN_TYPE_FLAG APPROVED_COST_PLAN_TYPE_FLAG
, APPROVED_REV_PLAN_TYPE_FLAG APPROVED_REV_PLAN_TYPE_FLAG
, PROJFUNC_COST_RATE_TYPE PROJFUNC_COST_RATE_TYPE
, PROJFUNC_COST_RATE_DATE_TYPE PROJFUNC_COST_RATE_DATE_TYPE
, PROJFUNC_COST_RATE_DATE PROJFUNC_COST_RATE_DATE
, PROJFUNC_REV_RATE_TYPE PROJFUNC_REV_RATE_TYPE
, PROJFUNC_REV_RATE_DATE_TYPE PROJFUNC_REV_RATE_DATE_TYPE
, PROJFUNC_REV_RATE_DATE PROJFUNC_REV_RATE_DATE
, PROJECT_COST_RATE_TYPE PROJECT_COST_RATE_TYPE
, PROJECT_COST_RATE_DATE_TYPE PROJECT_COST_RATE_DATE_TYPE
, PROJECT_COST_RATE_DATE PROJECT_COST_RATE_DATE
, PROJECT_REV_RATE_TYPE PROJECT_REV_RATE_TYPE
, PROJECT_REV_RATE_DATE_TYPE PROJECT_REV_RATE_DATE_TYPE
, PROJECT_REV_RATE_DATE PROJECT_REV_RATE_DATE
, 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
, MIGRATED_FRM_BDGT_TYP_CODE MIGRATED_FRM_BDGT_TYP_CODE
, ENABLE_PARTIAL_IMPL_FLAG ENABLE_PARTIAL_IMPL_FLAG
, PRIMARY_COST_FORECAST_FLAG PRIMARY_COST_FORECAST_FLAG
, PRIMARY_REV_FORECAST_FLAG PRIMARY_REV_FORECAST_FLAG
, EDIT_AFTER_BASELINE_FLAG EDIT_AFTER_BASELINE_FLAG
, USE_FOR_WORKPLAN_FLAG USE_FOR_WORKPLAN_FLAG
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "PA"."PA_FIN_PLAN_TYPES_B"