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

VIEW: APPS.WIPBV_MFG_ORDERS

Object Details
Object Name: WIPBV_MFG_ORDERS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewWIP.WIPBV_MFG_ORDERS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


This shows information about manufacturing orders (discrete jobs, repetitive schedules and flow schedules). This information is used to control production activities and maintain entity name uniqueness.


[View Source]

Columns
Name Datatype Length Mandatory Comments
MFG_ORDER_NAME VARCHAR2 (240)
_LA:MFG_ORDER_TYPE CHAR (49)
DESCRIPTION VARCHAR2 (240)
COMPLETED_QUANTITY NUMBER

START_DATE DATE

COMPLETION_DATE DATE

ORDER_CLOSED_DATE DATE

_LA:MFG_ORDER_STATUS VARCHAR2 (58)
BOM_REVISION_DATE DATE

ROUTING_REVISION_DATE DATE

ALTERNATE_BOM_DESIGNATOR VARCHAR2 (10)
ALTERNATE_ROUTING_DESIGNATOR VARCHAR2 (10)
DEMAND_CLASS VARCHAR2 (30)
MFG_ORDER_ID NUMBER

ORGANIZATION_ID NUMBER

INVENTORY_ITEM_ID NUMBER

CREATED_DATE DATE

CREATED_BY NUMBER

UPDATED_DATE DATE

UPDATED_BY NUMBER

Query Text

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


SELECT MFG_ORDER_NAME
,      _LA:MFG_ORDER_TYPE
,      DESCRIPTION
,      COMPLETED_QUANTITY
,      START_DATE
,      COMPLETION_DATE
,      ORDER_CLOSED_DATE
,      _LA:MFG_ORDER_STATUS
,      BOM_REVISION_DATE
,      ROUTING_REVISION_DATE
,      ALTERNATE_BOM_DESIGNATOR
,      ALTERNATE_ROUTING_DESIGNATOR
,      DEMAND_CLASS
,      MFG_ORDER_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      CREATED_DATE
,      CREATED_BY
,      UPDATED_DATE
,      UPDATED_BY
FROM APPS.WIPBV_MFG_ORDERS;

Dependencies

[top of page]

APPS.WIPBV_MFG_ORDERS references the following:

SchemaAPPS
SynonymWIP_DISCRETE_JOBS
SynonymWIP_ENTITIES
SynonymWIP_FLOW_SCHEDULES
SynonymWIP_REPETITIVE_SCHEDULES

APPS.WIPBV_MFG_ORDERS is not referenced by any database object