How do you get an existing field (not a custom field) to show up on a different page?
I am trying to display the Organization Code (org_code) from the Organization and Position Assignments page (company_pers_assign_act view) on the Purchase Orders Lines (POL) page (purchase_order_line_all view). So it is an already existing field and not a custom field. When I try to create a custom field so it will display on the POL page I cannot get it to work. I have tried Reference (can’t find the field I want to display), Select (mostly get the not a custom field error) and Expression (Mostly get statement is invalid).
I am not 100% sure which is the best route. I thougtht the expression looked the most promising. I have tried:
company_pers_assign_api.get_org_code((select assignment_seq_no from company_pers_assign_act where person_id = v.authorize_code))
as the expression. The get_org_code needs the assignment_seq_no as the parameter which is what the select statement is trying to get. Looking at the COMPANY_PERS_ASSIGN_ACT view it does look to have assignment_seq_no as one of the fields, but couldn’t get that to work (got statement is invalid).
So, how an I get an existing field to display in a different page not associated with said view/field?