VIEW: APPS.WIP_BIS_SCRAP_REASONS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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