ERROR PLS HELP

[abungas]

GOOD Day,

This is the  Query Statement...

Actually i only modify the query i only add a few columns

And this is a query statement

 

SELECT  C_ORDER.C_ORDER_ID,

    C_ORDER.DATEORDERED,

    C_ORDER.DOCUMENTNO,

    C_BPARTNER.NAME,

        C_BPARTNER_LOCATION.FAX,

    C_BPARTNER_LOCATION.PHONE,

        REPLACE(C_ORDER.DESCRIPTION, CHR(10), '') AS DESCRIPTION,

        REPLACE(C_ORDER.DELIVERYNOTES, CHR(10), '') AS DELIVERYNOTES,

        AD_CLIENT.DESCRIPTION AS ENTITY,

        C_LOCATION_DESCRIPTION(AD_ORGINFO.C_LOCATION_ID) AS LOCATION,

    FREIGHTCOSTRULE.NAME AS DELIVERYEXPENSE,

        DELIVERYRULE.NAME AS DELIVERYTERM,

    C_CURRENCY.ISO_CODE,

    PAYMENTTERM.TERM AS PAYMENTTERM,

        C_ORDER.DATEPROMISED,

    C_ORDER.CREATEDBY,

    C_ORDER.POSTED,

    C_ORDER.DELIVERY_LOCATION_ID

   

 

FROM    C_ORDER left join C_BPARTNER_LOCATION on C_ORDER.BILLTO_ID = C_BPARTNER_LOCATION.C_BPARTNER_ID,

        C_BPARTNER, AD_ORGINFO, AD_CLIENT, C_CURRENCY,

        (SELECT VALUE,

    NAME

FROM AD_REF_LIST_V

 

WHERE AD_REFERENCE_ID = 153

  AND AD_LANGUAGE = $P{LANGUAGE}) FREIGHTCOSTRULE,

      (SELECT VALUE,

    NAME

 

FROM AD_REF_LIST_V

 

WHERE AD_REFERENCE_ID = 151

  AND AD_LANGUAGE = $P{LANGUAGE}) DELIVERYRULE,

  (SELECT C_PAYMENTTERM.C_PAYMENTTERM_ID, COALESCE( C_PAYMENTTERM_TRL.NAME, C_PAYMENTTERM.NAME) AS TERM

 

FROM C_PAYMENTTERM LEFT JOIN C_PAYMENTTERM_TRL ON C_PAYMENTTERM.C_PAYMENTTERM_ID = C_PAYMENTTERM_TRL.C_PAYMENTTERM_ID

   AND C_PAYMENTTERM_TRL.AD_LANGUAGE= $P{LANGUAGE}) PAYMENTTERM

WHERE C_ORDER.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID

AND C_ORDER.ISSOTRX = 'N'

AND C_ORDER.ad_org_id = AD_ORGINFO.ad_org_id

AND C_ORDER.AD_CLIENT_ID = AD_CLIENT.AD_CLIENT_ID

AND C_ORDER.FREIGHTCOSTRULE = FREIGHTCOSTRULE.VALUE

AND C_ORDER.DELIVERYRULE = DELIVERYRULE.VALUE

AND C_ORDER.C_CURRENCY_ID = C_CURRENCY.C_CURRENCY_ID

AND C_ORDER.C_PAYMENTTERM_ID = PAYMENTTERM.C_PAYMENTTERM_ID

AND C_ORDER.C_ORDER_ID IN $P!{ORDER_ID}

 

 

 

And this is the ERROR Massage....

net.sf.jasperreports.engine.design.JRValidationException: Report design not valid :      

1. Field not found : C_ORDER_ID    

 2. Field not found : ENTITY     

3. Field not found : NAME    

 4. Field not found : FAX     

5. Field not found : DOCUMENTNO     

6. Field not found : LOCATION     

7. Field not found : C_ORDER_ID     

8. Field not found : ISO_CODE     

9. Field not found : DELIVERYNOTES     

10. Field not found : DESCRIPTION     

11. Field not found : DELIVERYTERM     

12. Field not found : DELIVERYEXPENSE    

 13. Field not found : PAYMENTTERM    

at net.sf.jasperreports.engine.design.JRAbstractCompiler.verifyDesign(JRAbstractCompiler.java:260)     at net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:144)     at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:587)     at java.lang.Thread.run(Unknown Source)

Which is this Field is actually existing from the original query and even in the New query PLS hep me is there anay thing should i Configure