Project

General

Profile

Feature #1068

new screen استعلام نواقص تفتيش العمالة الوطنية

Added by Abdelhalim Abu Qamar about 6 years ago. Updated almost 6 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Abdelhalim Abu Qamar
Start date:
03/25/2019
Due date:
05/21/2019
% Done:

100%

Co-Workers:
Abdelhalim Abu Qamar
Severity:
Normal
Category:
inspection new feature
Sub-Category:
Step_Description:
Pre_Conditions:
Expected Result:
Actual Result:
Environment:
Production
Test Case ID:

Description

يرجى انشاء شاشة جديدة للاستعلام عن النواقص التي تم ادخالها للعمالة الوطنية كما هو موضح بالصورة
------------
also, need to use the following SQL to return date :
SELECT * FROM INS_S_NON_EXISITING_NAT_WORKER where EMP_LF_RECID in (select LF_RECID from MOSAL_USER.NMP_LICNFILE_V where ONR_ID = :p_ONR_ID) ;
------------

new_inqiuer_screen.jpg (145 KB) Abdelhalim Abu Qamar, 03/25/2019 03:06 PM

Screenshot_1.jpg (174 KB) Abdelhalim Abu Qamar, 05/20/2019 12:19 PM

History

#1 Updated by Ahmad Amer about 6 years ago

  • Assignee changed from Ahmad Amer to Abdelhalim Abu Qamar
  • % Done changed from 0 to 30

Dear Halim,
Please update the query to include the following fields:
1)الوظيفة
2)اسم الترخيص
3)رقم الجهة المدني
4)مسجل على الباب
5)سبب عدم التواجد
6)مرفقات الاثبات
it not included with
SELECT * FROM INS_S_NON_EXISITING_NAT_WORKER where EMP_LF_RECID in (select LF_RECID from MOSAL_USER.NMP_LICNFILE_V where ONR_ID = :p_ONR_ID) ; ?

#2 Updated by Abdelhalim Abu Qamar about 6 years ago

  • Status changed from Open to In Progress
  • Assignee changed from Abdelhalim Abu Qamar to Ahmad Amer
  • Environment Development added
  • Environment deleted (QA)

SELECT
--)الوظيفة
NMP_GET_PKG.GET_JOB_NAME ( sS.affair_job_recid ) EMP_JOB_NAME ,
--2)اسم الترخيص
(
SELECT LL.COMPANY_NAME
FROM PMP_LICN_REQ LL,
NMP_LICNFILE LF
WHERE LL.LICN_REQ_RECID = LF.LIC_RECID
AND LL.LICN_STAGE >= 12
AND LF.LF_RECID = ss.LF_RECID
) COMPANY_NAME ,
--3)رقم الجهة المدني
(
SELECT LL.LICN_CIVIL_ID
FROM PMP_LICN_REQ LL,
NMP_LICNFILE LF
WHERE LL.LICN_REQ_RECID = LF.LIC_RECID
AND LL.LICN_STAGE >= 12
AND LF.LF_RECID = ss.LF_RECID
) LICN_CIVIL_ID ,
CLARIFICATION_ID,
IDENTIFIC_NUM
FROM INS_S_NON_EXISITING_NAT_WORKER ;

#3 Updated by Ahmad Amer about 6 years ago

  • Assignee changed from Ahmad Amer to Abdelhalim Abu Qamar

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

#4 Updated by Abdelhalim Abu Qamar about 6 years ago

  • Assignee changed from Abdelhalim Abu Qamar to Ahmad Amer

remove affair_job_recid ..

SELECT
--2)اسم الترخيص
(
SELECT LL.COMPANY_NAME
FROM PMP_LICN_REQ LL,
NMP_LICNFILE LF
WHERE LL.LICN_REQ_RECID = LF.LIC_RECID
AND LL.LICN_STAGE >= 12
AND LF.LF_RECID = ss.LF_RECID
) COMPANY_NAME ,
--3)رقم الجهة المدني
(
SELECT LL.LICN_CIVIL_ID
FROM PMP_LICN_REQ LL,
NMP_LICNFILE LF
WHERE LL.LICN_REQ_RECID = LF.LIC_RECID
AND LL.LICN_STAGE >= 12
AND LF.LF_RECID = ss.LF_RECID
) LICN_CIVIL_ID ,
CLARIFICATION_ID,
IDENTIFIC_NUM
FROM INS_S_NON_EXISITING_NAT_WORKER ss ;

select * from INS_S_NON_EXISITING_NAT_WORKER ss ;

#5 Updated by Ahmad Amer about 6 years ago

  • Assignee changed from Ahmad Amer to Abdelhalim Abu Qamar
  • % Done changed from 30 to 100

done on test, please review the screen.

#6 Updated by Abdelhalim Abu Qamar about 6 years ago

  • File Screenshot_1.jpg added
  • Co-Workers Ahmad Amer added
  • Co-Workers deleted (Abdelhalim Abu Qamar)

kindly update the screen as the attachment photo

#7 Updated by Abdelhalim Abu Qamar about 6 years ago

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

#8 Updated by Abdelhalim Abu Qamar about 6 years ago

  • Assignee changed from Abdelhalim Abu Qamar to Ahmad Amer
  • Co-Workers Abdelhalim Abu Qamar added
  • Co-Workers deleted (Ahmad Amer)

#9 Updated by Ahmad Amer about 6 years ago

  • Assignee changed from Ahmad Amer to Abdelhalim Abu Qamar

done on test , please review the screen

#10 Updated by Abdelhalim Abu Qamar about 6 years ago

  • Due date set to 05/21/2019
  • Status changed from In Progress to Fixed
  • Environment Production added
  • Environment deleted (Development)

work fine move to prod.

#11 Updated by Abdelhalim Abu Qamar almost 6 years ago

  • Status changed from Fixed to Closed

Also available in: Atom PDF