Eltzam Quers

XXCUSTOM.
MEWA_MAWARED_ELTEZAM_MAP_TB
FROM XXCUSTOM.XXX_MAWARED_ELTEZAM_MAP_TB DONOT update any thing

---------------------------------------------------------------------------
SELECT
ROWID, EBS_ID, EBS_DESC, ELTEZAM_ID,
ELTEZAM_DESC, MAP_TYPE, MAP_MEANING,
LAST_UPDATE_LOGIN, LAST_UPDATE_DATE, LAST_UPDATED_BY,
CREATED_BY, CREATION_DATE
FROM XXCUSTOM.MEWA_MAWARED_ELTEZAM_MAP_TB
Where
MAP_TYPE = 'JOB_NAME_CODE'
update XXCUSTOM.MEWA_MAWARED_ELTEZAM_MAP_TB set ELTEZAM_DESC = null
where MAP_TYPE ='JOB_NAME_CODE'
-----------------------------------------------------------------------------------
------
select nvl(substr(meaning,1,nvl(instr(meaning,'(',1),999)-1),meaning),LOOKUP_TYPE ,
LOOKUP_CODE , MEANING
from FND_LOOKUP_VALUES
where LANGUAGE ='AR'
and LOOKUP_TYPE = 'XXX_HR_JOB_CATEGORY'
union
select LOOKUP_TYPE , LOOKUP_CODE , MEANING
and LOOKUP_TYPE = 'XXX_HR_JOB_GROUP_NO'
union
and LOOKUP_TYPE = 'XXX_HR_MAJOR_QUALIFICATION'--XXX_HR_TYPE_QUALIFICATION

and LOOKUP_TYPE = 'XXX_HR_TYPE_QUALIFICATION'--XXX_HR_TYPE_QUALIFICATION
union
and LOOKUP_TYPE = 'XXX_HR_SPECIAL_QUALIFICATION'
union
select LOOKUP_TYPE , LOOKUP_CODE , MEANING ,'TER_NATIONAL','‫'الجنسية‬
and LOOKUP_TYPE = 'NATIONALITY'
union
and LOOKUP_TYPE = 'XXX_HR_AREA_CODES'
union
and LOOKUP_TYPE = 'XXX_HR_JOB_GROUP_TYPE'
union
and LOOKUP_TYPE = 'XXX_HR_JOB_TITLES'
union
select LOOKUP_TYPE , LOOKUP_CODE , MEANING ,'SA_CITY','‫'تعريف المدن‬
and LOOKUP_TYPE = 'XXX_HR_AREA_CODES'--LEAV_REAS'--XXX_HR_AREA_CODES
and ATTRIBUTE1 ='SA'
union
select LOOKUP_TYPE , LOOKUP_CODE , MEANING ,'TERM_TYPE','‫'اسباب انهاء الخدمة‬
and LOOKUP_TYPE = 'LEAV_REAS'--LEAV_REAS'--XXX_HR_ASSIGNMENT_STATUSES
select LOOKUP_TYPE , LOOKUP_CODE , MEANING ,'EMP_S_CODE','‫'حالة الموظف الوظيفية‬

and LOOKUP_TYPE = 'XXX_HR_ASSIGNMENT_STATUSES'--LEAV_REAS'-EMP_ASSIGN_REASON
select LOOKUP_TYPE , LOOKUP_CODE , MEANING ,'EMP_TRANS_CODE','‫'الحركات الوظيفية‬

and LOOKUP_TYPE = 'EMP_ASSIGN_REASON'--XXX_HR_EMP_PREV_EMP_ACT_TYPE
select LOOKUP_TYPE , LOOKUP_CODE , MEANING ,'HIST_TRANS_CODE','‫'القرار الوظيفية التاريخية‬

