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

VIEW: APPLSYS.FND_OAM_DSCRAM_STATS#

Object Details
Object Name: FND_OAM_DSCRAM_STATS#
Object Type: VIEW
Owner: APPLSYS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
STAT_ID NUMBER (15) Yes
RUN_STAT_ID NUMBER (15)
SOURCE_OBJECT_TYPE VARCHAR2 (30) Yes
SOURCE_OBJECT_ID NUMBER (15) Yes
OBJECT_START DATE

OBJECT_END DATE

PRESTART_OBJECT_STATUS VARCHAR2 (30)
POSTEND_OBJECT_STATUS VARCHAR2 (30)
CHILD_FIRST_START DATE

CHILD_LAST_START DATE

CHILD_LAST_END DATE

TOTAL_RUNTIME NUMBER (15)
PCT_DONE NUMBER (15)
STATS_LAST_COLLECTED DATE

DATAPOINTS_COLLECTED NUMBER (15)
DATAPOINTS_TOTAL NUMBER (15)
ERRORS_FOUND_FLAG VARCHAR2 (3)
FINISHED_INCOMPLETE_FLAG VARCHAR2 (3)
MESSAGE VARCHAR2 (4000)
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15) Yes
Query Text

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


SELECT STAT_ID
,      RUN_STAT_ID
,      SOURCE_OBJECT_TYPE
,      SOURCE_OBJECT_ID
,      OBJECT_START
,      OBJECT_END
,      PRESTART_OBJECT_STATUS
,      POSTEND_OBJECT_STATUS
,      CHILD_FIRST_START
,      CHILD_LAST_START
,      CHILD_LAST_END
,      TOTAL_RUNTIME
,      PCT_DONE
,      STATS_LAST_COLLECTED
,      DATAPOINTS_COLLECTED
,      DATAPOINTS_TOTAL
,      ERRORS_FOUND_FLAG
,      FINISHED_INCOMPLETE_FLAG
,      MESSAGE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPLSYS.FND_OAM_DSCRAM_STATS#;

Dependencies

[top of page]

APPLSYS.FND_OAM_DSCRAM_STATS# references the following:

SchemaAPPLSYS
TableFND_OAM_DSCRAM_STATS
APPLSYS.FND_OAM_DSCRAM_STATS# is referenced by following:

SchemaAPPS
SynonymFND_OAM_DSCRAM_STATS