Summary

[BIP]Missing right paranthesis

Content

hi,

I tried to use the query below.

It gave me an error ORA 000907 - Missing right parenthesis.

--------------

SELECT B1.Phase AS "Budget - Phase",

  B1.PhaseDesc AS "Budget - Phase - Desc",

  B1.Imput AS "Budget - Imput",

  B1.ImputDesc AS "Budget - Imput - Desc",

  B1.CRURef AS "CRU Ref",

  B1.id as "ID TACHE",

  B2.QteATerm AS "Qte A Term"

FROM (

  SELECT phase.activitycodevalue AS "Phase",

  phase.activitycodedescription AS "PhaseDesc",

  imput.activitycodevalue AS "Imput",

  imput.activitycodedescription AS "ImputDesc",

  CRURef.udfnumber AS "CRURef",

  blacti.id AS "ID"

  FROM baseline bsln

  INNER JOIN blactivity blacti ON blacti.projectobjectid = bsln.objectid

  INNER JOIN activitycodeassignment phase ON phase.activityobjectid = blacti.objectid

  AND phase.activitycodetypename = 'Phase Budget'

  LEFT OUTER JOIN activitycodeassignment imput ON imput.activityobjectid = blacti.objectid

  AND imput.activitycodetypename = 'Imputs'

  INNER JOIN project proj ON proj.id = :p_Project_ID

  LEFT OUTER JOIN udfvalue CRURef ON CRURef.foreignobjectid = blacti.objectid

  AND CRURef.udftypeobjectid IN (

  SELECT ut_cruref.objectid

  FROM udftype ut_cruref

  WHERE ut_cruref.title = 'SPEC-CUP Ref/Planned Baseline Unit Cost'

  )

  WHERE bsln.id = :bl_budget

  ) AS B1,

  (

  SELECT QteCompl.udfnumber AS "QteATerm",

  blacti.id AS "ID"

  FROM baseline bsln2

  INNER JOIN blactivity blacti2 ON blacti2.projectobjectid = bsln2.objectid

  LEFT OUTER JOIN udfvalue QteCompl ON QteCompl.foreignobjectid = blacti2.objectid

  AND QteCompl.udftypeobjectid IN (

  SELECT ut_qtecompl.objectid

  FROM udftype ut_qtecompl

  WHERE ut_qtecompl.title = 'SPEC-Qte a Terminaison/Qty at Completion'

  )

  WHERE bsln2.id = :bl_progres

  ) AS B2

WHERE B1.ID = B2.ID

--------------

I can't understand why.

Thanks

Pierre