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.GMP_SCHEDULING_EXCEPTIONS_V

Object Details

Object Name:	GMP_SCHEDULING_EXCEPTIONS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GMP.GMP_SCHEDULING_EXCEPTIONS_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

Scheduling Exceptions for OPM Batches

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
JOB_NAME	VARCHAR2	(32)	Yes	Batch Number
ORGANIZATION_CODE	VARCHAR2	(3)		Plant name
ASSEMBLY	VARCHAR2	(40)		Product Item Number
ASSEMBLY_DESC	VARCHAR2	(240)		Product Item description
PRIMARY_ITEM_ID	NUMBER		Yes	Product Item Id
SCHEDULING_SOURCE	VARCHAR2	(30)		Source for scheduling
SCHEDULING_SOURCE_ID	NUMBER			Id of scheduling source
MESG_SEQUENCE	NUMBER		Yes	Sequence number of the message
MESSAGE_TYPE	NUMBER			Type of message
REPORTED_DATE	DATE		Yes	Date of message
BATCH_STATUS	NUMBER	(5)	Yes	Status of Batch
PLANNED_START	DATE		Yes	Planned start date of batch
PLANNED_COMPLETION	DATE		Yes	Planned completion date of batch
REQUIRED_COMPLETION	DATE		Yes	Required completion date of batch
SCHEDULING_PRIORITY	NUMBER		Yes	Scheduling priority
WIP_ENTITY_ID	NUMBER			Batch Id
ORGANIZATION_ID	NUMBER		Yes	Plant Id
RECIPE_VALIDITY_RULE_ID	NUMBER	(10)		Reciep validity rule id of the batch
ROUTING_ID	NUMBER	(10)		Routing ID of the batch
FORMULA_ID	NUMBER	(10)		Formula ID

Query Text

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


SELECT JOB_NAME
,      ORGANIZATION_CODE
,      ASSEMBLY
,      ASSEMBLY_DESC
,      PRIMARY_ITEM_ID
,      SCHEDULING_SOURCE
,      SCHEDULING_SOURCE_ID
,      MESG_SEQUENCE
,      MESSAGE_TYPE
,      REPORTED_DATE
,      BATCH_STATUS
,      PLANNED_START
,      PLANNED_COMPLETION
,      REQUIRED_COMPLETION
,      SCHEDULING_PRIORITY
,      WIP_ENTITY_ID
,      ORGANIZATION_ID
,      RECIPE_VALIDITY_RULE_ID
,      ROUTING_ID
,      FORMULA_ID
FROM APPS.GMP_SCHEDULING_EXCEPTIONS_V;

Dependencies

[top of page]

APPS.GMP_SCHEDULING_EXCEPTIONS_V references the following:

APPS: GMD_RECIPE_VALIDITY_RULES; GME_BATCH_HEADER; MTL_PARAMETERS; MTL_SYSTEM_ITEMS_KFV; WIP_SCHEDULING_EXCEPTIONS

APPS.GMP_SCHEDULING_EXCEPTIONS_V is not referenced by any database object