View: WIP_RES_UNITS_WORKED_VIEW

Product:	WIP - Work in Process
Description:	Resource transaction quantities
Implementation/DBA Data:	APPS.WIP_RES_UNITS_WORKED_VIEW

View Text

SELECT TRUNC(WT.TRANSACTION_DATE)
, WE.WIP_ENTITY_NAME
, WL.LINE_CODE
, WT.OPERATION_SEQ_NUM
, BD.DEPARTMENT_CODE
, BR.RESOURCE_CODE
, SUM(WT.PRIMARY_QUANTITY)
, MIN(WT.PRIMARY_UOM)
FROM BOM_DEPARTMENTS BD
, BOM_RESOURCES BR
, WIP_ENTITIES WE
, WIP_LINES WL
, WIP_TRANSACTIONS WT
WHERE WT.TRANSACTION_TYPE IN (1
, 3)
AND BD.DEPARTMENT_ID = WT.DEPARTMENT_ID
AND BR.RESOURCE_ID = WT.RESOURCE_ID
AND WE.WIP_ENTITY_ID = WT.WIP_ENTITY_ID
AND WE.ORGANIZATION_ID = WT.ORGANIZATION_ID
AND WL.LINE_ID (+) = WT.LINE_ID
AND WL.ORGANIZATION_ID (+) = WT.ORGANIZATION_ID GROUP BY TRUNC(WT.TRANSACTION_DATE)
, WE.WIP_ENTITY_NAME
, WL.LINE_CODE
, WT.OPERATION_SEQ_NUM
, BD.DEPARTMENT_CODE
, BR.RESOURCE_CODE

Columns