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.

[Home] [Help]

View: EAM_MATERIALS_V

Product:	EAM - Enterprise Asset Management
Description:	View shows the details of materials for a work order
Implementation/DBA Data:	APPS.EAM_MATERIALS_V

View Text

SELECT EED.WIP_ENTITY_ID
, EED.ORGANIZATION_ID
, EED.OPERATIONS_DEPT_ID
, EED.OPERATIONS_SEQ_NUM
, BD.DEPARTMENT_CODE
, MSIK.CONCATENATED_SEGMENTS
, EED.REQUIRED_QUANTITY
, EED.ITEM_COST
, NVL(EED.ITEM_COST
, 0)*NVL(EED.REQUIRED_QUANTITY
, 0)
FROM CST_EAM_WO_ESTIMATE_DETAILS EED
, MTL_SYSTEM_ITEMS_KFV MSIK
, BOM_DEPARTMENTS BD
WHERE EED.INVENTORY_ITEM_ID=MSIK.INVENTORY_ITEM_ID
AND EED.ORGANIZATION_ID=MSIK.ORGANIZATION_ID
AND EED.ORGANIZATION_ID=BD.ORGANIZATION_ID
AND BD.DEPARTMENT_ID=EED.OWNING_DEPT_ID

Columns

Name
WIP_ENTITY_ID
ORGANIZATION_ID
OPERATIONS_DEPT_ID
OPERATIONS_SEQ_NUM
OPERATION_DEPT_CODE
CONCATENATED_SEGMENTS
REQUIRED_QUANTITY
ITEM_COST
TOTAL_ITEM_COST