PAMInspection

05/23/2019

12:17 PM Bug #1183: ادخال نواقس الرواتب

done on both prod and test Ahmad Amer

05/22/2019

02:46 PM Bug #1183: ادخال نواقس الرواتب

Aslo to add new validtion on screen :
------------------------------------------
for CWI_NS_REASONS_RECID = 2
used... Abdelhalim Abu Qamar

01:30 PM Bug #1183: ادخال نواقس الرواتب

done on test, please review the screen Ahmad Amer

12:57 PM Bug #1183: ادخال نواقس الرواتب

kindly update the LOV to redirect ream from old Database *MOSAL_USER*
SELECT CWI_NS_REASONS_RECID , REASON_CODE ,R... Abdelhalim Abu Qamar

05/21/2019

11:57 AM Feature #1068 (Fixed): new screen استعلام نواقص تفتيش العمالة الوطنية

*work fine move to prod.* Abdelhalim Abu Qamar

05/20/2019

02:27 PM Feature #1068: new screen استعلام نواقص تفتيش العمالة الوطنية

done on test , please review the screen Ahmad Amer

12:21 PM Feature #1068: new screen استعلام نواقص تفتيش العمالة الوطنية

-----------
also to update label from (رقم الترخيص) to (الرقم المدني للجهة) Abdelhalim Abu Qamar

12:19 PM Feature #1068: new screen استعلام نواقص تفتيش العمالة الوطنية

kindly update the screen as the attachment photo Abdelhalim Abu Qamar

05/19/2019

03:20 PM Bug #1183: ادخال نواقس الرواتب

done on test please review the screen Ahmad Amer

12:23 PM Bug #1183: ادخال نواقس الرواتب

u must add new object view with SQL :
SELECT REASON_CODE ,REASON_NAME FROM INS_SALARY_SHORTFALLS WHERE STATUS = 1 ; Abdelhalim Abu Qamar

03:20 PM Feature #1068: new screen استعلام نواقص تفتيش العمالة الوطنية

done on test, please review the screen. Ahmad Amer

05/16/2019

02:38 PM Bug #1208: attachment shows a blank page

Dear Ahlam,
we need to check this case with UCM developer Abdelhalim Abu Qamar

01:32 PM Feature #1068: new screen استعلام نواقص تفتيش العمالة الوطنية

remove affair_job_recid ..
SELECT
--2)اسم الترخيص
(
SELECT LL.COMPANY_NAME
FROM PMP_LICN_REQ LL,
NMP_LICNFI... Abdelhalim Abu Qamar

05/14/2019

01:39 PM Bug #1169: طباعه تقرير الاستثناء

done on test , please check Ahmad Amer

05/13/2019

02:58 PM Bug #1183: ادخال نواقس الرواتب

please provide me with the lookup M_ID for the reason. Ahmad Amer

12:44 PM Bug #1208: attachment shows a blank page

dear halim, please review the saved data on database and please check ucm data
all data is running fine.. except th... Ahmad Amer

05/12/2019

04:47 PM Bug #1208 (Open): attachment shows a blank page

Dear Ahmed,
kindly find the problem while ADF screen trying to call attachment photo that already has an index on ... Abdelhalim Abu Qamar

05/06/2019

01:29 PM Bug #1183 (Open): ادخال نواقس الرواتب

dear Ahmed
kindly find attachment photo to update the LOV and show reason name not only code Abdelhalim Abu Qamar

05/05/2019

12:08 PM Bug #1059: زيارات تفتيش معلقة

done on prod for filters
please review the report query for the problem. Ahmad Amer

04/30/2019

03:58 PM Bug #1055: انجاز المفتشين

done on test, please check Ahmad Amer

04/29/2019

12:42 PM Bug #1059: زيارات تفتيش معلقة

Also to update the report Abdelhalim Abu Qamar

12:40 PM Bug #1059: زيارات تفتيش معلقة

also to add new filter (نوع القرار, نوع التفتيش) Abdelhalim Abu Qamar

12:37 PM Bug #1059 (In Progress): زيارات تفتيش معلقة

update the filed (نوع التفتيش) to read the inspection type Abdelhalim Abu Qamar

12:36 PM Bug #1169 (In Progress): طباعه تقرير الاستثناء

based on latest conversion kindly add the new report Abdelhalim Abu Qamar

12:10 PM Bug #1055 (In Progress): انجاز المفتشين

by adding a new condition on LOV of ((اسم الموظف ))
select * from INS_INSPECTOR_PROFILE where STATUS = 1
and GROUP... Abdelhalim Abu Qamar

04/24/2019

04:50 PM Bug #1144: تقرير ادخال نواقص الوافدة

done on test , please review the report. Ahmad Amer

11:30 AM Bug #1144 (Open): تقرير ادخال نواقص الوافدة

Hello Ahmed,
about screen (إدخال نواقص تفتيش المتابعة) kindly find the following :
1- report (InsWorkerNonExistNa... Abdelhalim Abu Qamar

04:49 PM Feature #1068: new screen استعلام نواقص تفتيش العمالة الوطنية

please review the sql query its return >>
ORA-00904: "SS"."AFFAIR_JOB_RECID": invalid identifier
Ahmad Amer