Subversion Repositories DevTools

Rev

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

Rev 5506 Rev 5759
Line 1... Line 1...
1 
/* Find Package Version */
 1 
/* Find Package Version */
2 
SELECT pv.PKG_VERSION,
 2 
SELECT DISTINCT pv.PKG_VERSION,
3 
	   pv.PV_ID,
 3 
    pv.PV_ID,
4 
	   pv.DLOCKED,
 4 
    pv.DLOCKED,
5 
	   pv.MODIFIED_STAMP,
 5 
    pv.MODIFIED_STAMP,
6 
	   pv.COMMENTS,
 6 
    pv.COMMENTS,
7 
	   NVL(usr.FULL_NAME, 'Unknown User') AS FULL_NAME,
 7 
    NVL(usr.FULL_NAME, 'Unknown User') AS FULL_NAME,
8 
	   usr.USER_EMAIL
 8 
    usr.USER_EMAIL,
- 
 
 9 
    -- Field to assist in determining if the user can delete the version
- 
 
 10 
    pv.OWNER_ID,
- 
 
 11 
    pv.CREATOR_ID,
- 
 
 12 
    NVL2(rc.rtag_id,1,0) as inuse,
- 
 
 13 
    trunc(SYSDATE - pv.CREATED_STAMP + 0.5) as age
9 
  FROM PACKAGE_VERSIONS pv,
 14 
  FROM PACKAGE_VERSIONS pv,
10 
  	   USERS usr
 15 
       USERS usr,
- 
 
 16 
       RELEASE_CONTENT rc
11 
 WHERE pv.PKG_ID = :PKG_ID
 17 
 WHERE pv.PKG_ID = :PKG_ID
12 
   AND pv.PKG_VERSION LIKE :PKG_VERSION
 18 
   AND pv.PKG_VERSION LIKE :PKG_VERSION
13 
   AND pv.MODIFIER_ID = usr.USER_ID(+)
 19 
   AND pv.MODIFIER_ID = usr.USER_ID(+)
14
- 
 
15 

            20
            
   AND pv.pv_id = rc.pv_id(+)      

          

          

            -
            
 

            21
            

          

          

            16
            

            22