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

TABLE: ISC.MLOG$_ISC_FS_TASK_ASSIGNMN

Object Details
Object Name: MLOG$_ISC_FS_TASK_ASSIGNMN
Object Type: TABLE
Owner: ISC
Subobject Name:
Status: VALID

snapshot log for master table ISC.ISC_FS_TASK_ASSIGNMNTS_F

Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
ACTUAL_EFFORT_HRS NUMBER

ACTUAL_END_DATE DATE

ACTUAL_START_DATE DATE

ACTUAL_TRAVEL_DISTANCE_KM NUMBER

ACTUAL_TRAVEL_DURATION_MIN NUMBER

ASSIGNMENT_CREATION_DATE DATE

CANCELLED_FLAG VARCHAR2 (1)
DELETED_FLAG VARCHAR2 (1)
DISTRICT_ID NUMBER

REPORT_DATE DATE

RESOURCE_ID NUMBER

RESOURCE_TYPE VARCHAR2 (8)
SCHED_TRAVEL_DISTANCE_KM NUMBER

SCHED_TRAVEL_DURATION_MIN NUMBER

TASK_ASSIGNMENT_ID NUMBER

TASK_ID NUMBER

M_ROW$$ VARCHAR2 (255)
SEQUENCE$$ NUMBER

SNAPTIME$$ DATE

DMLTYPE$$ VARCHAR2 (1)
OLD_NEW$$ VARCHAR2 (1)
CHANGE_VECTOR$$ RAW (255)
Query Text

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


SELECT ACTUAL_EFFORT_HRS
,      ACTUAL_END_DATE
,      ACTUAL_START_DATE
,      ACTUAL_TRAVEL_DISTANCE_KM
,      ACTUAL_TRAVEL_DURATION_MIN
,      ASSIGNMENT_CREATION_DATE
,      CANCELLED_FLAG
,      DELETED_FLAG
,      DISTRICT_ID
,      REPORT_DATE
,      RESOURCE_ID
,      RESOURCE_TYPE
,      SCHED_TRAVEL_DISTANCE_KM
,      SCHED_TRAVEL_DURATION_MIN
,      TASK_ASSIGNMENT_ID
,      TASK_ID
,      M_ROW$$
,      SEQUENCE$$
,      SNAPTIME$$
,      DMLTYPE$$
,      OLD_NEW$$
,      CHANGE_VECTOR$$
FROM ISC.MLOG$_ISC_FS_TASK_ASSIGNMN;

Dependencies

[top of page]

ISC.MLOG$_ISC_FS_TASK_ASSIGNMN does not reference any database object

ISC.MLOG$_ISC_FS_TASK_ASSIGNMN is referenced by following:

SchemaAPPS
SynonymMLOG$_ISC_FS_TASK_ASSIGNMN