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

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!