Skip to content

DBA Data[Home] [Help] [Dependency Information]

VIEW: PA.PA_TASKS#

Object Details
Object Name: PA_TASKS#
Object Type: VIEW
Owner: PA
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
TASK_ID NUMBER (15) Yes
PROJECT_ID NUMBER (15) Yes
TASK_NUMBER VARCHAR2 (25) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15) Yes
TASK_NAME VARCHAR2 (20) Yes
TOP_TASK_ID NUMBER (15) Yes
WBS_LEVEL NUMBER (3) Yes
READY_TO_BILL_FLAG VARCHAR2 (1) Yes
READY_TO_DISTRIBUTE_FLAG VARCHAR2 (1) Yes
PARENT_TASK_ID NUMBER (15)
DESCRIPTION VARCHAR2 (250)
CARRYING_OUT_ORGANIZATION_ID NUMBER (15) Yes
SERVICE_TYPE_CODE VARCHAR2 (30)
TASK_MANAGER_PERSON_ID NUMBER (9)
CHARGEABLE_FLAG VARCHAR2 (1)
BILLABLE_FLAG VARCHAR2 (1)
LIMIT_TO_TXN_CONTROLS_FLAG VARCHAR2 (1)
START_DATE DATE

COMPLETION_DATE DATE

ADDRESS_ID NUMBER (15)
LABOR_BILL_RATE_ORG_ID NUMBER (15)
LABOR_STD_BILL_RATE_SCHDL VARCHAR2 (20)
LABOR_SCHEDULE_FIXED_DATE DATE

LABOR_SCHEDULE_DISCOUNT NUMBER (7)
NON_LABOR_BILL_RATE_ORG_ID NUMBER (15)
NON_LABOR_STD_BILL_RATE_SCHDL VARCHAR2 (30)
NON_LABOR_SCHEDULE_FIXED_DATE DATE

NON_LABOR_SCHEDULE_DISCOUNT NUMBER (7)
LABOR_COST_MULTIPLIER_NAME VARCHAR2 (20)
REQUEST_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
COST_IND_RATE_SCH_ID NUMBER (15)
REV_IND_RATE_SCH_ID NUMBER (15)
INV_IND_RATE_SCH_ID NUMBER (15)
COST_IND_SCH_FIXED_DATE DATE

REV_IND_SCH_FIXED_DATE DATE

INV_IND_SCH_FIXED_DATE DATE

LABOR_SCH_TYPE VARCHAR2 (1)
NON_LABOR_SCH_TYPE VARCHAR2 (1)
OVR_COST_IND_RATE_SCH_ID NUMBER (15)
OVR_INV_IND_RATE_SCH_ID NUMBER (15)
OVR_REV_IND_RATE_SCH_ID NUMBER (15)
PM_PRODUCT_CODE VARCHAR2 (30)
PM_TASK_REFERENCE VARCHAR2 (25)
ACTUAL_START_DATE DATE

ACTUAL_FINISH_DATE DATE

EARLY_START_DATE DATE

EARLY_FINISH_DATE DATE

LATE_START_DATE DATE

LATE_FINISH_DATE DATE

SCHEDULED_START_DATE DATE

SCHEDULED_FINISH_DATE DATE

ADW_NOTIFY_FLAG VARCHAR2 (1)
ALLOW_CROSS_CHARGE_FLAG VARCHAR2 (1) Yes
PROJECT_RATE_DATE DATE

PROJECT_RATE_TYPE VARCHAR2 (30)
CC_PROCESS_LABOR_FLAG VARCHAR2 (1) Yes
LABOR_TP_SCHEDULE_ID NUMBER

LABOR_TP_FIXED_DATE DATE

CC_PROCESS_NL_FLAG VARCHAR2 (1) Yes
NL_TP_SCHEDULE_ID NUMBER

NL_TP_FIXED_DATE DATE

RECEIVE_PROJECT_INVOICE_FLAG VARCHAR2 (1)
WORK_TYPE_ID NUMBER (15)
RECORD_VERSION_NUMBER NUMBER (15)
JOB_BILL_RATE_SCHEDULE_ID NUMBER

EMP_BILL_RATE_SCHEDULE_ID NUMBER

TASKFUNC_COST_RATE_TYPE VARCHAR2 (30)
TASKFUNC_COST_RATE_DATE DATE

NON_LAB_STD_BILL_RT_SCH_ID NUMBER (15)
LABOR_DISC_REASON_CODE VARCHAR2 (30)
NON_LABOR_DISC_REASON_CODE VARCHAR2 (30)
LONG_TASK_NAME VARCHAR2 (240)
RETIREMENT_COST_FLAG VARCHAR2 (1)
CINT_ELIGIBLE_FLAG VARCHAR2 (1)
CINT_STOP_DATE DATE

