Bug #753
ins045 نواقص العمالة الوطنية _new
Status:
Closed
Priority:
High
Assignee:
Abdelhalim Abu Qamar
Start date:
10/08/2018
Due date:
% Done:
0%
Description
kindly update (نواقص العمالة الوطنية) with new issues :
----------------------------
1-show (RES=1 موقع اخر) while new location reason
-- FIND ATT. PIC.
----------------------------
2-show LOV for all license of file while reason is another license = 15
SELECT LF.LF_RECID , LICN_CIVIL_ID,L.COMPANY_NAME LICN_NAME
FROM NMP_FILE F,NMP_LICNFILE LF,pmp_licn_req l
WHERE ONR_ID = :ONR_ID
AND LF.FLE_RECID = F.FILE_RECID
AND LF.LIC_RECID = L.LICN_REQ_RECID
AND l.licn_stage = 12
AND l.licn_status IN ('REACTIVE', 'ACTIVE')
and lf.LICN_STATUS in ('A','P')
AND l.request_labour IS NOT NULL
----------------------------
3- show all workers
History
#1 Updated by Ahmad Amer over 6 years ago
- Assignee changed from Ahmad Amer to Abdelhalim Abu Qamar
need to complete procedure INS_PKG.NEW_ORDER_FILE_NONEXIST
#2 Updated by Abdelhalim Abu Qamar about 6 years ago
- Status changed from In Progress to Closed