VIEW: APPS.EAM_CFR_MATERIALS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'