eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.PA_FIN_STRUCTURES_TASKS_V

Object Details

Object Name:	PA_FIN_STRUCTURES_TASKS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_FIN_STRUCTURES_TASKS_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ELEMENT_NUMBER	VARCHAR2	(100)		User-defined alphanumeric character that uniquely identifies the element within a project or structure
ELEMENT_NAME	VARCHAR2	(240)		User-defined long name of the element. This value is used for scheduling, progress reporting, and should be used for any new functionality related to Oracle Projects.
DESCRIPTION	VARCHAR2	(2000)		Description of the element
OBJECT_TYPE	VARCHAR2	(30)	Yes	The type of the object for the element. The value can be TASK or STRUCTURE.
ELEMENT_VERSION_ID	NUMBER	(15)	Yes	The identifier of the element version
PROJ_ELEMENT_ID	NUMBER	(15)	Yes	The identifier of the project element
PROJECT_ID	NUMBER	(15)	Yes	The identifier of the project to which the structure version or task version belongs
DISPLAY_SEQUENCE	NUMBER	(15)		Identifies the display order of the task version within a structure version. This is a task-specific attribute.
PARENT_ELEMENT_VERSION_ID	NUMBER	(15)		The identifier of the parent element version
PARENT_OBJECT_TYPE	VARCHAR2	(30)	Yes	The type of the object for the parent element. The value can be TASK or STRUCTURE.
RELATIONSHIP_TYPE	VARCHAR2	(30)	Yes	The relationship type with respect to the parent
RELATIONSHIP_SUBTYPE	VARCHAR2	(30)		The relationship subtype with respect to the parent
SUMMARY_ELEMENT_FLAG	VARCHAR2	(4000)		Flag that indicates if the task version is a summary task. This is a task-specific attribute.
TASK_MANAGER_ID	NUMBER	(15)		The identifier of the person who manages the task. This is a task-specific attribute.
TASK_MANAGER	VARCHAR2	(240)		The name of the person who manages the task. This is a task-specific attribute.
PARENT_STRUCTURE_VERSION_ID	NUMBER	(15)		The identifier of the structure version to which the task version belongs
WBS_LEVEL	NUMBER	(3)		Identifies the hierarchical level of the task version within a structure version. This is a task-specific attribute.
WBS_NUMBER	VARCHAR2	(240)		System-generated formatted number for a task version. This is a task-specific attribute.
ELEM_REC_VER_NUMBER	NUMBER	(15)		Record version number for the project element
ELEM_VER_REC_VER_NUMBER	NUMBER	(15)		Record version number for the project element version
PARENT_VER_REC_VER_NUMBER	NUMBER	(15)
STATUS_CODE	VARCHAR2	(150)		The status code
STATUS_CODE_MEANING	VARCHAR2	(80)		The meaning of the status
PRIORITY_CODE	VARCHAR2	(30)		The priority of the task. This is a task-specific attribute.
PRIORITY_DESCRIPTION	VARCHAR2	(4000)		The description of the priority
ORGANIZATION_ID	NUMBER	(15)		The identifier of the organization that is responsible for the work. The task organization is copied from the project organization when the task is created. This is a task-specific attribute.
ORGANIZATION_NAME	VARCHAR2	(240)		The name of the organization that is responsible for the work
OBJECT_RELATIONSHIP_ID	NUMBER		Yes	The identifier of the relationship
OBJECT_REC_VER_NUMBER	NUMBER			Record version number for the relationship
LATEST_EFF_PUBLISHED_FLAG	VARCHAR2	(1)		Flag to indicate that this structure version is the latest published version for each purpose
PROJECT_NUMBER	VARCHAR2	(25)	Yes	The number of the project
PROJECT_NAME	VARCHAR2	(30)	Yes	The name of the project
PARENT_ELEMENT_ID	NUMBER	(15)		The identifier of the parent element
STRUCTURE_TYPE_CLASS_CODE	VARCHAR2	(30)		The class of structure type
PUBLISHED_DATE	DATE			The date that the structure version was published
LINK_TASK_FLAG	VARCHAR2	(1)
DISPLAY_PARENT_VERSION_ID	NUMBER	(15)
BASELINE_START_DATE	DATE
BASELINE_FINISH_DATE	DATE
PM_SOURCE_NAME	VARCHAR2	(4000)
PM_SOURCE_CODE	VARCHAR2	(30)
PM_SOURCE_REFERENCE	VARCHAR2	(25)
ACTIVE_TASK_FLAG	VARCHAR2	(4000)
ACTIVE_TASK_MEANING	VARCHAR2	(4000)
DAYS_TO_SCH_START	NUMBER
DAYS_TO_SCH_FINISH	NUMBER
WORK_TELEPHONE	VARCHAR2	(60)
SERVICE_TYPE_MEANING	VARCHAR2	(4000)
SERVICE_TYPE_CODE	VARCHAR2	(30)
WORK_TYPE_NAME	VARCHAR2	(80)
WORK_TYPE_ID	NUMBER	(15)
CHARGEABLE_MEANING	VARCHAR2	(4000)
CHARGEABLE_FLAG	VARCHAR2	(1)
BILLABLE_MEANING	VARCHAR2	(4000)
BILLABLE_FLAG	VARCHAR2	(1)
RECEIVE_PROJECT_INVOICE_M	VARCHAR2	(4000)
RECEIVE_PROJECT_INVOICE_FLAG	VARCHAR2	(1)
TRANSACTION_CTRL_START_DATE	DATE
TRANSACTION_CTRL_FINISH_DATE	DATE
TRANSACTION_AS_OF_DATE	DATE
BASELINE_AS_OF_DATE	DATE
FINANCIAL_TASK_FLAG	VARCHAR2	(1)
TASK_CREATION_DATE	DATE		Yes
LOWEST_TASK_MEANING	VARCHAR2	(4000)
TASK_TYPE_ID	NUMBER	(15)
TASK_TYPE	VARCHAR2	(150)	Yes
TASK_STATUS_CODE	VARCHAR2	(150)
TASK_STATUS_MEANING	VARCHAR2	(80)
ADDRESS_ID	NUMBER	(15)
ADDRESS1	VARCHAR2	(240)
ADDRESS2	VARCHAR2	(240)
ADDRESS3	VARCHAR2	(240)
ADDRESS4	VARCHAR2	(426)
STRUCT_PUBLISHED_FLAG	VARCHAR2	(4000)
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
TASK_UNPUB_VER_STATUS_CODE	VARCHAR2	(30)
OPEN_ISSUES	NUMBER
OPEN_CHANGE_DOCUMENTS	NUMBER
CHILD_ELEMENT_FLAG	VARCHAR2	(4000)
OPEN_CHANGE_REQUESTS	NUMBER
OPEN_CHANGE_ORDERS	NUMBER
TASK_STATUS	VARCHAR2	(80)		This column stores the status of tasks created using the Change Management flow.
TASK_APPROVER_ID	NUMBER			This column stores the ID of the user who approved the tasks created using the Change Management flow.

