eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.WIP_SCHEDULING_EXCEPTIONS_V

Object Details

Object Name:	WIP_SCHEDULING_EXCEPTIONS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	WIP.WIP_SCHEDULING_EXCEPTIONS_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
JOB_NAME	VARCHAR2	(240)	Yes
JOB_DESC	VARCHAR2	(240)
ASSEMBLY	VARCHAR2	(40)
ASSEMBLY_DESC	VARCHAR2	(240)
PRIMARY_ITEM_ID	NUMBER
SCHEDULING_SOURCE_TYPE	VARCHAR2	(30)
SCHEDULING_SOURCE_ID	NUMBER
MESG_SEQUENCE	NUMBER		Yes
MESSAGE_TYPE	NUMBER
MESSAGE_TEXT	VARCHAR2	(1000)	Yes
MARKED_FLAG	VARCHAR2	(1)
REPORTED_DATE	DATE		Yes
STATUS_TYPE	NUMBER		Yes
SCHEDULED_COMPLETION_DATE	DATE		Yes
DUE_DATE	DATE
SCHEDULING_PRIORITY	NUMBER
WIP_ENTITY_ID	NUMBER		Yes
ORGANIZATION_ID	NUMBER		Yes
OPERATION_SEQ_NUM	NUMBER
RESOURCE_SEQ_NUM	NUMBER
RESOURCE_CODE	VARCHAR2	(10)
RESOURCE_ID	NUMBER
COMPONENT_NAME	VARCHAR2	(40)		Component Name for material exception
COMPONENT_ID	NUMBER			Component Identifier
INSTANCE_ID	NUMBER
SERIAL_NUMBER	VARCHAR2	(30)
START_DATE	DATE

Query Text

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


SELECT JOB_NAME
,      JOB_DESC
,      ASSEMBLY
,      ASSEMBLY_DESC
,      PRIMARY_ITEM_ID
,      SCHEDULING_SOURCE_TYPE
,      SCHEDULING_SOURCE_ID
,      MESG_SEQUENCE
,      MESSAGE_TYPE
,      MESSAGE_TEXT
,      MARKED_FLAG
,      REPORTED_DATE
,      STATUS_TYPE
,      SCHEDULED_COMPLETION_DATE
,      DUE_DATE
,      SCHEDULING_PRIORITY
,      WIP_ENTITY_ID
,      ORGANIZATION_ID
,      OPERATION_SEQ_NUM
,      RESOURCE_SEQ_NUM
,      RESOURCE_CODE
,      RESOURCE_ID
,      COMPONENT_NAME
,      COMPONENT_ID
,      INSTANCE_ID
,      SERIAL_NUMBER
,      START_DATE
FROM APPS.WIP_SCHEDULING_EXCEPTIONS_V;

Dependencies

[top of page]

APPS.WIP_SCHEDULING_EXCEPTIONS_V references the following:

APPS: BOM_RESOURCES; MTL_SYSTEM_ITEMS_KFV; WIP_DISCRETE_JOBS; WIP_ENTITIES; WIP_OPERATION_RESOURCES; WIP_SCHEDULING_EXCEPTIONS

APPS.WIP_SCHEDULING_EXCEPTIONS_V is not referenced by any database object