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

Define value set with bind variable

Accepted answer
173
Views
11
Comments
edited Mar 15, 2019 2:44AM in Purchasing 11 comments

Summary

Define value set with bind variable

Content

I have a requirement to define a value set in PO Distribution level and such value always the same as the PO charge account segment3.

SELECT cc.segment3 DEPT,

 FROM po_distributions_all po_dis,

             gl_code_combinations cc

 WHERE po_dis.CODE_COMBINATION_ID = cc.CODE_COMBINATION_ID

 and        po_dis.po_distribution_id = ?????? (screen UI)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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