ins rep_exiting.txt
| 1 |
, TO_CHAR ((SELECT AVD.VOILATION_PRINTING_DATE FROM INS_VIOLATION_AVOIDANCE AVD |
|---|---|
| 2 |
WHERE AVD.VISIT_ID = $P{visitid} AND ROWNUM =1), 'HH:MI' ) AS "INS_TIME_visit1"
|
| 3 |
, (CASE TO_CHAR ((SELECT AVD.VOILATION_PRINTING_DATE FROM INS_VIOLATION_AVOIDANCE AVD |
| 4 |
WHERE AVD.VISIT_ID = $P{visitid} AND ROWNUM =1), 'AM') WHEN 'PM' THEN '????' WHEN 'AM' THEN '?????' END ) AS "TIME_TYPE_visit1"
|
| 5 |
-- *---------------------------------------------------------- |
| 6 |
|
| 7 |
, (SELECT TO_CHAR ((SELECT AVD.AVOIDANCE_PRINTING_DATE FROM INS_VIOLATION_AVOIDANCE AVD |
| 8 |
WHERE AVD.VISIT_ID = $P{visitid} AND ROWNUM =1 ), 'HH:MI') FROM DUAL ) AS "INS_TIME_visit_2"
|
| 9 |
, (CASE (SELECT TO_CHAR ((SELECT AVD.AVOIDANCE_PRINTING_DATE FROM INS_VIOLATION_AVOIDANCE AVD |
| 10 |
WHERE AVD.VISIT_ID = $P{visitid} AND ROWNUM =1 ), 'AM') FROM DUAL ) WHEN 'PM' THEN '????' WHEN 'AM' THEN '?????' END ) AS "TIME_TYPE_visit_2"
|