VIEW: PA.PA_TASKS#

Source

View Text - Preformatted

select TASK_ID TASK_ID, PROJECT_ID PROJECT_ID, TASK_NUMBER TASK_NUMBER, 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, TASK_NAME TASK_NAME, TOP_TASK_ID TOP_TASK_ID, WBS_LEVEL WBS_LEVEL, READY_TO_BILL_FLAG READY_TO_BILL_FLAG, READY_TO_DISTRIBUTE_FLAG READY_TO_DISTRIBUTE_FLAG, PARENT_TASK_ID PARENT_TASK_ID, DESCRIPTION DESCRIPTION, CARRYING_OUT_ORGANIZATION_ID CARRYING_OUT_ORGANIZATION_ID, SERVICE_TYPE_CODE SERVICE_TYPE_CODE, TASK_MANAGER_PERSON_ID TASK_MANAGER_PERSON_ID, CHARGEABLE_FLAG CHARGEABLE_FLAG, BILLABLE_FLAG BILLABLE_FLAG, LIMIT_TO_TXN_CONTROLS_FLAG LIMIT_TO_TXN_CONTROLS_FLAG, START_DATE START_DATE, COMPLETION_DATE COMPLETION_DATE, ADDRESS_ID ADDRESS_ID, LABOR_BILL_RATE_ORG_ID LABOR_BILL_RATE_ORG_ID, LABOR_STD_BILL_RATE_SCHDL LABOR_STD_BILL_RATE_SCHDL, LABOR_SCHEDULE_FIXED_DATE LABOR_SCHEDULE_FIXED_DATE, LABOR_SCHEDULE_DISCOUNT LABOR_SCHEDULE_DISCOUNT, NON_LABOR_BILL_RATE_ORG_ID NON_LABOR_BILL_RATE_ORG_ID, NON_LABOR_STD_BILL_RATE_SCHDL NON_LABOR_STD_BILL_RATE_SCHDL, NON_LABOR_SCHEDULE_FIXED_DATE NON_LABOR_SCHEDULE_FIXED_DATE, NON_LABOR_SCHEDULE_DISCOUNT NON_LABOR_SCHEDULE_DISCOUNT, LABOR_COST_MULTIPLIER_NAME LABOR_COST_MULTIPLIER_NAME, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_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, 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_IND_SCH_FIXED_DATE COST_IND_SCH_FIXED_DATE, REV_IND_SCH_FIXED_DATE REV_IND_SCH_FIXED_DATE, INV_IND_SCH_FIXED_DATE INV_IND_SCH_FIXED_DATE, LABOR_SCH_TYPE LABOR_SCH_TYPE, NON_LABOR_SCH_TYPE NON_LABOR_SCH_TYPE, OVR_COST_IND_RATE_SCH_ID OVR_COST_IND_RATE_SCH_ID, OVR_INV_IND_RATE_SCH_ID OVR_INV_IND_RATE_SCH_ID, OVR_REV_IND_RATE_SCH_ID OVR_REV_IND_RATE_SCH_ID, PM_PRODUCT_CODE PM_PRODUCT_CODE, PM_TASK_REFERENCE PM_TASK_REFERENCE, ACTUAL_START_DATE ACTUAL_START_DATE, ACTUAL_FINISH_DATE ACTUAL_FINISH_DATE, EARLY_START_DATE EARLY_START_DATE, EARLY_FINISH_DATE EARLY_FINISH_DATE, LATE_START_DATE LATE_START_DATE, LATE_FINISH_DATE LATE_FINISH_DATE, SCHEDULED_START_DATE SCHEDULED_START_DATE, SCHEDULED_FINISH_DATE SCHEDULED_FINISH_DATE, ADW_NOTIFY_FLAG ADW_NOTIFY_FLAG, ALLOW_CROSS_CHARGE_FLAG ALLOW_CROSS_CHARGE_FLAG, PROJECT_RATE_DATE PROJECT_RATE_DATE, PROJECT_RATE_TYPE PROJECT_RATE_TYPE, CC_PROCESS_LABOR_FLAG CC_PROCESS_LABOR_FLAG, LABOR_TP_SCHEDULE_ID LABOR_TP_SCHEDULE_ID, LABOR_TP_FIXED_DATE LABOR_TP_FIXED_DATE, CC_PROCESS_NL_FLAG CC_PROCESS_NL_FLAG, NL_TP_SCHEDULE_ID NL_TP_SCHEDULE_ID, NL_TP_FIXED_DATE NL_TP_FIXED_DATE, RECEIVE_PROJECT_INVOICE_FLAG RECEIVE_PROJECT_INVOICE_FLAG, WORK_TYPE_ID WORK_TYPE_ID, RECORD_VERSION_NUMBER RECORD_VERSION_NUMBER, JOB_BILL_RATE_SCHEDULE_ID JOB_BILL_RATE_SCHEDULE_ID, EMP_BILL_RATE_SCHEDULE_ID EMP_BILL_RATE_SCHEDULE_ID, TASKFUNC_COST_RATE_TYPE TASKFUNC_COST_RATE_TYPE, TASKFUNC_COST_RATE_DATE TASKFUNC_COST_RATE_DATE, NON_LAB_STD_BILL_RT_SCH_ID NON_LAB_STD_BILL_RT_SCH_ID, LABOR_DISC_REASON_CODE LABOR_DISC_REASON_CODE, NON_LABOR_DISC_REASON_CODE NON_LABOR_DISC_REASON_CODE, LONG_TASK_NAME LONG_TASK_NAME, RETIREMENT_COST_FLAG RETIREMENT_COST_FLAG, CINT_ELIGIBLE_FLAG CINT_ELIGIBLE_FLAG, CINT_STOP_DATE CINT_STOP_DATE, REVENUE_ACCRUAL_METHOD REVENUE_ACCRUAL_METHOD, INVOICE_METHOD INVOICE_METHOD, CUSTOMER_ID CUSTOMER_ID, GEN_ETC_SOURCE_CODE GEN_ETC_SOURCE_CODE, BILL_SCHE_OVRD_FLAG BILL_SCHE_OVRD_FLAG, ADJ_ON_STD_INV ADJ_ON_STD_INV from "PA"."PA_TASKS"

