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

VIEW: MSC.MSC_EXCEPTION_DETAILS#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
EXCEPTION_DETAIL_ID NUMBER
Yes
EXCEPTION_TYPE NUMBER
Yes
QUANTITY NUMBER

DATE1 DATE

DATE2 DATE

DATE3 DATE

DATE4 DATE

NUMBER1 NUMBER

NUMBER2 NUMBER

NUMBER3 NUMBER

NUMBER4 NUMBER

CHAR1 VARCHAR2 (80)
CHAR2 VARCHAR2 (80)
PLAN_ID NUMBER
Yes
ORGANIZATION_ID NUMBER
Yes
INVENTORY_ITEM_ID NUMBER
Yes
RESOURCE_ID NUMBER
Yes
DEPARTMENT_ID NUMBER
Yes
SR_INSTANCE_ID NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

SUPPLIER_ID NUMBER

SUPPLIER_SITE_ID NUMBER

CUSTOMER_ID NUMBER

CUSTOMER_SITE_ID NUMBER

ORDER_NUMBER VARCHAR2 (240)
ORDER_REL_NUMBER VARCHAR2 (20)
ORDER_LINE_NUMBER VARCHAR2 (20)
END_ORDER_NUMBER VARCHAR2 (240)
END_ORDER_REL_NUMBER VARCHAR2 (20)
END_ORDER_LINE_NUMBER VARCHAR2 (20)
DATE5 DATE

NUMBER5 NUMBER

TRANSACTION_ID NUMBER

DEMAND_ID NUMBER

ACTION_TAKEN NUMBER

NUMBER6 NUMBER

NUMBER7 NUMBER

NUMBER8 NUMBER

CAUSE NUMBER

NEW_EXCEPTION NUMBER

ACTION_TAKEN_BY NUMBER

ACTION_TAKEN_DATE DATE

FIRST_GENERATED_DATE DATE

PART_CONDITION NUMBER

ZONE_ID NUMBER

DATE6 DATE

Query Text

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


SELECT EXCEPTION_DETAIL_ID
,      EXCEPTION_TYPE
,      QUANTITY
,      DATE1
,      DATE2
,      DATE3
,      DATE4
,      NUMBER1
,      NUMBER2
,      NUMBER3
,      NUMBER4
,      CHAR1
,      CHAR2
,      PLAN_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      RESOURCE_ID
,      DEPARTMENT_ID
,      SR_INSTANCE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      CUSTOMER_ID
,      CUSTOMER_SITE_ID
,      ORDER_NUMBER
,      ORDER_REL_NUMBER
,      ORDER_LINE_NUMBER
,      END_ORDER_NUMBER
,      END_ORDER_REL_NUMBER
,      END_ORDER_LINE_NUMBER
,      DATE5
,      NUMBER5
,      TRANSACTION_ID
,      DEMAND_ID
,      ACTION_TAKEN
,      NUMBER6
,      NUMBER7
,      NUMBER8
,      CAUSE
,      NEW_EXCEPTION
,      ACTION_TAKEN_BY
,      ACTION_TAKEN_DATE
,      FIRST_GENERATED_DATE
,      PART_CONDITION
,      ZONE_ID
,      DATE6
FROM MSC.MSC_EXCEPTION_DETAILS#;

Dependencies

[top of page]

MSC.MSC_EXCEPTION_DETAILS# references the following:

SchemaMSC
TableMSC_EXCEPTION_DETAILS
MSC.MSC_EXCEPTION_DETAILS# is referenced by following:

SchemaAPPS
SynonymMSC_EXCEPTION_DETAILS