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


VIEW: APPS.AST_TASKS_V

Object Details
Object Name: AST_TASKS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAST.AST_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

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
TASK_ID NUMBER
Yes
TASK_NUMBER VARCHAR2 (30) Yes
TASK_NAME VARCHAR2 (80) Yes
DESCRIPTION VARCHAR2 (4000)
TASK_TYPE_ID NUMBER
Yes
TASK_TYPE VARCHAR2 (30)
TASK_STATUS_ID NUMBER
Yes
TASK_STATUS VARCHAR2 (30) Yes
CLOSED VARCHAR2 (1)
CANCELLED VARCHAR2 (1)
COMPLETED VARCHAR2 (1)
REJECTED VARCHAR2 (1)
TASK_PRIORITY_ID NUMBER

TASK_PRIORITY VARCHAR2 (30)
OWNER_ID NUMBER
Yes
OWNER_TYPE_CODE VARCHAR2 (30) Yes
OWNER_TYPE VARCHAR2 (30) Yes
OWNER VARCHAR2 (4000)
SOURCE_OBJECT_ID NUMBER

SOURCE_OBJECT_NAME VARCHAR2 (80)
SOURCE_OBJECT_TYPE_CODE VARCHAR2 (30)
SOURCE_OBJECT_TYPE VARCHAR2 (30) Yes
REASON_CODE VARCHAR2 (30)
PRIVATE_FLAG VARCHAR2 (1)
PUBLISH_FLAG VARCHAR2 (1)
NOTIFICATION_FLAG VARCHAR2 (1)
CUSTOMER_ID NUMBER

ATTRIBUTE_CATEGORY VARCHAR2 (150)
Descriptive flexfield structure definition column.
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
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ASSIGNED_BY_ID NUMBER

ASSIGNED_BY_NAME VARCHAR2 (100)
CUST_ACCOUNT_ID NUMBER

ADDRESS_ID NUMBER

PLANNED_START_DATE DATE

NOTIFICATION_PERIOD NUMBER

NOTIFICATION_PERIOD_UOM VARCHAR2 (3)
PARENT_TASK_ID VARCHAR2 (0)
PARENT_TASK_NUMBER VARCHAR2 (0)
RECURRENCE_RULE_ID NUMBER

ALARM_START NUMBER

ALARM_START_UOM VARCHAR2 (3)
DELETED_FLAG VARCHAR2 (1)
ACTUAL_START_DATE DATE

ACTUAL_END_DATE DATE

DURATION NUMBER

DURATION_UOM VARCHAR2 (3)
PLANNED_EFFORT NUMBER

PLANNED_EFFORT_UOM VARCHAR2 (3)
ACTUAL_EFFORT NUMBER

ACTUAL_EFFORT_UOM VARCHAR2 (3)
PERCENTAGE_COMPLETE NUMBER

PLANNED_END_DATE DATE

SCHEDULED_START_DATE DATE

SCHEDULED_END_DATE DATE

OBJECT_VERSION_NUMBER NUMBER
Yes
OWNER_TERRITORY_ID NUMBER

Query Text

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


SELECT ROW_ID
,      TASK_ID
,      TASK_NUMBER
,      TASK_NAME
,      DESCRIPTION
,      TASK_TYPE_ID
,      TASK_TYPE
,      TASK_STATUS_ID
,      TASK_STATUS
,      CLOSED
,      CANCELLED
,      COMPLETED
,      REJECTED
,      TASK_PRIORITY_ID
,      TASK_PRIORITY
,      OWNER_ID
,      OWNER_TYPE_CODE
,      OWNER_TYPE
,      OWNER
,      SOURCE_OBJECT_ID
,      SOURCE_OBJECT_NAME
,      SOURCE_OBJECT_TYPE_CODE
,      SOURCE_OBJECT_TYPE
,      REASON_CODE
,      PRIVATE_FLAG
,      PUBLISH_FLAG
,      NOTIFICATION_FLAG
,      CUSTOMER_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ASSIGNED_BY_ID
,      ASSIGNED_BY_NAME
,      CUST_ACCOUNT_ID
,      ADDRESS_ID
,      PLANNED_START_DATE
,      NOTIFICATION_PERIOD
,      NOTIFICATION_PERIOD_UOM
,      PARENT_TASK_ID
,      PARENT_TASK_NUMBER
,      RECURRENCE_RULE_ID
,      ALARM_START
,      ALARM_START_UOM
,      DELETED_FLAG
,      ACTUAL_START_DATE
,      ACTUAL_END_DATE
,      DURATION
,      DURATION_UOM
,      PLANNED_EFFORT
,      PLANNED_EFFORT_UOM
,      ACTUAL_EFFORT
,      ACTUAL_EFFORT_UOM
,      PERCENTAGE_COMPLETE
,      PLANNED_END_DATE
,      SCHEDULED_START_DATE
,      SCHEDULED_END_DATE
,      OBJECT_VERSION_NUMBER
,      OWNER_TERRITORY_ID
FROM APPS.AST_TASKS_V;

Dependencies

[top of page]

APPS.AST_TASKS_V references the following:

SchemaAPPS
SynonymFND_USER
ViewJTF_OBJECTS_VL
ViewJTF_TASKS_VL
SynonymJTF_TASK_PRIORITIES_TL
ViewJTF_TASK_STATUSES_VL
SynonymJTF_TASK_TYPES_TL
PL/SQL PackageJTF_TASK_UTL - show dependent code

APPS.AST_TASKS_V is not referenced by any database object