APEX

I see a discrepancy between what my bar chart shows and the data when looked at in the Database (Both SQL Developer and within SQL Workshop with Apex - These 2 are in sync) - I am perplexed as to how this is happening.

This is my bar chart screenshot (below),

When the SQL query is executed in both SQL Developer and SQL Workshop (within APEX) - I am getting the below dataset,

And from this its clear that the discrepancy is on "Pending Return" status that database shows it's against EQ TEC DE INF (Asset Type) and Chart shows it's against EQ AGRICOLA (Asset Type)

Note: Caching is disabled both at the application level and also at the chart/region level and I have tried logging out and logging back multiple times just to make sure if its down any session cache?

My SQL query which is in the series is as below with ASSET_RETURN_STATUS being the "Series", ASSET_TYPE being the "Label" and COUNT(ASSET_SERIAL) being "Value"

SELECT ASSET_RETURN_STATUS

   ,ASSET\_TYPE

   ,COUNT(ASSET\_SERIAL)

FROM (SELECT DISTINCT

           FAC.SEGMENT1                                                  ASSET\_TYPE

           ,ASR.ARS\_CODE                                                 ARS\_CODE

           ,ASR.ASSET\_RETURN\_STATUS                                      ASSET\_RETURN\_STATUS

           ,NVL(CSI.SERIAL\_NUMBER,ASR.ASSET\_NUMBER)                      ASSET\_SERIAL

      FROM APPS.CSI\_ITEM\_INSTANCES           CSI

           ,APPS.OKC\_K\_ITEMS                 CIM\_IB

           ,APPS.OKC\_K\_LINES\_B             CLE\_IB

           ,APPS.OKC\_LINE\_STYLES\_B           LSE\_IB

           ,APPS.OKC\_K\_LINES\_B             CLE\_INST

           ,APPS.OKC\_K\_LINES\_B               CLE\_FIN

           ,APPS.OKL\_TXL\_ASSETS\_B     OFA

           ,APPS.OKC\_K\_LINES\_TL     CLE\_ASSET

           ,APPS.FA\_ADDITIONS\_B              FAA

           ,APPS.FA\_CATEGORIES\_B             FAC

           ,APPS.OKL\_AM\_ASSET\_RETURNS\_UV     ASR

     WHERE 1 = 1

       AND CSI.INSTANCE\_ID             = CIM\_IB.OBJECT1\_ID1

       AND CIM\_IB.CLE\_ID        = CLE\_IB.ID

       AND CIM\_IB.DNZ\_CHR\_ID         = CLE\_IB.DNZ\_CHR\_ID

       AND CLE\_IB.LSE\_ID           = LSE\_IB.ID

       AND CLE\_IB.CLE\_ID        = CLE\_INST.ID

       AND CLE\_IB.DNZ\_CHR\_ID        = CLE\_INST.DNZ\_CHR\_ID

       AND CLE\_FIN.CHR\_ID        = CLE\_FIN.DNZ\_CHR\_ID

       AND CLE\_INST.CLE\_ID        = CLE\_FIN.ID

       AND CLE\_INST.DNZ\_CHR\_ID        = CLE\_FIN.DNZ\_CHR\_ID

       AND OFA.DNZ\_KHR\_ID        = CLE\_FIN.DNZ\_CHR\_ID

       AND OFA.ASSET\_NUMBER             = CLE\_ASSET.NAME

       AND OFA.ASSET\_NUMBER             = FAA.ASSET\_NUMBER

       AND FAA.ASSET\_CATEGORY\_ID       = FAC.CATEGORY\_ID

       AND CLE\_FIN.CLE\_ID        IS NULL

       AND OFA.TAL\_TYPE                 = 'CFA'

       AND CLE\_FIN.ID            = CLE\_ASSET.ID

       AND ASR.KLE\_ID            = CLE\_FIN.ID

       AND CIM\_IB.JTOT\_OBJECT1\_CODE     = 'OKX\_IB\_ITEM'

       AND CIM\_IB.OBJECT1\_ID2           = '#'

       AND ASR.ARS\_CODE            IN ('SCHEDULED','PENDING\_RETURN','RETURNED','RET\_INSPECTED','AVAILABLE\_FOR\_SALE')

       AND CLE\_ASSET.LANGUAGE      = 'US'

   )

   GROUP BY ASSET\_RETURN\_STATUS

   ,ASSET\_TYPE