| Line 50... |
Line 50... |
| 50 |
joiner = ""
|
50 |
joiner = ""
|
| 51 |
If InStr(parReason, "N") <> 0 Then sReason = sReason & joiner & "'N'" : joiner = ","
|
51 |
If InStr(parReason, "N") <> 0 Then sReason = sReason & joiner & "'N'" : joiner = ","
|
| 52 |
If InStr(parReason, "R") <> 0 Then sReason = sReason & joiner & "'R'" : joiner = ","
|
52 |
If InStr(parReason, "R") <> 0 Then sReason = sReason & joiner & "'R'" : joiner = ","
|
| 53 |
If InStr(parReason, "T") <> 0 Then sReason = sReason & joiner & "'T'" : joiner = ","
|
53 |
If InStr(parReason, "T") <> 0 Then sReason = sReason & joiner & "'T'" : joiner = ","
|
| 54 |
If InStr(parReason, "P") <> 0 Then sReason = sReason & joiner & "'P'" : joiner = ","
|
54 |
If InStr(parReason, "P") <> 0 Then sReason = sReason & joiner & "'P'" : joiner = ","
|
| - |
|
55 |
If InStr(parReason, "F") <> 0 Then sReason = sReason & joiner & "'F'" : joiner = ","
|
| 55 |
If sReason <> "" Then
|
56 |
If sReason <> "" Then
|
| 56 |
sReason = " AND bi.reason in (" & sReason & ")"
|
57 |
sReason = " AND bi.reason in (" & sReason & ")"
|
| 57 |
End If
|
58 |
End If
|
| 58 |
End If
|
59 |
End If
|
| 59 |
|
60 |
|
| Line 161... |
Line 162... |
| 161 |
" pj.PROJ_ID, " &_
|
162 |
" pj.PROJ_ID, " &_
|
| 162 |
" RTAG_NAME, " &_
|
163 |
" RTAG_NAME, " &_
|
| 163 |
" p.PKG_NAME, " &_
|
164 |
" p.PKG_NAME, " &_
|
| 164 |
" NVL(pv.V_EXT, '') AS V_EXT, " &_
|
165 |
" NVL(pv.V_EXT, '') AS V_EXT, " &_
|
| 165 |
" TO_CHAR(bi.TIMESTAMP, 'Dy DD-Mon-YYYY HH24:MI:SS') AS TIMESTAMPTXT, " &_
|
166 |
" TO_CHAR(bi.TIMESTAMP, 'Dy DD-Mon-YYYY HH24:MI:SS') AS TIMESTAMPTXT, " &_
|
| 166 |
" DECODE(bi.reason, 'N', 'New Version', 'R', 'Ripple', 'T', 'Test', 'P', 'Restored', 'Unknown') AS REASON, " &_
|
167 |
" DECODE(bi.reason, 'N', 'New Version', 'R', 'Ripple', 'T', 'Test', 'P', 'Restored', 'F', 'ForcedRipple', 'Unknown') AS REASON, " &_
|
| 167 |
" DECODE(bi.state, 'B', 'Buiding', 'C', 'Complete', 'E', 'Error', 'S', 'SysErr', 'Unknown') AS STATE, " &_
|
168 |
" DECODE(bi.state, 'B', 'Buiding', 'C', 'Complete', 'E', 'Error', 'S', 'SysErr', 'Unknown') AS STATE, " &_
|
| 168 |
" bi.build_id " &_
|
169 |
" bi.build_id " &_
|
| 169 |
"FROM BUILD_INSTANCES bi, " &_
|
170 |
"FROM BUILD_INSTANCES bi, " &_
|
| 170 |
" projects pj, " &_
|
171 |
" projects pj, " &_
|
| 171 |
" RELEASE_TAGS rt, " &_
|
172 |
" RELEASE_TAGS rt, " &_
|