with clause subquery and function together and usage of bind variable

Summary:

Hi Team,

I am facing an error as "ORA-17003: Invalid column index".

I am using functions(with clause) and I have to get the value from the BIP report parameter.

I tried below but none worked.

1. Simple SELECT (also attached here the query)
2. Used the above SELECT in another with clause (sub-query)
3. Used CASE or DECODE statements

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):