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: ViewGMP.GMP_SCHEDULING_EXCEPTIONS_V
Subobject Name:
Status: VALID

View Type

MultiLingual view (a language resolved view of the data.)


Exception generated by Manufacturing Scheduler during scheduling run


[View Source]

Columns
Name Datatype Length Mandatory Comments
JOB_NAME VARCHAR2 (32) Yes
ORGANIZATION_CODE VARCHAR2 (3)
ASSEMBLY VARCHAR2 (40)
ASSEMBLY_DESC VARCHAR2 (240)
PRIMARY_ITEM_ID NUMBER
Yes
SCHEDULING_SOURCE VARCHAR2 (30)
SCHEDULING_SOURCE_ID NUMBER

MESG_SEQUENCE NUMBER
Yes
MESSAGE_TYPE NUMBER

REPORTED_DATE DATE
Yes
BATCH_STATUS NUMBER (5) Yes
PLANNED_START DATE
Yes
PLANNED_COMPLETION DATE
Yes
REQUIRED_COMPLETION DATE
Yes
SCHEDULING_PRIORITY NUMBER
Yes
WIP_ENTITY_ID NUMBER

ORGANIZATION_ID NUMBER
Yes
RECIPE_VALIDITY_RULE_ID NUMBER (10)
ROUTING_ID NUMBER (10)
FORMULA_ID NUMBER (10)
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:

SchemaAPPS
SynonymGMD_RECIPE_VALIDITY_RULES
SynonymGME_BATCH_HEADER
SynonymMTL_PARAMETERS
SynonymMTL_SYSTEM_ITEMS_KFV
SynonymWIP_SCHEDULING_EXCEPTIONS

APPS.GMP_SCHEDULING_EXCEPTIONS_V is not referenced by any database object