sql_nationalworker.txt
| 1 |
SELECT msor.SOURCE_ID , |
|---|---|
| 2 |
msor.SOURCE_STATUS , |
| 3 |
msor.CREATED_DATE, |
| 4 |
msor.FILE_RECID , |
| 5 |
(SELECT mv.LICN_CON_NO |
| 6 |
FROM MOSAL_USER.NMP_LICNFILE_V mv , |
| 7 |
INS_SOURCE_ORDER_DTL dtl |
| 8 |
WHERE dtl.lf_recid = mv.LF_RECID |
| 9 |
AND dtl.SOURCE_ID = msor.SOURCE_ID |
| 10 |
) LICN_civil_NO |
| 11 |
FROM INS_SOURCE_ORDER msor |
| 12 |
WHERE msor.SOURCE_TYPE in ( 1,5,6) |
| 13 |
AND msor.SOURCE_ID IN |
| 14 |
( SELECT SOURCE_ID FROM INS_SOURCE_ORDER_DTL WHERE INSPECTION_TYPE_ID IN (4,5)) |
| 15 |
AND msor.FILE_RECID = :b_fileRecid |