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