Subversion Repositories DevTools

Rev

Rev 5506 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 5506 Rev 5898
Line 1... Line 1...
1 
/* Planned (Pending) Package operation details */
 1 
/* Planned (Pending) Package operation details */
2 
SELECT
 - 
 
3 
(CASE
 - 
 
4 
    WHEN pl.operation IS NOT NULL THEN pl.operation ELSE ' '
 2 
SELECT NVL(pl.operation, ' ') AS operation, pv.build_type
5 
    END) AS operation
 - 
 
6 
FROM planned pl
 3 
 FROM planned pl, package_versions pv
7 
WHERE pl.PV_ID = :PV_ID
 4 
WHERE pl.PV_ID = :PV_ID
8 
AND pl.RTAG_ID = :RTAG_ID
 5 
  AND pl.RTAG_ID = :RTAG_ID
- 
 
 6 
  AND pv.pv_id = :PV_ID
9 
 
 7