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


VIEW: APPS.EAM_DIRECT_ITEM_RECS_V

Object Details
Object Name: EAM_DIRECT_ITEM_RECS_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


This view does a union between WIP_REQUIREMENT_OPERATIONS and WIP_EAM_DIRECT_ITEMS.
From WIP_REQUIREMENT_OPERATIONS, it selects non-stockable inventory items. From
WIP_EAM_DIRECT_ITEMS, it selects all the description based direct items.


[View Source]

Columns
Name Datatype Length Mandatory Comments
DIRECT_ITEM_TYPE VARCHAR2 (80)
Type of direct item being represented
DIRECT_ITEM_TYPE_ID NUMBER

Type ID of direct item being represented
TASK_NUMBER NUMBER

The operation sequence number to which the direct item is associated with
PURCHASING_CATEGORY VARCHAR2 (163)
The purchasing category associated with the direct item
PURCHASING_CATEGORY_ID NUMBER

The purchasing category ID associated with the direct item
CURR_CODE VARCHAR2 (15)
The currency code for the direct item
ITEM_DESCRIPTION VARCHAR2 (40)
The description for the direct item
DESCRIPTION VARCHAR2 (240)
The description for the direct item
UOM_CODE VARCHAR2 (3)
Unit of measure
WIP_ENTITY_ID NUMBER

WIP Entity ID for the work order
ORGANIZATION_ID NUMBER

Organization ID for the work order
UNIT_PRICE NUMBER

Unit price for the direct item
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 (240)
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 (40)
Suggested vendor phone number for the direct item
SUGGESTED_VENDOR_ITEM_NUM VARCHAR2 (25)
Suggested vendor item number for the direct item
REQUIRED_QUANTITY NUMBER

Required quantity for the direct item
DATE_REQUIRED DATE

The date by which the item is expected to be delivered
AUTO_REQUEST_MATERIAL VARCHAR2 (1)
The auto request material flag for the direct item
INVENTORY_ITEM_ID NUMBER

The inventory item id of the non-stockable inventory item
DIRECT_ITEM_SEQUENCE_ID NUMBER

The primary key of the WIP_EAM_DIRECT_ITEMS table
QUANTITY_RECEIVED NUMBER

Received quantity for the direct item
DEPARTMENT_ID NUMBER

The department ID of the operation
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
RQL_QUANTITY_ORDERED NUMBER

Ordered quantity in the requisition
PO_QUANTITY_ORDERED NUMBER

Ordered quantity in the purchase order
PO_QUANTITY_CANCELLED NUMBER

Quantity cancelled in the purchase order
EFFECTIVITY_CONTROL NUMBER

Effectivity Control of the item
EAM_ITEM_TYPE NUMBER

EAM Item Type
ORDER_TYPE_LOOKUP_CODE VARCHAR2 (25)
order type of Req/PO
AMOUNT NUMBER

amount on po/req when order type is Amount
AMOUNT_DELIVERED NUMBER

Amount Received
RQL_AMOUNT_ORDERED NUMBER

Amount on Requistion Line
PO_AMOUNT_ORDERED NUMBER

Amount on PO Line
SERVICE_LINE_TYPE_ID NUMBER

Service
SERVICE_LINE_TYPE VARCHAR2 (80)
Service Line Type for EAM
Query Text

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


SELECT DIRECT_ITEM_TYPE
,      DIRECT_ITEM_TYPE_ID
,      TASK_NUMBER
,      PURCHASING_CATEGORY
,      PURCHASING_CATEGORY_ID
,      CURR_CODE
,      ITEM_DESCRIPTION
,      DESCRIPTION
,      UOM_CODE
,      WIP_ENTITY_ID
,      ORGANIZATION_ID
,      UNIT_PRICE
,      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
,      REQUIRED_QUANTITY
,      DATE_REQUIRED
,      AUTO_REQUEST_MATERIAL
,      INVENTORY_ITEM_ID
,      DIRECT_ITEM_SEQUENCE_ID
,      QUANTITY_RECEIVED
,      DEPARTMENT_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      RQL_QUANTITY_ORDERED
,      PO_QUANTITY_ORDERED
,      PO_QUANTITY_CANCELLED
,      EFFECTIVITY_CONTROL
,      EAM_ITEM_TYPE
,      ORDER_TYPE_LOOKUP_CODE
,      AMOUNT
,      AMOUNT_DELIVERED
,      RQL_AMOUNT_ORDERED
,      PO_AMOUNT_ORDERED
,      SERVICE_LINE_TYPE_ID
,      SERVICE_LINE_TYPE
FROM APPS.EAM_DIRECT_ITEM_RECS_V;

Dependencies

[top of page]

APPS.EAM_DIRECT_ITEM_RECS_V references the following:

SchemaAPPS
ViewEAM_WORK_ORDER_DIRECT_ITEMS_V
ViewEAM_WORK_ORDER_REQ_PO_V
ViewGL_SETS_OF_BOOKS
SynonymHR_ORGANIZATION_INFORMATION
ViewMFG_LOOKUPS
SynonymMTL_CATEGORIES_KFV
ViewMTL_SYSTEM_ITEMS_B_KFV
SynonymWIP_REQUIREMENT_OPERATIONS
APPS.EAM_DIRECT_ITEM_RECS_V is referenced by following:

SchemaAPPS
ViewEAM_CAPT_BILL_BY_REQ_V
Package BodyEAM_MATERIAL_VALIDATE_PUB - show dependent code
Package BodyEAM_PROCESS_WO_UTIL_PVT - show dependent code
Package BodyEAM_WORKORDERREP_PVT - show dependent code
ViewWIP_EAM_REQUIREMENTS_ALL_V