VIEW: APPS.WIP_FLOW_MIX_LINEARITY_V

Source

View Text - Preformatted

SELECT subview.organization_id, subview.line_id, subview.cdate "SCHEDULED_COMPLETION_DATE", sum(subview.planned) "TOTAL_PLANNED_QTY", sum(subview.completed) "TOTAL_QTY_COMPLETED", sum(abs(subview.planned - subview.completed)) "SUM_ITEM_DIFFERENCE", greatest( decode(sum(subview.planned), 0, decode(sum(abs(subview.planned - subview.completed)), 0, 100, 0), ( (1 - sum(abs(subview.planned - subview.completed)) / sum(subview.planned)) * 100 )), 0) "MIX_PERCENT" FROM (SELECT trunc(wip_sfcb_utilities.sdate_to_cdate(wfs.scheduled_completion_date)) cdate, wfs.organization_id, wfs.line_id, wfs.primary_item_id, sum(wfs.planned_quantity) planned, sum(wfs.quantity_completed) completed FROM wip_flow_schedules wfs GROUP BY wfs.organization_id, wfs.line_id, trunc(wip_sfcb_utilities.sdate_to_cdate(wfs.scheduled_completion_date)), wfs.primary_item_id ) subview GROUP BY subview.organization_id, subview.line_id, subview.cdate

View Text - HTML Formatted

SELECT SUBVIEW.ORGANIZATION_ID
, SUBVIEW.LINE_ID
, SUBVIEW.CDATE "SCHEDULED_COMPLETION_DATE"
, SUM(SUBVIEW.PLANNED) "TOTAL_PLANNED_QTY"
, SUM(SUBVIEW.COMPLETED) "TOTAL_QTY_COMPLETED"
, SUM(ABS(SUBVIEW.PLANNED - SUBVIEW.COMPLETED)) "SUM_ITEM_DIFFERENCE"
, GREATEST( DECODE(SUM(SUBVIEW.PLANNED)
, 0
, DECODE(SUM(ABS(SUBVIEW.PLANNED - SUBVIEW.COMPLETED))
, 0
, 100
, 0)
, ( (1 - SUM(ABS(SUBVIEW.PLANNED - SUBVIEW.COMPLETED)) / SUM(SUBVIEW.PLANNED)) * 100 ))
, 0) "MIX_PERCENT"
FROM (SELECT TRUNC(WIP_SFCB_UTILITIES.SDATE_TO_CDATE(WFS.SCHEDULED_COMPLETION_DATE)) CDATE
, WFS.ORGANIZATION_ID
, WFS.LINE_ID
, WFS.PRIMARY_ITEM_ID
, SUM(WFS.PLANNED_QUANTITY) PLANNED
, SUM(WFS.QUANTITY_COMPLETED) COMPLETED
FROM WIP_FLOW_SCHEDULES WFS GROUP BY WFS.ORGANIZATION_ID
, WFS.LINE_ID
, TRUNC(WIP_SFCB_UTILITIES.SDATE_TO_CDATE(WFS.SCHEDULED_COMPLETION_DATE))
, WFS.PRIMARY_ITEM_ID ) SUBVIEW GROUP BY SUBVIEW.ORGANIZATION_ID
, SUBVIEW.LINE_ID
, SUBVIEW.CDATE