exp userid=wyeth/wyeth@oce.systimembp.com owner=wyeth direct=y constraints=y indexes=y statistics=none file=c:\exp10g.dmp

ORA-04063: view "WYETHTEST.RAW_MATERIAL_LOT_MATCHING_RPT" has errors

CREATE OR REPLACE VIEW RAW_MATERIAL_LOT_MATCHING_RPT
(WN_JDE_LOT, WN_SUPPLIER, WN_ITEM_NO, NAME, REPORTED_VALUE)
AS 
SELECT
    SAMPLE.WN_JDE_LOT,
    SAMPLE.WN_SUPPLIER,
    SAMPLE.WN_ITEM_NO,
    RESULT.NAME, 
    RESULT.REPORTED_VALUE 
FROM 
    RESULT@DB_LIMS, TEST@DB_LIMS, SAMPLE@DB_LIMS
WHERE
    RESULT.TEST_NUMBER = TEST.TEST_NUMBER
    AND TEST.SAMPLE_NUMBER = SAMPLE.SAMPLE_NUMBER
    AND SAMPLE.STAGE = 'CHEMISTRY' 
    AND SAMPLE.WN_SAMPLE_TYPE  = 'RM' 
    AND SAMPLE.STATUS = 'A' 
    AND SAMPLE.WN_ITEM_NO = 'X0194'
    AND TEST.STATUS = 'A'
        AND RESULT.STATUS = 'A'
    AND RESULT.NAME IN('Avg of Calcium','Avg of Magnesium','Avg of Phosphorus','Avg of Potassium','Avg of Protein','Avg of Sodium','RM Chloride result')
/