Cost center and sub-cost center UDV query

[millicentdark]

Hi Experts,

We have set up cost centers for our customer to assign to their transactions.

We will like to assign sub cost centers whenever a cost center is chosen automatically with a query.

Below are the cost centers defined and their respective sub cost centers and the query i applied but it does not work well.

Urgent assistance on how to rectify this without issues will be appreciated.

select case

(when rct2.OcrCode = 'ADM' then 'AD'

end)

My customer needs this to work urgently.

Regards

Justice

[millicentdark]

Hi All,

any assistance with my request?    

Regards

Justice