VIEW: PA.PA_PROJECT_TYPES_ALL#

Source

View Text - Preformatted

select PROJECT_TYPE PROJECT_TYPE, 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, DIRECT_FLAG DIRECT_FLAG, SERVICE_TYPE_CODE SERVICE_TYPE_CODE, BURDEN_COST_FLAG BURDEN_COST_FLAG, START_DATE_ACTIVE START_DATE_ACTIVE, LABOR_INVOICE_FORMAT_ID LABOR_INVOICE_FORMAT_ID, NON_LABOR_INVOICE_FORMAT_ID NON_LABOR_INVOICE_FORMAT_ID, LABOR_BILL_RATE_ORG_ID LABOR_BILL_RATE_ORG_ID, LABOR_STD_BILL_RATE_SCHDL LABOR_STD_BILL_RATE_SCHDL, NON_LABOR_BILL_RATE_ORG_ID NON_LABOR_BILL_RATE_ORG_ID, NON_LABOR_STD_BILL_RATE_SCHDL NON_LABOR_STD_BILL_RATE_SCHDL, END_DATE_ACTIVE END_DATE_ACTIVE, DESCRIPTION DESCRIPTION, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, LABOR_SCH_TYPE LABOR_SCH_TYPE, NON_LABOR_SCH_TYPE NON_LABOR_SCH_TYPE, COST_IND_RATE_SCH_ID COST_IND_RATE_SCH_ID, REV_IND_RATE_SCH_ID REV_IND_RATE_SCH_ID, INV_IND_RATE_SCH_ID INV_IND_RATE_SCH_ID, COST_SCH_OVERRIDE_FLAG COST_SCH_OVERRIDE_FLAG, REV_BUDGET_ENTRY_METHOD_CODE REV_BUDGET_ENTRY_METHOD_CODE, REV_BUDGET_RESOURCE_LIST_ID REV_BUDGET_RESOURCE_LIST_ID, ALLOW_REV_BUDGET_ENTRY_FLAG ALLOW_REV_BUDGET_ENTRY_FLAG, COST_BUDGET_ENTRY_METHOD_CODE COST_BUDGET_ENTRY_METHOD_CODE, COST_BUDGET_RESOURCE_LIST_ID COST_BUDGET_RESOURCE_LIST_ID, ALLOW_COST_BUDGET_ENTRY_FLAG ALLOW_COST_BUDGET_ENTRY_FLAG, DEFAULT_RESOURCE_LIST_ID DEFAULT_RESOURCE_LIST_ID, ALLOWABLE_FUNDING_LEVEL_CODE ALLOWABLE_FUNDING_LEVEL_CODE, PROJECT_TYPE_CLASS_CODE PROJECT_TYPE_CLASS_CODE, INTERFACE_COMPLETE_ASSET_FLAG INTERFACE_COMPLETE_ASSET_FLAG, CIP_GROUPING_METHOD_CODE CIP_GROUPING_METHOD_CODE, CAPITAL_COST_TYPE_CODE CAPITAL_COST_TYPE_CODE, INTERFACE_ASSET_COST_CODE INTERFACE_ASSET_COST_CODE, ORG_ID ORG_ID, BURDEN_AMT_DISPLAY_METHOD BURDEN_AMT_DISPLAY_METHOD, BURDEN_ACCOUNT_FLAG BURDEN_ACCOUNT_FLAG, BURDEN_SUM_DEST_PROJECT_ID BURDEN_SUM_DEST_PROJECT_ID, BURDEN_SUM_DEST_TASK_ID BURDEN_SUM_DEST_TASK_ID, ENABLE_BUDGET_WF_FLAG ENABLE_BUDGET_WF_FLAG, ENABLE_PROJECT_WF_FLAG ENABLE_PROJECT_WF_FLAG, BILLING_OFFSET BILLING_OFFSET, BILLING_CYCLE_ID BILLING_CYCLE_ID, ADW_NOTIFY_FLAG ADW_NOTIFY_FLAG, DEF_START_PROJ_STATUS_CODE DEF_START_PROJ_STATUS_CODE, VENDOR_INVOICE_GROUPING_CODE VENDOR_INVOICE_GROUPING_CODE, OVERRIDE_ASSET_ASSIGNMENT_FLAG OVERRIDE_ASSET_ASSIGNMENT_FLAG, CC_PRVDR_FLAG CC_PRVDR_FLAG, BILL_JOB_GROUP_ID BILL_JOB_GROUP_ID, COST_JOB_GROUP_ID COST_JOB_GROUP_ID, ADMINISTRATIVE_FLAG ADMINISTRATIVE_FLAG, ROLE_LIST_ID ROLE_LIST_ID, WORK_TYPE_ID WORK_TYPE_ID, PROBABILITY_LIST_ID PROBABILITY_LIST_ID, UNASSIGNED_TIME UNASSIGNED_TIME, JOB_BILL_RATE_SCHEDULE_ID JOB_BILL_RATE_SCHEDULE_ID, EMP_BILL_RATE_SCHEDULE_ID EMP_BILL_RATE_SCHEDULE_ID, BUDGETARY_OVERRIDE_FLAG BUDGETARY_OVERRIDE_FLAG, NON_LAB_STD_BILL_RT_SCH_ID NON_LAB_STD_BILL_RT_SCH_ID, BASELINE_FUNDING_FLAG BASELINE_FUNDING_FLAG, PROJECT_TYPE_ID PROJECT_TYPE_ID, ORG_PROJECT_FLAG ORG_PROJECT_FLAG, REVALUATE_FUNDING_FLAG REVALUATE_FUNDING_FLAG, INCLUDE_GAINS_LOSSES_FLAG INCLUDE_GAINS_LOSSES_FLAG, RLZD_GAINS_EVENT_TYPE_ID RLZD_GAINS_EVENT_TYPE_ID, RLZD_LOSSES_EVENT_TYPE_ID RLZD_LOSSES_EVENT_TYPE_ID, TOTAL_BURDEN_FLAG TOTAL_BURDEN_FLAG, ASSET_ALLOCATION_METHOD ASSET_ALLOCATION_METHOD, CAPITAL_EVENT_PROCESSING CAPITAL_EVENT_PROCESSING, CINT_RATE_SCH_ID CINT_RATE_SCH_ID, CINT_SCH_OVERRIDE_FLAG CINT_SCH_OVERRIDE_FLAG, SPONSORED_FLAG SPONSORED_FLAG, DATE_EFF_FUNDS_CONSUMPTION DATE_EFF_FUNDS_CONSUMPTION, CWK_CLEARING_FLAG CWK_CLEARING_FLAG, AR_REC_NOTIFY_FLAG AR_REC_NOTIFY_FLAG, AUTO_RELEASE_PWP_INV AUTO_RELEASE_PWP_INV from "PA"."PA_PROJECT_TYPES_ALL"