and LOOKUP_TYPE = 'XXX_HR_EMP_PREV_EMP_ACT_TYPE'--XXX_HR_EMP_PREV_EMP_ACT_TYPE
-----------------------------------------------------------------------------------
---
SELECT
SHARED_TYPE_NAME,
SHARED_TYPE_CODE ,
'TRANS_CODE','‫'الحركات على الوظائف‬
FROM per_shared_types_vl
WHERE NVL (business_group_id, -9999) = NVL ('', -9999)
AND lookup_type = 'POSITION_AVAILABILITY_STATUS'
AND (LOOKUP_TYPE LIKE 'POSITION_AVAILABILITY_STATUS')
-------------------------------------------------------------------------------
select petft.ELEMENT_NAME ,ATTRIBUTE1 ,'HRPUBLIC_ELEMENT_MEANING','‫'مسميات العناصر‬
from PAY_ELEMENT_TYPES_F_TL petft , PAY_ELEMENT_TYPES_F petf
where 1=1
and LANGUAGE ='AR'
and petf.CLASSIFICATION_ID not in (86,1,146,89)
and petft.ELEMENT_TYPE_ID = petf.ELEMENT_TYPE_ID
and petf.EFFECTIVE_END_DATE >sysdate --:P_D
---------------------------------------------------------
select (SUBSTR
(FFVT.FLEX_VALUE,1,2)) ,FFVT.FLEX_VALUE_MEANING ,FFVT2.FLEX_VALUE_MEANING
from FND_FLEX_VALUES_VL FFVT ,FND_FLEX_VALUES_VL FFVT2
WHERE 1=1
AND FFVT.FLEX_VALUE_SET_ID = 1016530
AND FFVT2.FLEX_VALUE_SET_ID = 1016529
AND SUBSTR (FFVT.FLEX_VALUE,1,2) = FFVT2.FLEX_VALUE
AND (SUBSTR (FFVT.FLEX_VALUE,1,2))IN (
SELECT DISTINCT EMPLOYMENT_CATEGORY

FROM PER_ALL_ASSIGNMENTS_F
WHERE 1=1
AND ASSIGNMENT_STATUS_TYPE_ID <> 3
AND EMPLOYMENT_CATEGORY IS NOT NULL
AND SYSDATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE )
ORDER BY 1
------------------------------------------------------------------------
select LOOKUP_CODE,Meaning ,'RATING_NEW','‫'درجة تقييم االداء بالترميز الجديد‬
where
LOOKUP_TYPE = 'XXX_APPRAISAL_RATE_DESC'
and LANGUAGE ='AR'
----------------------------------------------------------------------------------
Select FCL.MEANING , FCL.LOOKUP_CODE ,'TERM_TYPE','‫'اسباب انهاء الخدمة‬
From
FND_COMMON_LOOKUPS FCL,FND_SESSIONS FS
WHERE FCL.LOOKUP_TYPE = 'LEAV_REAS'
AND FS.SESSION_ID = USERENV('SESSIONID')
AND FCL.LOOKUP_CODE NOT IN
('XRESIGNING','XRESIGNINGFRCMAJ','XRESIGNINGPERS','XRESIGNINGNOUNCONTRENFEMP','XRET
IREMENTEARLY')
AND (
EXISTS( SELECT 'Y'
FROM PAY_USER_COLUMNS PUC,
PAY_USER_COLUMNS_TL PUCT,
PAY_USER_TABLES PUT,
PAY_USER_ROWS_F PUR,
PAY_USER_ROWS_F_TL PURT,
PAY_USER_COLUMN_INSTANCES_F PUCI
WHERE 1 = 1
AND PUT.USER_TABLE_ID = PUC.USER_TABLE_ID
AND PUCT.USER_COLUMN_ID = PUC.USER_COLUMN_ID
AND PUT.USER_TABLE_ID = PUR.USER_TABLE_ID
AND PURT.USER_ROW_ID = PUR.USER_ROW_ID
AND PUC.USER_COLUMN_ID = PUCI.USER_COLUMN_ID
AND PUR.USER_ROW_ID = PUCI.USER_ROW_ID
AND PUCT.LANGUAGE = 'AR'
AND PUCT.LANGUAGE = 'AR'
AND PUT.USER_TABLE_NAME = 'XXX_TERMINATION_REASON'
AND PUR.ROW_LOW_RANGE_OR_NAME = FCL.LOOKUP_CODE
AND sysdate BETWEEN PUCI.EFFECTIVE_START_DATE AND
PUCI.EFFECTIVE_END_DATE
AND sysdate BETWEEN PUR.EFFECTIVE_START_DATE AND
PUR.EFFECTIVE_END_DATE))
-----------------------------------------------------------------------------------
-----------------------
select TERRITORY_SHORT_NAME ,TERRITORY_CODE ,'SA_COUNTRY','‫'تعريف الدول‬
from FND_TERRITORIES_VL
WHERE OBSOLETE_FLAG<>'Y'
--and TERRITORY_CODE ='EG'
ORDER BY TERRITORY_SHORT_NAME
-----------------------------------------------------------------------------------
-------------------------

Eltzam Quers

Uploaded by

Copyright:

Available Formats

Eltzam Quers

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Eltzam Quers

Uploaded by

Copyright:

Available Formats

XXCUSTOM.

FROM XXCUSTOM.XXX_MAWARED_ELTEZAM_MAP_TB DONOT update any thing

select LOOKUP_TYPE , LOOKUP_CODE , MEANING

select LOOKUP_TYPE , LOOKUP_CODE , MEANING ,'EMP_S_CODE','‫'حالة الموظف الوظيفية‬

select LOOKUP_TYPE , LOOKUP_CODE , MEANING ,'EMP_TRANS_CODE','‫'الحركات الوظيفية‬

select LOOKUP_TYPE , LOOKUP_CODE , MEANING ,'HIST_TRANS_CODE','‫'القرار الوظيفية التاريخية‬

SELECT DISTINCT EMPLOYMENT_CATEGORY

You might also like