Project

General

Profile

Bug #2160

the screen تفاصيل تأشيرة does not view any data in استعلام عن تصريح screen

Added by Israa Naser over 5 years ago. Updated over 5 years ago.

Status:
Feedback
Priority:
Normal
Assignee:
Israa Naser
Start date:
12/31/2019
Due date:
% Done:

0%

Co-Workers:
Israa Naser, Mouath Saadah
Severity:
Normal
Category:
PAMP phase 2 - Counter Employment
Sub-Category:
Step_Description:
Pre_Conditions:
Expected Result:
Actual Result:
Environment:
QA
Transaction Number:
Browser:
Chrome
URL:
Test Case ID:
SERVICE_ID:
0

Description

the screen تفاصيل تأشيرة does not view any data in استعلام عن تصريح screen

تفاصيل تأشيرة العامل.png - No data displayed (106 KB) Israa Naser, 12/31/2019 12:49 PM

null moi visa.png (37.3 KB) Mouath Saadah, 12/31/2019 03:56 PM

History

#1 Updated by Mouath Saadah over 5 years ago

  • File null moi visa.png added
  • Status changed from Open to Feedback
  • Assignee changed from Mouath Saadah to Israa Naser

dear Israa

I filter my screen used this att"MOI_VISA_NO"

it's return null in table

check query for screen no : MPM001 => استعلام عن تصريح

select WORK_VISA_ID,
(Select file_id from fle_license where licn_id = MPM_WORK_VISA.licn_id)file_id,
(SELECT LICN_PACI_ID FROM FLE_LICENSE
WHERE LICN_ID = MPM_WORK_VISA.LICN_ID
)LICN_PACI_ID,
(SELECT NAME_AR FROM FLE_LICENSE
WHERE LICN_ID = MPM_WORK_VISA.LICN_ID) Licn_name,
(SELECT LICN_CATEGORY FROM FLE_LICENSE
WHERE LICN_ID = MPM_WORK_VISA.LICN_ID) LICN_CATEGORY,
labor_id,
(Select LABOR_TYPE From MPM_LABOR_PROFILE
Where labor_id = MPM_WORK_VISA.labor_id)LABOR_TYPE,
STATUS,
(Select FULL_NAME_AR from MPM_LABOR_PROFILE
Where LABOR_ID =MPM_WORK_VISA.LABOR_ID)FULL_NAME_AR,
LICN_ID,
(Select DESCRIPTION
From UTL_JOB
Where JOB_ID = MPM_WORK_VISA.JOB_ID)JOB_DESC,
SALARY,
(Select
LABOR_EST_TYPE
From LES_LABOR_ESTIMATION
Where LABOR_ESTIMATION_ID =MPM_WORK_VISA.LABOR_ESTIMATION_ID)LABOR_EST_TYPE ,
MOI_VISA_NO
from MPM_WORK_VISA

**check the screen shot attached
Best Regards,
Mouath Saadah

Also available in: Atom PDF