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

VIEW: MSC.MSC_EXC_DETAILS_ALL#

Object Details
Object Name: MSC_EXC_DETAILS_ALL#
Object Type: VIEW
Owner: MSC
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
EXCEPTION_DETAIL_ID NUMBER

EXCEPTION_TYPE NUMBER

QUANTITY NUMBER

ID_KEY VARCHAR2 (500)
COMPARE_KEY VARCHAR2 (500)
DATE1 DATE

DATE2 DATE

DATE3 DATE

DATE4 DATE

DATE5 DATE

NUMBER1 NUMBER

NUMBER2 NUMBER

NUMBER3 NUMBER

NUMBER4 NUMBER

NUMBER5 NUMBER

NUMBER6 NUMBER

CHAR1 VARCHAR2 (250)
CHAR2 VARCHAR2 (250)
CHAR3 VARCHAR2 (250)
CHAR4 VARCHAR2 (250)
CHAR5 VARCHAR2 (250)
CHAR6 VARCHAR2 (250)
CHAR7 VARCHAR2 (250)
CHAR8 VARCHAR2 (250)
CHAR9 VARCHAR2 (250)
CHAR10 VARCHAR2 (250)
CHAR11 VARCHAR2 (250)
CHAR12 VARCHAR2 (250)
CHAR13 VARCHAR2 (250)
PLAN_ID NUMBER

ORGANIZATION_ID NUMBER

SR_INSTANCE_ID NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

LOAD_RATIO NUMBER

ORGANIZATION_CODE VARCHAR2 (10)
Query Text

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


SELECT EXCEPTION_DETAIL_ID
,      EXCEPTION_TYPE
,      QUANTITY
,      ID_KEY
,      COMPARE_KEY
,      DATE1
,      DATE2
,      DATE3
,      DATE4
,      DATE5
,      NUMBER1
,      NUMBER2
,      NUMBER3
,      NUMBER4
,      NUMBER5
,      NUMBER6
,      CHAR1
,      CHAR2
,      CHAR3
,      CHAR4
,      CHAR5
,      CHAR6
,      CHAR7
,      CHAR8
,      CHAR9
,      CHAR10
,      CHAR11
,      CHAR12
,      CHAR13
,      PLAN_ID
,      ORGANIZATION_ID
,      SR_INSTANCE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LOAD_RATIO
,      ORGANIZATION_CODE
FROM MSC.MSC_EXC_DETAILS_ALL#;

Dependencies

[top of page]

MSC.MSC_EXC_DETAILS_ALL# references the following:

SchemaMSC
TableMSC_EXC_DETAILS_ALL
MSC.MSC_EXC_DETAILS_ALL# is referenced by following:

SchemaAPPS
SynonymMSC_EXC_DETAILS_ALL