0

How to define Decode in Materialized View

Hi,

can anyone help me how to convert below query in Materialized View?

ROUND(DECODE (ACOST.ORGANIZATION_ID, APARM.COST_ORGANIZATION_ID, DECODE (ACOST.COST_TYPE_ID, CTYPE.COST_TYPE_ID, NVL (ACOST.MATERIAL_COST, 0),
            CTYPE.DEFAULT_COST_TYPE_ID, NVL (ACOST.MATERIAL_COST, 0), 0), 0), 2) 

 

Regards,

Hari.

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • 4 mths agoLast active
  • 1Replies
  • 14Views
  • 2 Following

Product Announcement

Incorta 4.9 is now Generally Available (GA)!!!