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

TABLE: EAM.EAM_FORECAST_WRO

Object Details
Object Name: EAM_FORECAST_WRO
Object Type: TABLE
Owner: EAM
FND Design Data: TableEAM.EAM_FORECAST_WRO
Subobject Name:
Status: VALID


This table stores the material requirements of forecasted work orders for eaM maintenance budgeting and forecasting. This mirrors the structure of wip_requirement_operations.
WIP_REQUIREMENT_OPERATIONS stores information about the material
requirements of jobs and schedules. Each row represents a
material requirement and contains information about the component
item, its usage quantities, the using department, requirement date,
and the material control method. Oracle Work in Process uses this
information to track the material usage of jobs and schedules.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
INVENTORY_ITEM_ID NUMBER
Yes Item Identifier
ORGANIZATION_ID NUMBER
Yes Organization Identifier
WIP_ENTITY_ID NUMBER
Yes WIP job or repetitive assembly Identifier
OPERATION_SEQ_NUM NUMBER
Yes Operation sequence number within a routing
REPETITIVE_SCHEDULE_ID NUMBER

WIP repetitive schedule Identifier
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REQUEST_ID NUMBER

Enhanced Who column
PROGRAM_APPLICATION_ID NUMBER

Enhanced Who column
PROGRAM_ID NUMBER

Enhanced Who column
PROGRAM_UPDATE_DATE DATE

Enhanced Who column
COMPONENT_SEQUENCE_ID NUMBER

Bill of materials component sequence Identifier
DEPARTMENT_ID NUMBER

Department Identifier
WIP_SUPPLY_TYPE NUMBER
Yes Method of material consumption within WIP
DATE_REQUIRED DATE

Operation requirement start date
REQUIRED_QUANTITY NUMBER
Yes Part quantity required
QUANTITY_ISSUED NUMBER
Yes Part quantity issued
QUANTITY_PER_ASSEMBLY NUMBER
Yes Part usage quantity
COMMENTS VARCHAR2 (240)
Component comment descriptive text
SUPPLY_SUBINVENTORY VARCHAR2 (10)
Subinventory used to supply component to WIP
SUPPLY_LOCATOR_ID NUMBER

Locator used to supply component to WIP
MRP_NET_FLAG NUMBER
Yes Determines whether or not MRP should consider the component requirement in its netting process
MPS_REQUIRED_QUANTITY NUMBER

Quantity used by MPS relief process
MPS_DATE_REQUIRED DATE

Date used by MPS relief process
SEGMENT1 VARCHAR2 (40)
Item flexfield segment, copied from Inventory
SEGMENT2 VARCHAR2 (40)
Item flexfield segment, copied from Inventory
SEGMENT3 VARCHAR2 (40)
Item flexfield segment, copied from Inventory
SEGMENT4 VARCHAR2 (40)
Item flexfield segment, copied from Inventory
SEGMENT5 VARCHAR2 (40)
Item flexfield segment, copied from Inventory
SEGMENT6 VARCHAR2 (40)
Item flexfield segment, copied from Inventory
SEGMENT7 VARCHAR2 (40)
Item flexfield segment, copied from Inventory
SEGMENT8 VARCHAR2 (40)
Item flexfield segment, copied from Inventory
SEGMENT9 VARCHAR2 (40)
Item flexfield segment, copied from Inventory
SEGMENT10 VARCHAR2 (40)
Item flexfield segment, copied from Inventory
SEGMENT11 VARCHAR2 (40)
Item flexfield segment, copied from Inventory
SEGMENT12 VARCHAR2 (40)
Item flexfield segment, copied from Inventory
SEGMENT13 VARCHAR2 (40)
Item flexfield segment, copied from Inventory
SEGMENT14 VARCHAR2 (40)
Item flexfield segment, copied from Inventory
SEGMENT15 VARCHAR2 (40)
Item flexfield segment, copied from Inventory
SEGMENT16 VARCHAR2 (40)
Item flexfield segment, copied from Inventory
SEGMENT17 VARCHAR2 (40)
Item flexfield segment, copied from Inventory
SEGMENT18 VARCHAR2 (40)
Item flexfield segment, copied from Inventory
SEGMENT19 VARCHAR2 (40)
Item flexfield segment, copied from Inventory
SEGMENT20 VARCHAR2 (40)
Item flexfield segment, copied from Inventory
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment
RELIEVED_MATL_COMPLETION_QTY NUMBER

Material quantity relieved due to WIP completion
RELIEVED_MATL_SCRAP_QUANTITY NUMBER

Material quantity relieved due to WIP scrap
RELIEVED_MATL_FINAL_COMP_QTY NUMBER

Material quantity relieved due to negative final completion
QUANTITY_ALLOCATED NUMBER

Quantity allocated
QUANTITY_BACKORDERED NUMBER

Quantity backordered
QUANTITY_RELIEVED NUMBER

Quantity Relieved
COSTED_QUANTITY_ISSUED NUMBER

Costed Quantity Issued
COSTED_QUANTITY_RELIEVED NUMBER

Costed Quantity Relieved
AUTO_REQUEST_MATERIAL VARCHAR2 (1)
auto request material, used by EAM
RELEASED_QUANTITY NUMBER

This column stores material requirement at released time.
SUGGESTED_VENDOR_NAME VARCHAR2 (240)
Suggested Vendor Name
VENDOR_ID NUMBER

Vendor identifier
UNIT_PRICE NUMBER

Unit price
BASIS_TYPE NUMBER

material basis type (either lot or item)
FORECAST_ID NUMBER
Yes Forecast Identifier
COMPONENT_YIELD_FACTOR NUMBER

component yield factor
PRIMARY_COMPONENT_ID NUMBER

An ID of original component.
Query Text

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


SELECT INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      WIP_ENTITY_ID
,      OPERATION_SEQ_NUM
,      REPETITIVE_SCHEDULE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      COMPONENT_SEQUENCE_ID
,      DEPARTMENT_ID
,      WIP_SUPPLY_TYPE
,      DATE_REQUIRED
,      REQUIRED_QUANTITY
,      QUANTITY_ISSUED
,      QUANTITY_PER_ASSEMBLY
,      COMMENTS
,      SUPPLY_SUBINVENTORY
,      SUPPLY_LOCATOR_ID
,      MRP_NET_FLAG
,      MPS_REQUIRED_QUANTITY
,      MPS_DATE_REQUIRED
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT20
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      RELIEVED_MATL_COMPLETION_QTY
,      RELIEVED_MATL_SCRAP_QUANTITY
,      RELIEVED_MATL_FINAL_COMP_QTY
,      QUANTITY_ALLOCATED
,      QUANTITY_BACKORDERED
,      QUANTITY_RELIEVED
,      COSTED_QUANTITY_ISSUED
,      COSTED_QUANTITY_RELIEVED
,      AUTO_REQUEST_MATERIAL
,      RELEASED_QUANTITY
,      SUGGESTED_VENDOR_NAME
,      VENDOR_ID
,      UNIT_PRICE
,      BASIS_TYPE
,      FORECAST_ID
,      COMPONENT_YIELD_FACTOR
,      PRIMARY_COMPONENT_ID
FROM EAM.EAM_FORECAST_WRO;

Dependencies

[top of page]

EAM.EAM_FORECAST_WRO does not reference any database object

EAM.EAM_FORECAST_WRO is referenced by following:

SchemaEAM
ViewEAM_FORECAST_WRO#