eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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
FND Design Data:	EAM.EAM_DIRECT_ITEM_RECS_V
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	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:

APPS: EAM_WORK_ORDER_DIRECT_ITEMS_V; EAM_WORK_ORDER_REQ_PO_V; FND_GLOBAL - show dependent code; GL_SETS_OF_BOOKS; HR_ORGANIZATION_INFORMATION; MFG_LOOKUPS; MTL_CATEGORIES_KFV; MTL_SYSTEM_ITEMS_B_KFV; WIP_EAM_DIRECT_ITEMS; WIP_REQUIREMENT_OPERATIONS

APPS.EAM_DIRECT_ITEM_RECS_V is referenced by following:

APPS: EAM_CAPT_BILL_BY_REQ_V; EAM_MATERIAL_VALIDATE_PUB - show dependent code; EAM_PROCESS_WO_UTIL_PVT - show dependent code; EAM_WORKORDERREP_PVT - show dependent code; WIP_EAM_REQUIREMENTS_ALL_V