Missing right paranthesis

Pierre Delareux

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

Sherry George

Try like this B2."QteATerm"

Pierre Delareux

Perfect !!

Thanks a lot

Pierre Delareux

Must better !!

But an other error occurs : ORA00904 B2.QteATarm is invalid.

Now the code is :

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

  ) B1,

  (

  SELECT QteCompl.udfnumber AS "QteATerm",

  blacti2.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

  ) B2

WHERE B1.ID = B2.ID

Pierre Delareux

can you precise "Aliasing" ?? thanks

Sherry George

Instead of "AS B1" and "AS B2"  just B1 and B2

Sherry George

Try aliasing the subquery without the AS keyword.