VIEW: APPS.WIP_RES_UNITS_WORKED_VIEW

Source

View Text - Preformatted

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

View Text - HTML Formatted

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