Display org name base on resp id in Form
HI : I am new using oracle Form 6i to support EBS 11.5.10.2. I use template.fmb to create a simple form. I was able to use fnd_profile.value(org_id ) to get the org_id. here is my questions
1) I need to use this org_id to display the organization name on the form. Then also save the org_id into a custom table. The organization name is display only. and should not affect anything. How to do that?
2) the org_id is different. I need to save it back to custom table. not a issue. But I have to use it as a filter when I do the Find/F11 to retrieve record from custom table. For example. if user login as US responsibility, the org_Id = 1 ( assume org_id = 1 mean US organization ). when user do the F11 to find all record, it should only returns the record with org_id = 1 ( select * from custom_table where org_id = 1 ). Now the thing is the org_id is not a display field. So user