| Line 14... |
Line 14... |
| 14 |
"select bi.BUILD_ID, bi.PV_ID, bi.RTAG_ID,pv.pkg_id," &_
|
14 |
"select bi.BUILD_ID, bi.PV_ID, bi.RTAG_ID,pv.pkg_id," &_
|
| 15 |
" SUBSTR(NVL(pj.PROJ_NAME,'-Deleted-'), 0, 60) as PROJ_NAME, " &_
|
15 |
" SUBSTR(NVL(pj.PROJ_NAME,'-Deleted-'), 0, 60) as PROJ_NAME, " &_
|
| 16 |
" pj.PROJ_ID, " &_
|
16 |
" pj.PROJ_ID, " &_
|
| 17 |
" SUBSTR(NVL(rt.RTAG_NAME,'-Deleted-'), 0, 60) as RTAG_NAME, " &_
|
17 |
" SUBSTR(NVL(rt.RTAG_NAME,'-Deleted-'), 0, 60) as RTAG_NAME, " &_
|
| 18 |
" TO_CHAR(bi.TIMESTAMP, 'Dy DD-Mon-YYYY HH24:MI:SS') as TIMESTAMP, " &_
|
18 |
" TO_CHAR(bi.TIMESTAMP, 'Dy DD-Mon-YYYY HH24:MI:SS') as TIMESTAMP, " &_
|
| 19 |
" DECODE(bi.reason, 'N', 'New Version', 'R', 'Ripple', 'T', 'Test', 'P', 'Restored', 'Unknown') as REASON," &_
|
19 |
" DECODE(bi.reason, 'N', 'New Version', 'R', 'Ripple', 'T', 'Test', 'P', 'Restored', 'F', 'ForcedRipple', 'Unknown') as REASON," &_
|
| 20 |
" DECODE(bi.state, 'B', 'Buiding', 'C', 'Complete', 'E', 'Error', 'S', 'SysErr', 'Unknown') as STATE" &_
|
20 |
" DECODE(bi.state, 'B', 'Buiding', 'C', 'Complete', 'E', 'Error', 'S', 'SysErr', 'Unknown') as STATE" &_
|
| 21 |
" from BUILD_INSTANCES bi, " &_
|
21 |
" from BUILD_INSTANCES bi, " &_
|
| 22 |
" projects pj, " &_
|
22 |
" projects pj, " &_
|
| 23 |
" RELEASE_TAGS rt, " &_
|
23 |
" RELEASE_TAGS rt, " &_
|
| 24 |
" packages p, " &_
|
24 |
" packages p, " &_
|