Query Text

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


SELECT ELEMENT_NUMBER
,      ELEMENT_NAME
,      DESCRIPTION
,      OBJECT_TYPE
,      ELEMENT_VERSION_ID
,      PROJ_ELEMENT_ID
,      PROJECT_ID
,      DISPLAY_SEQUENCE
,      PARENT_ELEMENT_VERSION_ID
,      PARENT_OBJECT_TYPE
,      RELATIONSHIP_TYPE
,      RELATIONSHIP_SUBTYPE
,      SUMMARY_ELEMENT_FLAG
,      TASK_MANAGER_ID
,      TASK_MANAGER
,      PARENT_STRUCTURE_VERSION_ID
,      WBS_LEVEL
,      WBS_NUMBER
,      ELEM_REC_VER_NUMBER
,      ELEM_VER_REC_VER_NUMBER
,      PARENT_VER_REC_VER_NUMBER
,      STATUS_CODE
,      STATUS_CODE_MEANING
,      PRIORITY_CODE
,      PRIORITY_DESCRIPTION
,      ORGANIZATION_ID
,      ORGANIZATION_NAME
,      OBJECT_RELATIONSHIP_ID
,      OBJECT_REC_VER_NUMBER
,      LATEST_EFF_PUBLISHED_FLAG
,      PROJECT_NUMBER
,      PROJECT_NAME
,      PARENT_ELEMENT_ID
,      STRUCTURE_TYPE_CLASS_CODE
,      PUBLISHED_DATE
,      LINK_TASK_FLAG
,      DISPLAY_PARENT_VERSION_ID
,      BASELINE_START_DATE
,      BASELINE_FINISH_DATE
,      PM_SOURCE_NAME
,      PM_SOURCE_CODE
,      PM_SOURCE_REFERENCE
,      ACTIVE_TASK_FLAG
,      ACTIVE_TASK_MEANING
,      DAYS_TO_SCH_START
,      DAYS_TO_SCH_FINISH
,      WORK_TELEPHONE
,      SERVICE_TYPE_MEANING
,      SERVICE_TYPE_CODE
,      WORK_TYPE_NAME
,      WORK_TYPE_ID
,      CHARGEABLE_MEANING
,      CHARGEABLE_FLAG
,      BILLABLE_MEANING
,      BILLABLE_FLAG
,      RECEIVE_PROJECT_INVOICE_M
,      RECEIVE_PROJECT_INVOICE_FLAG
,      TRANSACTION_CTRL_START_DATE
,      TRANSACTION_CTRL_FINISH_DATE
,      TRANSACTION_AS_OF_DATE
,      BASELINE_AS_OF_DATE
,      FINANCIAL_TASK_FLAG
,      TASK_CREATION_DATE
,      LOWEST_TASK_MEANING
,      TASK_TYPE_ID
,      TASK_TYPE
,      TASK_STATUS_CODE
,      TASK_STATUS_MEANING
,      ADDRESS_ID
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      STRUCT_PUBLISHED_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      TASK_UNPUB_VER_STATUS_CODE
,      OPEN_ISSUES
,      OPEN_CHANGE_DOCUMENTS
,      CHILD_ELEMENT_FLAG
,      OPEN_CHANGE_REQUESTS
,      OPEN_CHANGE_ORDERS
,      TASK_STATUS
,      TASK_APPROVER_ID
FROM APPS.PA_FIN_STRUCTURES_TASKS_V;

Dependencies

[top of page]

APPS.PA_FIN_STRUCTURES_TASKS_V references the following:

APPS: HR_ALL_ORGANIZATION_UNITS_TL; HZ_CUST_ACCT_SITES_ALL; HZ_LOCATIONS; HZ_PARTY_SITES; PA_CONTROL_ITEMS_UTILS - show dependent code; PA_LOOKUPS; PA_OBJECT_RELATIONSHIPS; PA_PROJECTS_ALL; PA_PROJECT_STATUSES; PA_PROJECT_STRUCTURE_UTILS - show dependent code; PA_PROJ_ELEMENTS; PA_PROJ_ELEMENTS_UTILS - show dependent code; PA_PROJ_ELEMENT_VERSIONS; PA_PROJ_ELEM_VER_STRUCTURE; PA_PROJ_STRUCTURE_TYPES; PA_STRUCTURE_TYPES; PA_TASKS; PA_TASK_TYPES; PA_WORK_TYPES_TL; PER_ALL_PEOPLE_F

APPS.PA_FIN_STRUCTURES_TASKS_V is not referenced by any database object