View: WIP_BIS_SCRAP_REASONS_V

Product:	WIP - Work in Process
Description:	Information about scrapped assemblies on a given date
Implementation/DBA Data:	APPS.WIP_BIS_SCRAP_REASONS_V

View Text

SELECT WMT.ORGANIZATION_ID
, WMT.TRANSACTION_DATE
, NVL(MTR.DESCRIPTION
, FND_MESSAGE.GET_STRING('WIP'
, 'WIP_OTHER'))
, MIF.ITEM_NUMBER
, MIF.PRIMARY_UOM_CODE
, MIF.DESCRIPTION
, SUM(DECODE(WMT.FM_INTRAOPERATION_STEP_TYPE
, 5
, DECODE(WMT.TO_INTRAOPERATION_STEP_TYPE
, 5
, 0
, WMT.PRIMARY_QUANTITY * -1)
, WMT.PRIMARY_QUANTITY))
FROM WIP_MOVE_TRANSACTIONS WMT
, MTL_TRANSACTION_REASONS MTR
, MTL_ITEM_FLEXFIELDS MIF
WHERE (WMT.FM_INTRAOPERATION_STEP_TYPE = 5 OR WMT.TO_INTRAOPERATION_STEP_TYPE = 5)
AND MTR.REASON_ID (+) = WMT.REASON_ID
AND MIF.INVENTORY_ITEM_ID = WMT.PRIMARY_ITEM_ID
AND MIF.ORGANIZATION_ID = WMT.ORGANIZATION_ID GROUP BY WMT.ORGANIZATION_ID
, WMT.TRANSACTION_DATE
, NVL(MTR.DESCRIPTION
, FND_MESSAGE.GET_STRING('WIP'
, 'WIP_OTHER'))
, MIF.ITEM_NUMBER
, MIF.PRIMARY_UOM_CODE
, MIF.DESCRIPTION

Columns