eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: CZ_ERRORS_SUMMARY_V

Product:	BOM - Bills of Material
Description:	Summary of errors
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT DISTINCT OE_CONFIG.CZ_MESSAGE_COUNT(CZ.SYSTEM_ID
, CZ.HEADER_ID
, CZ.LINE_ID)MESSAGE_COUNT
, OE_CONFIG.CZ_ERROR_COUNT(CZ.SYSTEM_ID
, CZ.HEADER_ID
, CZ.LINE_ID) ERROR_COUNT
, OE_CONFIG.CZ_SUGGEST_COUNT(CZ.SYSTEM_ID
, CZ.HEADER_ID
, CZ.LINE_ID) SUGGESTION_COUNT
, OE_CONFIG.CZ_WARN_COUNT(CZ.SYSTEM_ID
, CZ.HEADER_ID
, CZ.LINE_ID) WARNING_COUNT
, OE_CONFIG.CZ_AUTOSELECT_COUNT(CZ.SYSTEM_ID
, CZ.HEADER_ID
, CZ.LINE_ID) AUTOSELECTION_COUNT
, OE_CONFIG.CZ_OVERRIDEN_COUNT(CZ.SYSTEM_ID
, CZ.HEADER_ID
, CZ.LINE_ID) OVERRIDEN_ERROR_COUNT
, OE_CONFIG.CZ_OVERRIDE_ERROR_COUNT(CZ.SYSTEM_ID
, CZ.HEADER_ID
, CZ.LINE_ID) OVERRIDE_ERROR_COUNT
, CZ.SYSTEM_ID
, CS.NAME SYSTEM_NAME
, MSI.CONCATENATED_SEGMENTS MODEL_NAME
, CZ.HEADER_ID
, SOH.ORDER_NUMBER
, SOT.NAME ORDER_TYPE
, CZ.LINE_ID
, OE_QUERY.LINE_NUMBER(SOL1.LINE_ID
, SOL1.PARENT_LINE_ID
, SOL1.SHIPMENT_SCHEDULE_LINE_ID
, SOL1.LINE_NUMBER) LINE_NUMBER
, OE_QUERY.SHIPMENT_NUMBER(SOL1.LINE_ID
, SOL1.PARENT_LINE_ID
, SOL1.SHIPMENT_SCHEDULE_LINE_ID
, SOL1.LINE_NUMBER) SHIPMENT_NUMBER
, DECODE(SOL1.PARENT_LINE_ID
, NULL
, NULL
, SOL1.LINE_NUMBER) OPTION_NUMBER
FROM CS_SYSTEMS CS
, MTL_SYSTEM_ITEMS_KFV MSI
, SO_ORDER_TYPES SOT
, SO_HEADERS_ALL SOH
, SO_LINES_ALL SOL1
, SO_LINES_ALL SOLP
, CZ_ERRORS CZ
WHERE SOL1.LINE_ID (+) = NVL(CZ.LINE_ID
, -999)
AND SOH.HEADER_ID (+) = NVL(SOL1.HEADER_ID
, -999)
AND CS.SYSTEM_ID (+) = NVL(CZ.SYSTEM_ID
, -999)
AND SOT.ORDER_TYPE_ID (+) = SOH.ORDER_TYPE_ID
AND SOLP.LINE_ID = NVL(SOL1.PARENT_LINE_ID
, SOL1.LINE_ID)
AND MSI.INVENTORY_ITEM_ID = SOLP.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = SOLP.WAREHOUSE_ID GROUP BY CZ.SYSTEM_ID
, CS.NAME
, CZ.HEADER_ID
, SOH.ORDER_NUMBER
, SOT.NAME
, CZ.LINE_ID
, SOL1.LINE_ID
, SOL1.PARENT_LINE_ID
, SOL1.SHIPMENT_SCHEDULE_LINE_ID
, SOL1.LINE_NUMBER
, CZ.ASSIGNMENT_ID
, MSI.CONCATENATED_SEGMENTS UNION SELECT DISTINCT OE_CONFIG.CZ_MESSAGE_COUNT(CZ.SYSTEM_ID
, CZ.HEADER_ID
, CZ.LINE_ID)MESSAGE_COUNT
, OE_CONFIG.CZ_ERROR_COUNT(CZ.SYSTEM_ID
, CZ.HEADER_ID
, CZ.LINE_ID) ERROR_COUNT
, OE_CONFIG.CZ_SUGGEST_COUNT(CZ.SYSTEM_ID
, CZ.HEADER_ID
, CZ.LINE_ID) SUGGESTION_COUNT
, OE_CONFIG.CZ_WARN_COUNT(CZ.SYSTEM_ID
, CZ.HEADER_ID
, CZ.LINE_ID) WARNING_COUNT
, OE_CONFIG.CZ_AUTOSELECT_COUNT(CZ.SYSTEM_ID
, CZ.HEADER_ID
, CZ.LINE_ID) AUTOSELECTION_COUNT
, OE_CONFIG.CZ_OVERRIDEN_COUNT(CZ.SYSTEM_ID
, CZ.HEADER_ID
, CZ.LINE_ID) OVERRIDEN_ERROR_COUNT
, OE_CONFIG.CZ_OVERRIDE_ERROR_COUNT(CZ.SYSTEM_ID
, CZ.HEADER_ID
, CZ.LINE_ID) OVERRIDE_ERROR_COUNT
, CS.SYSTEM_ID
, CS.NAME SYSTEM_NAME
, NULL MODEL_NAME
, CZ.HEADER_ID
, 0 ORDER_NUMBER
, NULL ORDER_TYPE
, CZ.LINE_ID
, 0 LINE_NUMBER
, 0 SHIPMENT_NUMBER
, DECODE(NULL
, NULL
, NULL
, NULL) OPTION_NUMBER
FROM CS_SYSTEMS_ALL_TL CS
, CZ_ERRORS CZ
WHERE CS.SYSTEM_ID = CZ.SYSTEM_ID

Columns

Name
MESSAGE_COUNT
ERROR_COUNT
SUGGESTION_COUNT
WARNING_COUNT
AUTOSELECTION_COUNT
OVERRIDEN_ERROR_COUNT
OVERRIDE_ERROR_COUNT
SYSTEM_ID
SYSTEM_NAME
MODEL_NAME
HEADER_ID
ORDER_NUMBER
ORDER_TYPE
LINE_ID
LINE_NUMBER
SHIPMENT_NUMBER
OPTION_NUMBER