PAMInspection

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) ; ?

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 ;

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

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 ;

done on test, please review the screen.

kindly update the screen as the attachment photo

done on test , please review the screen

work fine move to prod.