Invoice Filter does not work. Please review and provide any suggestion for this OTBI code.
Summary:
Invoice id Filter does not work. Please review and provide any suggestion for this OTBI code.
Content (required):
OTBI
Version (include the version you are using, if applicable):
22D
Code Snippet (add any code snippets that support your topic, if applicable):
SELECT
v_0 saw_0,
v_1 saw_1,
v_2 saw_2,
v_3 saw_3,
v_4 saw_4,
v_5 saw_5,
v_6 saw_6,
v_7 saw_7,
v_8 saw_8,
v_9 saw_9,
v_10 saw_10,
v_11 saw_11,
v_13 saw_12,
v_14 saw_13,
v_15 saw_14,
v_16 saw_15,
v_17 saw_16,
v_18 saw_17,
v_19 saw_18,
v_20 saw_19,
v_21 saw_20,
u_1 saw_21,
u_2 saw_22
FROM (SELECT
"- General Information"."Invoice Number" v_0,
"- Invoice Distribution Details - General Information"."Distribution Line Number" v_1,