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

TABLE: EAM.EAM_FORECAST_WEDI

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


This table stores the direct item information for forecasted work orders in eAM maintenance budgeting and forecasting. This mirrors the structure of wip_eam_direct_items.
This table stores the description based direct items associated with an EAM work order.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
DESCRIPTION VARCHAR2 (240) Yes The description for the direct item.
PURCHASING_CATEGORY_ID NUMBER
Yes The purchasing category ID associated with the direct item.
DIRECT_ITEM_SEQUENCE_ID NUMBER
Yes The primary key of the WIP_EAM_DIRECT_ITEMS table.
OPERATION_SEQ_NUM NUMBER
Yes The operation sequence number to which the direct item is associated with.
DEPARTMENT_ID NUMBER

The department ID of the operation.
WIP_ENTITY_ID NUMBER
Yes WIPEntity ID for the work order.
ORGANIZATION_ID NUMBER
Yes Organization ID for the work order.
SUGGESTED_VENDOR_NAME VARCHAR2 (240)
Suggested vendor name for the direct item.
SUGGESTED_VENDOR_ID NUMBER

Suggested vendor ID for the direct item.
SUGGESTED_VENDOR_SITE VARCHAR2 (15)
Suggested vendor site name for the direct item.
SUGGESTED_VENDOR_SITE_ID NUMBER

Suggested vendor site ID for the direct item.
SUGGESTED_VENDOR_CONTACT VARCHAR2 (80)
Suggested vendor contact for the direct item.
SUGGESTED_VENDOR_CONTACT_ID NUMBER

Suggested vendor contact ID for the direct item.
SUGGESTED_VENDOR_PHONE VARCHAR2 (20)
Suggested vendor phone number for the direct item.
SUGGESTED_VENDOR_ITEM_NUM VARCHAR2 (25)
Suggested vendor item number for the direct item.
UNIT_PRICE NUMBER

Unit price for the direct item.
AUTO_REQUEST_MATERIAL VARCHAR2 (1)
The auto request material flag for the direct item.
REQUIRED_QUANTITY NUMBER
Yes Required quantity for the direct item.
UOM VARCHAR2 (3) Yes Unit of measure.
NEED_BY_DATE DATE

The date by which the item is expected to be delivered.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Standard flexfield column.
ATTRIBUTE1 VARCHAR2 (150)
Standard flexfield column.
ATTRIBUTE2 VARCHAR2 (150)
Standard flexfield column.
ATTRIBUTE3 VARCHAR2 (150)
Standard flexfield column.
ATTRIBUTE4 VARCHAR2 (150)
Standard flexfield column.
ATTRIBUTE5 VARCHAR2 (150)
Standard flexfield column.
ATTRIBUTE6 VARCHAR2 (150)
Standard flexfield column.
ATTRIBUTE7 VARCHAR2 (150)
Standard flexfield column.
ATTRIBUTE8 VARCHAR2 (150)
Standard flexfield column.
ATTRIBUTE9 VARCHAR2 (150)
Standard flexfield column.
ATTRIBUTE10 VARCHAR2 (150)
Standard flexfield column.
ATTRIBUTE11 VARCHAR2 (150)
Standard flexfield column.
ATTRIBUTE12 VARCHAR2 (150)
Standard flexfield column.
ATTRIBUTE13 VARCHAR2 (150)
Standard flexfield column.
ATTRIBUTE14 VARCHAR2 (150)
Standard flexfield column.
ATTRIBUTE15 VARCHAR2 (150)
Standard flexfield column.
CREATED_BY NUMBER

Standard column.
CREATION_DATE DATE

Standard column.
LAST_UPDATE_DATE DATE

Standard column.
LAST_UPDATE_LOGIN NUMBER

Standard column.
LAST_UPDATED_BY NUMBER

Standard column.
PROGRAM_APPLICATION_ID NUMBER

Standard column.
PROGRAM_ID NUMBER

Standard column.
PROGRAM_UPDATE_DATE DATE

Standard column.
REQUEST_ID NUMBER

Standard column.
FORECAST_ID NUMBER
Yes Forecast Id
Query Text

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


SELECT DESCRIPTION
,      PURCHASING_CATEGORY_ID
,      DIRECT_ITEM_SEQUENCE_ID
,      OPERATION_SEQ_NUM
,      DEPARTMENT_ID
,      WIP_ENTITY_ID
,      ORGANIZATION_ID
,      SUGGESTED_VENDOR_NAME
,      SUGGESTED_VENDOR_ID
,      SUGGESTED_VENDOR_SITE
,      SUGGESTED_VENDOR_SITE_ID
,      SUGGESTED_VENDOR_CONTACT
,      SUGGESTED_VENDOR_CONTACT_ID
,      SUGGESTED_VENDOR_PHONE
,      SUGGESTED_VENDOR_ITEM_NUM
,      UNIT_PRICE
,      AUTO_REQUEST_MATERIAL
,      REQUIRED_QUANTITY
,      UOM
,      NEED_BY_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      FORECAST_ID
FROM EAM.EAM_FORECAST_WEDI;

Dependencies

[top of page]

EAM.EAM_FORECAST_WEDI does not reference any database object

EAM.EAM_FORECAST_WEDI is referenced by following:

SchemaEAM
ViewEAM_FORECAST_WEDI#