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

VIEW: APPLSYS.AD_ADOP_SESSIONS#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
ADOP_SESSION_ID NUMBER
Yes
PREPARE_STATUS VARCHAR2 (1) Yes
APPLY_STATUS VARCHAR2 (1) Yes
FINALIZE_STATUS VARCHAR2 (1) Yes
CUTOVER_STATUS VARCHAR2 (1) Yes
CLEANUP_STATUS VARCHAR2 (1) Yes
ABORT_STATUS VARCHAR2 (1) Yes
STATUS VARCHAR2 (1) Yes
NODE_NAME VARCHAR2 (31)
NODE_TYPE VARCHAR2 (30)
APPLTOP_ID NUMBER

EDITION_NAME VARCHAR2 (30)
PID NUMBER

ABANDON_FLAG NUMBER

SESSION_INPUT_DATA CLOB (4000)
PREPARE_START_DATE DATE

PREPARE_END_DATE DATE

FINALIZE_START_DATE DATE

FINALIZE_END_DATE DATE

APPLY_START_DATE DATE

APPLY_END_DATE DATE

CUTOVER_START_DATE DATE

CUTOVER_END_DATE DATE

CLEANUP_START_DATE DATE

CLEANUP_END_DATE DATE

ABORT_START_DATE DATE

ABORT_END_DATE DATE

Query Text

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


SELECT ADOP_SESSION_ID
,      PREPARE_STATUS
,      APPLY_STATUS
,      FINALIZE_STATUS
,      CUTOVER_STATUS
,      CLEANUP_STATUS
,      ABORT_STATUS
,      STATUS
,      NODE_NAME
,      NODE_TYPE
,      APPLTOP_ID
,      EDITION_NAME
,      PID
,      ABANDON_FLAG
,      SESSION_INPUT_DATA
,      PREPARE_START_DATE
,      PREPARE_END_DATE
,      FINALIZE_START_DATE
,      FINALIZE_END_DATE
,      APPLY_START_DATE
,      APPLY_END_DATE
,      CUTOVER_START_DATE
,      CUTOVER_END_DATE
,      CLEANUP_START_DATE
,      CLEANUP_END_DATE
,      ABORT_START_DATE
,      ABORT_END_DATE
FROM APPLSYS.AD_ADOP_SESSIONS#;

Dependencies

[top of page]

APPLSYS.AD_ADOP_SESSIONS# references the following:

SchemaAPPLSYS
TableAD_ADOP_SESSIONS
APPLSYS.AD_ADOP_SESSIONS# is referenced by following:

SchemaAPPS
SynonymAD_ADOP_SESSIONS