Task / Role relationship

Hi to all. As probably many of you out there I was waiting for SAR # 5714205 so that we can finally get a report of the task/role relationship. They released it in ERP 9. We are running XE UPD5 SP19.1 in coexistence so supposedly that wouldn't work for us. If someone running ERP 9 could send me the source I'd appreciate it very much - that would help us to develop our own report and perhaps share with the rest of the list running in coexistence. Thanks in advance!

ERP9 has not been released yet. I think it might be
out in fall of 2003.

--- kate <[email protected]> wrote:
http://www.jdelist.com/ubb/showthreaded.php?Cat=&Board=OW&Number=50650


__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/

Oh great :-(
Thanks for the info.

Are you using Oracle? If so, the following works in Oracle 8.1.7, untested in other versions. It will display the entire task view for task 01 - in this case DV.

select lpad(' ',3*tr.LEV) ||tm.tmlngtask || ',' || tm.tmobnm || ',' || tm.tmver || ',' || tm.tmfmnm || ',' || tm.tmopcd
from testctl.f9000 tm,
(select tr.trparnttsk "TRPARNT", tr.trchildtsk "TRCHILD", level "LEV"
from testctl.f9001 tr
start with tr.trparnttsk = '01'
connect by prior tr.trchildtsk = tr.trparnttsk) tr
where tm.tmtaskid = tr.TRCHILD
and length(trim(tm.tmlngtask)) > 0

Not sure if this is something like what you're looking for?? I have also a couple of other slight modifications that allow you to display the task view for a given role.

- --
OneWorld XE SP20_N1
Oracle 8.1.7.3, HP-UX 11i
Citrix XPe