SELECT
TPDecisionOutcome.tpDecisionOutcomeID,
TPDecisionOutcome.decisionMatrixVersionID,
TPDecisionOutcome.outcomeID,
TPDecisionOutcome.typicalPictureVersionID,
TPDecisionOutcome.comments,
DAOutcome.outcomeName,
DecisionMatrixVersion.name
INTO
:tpDecisionOutcomeID,
:decisionMatrixVersionID,
:outcomeID,
:typicalPictureVersionID,
:comments,
:outcomeName,
:decisionMatrixName
FROM
TPDecisionOutcome,
DAOutcome,
DecisionMatrixVersion
WHERE TPDecisionOutcome.typicalPictureVersionID = :typicalPictureVersionID
AND TPDecisionOutcome.outcomeID = DAOutcome.outcomeID
AND TPDecisionOutcome.decisionMatrixVersionID = DecisionMatrixVersion.decisionMatrixVersionID
|