SQL Language (MOSC)

MOSC Banner

connect prior to

edited Sep 20, 2011 3:29AM in SQL Language (MOSC) 2 commentsAnswered
I am trying to make a query on Projects that shows commitments on the lowest task level and all tasks above. I am close but the results are wrong. On the middle task level wrong tasks pop up.

This query shows the right 3 tasks:

select wbs_level, task_id, task_number, parent_task_id
from pa_tasks
where project_id = 1891
start with task_id = 256202 connect by prior parent_task_id = task_id
;

This query shows 4 tasks:

select t.task_id, t.parent_task_id,  a.line_type, t.task_number, sum(distinct ACCT_RAW_COST)
from pa_commitment_txns_v a, pa_tasks t

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center