Default work type value from Cost Collection descriptive flexfield using the value of Project ID
Content
Hi Gurus-
Is there a way to default the value of the Work Type field base on the entered Project Number/ID on requisition distribution?
I tried to use SQL default type and use below SQL. However it doesn't work.
Select pwtt.name from pjf_project_all_b ppab, pjf_work_types_tl pwtt where ppab.work_type_id = pwtt.work_type_id and ppab.project_id = :{PARAMETER.ProjectId}
Any suggestion or inputs if anyone already tried it?
Thanks in advance
Haydee
Tagged:
0