View: EAM_CFR_MATERIALS_V

Product:	EAM - Enterprise Asset Management
Description:	This view displays information on materials for work orders.
Implementation/DBA Data:	APPS.EAM_CFR_MATERIALS_V

View Text

SELECT WRO.INVENTORY_ITEM_ID
, MSIK.CONCATENATED_SEGMENTS
, MSIK.DESCRIPTION ITEM_DESCRIPTION
, MSIK.PRIMARY_UOM_CODE ITEM_PRIMARY_UOM_CODE
, MSIK.INVENTORY_ASSET_FLAG
, MSIK.LOCATION_CONTROL_CODE
, MSIK.RESTRICT_LOCATORS_CODE
, MSIK.RESTRICT_SUBINVENTORIES_CODE
, WRO.ORGANIZATION_ID
, WRO.WIP_ENTITY_ID
, WRO.OPERATION_SEQ_NUM
, WRO.DEPARTMENT_ID
, BD.DEPARTMENT_CODE
, WRO.WIP_SUPPLY_TYPE
, ML1.MEANING WIP_SUPPLY_DISP
, WRO.DATE_REQUIRED
, WRO.REQUIRED_QUANTITY
, DECODE(WRO.QUANTITY_ISSUED
, 0
, TO_NUMBER(NULL)
, WRO.QUANTITY_ISSUED) QUANTITY_ISSUED
, (WRO.REQUIRED_QUANTITY-NVL(WRO.QUANTITY_ISSUED
, 0) - EAM_MATERIAL_ALLOCQTY_PKG.ALLOCATED_QUANTITY(WRO.WIP_ENTITY_ID
, WRO.OPERATION_SEQ_NUM
, WRO.ORGANIZATION_ID
, WRO.INVENTORY_ITEM_ID)) QUANTITY_OPEN
, WRO.QUANTITY_PER_ASSEMBLY
, WRO.COMMENTS
, WRO.SUPPLY_SUBINVENTORY
, WRO.SUPPLY_LOCATOR_ID
, WRO.MRP_NET_FLAG
, ML2.MEANING MRP_NET_DISP
, WRO.MPS_REQUIRED_QUANTITY
, WRO.MPS_DATE_REQUIRED
, EAM_MATERIAL_ALLOCQTY_PKG.ALLOCATED_QUANTITY(WRO.WIP_ENTITY_ID
, WRO.OPERATION_SEQ_NUM
, WRO.ORGANIZATION_ID
, WRO.INVENTORY_ITEM_ID) QUANTITY_ALLOCATED
, WRO.AUTO_REQUEST_MATERIAL
, WRO.RELEASED_QUANTITY
, WRO.COMPONENT_SEQUENCE_ID
, WRO.ATTRIBUTE_CATEGORY
, WRO.ATTRIBUTE1
, WRO.ATTRIBUTE2
, WRO.ATTRIBUTE3
, WRO.ATTRIBUTE4
, WRO.ATTRIBUTE5
, WRO.ATTRIBUTE6
, WRO.ATTRIBUTE7
, WRO.ATTRIBUTE8
, WRO.ATTRIBUTE9
, WRO.ATTRIBUTE10
, WRO.ATTRIBUTE11
, WRO.ATTRIBUTE12
, WRO.ATTRIBUTE13
, WRO.ATTRIBUTE14
, WRO.ATTRIBUTE15
FROM WIP_REQUIREMENT_OPERATIONS WRO
, MTL_SYSTEM_ITEMS_KFV MSIK
, BOM_DEPARTMENTS BD
, MFG_LOOKUPS ML1
, MFG_LOOKUPS ML2
WHERE MSIK.INVENTORY_ITEM_ID = WRO.INVENTORY_ITEM_ID
AND MSIK.ORGANIZATION_ID = WRO.ORGANIZATION_ID
AND ( MSIK.STOCK_ENABLED_FLAG IS NULL OR MSIK.STOCK_ENABLED_FLAG = 'Y' )
AND BD.DEPARTMENT_ID(+) = WRO.DEPARTMENT_ID
AND ML1.LOOKUP_CODE = WRO.WIP_SUPPLY_TYPE
AND ML1.LOOKUP_TYPE = 'WIP_SUPPLY'
AND ML2.LOOKUP_CODE = WRO.MRP_NET_FLAG
AND ML2.LOOKUP_TYPE = 'SYS_YES_NO'

Columns