SELECT                                                 /*+DRIVING_SITE(B)*/
                                                          /*+PARALLEL(A,100)*/
          B.SECURITY_ALIAS,
          '91821XAD5',
          A.SECURITY_ALIAS,
          '91821XAD5',
          'SECURITY_MASTER_DETAIL_HIST',
          'USER_GROUP_CHAR8',
          B.USER_GROUP_CHAR8,
          CAST (A.USER_GROUP_CHAR8 AS VARCHAR2 (100))
     FROM APP_DEVELOPMENT.SEC_MASTER_DTL_HIST_TBL A,
          SECURITYDBO.SECURITY_MASTER_DETAIL_HIST B
    WHERE     A.SRC_INTFC_INST = 140
          AND B.SRC_INTFC_INST = 140
          AND A.SECURITY_ALIAS = 100144129
          AND b.security_alias = 224719
          AND b.effective_date ='25-Apr-2006'
          AND A.USER_GROUP_CHAR8 <> B.USER_GROUP_CHAR8
   UNION ALL
   SELECT /*+DRIVING_SITE(B)*/
                                                          /*+PARALLEL(A,100)*/
          B.SECURITY_ALIAS,
          '91821XAD5',
          A.SECURITY_ALIAS,
          '91821XAD5',
          'SECURITY_MASTER_DETAIL_HIST',
          'USER_GROUP_CHAR8',
          B.USER_GROUP_CHAR8,
          'No Records Found'
     FROM APP_DEVELOPMENT.SEC_MASTER_DTL_HIST_TBL A,
          SECURITYDBO.SECURITY_MASTER_DETAIL_HIST B
    WHERE     A.SRC_INTFC_INST = 140
          AND B.SRC_INTFC_INST = 140
          AND A.SECURITY_ALIAS = 100144129
          AND b.security_alias = 224719
          AND b.effective_date ='25-Apr-2006'
          AND SYS_OP_MAP_NONNULL (A.USER_GROUP_CHAR8) = 'FF'
          AND SYS_OP_MAP_NONNULL (B.USER_GROUP_CHAR8) <> 'FF'