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
AND NVL(EED.DIRECT_ITEM
, 'N') <> 'Y'
AND MSIK.STOCK_ENABLED_FLAG='Y'

Columns