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

VIEW: APPS.PA_STRUCT_TASKS_AMG_V

Object Details
Object Name: PA_STRUCT_TASKS_AMG_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_STRUCT_TASKS_AMG_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


This view provides a list of structure versions


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Identifies the row ID
TASK_ID NUMBER (15)
The system-generated number that uniquely identifies the task
PROJECT_ID NUMBER (15)
The identifier of the project to which the task belongs
TASK_NUMBER VARCHAR2 (100)
User-generated number that uniquely identifies the task within a project
CREATION_DATE DATE

Standard Who Column
CREATED_BY NUMBER (15)
Standard Who Column
LAST_UPDATE_DATE DATE

Standard Who Column
LAST_UPDATED_BY NUMBER (15)
Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
TASK_NAME VARCHAR2 (240)
User-defined short name of the task
LONG_TASK_NAME VARCHAR2 (240)
User-defined long name of the task
TOP_TASK_ID NUMBER (15)
The identifier of the top task to which this task rolls up. If the task is a top task, the top_task_id is set to its own task_id
WBS_LEVEL NUMBER (3)
Identifies the hierarchical level of the task version within a structure version
READY_TO_BILL_FLAG VARCHAR2 (1)
Flag that indicates whether the task is authorized to be invoiced. The flag is only set for top tasks, defaults to Y upon creation of the task
READY_TO_DISTRIBUTE_FLAG VARCHAR2 (1)
Flag that indicates whether the task is authorized for revenue accrual. The flag is only set for top tasks, defaults to Y upon creation of the task
PARENT_TASK_ID NUMBER

The identifier of the task that is the parent of the task in the project work breakdown structure
DESCRIPTION VARCHAR2 (2000)
User-defined description of the task
CARRYING_OUT_ORGANIZATION_ID NUMBER (15)
The identifier of the organization that is responsible for the task work
SERVICE_TYPE_CODE VARCHAR2 (30)
The type of work performed on the task
TASK_MANAGER_PERSON_ID NUMBER

The identifier of the employee that manages the task
CHARGEABLE_FLAG VARCHAR2 (1)
Flag that indicates if expenditure items can be charged to the task. Only lowest level tasks can be chargeable
BILLABLE_FLAG VARCHAR2 (1)
Default flag for items charged to the task that indicates if the item can accrue revenue ( Y or N). For capital projects this flag is used as capitalizable_flag. For indirect projects this flag is set to N and is not used
LIMIT_TO_TXN_CONTROLS_FLAG VARCHAR2 (1)
Flag that indicates if users can only charge expenditures to the task that are listed in the transaction controls. If flag = Y, then only items listed in the controls are allowed. If flag = N or null, then items not listed are allowed
START_DATE DATE

The date on which the task starts
COMPLETION_DATE DATE

The date on which the task is completed
ADDRESS_ID NUMBER (15)
The identifier of the customer address that is the task work site
LABOR_BILL_RATE_ORG_ID NUMBER (15)
The identifier of the organization that owns the labor standard bill rate schedule
LABOR_STD_BILL_RATE_SCHDL VARCHAR2 (20)
The labor standard bill rate schedule that is used to calculate revenue for labor expenditure items charged to the task
LABOR_SCHEDULE_FIXED_DATE DATE

The date used to determine the effective bill rates of the task standard labor bill rate schedule. If no fixed date is entered, the expenditure item date is used to determine the effective bill rate for the item
LABOR_SCHEDULE_DISCOUNT NUMBER (7)
The percentage to be discounted from the task standard labor bill rate schedule
NON_LABOR_BILL_RATE_ORG_ID NUMBER (15)
The identifier of the organization that owns the non-labor standard bill rate schedule
NON_LABOR_STD_BILL_RATE_SCHDL VARCHAR2 (30)
The non-labor standard bill rate schedule that is used to calculate revenue for non-labor expenditure items charged to the task
NON_LABOR_SCHEDULE_FIXED_DATE DATE

The fixed date used to determine the effective bill rates of the standard non-labor bill rate schedule. . If no fixed date is entered, the expenditure item date is used to determine the effective bill rate for the item
NON_LABOR_SCHEDULE_DISCOUNT NUMBER (7)
The percentage to be discounted from the standard non-labor bill rate schedule
LABOR_COST_MULTIPLIER_NAME VARCHAR2 (20)
The labor cost multiplier defined for a task of a premium project
REQUEST_ID NUMBER

Standard Who Column
PROGRAM_APPLICATION_ID NUMBER

Standard Who Column
PROGRAM_ID NUMBER

Standard Who Column
PROGRAM_UPDATE_DATE DATE

