SELECT
IssueResolutionLink.issueResolutionLinkID,
IssueResolutionLink.resolutionConfigurationID,
ResolutionConfiguration.resolution,
IssueResolutionLink.startDate,
IssueResolutionLink.endDate,
IssueResolutionLink.recordStatus
INTO
:issueResolutionLinkID,
:resolutionConfigurationID,
:resolution,
:startDate,
:endDate,
:recordStatus
FROM
IssueResolutionLink,
ResolutionConfiguration
WHERE IssueResolutionLink.issueConfigurationID = :issueConfigurationID
AND IssueResolutionLink.resolutionConfigurationID = ResolutionConfiguration.resolutionConfigurationID
ORDER BY recordStatus,
startDate ASC
|