View Text - HTML Formatted

SELECT PROJECT_TYPE PROJECT_TYPE
, 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
, DIRECT_FLAG DIRECT_FLAG
, SERVICE_TYPE_CODE SERVICE_TYPE_CODE
, BURDEN_COST_FLAG BURDEN_COST_FLAG
, START_DATE_ACTIVE START_DATE_ACTIVE
, LABOR_INVOICE_FORMAT_ID LABOR_INVOICE_FORMAT_ID
, NON_LABOR_INVOICE_FORMAT_ID NON_LABOR_INVOICE_FORMAT_ID
, LABOR_BILL_RATE_ORG_ID LABOR_BILL_RATE_ORG_ID
, LABOR_STD_BILL_RATE_SCHDL LABOR_STD_BILL_RATE_SCHDL
, NON_LABOR_BILL_RATE_ORG_ID NON_LABOR_BILL_RATE_ORG_ID
, NON_LABOR_STD_BILL_RATE_SCHDL NON_LABOR_STD_BILL_RATE_SCHDL
, END_DATE_ACTIVE END_DATE_ACTIVE
, DESCRIPTION DESCRIPTION
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, LABOR_SCH_TYPE LABOR_SCH_TYPE
, NON_LABOR_SCH_TYPE NON_LABOR_SCH_TYPE
, COST_IND_RATE_SCH_ID COST_IND_RATE_SCH_ID
, REV_IND_RATE_SCH_ID REV_IND_RATE_SCH_ID
, INV_IND_RATE_SCH_ID INV_IND_RATE_SCH_ID
, COST_SCH_OVERRIDE_FLAG COST_SCH_OVERRIDE_FLAG
, REV_BUDGET_ENTRY_METHOD_CODE REV_BUDGET_ENTRY_METHOD_CODE
, REV_BUDGET_RESOURCE_LIST_ID REV_BUDGET_RESOURCE_LIST_ID
, ALLOW_REV_BUDGET_ENTRY_FLAG ALLOW_REV_BUDGET_ENTRY_FLAG
, COST_BUDGET_ENTRY_METHOD_CODE COST_BUDGET_ENTRY_METHOD_CODE
, COST_BUDGET_RESOURCE_LIST_ID COST_BUDGET_RESOURCE_LIST_ID
, ALLOW_COST_BUDGET_ENTRY_FLAG ALLOW_COST_BUDGET_ENTRY_FLAG
, DEFAULT_RESOURCE_LIST_ID DEFAULT_RESOURCE_LIST_ID
, ALLOWABLE_FUNDING_LEVEL_CODE ALLOWABLE_FUNDING_LEVEL_CODE
, PROJECT_TYPE_CLASS_CODE PROJECT_TYPE_CLASS_CODE
, INTERFACE_COMPLETE_ASSET_FLAG INTERFACE_COMPLETE_ASSET_FLAG
, CIP_GROUPING_METHOD_CODE CIP_GROUPING_METHOD_CODE
, CAPITAL_COST_TYPE_CODE CAPITAL_COST_TYPE_CODE
, INTERFACE_ASSET_COST_CODE INTERFACE_ASSET_COST_CODE
, ORG_ID ORG_ID
, BURDEN_AMT_DISPLAY_METHOD BURDEN_AMT_DISPLAY_METHOD
, BURDEN_ACCOUNT_FLAG BURDEN_ACCOUNT_FLAG
, BURDEN_SUM_DEST_PROJECT_ID BURDEN_SUM_DEST_PROJECT_ID
, BURDEN_SUM_DEST_TASK_ID BURDEN_SUM_DEST_TASK_ID
, ENABLE_BUDGET_WF_FLAG ENABLE_BUDGET_WF_FLAG
, ENABLE_PROJECT_WF_FLAG ENABLE_PROJECT_WF_FLAG
, BILLING_OFFSET BILLING_OFFSET
, BILLING_CYCLE_ID BILLING_CYCLE_ID
, ADW_NOTIFY_FLAG ADW_NOTIFY_FLAG
, DEF_START_PROJ_STATUS_CODE DEF_START_PROJ_STATUS_CODE
, VENDOR_INVOICE_GROUPING_CODE VENDOR_INVOICE_GROUPING_CODE
, OVERRIDE_ASSET_ASSIGNMENT_FLAG OVERRIDE_ASSET_ASSIGNMENT_FLAG
, CC_PRVDR_FLAG CC_PRVDR_FLAG
, BILL_JOB_GROUP_ID BILL_JOB_GROUP_ID
, COST_JOB_GROUP_ID COST_JOB_GROUP_ID
, ADMINISTRATIVE_FLAG ADMINISTRATIVE_FLAG
, ROLE_LIST_ID ROLE_LIST_ID
, WORK_TYPE_ID WORK_TYPE_ID
, PROBABILITY_LIST_ID PROBABILITY_LIST_ID
, UNASSIGNED_TIME UNASSIGNED_TIME
, JOB_BILL_RATE_SCHEDULE_ID JOB_BILL_RATE_SCHEDULE_ID
, EMP_BILL_RATE_SCHEDULE_ID EMP_BILL_RATE_SCHEDULE_ID
, BUDGETARY_OVERRIDE_FLAG BUDGETARY_OVERRIDE_FLAG
, NON_LAB_STD_BILL_RT_SCH_ID NON_LAB_STD_BILL_RT_SCH_ID
, BASELINE_FUNDING_FLAG BASELINE_FUNDING_FLAG
, PROJECT_TYPE_ID PROJECT_TYPE_ID
, ORG_PROJECT_FLAG ORG_PROJECT_FLAG
, REVALUATE_FUNDING_FLAG REVALUATE_FUNDING_FLAG
, INCLUDE_GAINS_LOSSES_FLAG INCLUDE_GAINS_LOSSES_FLAG
, RLZD_GAINS_EVENT_TYPE_ID RLZD_GAINS_EVENT_TYPE_ID
, RLZD_LOSSES_EVENT_TYPE_ID RLZD_LOSSES_EVENT_TYPE_ID
, TOTAL_BURDEN_FLAG TOTAL_BURDEN_FLAG
, ASSET_ALLOCATION_METHOD ASSET_ALLOCATION_METHOD
, CAPITAL_EVENT_PROCESSING CAPITAL_EVENT_PROCESSING
, CINT_RATE_SCH_ID CINT_RATE_SCH_ID
, CINT_SCH_OVERRIDE_FLAG CINT_SCH_OVERRIDE_FLAG
, SPONSORED_FLAG SPONSORED_FLAG
, DATE_EFF_FUNDS_CONSUMPTION DATE_EFF_FUNDS_CONSUMPTION
, CWK_CLEARING_FLAG CWK_CLEARING_FLAG
, AR_REC_NOTIFY_FLAG AR_REC_NOTIFY_FLAG
, AUTO_RELEASE_PWP_INV AUTO_RELEASE_PWP_INV
FROM "PA"."PA_PROJECT_TYPES_ALL"