在不存在对应记录的地方插入记录

我有包含以下数据的问题:

ISSUEID QUOTEID ISSUE_TYPE  DATE_ADDED  DATE_RESOLVED   RESOLVED_BY RESOLVED
4312    989435  TPIUplift   14-Jun-18                               N
4316    989077  TPIUplift   14-Jun-18                               N
4333    989071  TPIUplift   14-Jun-18                               N
4324    988403  TPIUplift   14-Jun-18   14-Jun-18       JohnSmith   Y
4323    988402  TPIUplift   14-Jun-18                               N
4317    987964  TPIUplift   14-Jun-18                               N

这个剧本:

INSERT INTO tblissues (
    quoteid,
    issue_type,
    date_added,
    resolved
)
    SELECT
        *
    FROM
        (
            SELECT
                q.quoteid,
                'TPIUplift',
                trunc(SYSDATE) newissuedate,
                'N'
            FROM
                tblquotesnew q
                LEFT JOIN tbltariffsnew t ON q.tariff_id = t.tariffid
            WHERE
                t.uplift = 0
                AND   q.sales_route = 'TPI'
                AND   q.quote_status = 'Accepted'
                AND   q.status <> 'Cancelled'
        ) x

脚本查找问题(这些问题将始终存在)。我希望添加新记录,但前提是现有的已解析记录不存在。

我已在插入的where子句中尝试使用此语句,但仍添加了一行

  WHERE
        NOT EXISTS (
            SELECT
                *
            FROM
                tblissues
            WHERE
                (x.quoteid = tblissues.quoteid
                AND   tblissues.issue_type = 'TPIUplift'
                AND   tblissues.resolved <> 'Y')

所以使用上面的示例数据,我不希望为quoteid 988403插入行,因为它的解析值是y。

这可能吗?