Standard Who Column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield context field
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
COST_IND_RATE_SCH_ID NUMBER (15)
The identifier of the default costing burden schedule
REV_IND_RATE_SCH_ID NUMBER (15)
The identifier of the default revenue burden schedule
INV_IND_RATE_SCH_ID NUMBER (15)
The identifier of the default invoice burden schedule
COST_IND_SCH_FIXED_DATE DATE

The schedule fixed date of firm costing burden schedule
REV_IND_SCH_FIXED_DATE DATE

The schedule fixed date of firm revenue burden schedule
INV_IND_SCH_FIXED_DATE DATE

The schedule fixed date of firm invoice burden schedule
LABOR_SCH_TYPE VARCHAR2 (1)
The schedule type of labor expenditure items
NON_LABOR_SCH_TYPE VARCHAR2 (1)
The schedule type of non-labor expenditure items
PM_TASK_REFERENCE VARCHAR2 (25)
The identifier of the task in the external project management system from which the task was imported
PM_PRODUCT_CODE VARCHAR2 (30)
The identifier of the external project management system from which the task was imported
CHILD_INDICATOR VARCHAR2 (1)
Indicates this task has subtasks
ACTUAL_START_DATE DATE

Actual start date of the task
ACTUAL_FINISH_DATE DATE

Actual finish date of the task
EARLY_START_DATE DATE

Early start date of the task
EARLY_FINISH_DATE DATE

Early finish date of the task
LATE_START_DATE DATE

Late start date of the task
LATE_FINISH_DATE DATE

Late finish date of the task
SCHEDULED_START_DATE DATE

Scheduled start date of the task
SCHEDULED_FINISH_DATE DATE

Scheduled finish date of the task
PRIORITY_CODE VARCHAR2 (30)
The task priority
DISPLAY_SEQUENCE NUMBER (15)
Identifies the display order of the task version within a structure version
WBS_NUMBER VARCHAR2 (240)
System-generated formatted number for the task version, indicating the exact position of the task version in the structure version
WQ_ITEM_CODE VARCHAR2 (30)
Work Item for Work Quantity for the task
WQ_UOM_CODE VARCHAR2 (30)
Unit of Measure used for Work Quantity for the task
WQ_ACTUAL_ENTRY_CODE VARCHAR2 (30)
Method to enter the Actual Work Quantity Code
WQ_PLANNED_QUANTITY NUMBER (17)
Planned Work Quantity for the task
TYPE_ID NUMBER (15)
Unique identifier for the task type
MILESTONE_FLAG VARCHAR2 (1)
Flag that indicates if the task version is a milestone (Y or N)
CRITICAL_FLAG VARCHAR2 (1)
Flag that indicates if the task version is part of the critical path (Y or N)
STATUS_CODE VARCHAR2 (150)
Status of the task version
ELEMENT_VERSION_ID NUMBER (15)
Unique identifier for the project element
PARENT_STRUCTURE_VERSION_ID NUMBER (15)
Unique identifier for the parent structure version
WORK_TYPE_ID NUMBER (15)
Unique identifier for the work type
PLANNED_EFFORT NUMBER

Planned Effort for the task
TASK_MANAGER_NAME VARCHAR2 (240)
The name of the person who manages the task
TASK_TYPE_NAME VARCHAR2 (150)
Implementation-defined name that uniquely identifies the task type
WORK_TYPE_NAME VARCHAR2 (80)
User-defined name that uniquely identifies the work type
DEPENDENCIES VARCHAR2 (4000)
For future use
SCHEDULED_DURATION_DAYS NUMBER

The duration between scheduled start date and scheduled end date using work calendar
CONSTRAINT_DATE DATE

Constraint Date for the task version
CONSTRAINT_TYPE VARCHAR2 (4000)
Constraint Type for the task version
CONSTRAINT_TYPE_CODE VARCHAR2 (30)
Constraint Type Code as in schedule information
FREE_SLACK NUMBER (15)
Free Slack for the task version
TOTAL_SLACK NUMBER (15)
Total Slack for the task version
PREDECESSORS VARCHAR2 (4000)
Predecessors for the task version
LEVEL_ASSIGNMENTS_FLAG VARCHAR2 (1)
Flag to determine if the assignments on this task should be leveled
EFFORT_DRIVEN_FLAG VARCHAR2 (1)
Flag to determine if the task is effort driven
FINANCIAL_TASK_FLAG VARCHAR2 (1)
To indicate a task can be used for financial management
SCHEDULING_TASK_TYPE_CODE VARCHAR2 (30)
Scheduling Tool Task Type for the task version
MAPPED_FINANCIAL_TASK_ID NUMBER

