View: MTL_CC_GRAPH_V

View Text

SELECT MCCE.ORGANIZATION_ID
, MCCE.CYCLE_COUNT_HEADER_ID
, MCCE.INVENTORY_ITEM_ID
, 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 ) ) HIT
, 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 ) ) MISS
, DECODE(SIGN(NVL(MCCE.ADJUSTMENT_AMOUNT
, 0))
, 1
, MCCE.ADJUSTMENT_AMOUNT
, NULL) POS_ADJ_VALUE
, DECODE(SIGN(NVL(MCCE.ADJUSTMENT_AMOUNT
, 0))
, -1
, MCCE.ADJUSTMENT_AMOUNT
, NULL) NEG_ADJ_VALUE
, ABS(NVL(MCCE.ADJUSTMENT_AMOUNT
, 0)) ABS_ADJ_VALUE
, DECODE(NVL(MCCE.ADJUSTMENT_QUANTITY
, 0)
, 0
, 0
, 1) TRANSACTED
, ABC.ABC_CLASS_NAME CLASS
, MCCE.SUBINVENTORY
, MCCE.COUNTED_BY_EMPLOYEE_ID_FIRST COUNTER_ID
, MCCE.COUNT_DATE_FIRST COUNT_DATE
FROM MTL_CYCLE_COUNT_ENTRIES MCCE
, MTL_CYCLE_COUNT_CLASSES MCCC
, MTL_ABC_CLASSES ABC
, MTL_CYCLE_COUNT_HEADERS MCCH
, MTL_CYCLE_COUNT_ITEMS MCCI
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 MCCI.CYCLE_COUNT_HEADER_ID = MCCE.CYCLE_COUNT_HEADER_ID
AND MCCI.INVENTORY_ITEM_ID = MCCE.INVENTORY_ITEM_ID
AND MCCI.ABC_CLASS_ID = MCCC.ABC_CLASS_ID
AND ABC.ORGANIZATION_ID = MCCE.ORGANIZATION_ID
AND ABC.ABC_CLASS_ID = MCCI.ABC_CLASS_ID
AND MCCE.COUNT_QUANTITY_FIRST IS NOT NULL

Columns