View Text - HTML Formatted

SELECT TASK_ID TASK_ID
, PROJECT_ID PROJECT_ID
, TASK_NUMBER TASK_NUMBER
, 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
, TASK_NAME TASK_NAME
, TOP_TASK_ID TOP_TASK_ID
, WBS_LEVEL WBS_LEVEL
, READY_TO_BILL_FLAG READY_TO_BILL_FLAG
, READY_TO_DISTRIBUTE_FLAG READY_TO_DISTRIBUTE_FLAG
, PARENT_TASK_ID PARENT_TASK_ID
, DESCRIPTION DESCRIPTION
, CARRYING_OUT_ORGANIZATION_ID CARRYING_OUT_ORGANIZATION_ID
, SERVICE_TYPE_CODE SERVICE_TYPE_CODE
, TASK_MANAGER_PERSON_ID TASK_MANAGER_PERSON_ID
, CHARGEABLE_FLAG CHARGEABLE_FLAG
, BILLABLE_FLAG BILLABLE_FLAG
, LIMIT_TO_TXN_CONTROLS_FLAG LIMIT_TO_TXN_CONTROLS_FLAG
, START_DATE START_DATE
, COMPLETION_DATE COMPLETION_DATE
, ADDRESS_ID ADDRESS_ID
, LABOR_BILL_RATE_ORG_ID LABOR_BILL_RATE_ORG_ID
, LABOR_STD_BILL_RATE_SCHDL LABOR_STD_BILL_RATE_SCHDL
, LABOR_SCHEDULE_FIXED_DATE LABOR_SCHEDULE_FIXED_DATE
, LABOR_SCHEDULE_DISCOUNT LABOR_SCHEDULE_DISCOUNT
, NON_LABOR_BILL_RATE_ORG_ID NON_LABOR_BILL_RATE_ORG_ID
, NON_LABOR_STD_BILL_RATE_SCHDL NON_LABOR_STD_BILL_RATE_SCHDL
, NON_LABOR_SCHEDULE_FIXED_DATE NON_LABOR_SCHEDULE_FIXED_DATE
, NON_LABOR_SCHEDULE_DISCOUNT NON_LABOR_SCHEDULE_DISCOUNT
, LABOR_COST_MULTIPLIER_NAME LABOR_COST_MULTIPLIER_NAME
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_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
, 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_IND_SCH_FIXED_DATE COST_IND_SCH_FIXED_DATE
, REV_IND_SCH_FIXED_DATE REV_IND_SCH_FIXED_DATE
, INV_IND_SCH_FIXED_DATE INV_IND_SCH_FIXED_DATE
, LABOR_SCH_TYPE LABOR_SCH_TYPE
, NON_LABOR_SCH_TYPE NON_LABOR_SCH_TYPE
, OVR_COST_IND_RATE_SCH_ID OVR_COST_IND_RATE_SCH_ID
, OVR_INV_IND_RATE_SCH_ID OVR_INV_IND_RATE_SCH_ID
, OVR_REV_IND_RATE_SCH_ID OVR_REV_IND_RATE_SCH_ID
, PM_PRODUCT_CODE PM_PRODUCT_CODE
, PM_TASK_REFERENCE PM_TASK_REFERENCE
, ACTUAL_START_DATE ACTUAL_START_DATE
, ACTUAL_FINISH_DATE ACTUAL_FINISH_DATE
, EARLY_START_DATE EARLY_START_DATE
, EARLY_FINISH_DATE EARLY_FINISH_DATE
, LATE_START_DATE LATE_START_DATE
, LATE_FINISH_DATE LATE_FINISH_DATE
, SCHEDULED_START_DATE SCHEDULED_START_DATE
, SCHEDULED_FINISH_DATE SCHEDULED_FINISH_DATE
, ADW_NOTIFY_FLAG ADW_NOTIFY_FLAG
, ALLOW_CROSS_CHARGE_FLAG ALLOW_CROSS_CHARGE_FLAG
, PROJECT_RATE_DATE PROJECT_RATE_DATE
, PROJECT_RATE_TYPE PROJECT_RATE_TYPE
, CC_PROCESS_LABOR_FLAG CC_PROCESS_LABOR_FLAG
, LABOR_TP_SCHEDULE_ID LABOR_TP_SCHEDULE_ID
, LABOR_TP_FIXED_DATE LABOR_TP_FIXED_DATE
, CC_PROCESS_NL_FLAG CC_PROCESS_NL_FLAG
, NL_TP_SCHEDULE_ID NL_TP_SCHEDULE_ID
, NL_TP_FIXED_DATE NL_TP_FIXED_DATE
, RECEIVE_PROJECT_INVOICE_FLAG RECEIVE_PROJECT_INVOICE_FLAG
, WORK_TYPE_ID WORK_TYPE_ID
, RECORD_VERSION_NUMBER RECORD_VERSION_NUMBER
, JOB_BILL_RATE_SCHEDULE_ID JOB_BILL_RATE_SCHEDULE_ID
, EMP_BILL_RATE_SCHEDULE_ID EMP_BILL_RATE_SCHEDULE_ID
, TASKFUNC_COST_RATE_TYPE TASKFUNC_COST_RATE_TYPE
, TASKFUNC_COST_RATE_DATE TASKFUNC_COST_RATE_DATE
, NON_LAB_STD_BILL_RT_SCH_ID NON_LAB_STD_BILL_RT_SCH_ID
, LABOR_DISC_REASON_CODE LABOR_DISC_REASON_CODE
, NON_LABOR_DISC_REASON_CODE NON_LABOR_DISC_REASON_CODE
, LONG_TASK_NAME LONG_TASK_NAME
, RETIREMENT_COST_FLAG RETIREMENT_COST_FLAG
, CINT_ELIGIBLE_FLAG CINT_ELIGIBLE_FLAG
, CINT_STOP_DATE CINT_STOP_DATE
, REVENUE_ACCRUAL_METHOD REVENUE_ACCRUAL_METHOD
, INVOICE_METHOD INVOICE_METHOD
, CUSTOMER_ID CUSTOMER_ID
, GEN_ETC_SOURCE_CODE GEN_ETC_SOURCE_CODE
, BILL_SCHE_OVRD_FLAG BILL_SCHE_OVRD_FLAG
, ADJ_ON_STD_INV ADJ_ON_STD_INV
FROM "PA"."PA_TASKS"