You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!