Creating Value Set with 'Table' as validation type
Summary:
I have this query that I want to use as for my Invoice Line DFF's value set
SELECT gcc1.segment1 || '.' || gcc1.segment2 || '.' || gcc1.segment3 || '.' || gcc1.segment4 || '.' || gcc1.segment5 || '.' || gcc1.segment6 || '.' || gcc1.segment7 as PO_CHARGE_ACCOUNT
, po_line_id
FROM po_distributions_all d LEFT JOIN gl_code_combinations gcc1
on gcc1.code_combination_id = d.code_combination_id
Content (please ensure you mask any confidential information):
How to distribute that query to become the definition of my Table Value Set?
Version (include the version you are using, if applicable):
0