View: MTL_CC_GRAPH_WK_V

View Text

SELECT MCCE.ORGANIZATION_ID
, MCCE.CYCLE_COUNT_HEADER_ID
, SUM ( DECODE(MCCE.SYSTEM_QUANTITY_FIRST
, 0
, 0
, DECODE(SIGN(ABS(MCCE.COUNT_QUANTITY_FIRST-MCCE.SYSTEM_QUANTITY_FIRS T)*100/MCCE.SYSTEM_QUANTITY_FIRST - ( DECODE(SIGN((MCCE.COUNT_QUANTITY_FIRST-MCCE.SYSTEM_QUANTITY_FIRST) )
, 1
, NVL(MCCC.HIT_MISS_TOLERANCE_POSITIVE
, MCCH.HIT_MISS_TOLERANCE_POSITIVE)
, NVL(MCCC.HIT_MISS_TOLERANCE_NEGATIVE
, MCCH.HIT_MISS_TOLERANCE_NEGATIVE)) ) )
, 1
, 0
, 1 ) ) ) HITS
, SUM ( DECODE(MCCE.SYSTEM_QUANTITY_FIRST
, 0
, 1
, DECODE(SIGN(ABS(MCCE.COUNT_QUANTITY_FIRST-MCCE.SYSTEM_QUANTITY_FIRS T)*100/MCCE.SYSTEM_QUANTITY_FIRST - ( DECODE(SIGN((MCCE.COUNT_QUANTITY_FIRST-MCCE.SYSTEM_QUANTITY_FIRST) )
, 1
, NVL(MCCC.HIT_MISS_TOLERANCE_POSITIVE
, MCCH.HIT_MISS_TOLERANCE_POSITIVE)
, NVL(MCCC.HIT_MISS_TOLERANCE_NEGATIVE
, MCCH.HIT_MISS_TOLERANCE_NEGATIVE)) ) )
, 1
, 1
, 0 ) ) ) MISSES
, SUM(1) TOTAL_COUNTS
, SUM(DECODE(SIGN(NVL(MCCE.ADJUSTMENT_AMOUNT
, 0))
, 1
, MCCE.ADJUSTMENT_AMOUNT
, NULL)) POS_ADJ_VALUE
, SUM(DECODE(SIGN(NVL(MCCE.ADJUSTMENT_AMOUNT
, 0))
, -1
, MCCE.ADJUSTMENT_AMOUNT
, NULL)) NEG_ADJ_VALUE
, SUM(DECODE(NVL(MCCE.ADJUSTMENT_QUANTITY
, 0)
, 0
, 0
, 1)) TRANSACTED
, TRUNC(MCCE.COUNT_DATE_FIRST
, 'DAY') WEEK_START_DATE
FROM MTL_CYCLE_COUNT_ENTRIES MCCE
, MTL_CYCLE_COUNT_CLASSES MCCC
, MTL_CYCLE_COUNT_HEADERS MCCH
WHERE MCCH.ORGANIZATION_ID = MCCE.ORGANIZATION_ID
AND MCCH.CYCLE_COUNT_HEADER_ID = MCCE.CYCLE_COUNT_HEADER_ID
AND MCCC.ORGANIZATION_ID = MCCE.ORGANIZATION_ID
AND MCCC.CYCLE_COUNT_HEADER_ID = MCCE.CYCLE_COUNT_HEADER_ID
AND MCCE.COUNT_QUANTITY_FIRST IS NOT NULL GROUP BY MCCE.ORGANIZATION_ID
, MCCE.CYCLE_COUNT_HEADER_ID
, TRUNC(MCCE.COUNT_DATE_FIRST
, 'DAY')

Columns