Mapped Financial Task Id
MAPPED_FINANCIAL_TASK_NAME VARCHAR2 (4000)
Mapped Financial Task Name
MAPPED_WORKPLAN_TASK_IDS VARCHAR2 (4000)
Comma separated list of workplan task ids, mapped to this financial task
MAPPED_WORKPLAN_TASK_NAMES VARCHAR2 (4000)
Comma separated list of workplan task names, mapped to this financial task
STRUCTURE_TYPE VARCHAR2 (150)
Structure Type: Workplan or Financial
EXTERNAL_SCHEDULE_DURATION NUMBER

The duration between scheduled start date and scheduled end date using work calendar for external source(Scheduling Tool)
EXTERNAL_ACTUAL_DURATION NUMBER

The Duration between actual start and actual finish date using work calendar for external source(Scheduling Tool)
EXTERNAL_REMAINING_DURATION NUMBER

The duration between scheduled finish date and current date using work calendar for external source(Scheduling Tool)
TASK_UNPUB_VER_STATUS_CODE VARCHAR2 (30)
indicates deleted or published status of task
PERCENT_COMPLETE NUMBER

The progress measured in percentage complete of task
ETC_EFFORT NUMBER

The remaining effort for task
Query Text

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


SELECT ROW_ID
,      TASK_ID
,      PROJECT_ID
,      TASK_NUMBER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      TASK_NAME
,      LONG_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
,      PM_TASK_REFERENCE
,      PM_PRODUCT_CODE
,      CHILD_INDICATOR
,      ACTUAL_START_DATE
,      ACTUAL_FINISH_DATE
,      EARLY_START_DATE
,      EARLY_FINISH_DATE
,      LATE_START_DATE
,      LATE_FINISH_DATE
,      SCHEDULED_START_DATE
,      SCHEDULED_FINISH_DATE
,      PRIORITY_CODE
,      DISPLAY_SEQUENCE
,      WBS_NUMBER
,      WQ_ITEM_CODE
,      WQ_UOM_CODE
,      WQ_ACTUAL_ENTRY_CODE
,      WQ_PLANNED_QUANTITY
,      TYPE_ID
,      MILESTONE_FLAG
,      CRITICAL_FLAG
,      STATUS_CODE
,      ELEMENT_VERSION_ID
,      PARENT_STRUCTURE_VERSION_ID
,      WORK_TYPE_ID
,      PLANNED_EFFORT
,      TASK_MANAGER_NAME
,      TASK_TYPE_NAME
,      WORK_TYPE_NAME
,      DEPENDENCIES
,      SCHEDULED_DURATION_DAYS
,      CONSTRAINT_DATE
,      CONSTRAINT_TYPE
,      CONSTRAINT_TYPE_CODE
,      FREE_SLACK
,      TOTAL_SLACK
,      PREDECESSORS
,      LEVEL_ASSIGNMENTS_FLAG
,      EFFORT_DRIVEN_FLAG
,      FINANCIAL_TASK_FLAG
,      SCHEDULING_TASK_TYPE_CODE
,      MAPPED_FINANCIAL_TASK_ID
,      MAPPED_FINANCIAL_TASK_NAME
,      MAPPED_WORKPLAN_TASK_IDS
,      MAPPED_WORKPLAN_TASK_NAMES
,      STRUCTURE_TYPE
,      EXTERNAL_SCHEDULE_DURATION
,      EXTERNAL_ACTUAL_DURATION
,      EXTERNAL_REMAINING_DURATION
,      TASK_UNPUB_VER_STATUS_CODE
,      PERCENT_COMPLETE
,      ETC_EFFORT
FROM APPS.PA_STRUCT_TASKS_AMG_V;

Dependencies

[top of page]

APPS.PA_STRUCT_TASKS_AMG_V references the following:

SchemaAPPS
SynonymPA_PROGRESS_ROLLUP
SynonymPA_PROJ_ELEMENTS
PL/SQL PackagePA_PROJ_ELEMENTS_UTILS - show dependent code
SynonymPA_PROJ_ELEMENT_VERSIONS
SynonymPA_PROJ_ELEM_VER_SCHEDULE
SynonymPA_PROJ_STRUCTURE_TYPES
PL/SQL PackagePA_PROJ_STRUC_MAPPING_UTILS - show dependent code
PL/SQL PackagePA_PROJ_TASK_STRUC_PUB - show dependent code
SynonymPA_STRUCTURE_TYPES
SynonymPA_TASKS
SynonymPA_TASK_TYPES
PL/SQL PackagePA_TASK_UTILS - show dependent code
ViewPA_WORK_TYPES_VL
SynonymPER_ALL_PEOPLE_F
ViewPJI_XBS_PLANS_PRJ_V

APPS.PA_STRUCT_TASKS_AMG_V is not referenced by any database object