Subversion Repositories DevTools

Rev

Rev 5686 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 5686 Rev 5687
Line 677... Line 677...
677
    SELECT an.note_id, an.NOTE_TITLE, an.NOTE_BODY, an.mod_date, usr.full_name, usr.user_email,
677
    SELECT an.note_id, an.NOTE_TITLE, an.NOTE_BODY, an.mod_date, usr.full_name, usr.user_email,
678
        an.mod_date ||' by '|| usr.full_name AS lastmod
678
        an.mod_date ||' by '|| usr.full_name AS lastmod
679
    FROM RELEASE_MANAGER.ADDITIONAL_NOTES an,
679
    FROM RELEASE_MANAGER.ADDITIONAL_NOTES an,
680
    RELEASE_MANAGER.USERS usr
680
    RELEASE_MANAGER.USERS usr
681
    WHERE an.pv_id = $opt_pvid
681
    WHERE an.pv_id = $opt_pvid
682
    AND an.mod_user = usr.user_id
682
    AND an.mod_user = usr.user_id(+)
683
    ORDER BY an.note_id
683
    ORDER BY an.note_id
684
END_SQL
684
END_SQL
685
 
685
 
686
    my @items = qw(
686
    my @items = qw(
687
        -note_id
687
        -note_id
Line 773... Line 773...
773
           AND olddep.pv_id = :OLD_PV_ID
773
           AND olddep.pv_id = :OLD_PV_ID
774
           AND newdpv.pkg_id = olddpv.pkg_id 
774
           AND newdpv.pkg_id = olddpv.pkg_id 
775
           AND NVL( newdpv.v_ext , 'LINK_A_NULL' ) = NVL( olddpv.v_ext, 'LINK_A_NULL' )
775
           AND NVL( newdpv.v_ext , 'LINK_A_NULL' ) = NVL( olddpv.v_ext, 'LINK_A_NULL' )
776
        ) comp
776
        ) comp
777
 WHERE comp.pkg_id = pkg.pkg_id  
777
 WHERE comp.pkg_id = pkg.pkg_id  
778
   AND comp.modifier_id = usr.user_id
778
   AND comp.modifier_id = usr.user_id(+)
779
 ORDER BY UPPER(pkg.pkg_name) 
779
 ORDER BY UPPER(pkg.pkg_name) 
780
END_SQL
780
END_SQL
781
 
781
 
782
    my @items = qw(
782
    my @items = qw(
783
        name
783
        name