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

VIEW: APPS.MRP_SNAPSHOT_TASKS_V

Object Details
Object Name: MRP_SNAPSHOT_TASKS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMRP.MRP_SNAPSHOT_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
TASK NUMBER
Yes Task type
DEPENDENT_TASK NUMBER

Task which must be executed before this task
DEPENDENT_TASK2 NUMBER

Task which must be executed before this task
ORGANIZATION_ID NUMBER
Yes Organization identifier
COMPILE_DESIGNATOR VARCHAR2 (10) Yes MPS, MRP or DRP plan identifier
TASK_TEXT VARCHAR2 (80) Yes Task meaning
DEPENDENT_TASK_TEXT VARCHAR2 (80)
Dependent task meaning
DEPENDENT_TASK2_TEXT VARCHAR2 (80)
Dependent task meaning
DEPENDENT_TASK3_TEXT VARCHAR2 (80)
Dependent task meaning
START_DATE DATE

Date the task was started
COMPLETION_DATE DATE

Date task was completed
DURATION VARCHAR2 (8)
Duration of task
REQUEST_ID NUMBER

Concurrent Who column
REQUIRES_LOCK NUMBER
Yes Flag to indicate if the task requires a snapshot lock
Query Text

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


SELECT TASK
,      DEPENDENT_TASK
,      DEPENDENT_TASK2
,      ORGANIZATION_ID
,      COMPILE_DESIGNATOR
,      TASK_TEXT
,      DEPENDENT_TASK_TEXT
,      DEPENDENT_TASK2_TEXT
,      DEPENDENT_TASK3_TEXT
,      START_DATE
,      COMPLETION_DATE
,      DURATION
,      REQUEST_ID
,      REQUIRES_LOCK
FROM APPS.MRP_SNAPSHOT_TASKS_V;

Dependencies

[top of page]

APPS.MRP_SNAPSHOT_TASKS_V references the following:

SchemaAPPS
ViewMFG_LOOKUPS
SynonymMRP_PLANS
SynonymMRP_SNAPSHOT_TASKS

APPS.MRP_SNAPSHOT_TASKS_V is not referenced by any database object