[Home] [Help]
View: 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
Name |
TRANSACTION_DATE |
WIP_ENTITY_NAME |
LINE_CODE |
OPERATION_SEQ_NUM |
DEPARTMENT_CODE |
RESOURCE_CODE |
RES_UNITS_WORKED |
PRIMARY_UOM |