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


VIEW: APPS.WIP_SCHEDULING_ERRORS_V

Object Details
Object Name: WIP_SCHEDULING_ERRORS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewWIP.WIP_SCHEDULING_ERRORS_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
GROUP_ID NUMBER
Yes Group ID to batch records
PROCESS_PHASE_MEANING VARCHAR2 (80)
Process Phase
PROCESS_STATUS_MEANING VARCHAR2 (80)
Process Status
WIP_ENTITY_NAME VARCHAR2 (240)
Job Name
ERROR VARCHAR2 (500)
Error Message
SCHEDULING_LEVEL_MEANING VARCHAR2 (80)
Indicates whether scheduling at the operation or resource level
OPERATION_SEQ_NUM NUMBER

Operation Sequence
OPERATION_START_DATE DATE

Operation Start Date
OPERATION_COMPLETION_DATE DATE

Operation Completion Date
RESOURCE_SEQ_NUM NUMBER

Resource Sequence
RESOURCE_START_DATE DATE

Resource Start Date
RESOURCE_COMPLETION_DATE DATE

Resource Completion Date
USAGE_RATE_OR_AMOUNT NUMBER

Usage Rate or Amount
SCHEDULING_LEVEL NUMBER
Yes Scheduling Level
WIP_ENTITY_ID NUMBER
Yes Wip Entity Id
ORGANIZATION_ID NUMBER
Yes Organization Id
PROCESS_PHASE NUMBER
Yes Process Phase
PROCESS_STATUS NUMBER
Yes Process Status
INTERFACE_ID NUMBER
Yes Interface Identifier
Query Text

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


SELECT GROUP_ID
,      PROCESS_PHASE_MEANING
,      PROCESS_STATUS_MEANING
,      WIP_ENTITY_NAME
,      ERROR
,      SCHEDULING_LEVEL_MEANING
,      OPERATION_SEQ_NUM
,      OPERATION_START_DATE
,      OPERATION_COMPLETION_DATE
,      RESOURCE_SEQ_NUM
,      RESOURCE_START_DATE
,      RESOURCE_COMPLETION_DATE
,      USAGE_RATE_OR_AMOUNT
,      SCHEDULING_LEVEL
,      WIP_ENTITY_ID
,      ORGANIZATION_ID
,      PROCESS_PHASE
,      PROCESS_STATUS
,      INTERFACE_ID
FROM APPS.WIP_SCHEDULING_ERRORS_V;

Dependencies

[top of page]

APPS.WIP_SCHEDULING_ERRORS_V references the following:

SchemaAPPS
ViewMFG_LOOKUPS
SynonymWIP_ENTITIES
SynonymWIP_INTERFACE_ERRORS
SynonymWIP_SCHEDULING_INTERFACE

APPS.WIP_SCHEDULING_ERRORS_V is not referenced by any database object