[Home] [Help] [Dependency Information]
Object Name: | PA_TASKS_ALL_EXPEND_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PA.PA_TASKS_ALL_EXPEND_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROJECT_ID | NUMBER | (15) | ||
PROJECT_NUMBER | VARCHAR2 | (25) | ||
TASK_ID | NUMBER | (15) | The task ID for projects for which cost breakdown planning is disabled or the alternate task ID for projects which have cost breakdown planning enabled | |
TASK_NUMBER | VARCHAR2 | (278) | The task number for projects for which cost breakdown planning is disabled or the alternate task number for projects which have cost breakdown planning enabled | |
TASK_NAME | VARCHAR2 | (263) | The task name for projects for which cost breakdown planning is disabled or the alternate task name for projects which have cost breakdown planning enabled | |
INDENTED_TASK_NAME | VARCHAR2 | (4000) | ||
START_DATE | DATE | |||
LABOR_COST_MULTIPLIER_NAME | VARCHAR2 | (20) | ||
COMPLETION_DATE | DATE | |||
CHARGEABLE_FLAG | VARCHAR2 | (1) | ||
WBS_SORT_ORDER | VARCHAR2 | (2000) | ||
ALLOW_CROSS_CHARGE_FLAG | VARCHAR2 | (1) | Flag to indicate whether cross charge are allowed | |
PROJECT_RATE_DATE | DATE | Task level default value for project rate date | ||
PROJECT_RATE_TYPE | VARCHAR2 | (30) | Task level default value for project rate type | |
BILLABLE_FLAG | VARCHAR2 | (1) | ||
TASK_ORGANIZATION | NUMBER | (15) | ||
TASK_DESCRIPTION | VARCHAR2 | (250) | ||
EXPENDITURE_ORG_ID | NUMBER | (15) | ||
CBS_ELEMENT_ID | NUMBER | The unique identifier of the cost breakdown structure element | ||
COST_CODE | VARCHAR2 | (250) | The unique cost code generated for the cost attribute | |
COST_CODE_NAME | VARCHAR2 | (240) | The cost code name | |
ACTUAL_TASK_ID | NUMBER | (15) | The system generated unique task identifier | |
TOP_TASK_ID | NUMBER | (15) | The identifier of the top task. If this is a top task, this value is the task ID | |
TASK_MANAGER_PERSON_ID | NUMBER | (9) | The identifier of the employee who manages the task |
Cut, paste (and edit) the following text to query this object:
SELECT PROJECT_ID
, PROJECT_NUMBER
, TASK_ID
, TASK_NUMBER
, TASK_NAME
, INDENTED_TASK_NAME
, START_DATE
, LABOR_COST_MULTIPLIER_NAME
, COMPLETION_DATE
, CHARGEABLE_FLAG
, WBS_SORT_ORDER
, ALLOW_CROSS_CHARGE_FLAG
, PROJECT_RATE_DATE
, PROJECT_RATE_TYPE
, BILLABLE_FLAG
, TASK_ORGANIZATION
, TASK_DESCRIPTION
, EXPENDITURE_ORG_ID
, CBS_ELEMENT_ID
, COST_CODE
, COST_CODE_NAME
, ACTUAL_TASK_ID
, TOP_TASK_ID
, TASK_MANAGER_PERSON_ID
FROM APPS.PA_TASKS_ALL_EXPEND_V;
|
|
|