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
Get Started with Redwood: Oracle Cloud SCM and Purchasing

TAble type value set to refer field in the screen

In table type value set how to refer field from screen eg (po_header_id)

Content (please ensure you mask any confidential information):

Dear Team,

iRequirement

In PO screen i have created DFF with Table type

query

SELECT DISTINCT PRHA.requisition_header_id

FROM por_req_distributions_all PRDA,

por_requisition_lines_all PRLA,

por_requisition_headers_all PRHA,

po_headers_all poh,

po_distributions_all pda

WHERE PRDA.distribution_id = req_distribution_id

AND PRDA.requisition_line_id = PRLA.requisition_line_id

AND prha.requisition_header_id = prla.requisition_header_id

and poh.po_header_id=pda.po_header_id

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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