REVENUE_ACCRUAL_METHOD VARCHAR2 (30)
INVOICE_METHOD VARCHAR2 (30)
CUSTOMER_ID NUMBER

GEN_ETC_SOURCE_CODE VARCHAR2 (30)
BILL_SCHE_OVRD_FLAG VARCHAR2 (1)
ADJ_ON_STD_INV VARCHAR2 (2)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TASK_ID
,      PROJECT_ID
,      TASK_NUMBER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      TASK_NAME
,      TOP_TASK_ID
,      WBS_LEVEL
,      READY_TO_BILL_FLAG
,      READY_TO_DISTRIBUTE_FLAG
,      PARENT_TASK_ID
,      DESCRIPTION
,      CARRYING_OUT_ORGANIZATION_ID
,      SERVICE_TYPE_CODE
,      TASK_MANAGER_PERSON_ID
,      CHARGEABLE_FLAG
,      BILLABLE_FLAG
,      LIMIT_TO_TXN_CONTROLS_FLAG
,      START_DATE
,      COMPLETION_DATE
,      ADDRESS_ID
,      LABOR_BILL_RATE_ORG_ID
,      LABOR_STD_BILL_RATE_SCHDL
,      LABOR_SCHEDULE_FIXED_DATE
,      LABOR_SCHEDULE_DISCOUNT
,      NON_LABOR_BILL_RATE_ORG_ID
,      NON_LABOR_STD_BILL_RATE_SCHDL
,      NON_LABOR_SCHEDULE_FIXED_DATE
,      NON_LABOR_SCHEDULE_DISCOUNT
,      LABOR_COST_MULTIPLIER_NAME
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      COST_IND_RATE_SCH_ID
,      REV_IND_RATE_SCH_ID
,      INV_IND_RATE_SCH_ID
,      COST_IND_SCH_FIXED_DATE
,      REV_IND_SCH_FIXED_DATE
,      INV_IND_SCH_FIXED_DATE
,      LABOR_SCH_TYPE
,      NON_LABOR_SCH_TYPE
,      OVR_COST_IND_RATE_SCH_ID
,      OVR_INV_IND_RATE_SCH_ID
,      OVR_REV_IND_RATE_SCH_ID
,      PM_PRODUCT_CODE
,      PM_TASK_REFERENCE
,      ACTUAL_START_DATE
,      ACTUAL_FINISH_DATE
,      EARLY_START_DATE
,      EARLY_FINISH_DATE
,      LATE_START_DATE
,      LATE_FINISH_DATE
,      SCHEDULED_START_DATE
,      SCHEDULED_FINISH_DATE
,      ADW_NOTIFY_FLAG
,      ALLOW_CROSS_CHARGE_FLAG
,      PROJECT_RATE_DATE
,      PROJECT_RATE_TYPE
,      CC_PROCESS_LABOR_FLAG
,      LABOR_TP_SCHEDULE_ID
,      LABOR_TP_FIXED_DATE
,      CC_PROCESS_NL_FLAG
,      NL_TP_SCHEDULE_ID
,      NL_TP_FIXED_DATE
,      RECEIVE_PROJECT_INVOICE_FLAG
,      WORK_TYPE_ID
,      RECORD_VERSION_NUMBER
,      JOB_BILL_RATE_SCHEDULE_ID
,      EMP_BILL_RATE_SCHEDULE_ID
,      TASKFUNC_COST_RATE_TYPE
,      TASKFUNC_COST_RATE_DATE
,      NON_LAB_STD_BILL_RT_SCH_ID
,      LABOR_DISC_REASON_CODE
,      NON_LABOR_DISC_REASON_CODE
,      LONG_TASK_NAME
,      RETIREMENT_COST_FLAG
,      CINT_ELIGIBLE_FLAG
,      CINT_STOP_DATE
,      REVENUE_ACCRUAL_METHOD
,      INVOICE_METHOD
,      CUSTOMER_ID
,      GEN_ETC_SOURCE_CODE
,      BILL_SCHE_OVRD_FLAG
,      ADJ_ON_STD_INV
FROM PA.PA_TASKS#;

Dependencies

[top of page]

PA.PA_TASKS# references the following:

SchemaPA
TablePA_TASKS
PA.PA_TASKS# is referenced by following:

SchemaAPPS
TriggerPA_ADW_TASKS_T1
TriggerPA_ADW_TASKS_T2
SynonymPA_TASKS