[Home] [Help]
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
Name |
ORGANIZATION_ID |
TRANSACTION_DATE |
REASON |
ITEM_NUMBER |
ITEM_UOM |
ITEM_DESCRIPTION |
QTY_SCRAPPED |