Select ITEM.CONTENT_ITEM_ID, ITEM.CONTENT_TYPE_ID, ITEM.CONTENT_ITEM_CODE,ITEM.DATE_FROM, ITEM.BUSINESS_GROUP_ID, TL.NAME, TL.ITEM_DESCRIPTION, TYPE.CONTEXT_NAME, ITEM.CREATED_BY, ITEM.CREATION_DATE, ITEM.LAST_UPDATED_BY, ITEM.LAST_UPDATE_DATE
select "HRG_GOAL_PLN_ASSIGNMENTS"."GOAL_PLAN_ASSIGNMENT_ID" as "GOAL_PLAN_ASSIGNMENT_ID", "HRG_GOAL_PLN_ASSIGNMENTS"."GOAL_PLAN_ID" as "GOAL_PLAN_ID", "HRG_GOAL_PLN_ASSIGNMENTS"."ASSIGNMENT_ID" as "ASSIGNMENT_ID",
Select Txnd.Status As Txn_Status ,Txnh.Module_Identifier ,p.person_number ,txnh.CREATION_DATE ,Txnh.Transaction_Id
select "PER_PERIODS_OF_SERVICE"."LAST_UPDATE_DATE" as "LAST_UPDATE_DATE", "PER_PERIODS_OF_SERVICE"."LAST_UPDATED_BY" as "LAST_UPDATED_BY", "PER_ALL_PEOPLE_F"."PERSON_NUMBER" as "PERSON_NUMBER"
SELECT SeniorityDateSetUp.seniority_date_code, HcmLookup.MEANING,SeniorityDateSetUp.SENIORITY_VERSION FROM fusion.per_seniority_dates_setup SeniorityDateSetUp,
Select distinct papf.person_number,profile_code from PER_ALL_PEOPLE_F PAPF, HRT_PROFILES_B HPB where PAPF.PERSON_ID = HPB.PERSON_ID AND Profile_Code is NULL
EXISTS (SELECT 1 FROM PER_ALL_ASSIGNMENTS_M ASG,PER_PERIODS_OF_SERVICE PS WHERE ASG.ASSIGNMENT_TYPE IN('E','C','N','P') AND ASG.EFFECTIVE_LATEST_CHANGE='Y' AND SYSDATE BETWEEN LEAST(SYSDATE,ASG.EFFECTIVE_START_DATE) AND ASG.EFFECTIVE_END_DATE AND
SELECT DISTINCT dhou.ATTRIBUTE2 as Project_Code, dhou.ATTRIBUTE3 as Expense_Code, dhou.name AS DEPT_NAME, dhou1.name AS PARENT_DEPARTMENT_NAME
For specific employee select * from PER_EMAIL_ADDRESSES where PERSON_ID in (select person_id from per_all_people_f where person_number = 'XXXX') For All employees select * from PER_EMAIL_ADDRESSES
The following SQL will give the list of all data roles and the column 'PERSON_SECURITY_PROFILE' will give the list of person security profiles associated with them. You can use this a build a report and filter on that. Alternatively, you can use the SQL and modify it to fetch the...
select * from ps_ceh_ft_emplid where emplid = '00000000'
Data File Name - Worker.dat METADATA|PersonEmail|EmailAddressId|PersonId|PersonNumber|DateFrom|DateTo|EmailType|EmailAddress|PrimaryFlag|GUID|SourceSystemOwner|SourceSystemId MERGE|PersonEmail|300000000000000|400000000000000|100|1951/01/01|4712/12/31|H1|HOMEEMAIL@oracle.com|N|||
SELECT v.level_name, v.level_value, v.profile_option_valueFROM fusion.fnd_profile_option_values v, fusion.fnd_profile_options_b bWHERE b.profile_option_id = v.profile_option_idAND b.profile_option_name = 'FND_FILE_UPLOAD_MAX_SIZE'
select papf_Reportee.person_number, to_char(pasf.EFFECTIVE_START_DATE,'yyyy/dd/mm') start_dt_spr from per_all_people_f papf, per_All_assignments_m paam, PER_ASSIGNMENT_SUPERVISORS_F pasf
SELECT p.* , (CASE WHEN p.state = 1 THEN 'Wait' WHEN p.state = 2 THEN 'Ready' WHEN p.state = 3 THEN 'Running' WHEN p.state = 4 THEN 'Completed' WHEN p.state = 9 THEN 'Cancelled'
Date of Birth: PER_PERSONS_ National identifier: PER_NATIONAL_IDENTIFIERS_
Select ASSIGNMENT_NUMBER, ASSIGNMENT_ID, PERIOD_OF_SERVICE_ID, WORK_TERMS_ASSIGNMENT_ID, ASSIGNMENT_STATUS_TYPE from per_all_assignments_f
SELECT DISTINCT SCHEDULE_NAME, SCHEDULE_TYPE_CODE , ASSIGNMENT_NUM FROM FUSION.ZMM_SR_SCHEDULES_VL WHERE SCHEDULE_NAME LIKE '%Provide your workschedule name here%'
select zmm.* from PER_ALL_ASSIGNMENTS_F PAAF, PER_SCHEDULE_ASSIGNMENTS PSA, zmm_sr_schedules_vl zmm, ZMM_SR_SCHEDU
select "PER_ALL_PEOPLE_F"."PERSON_NUMBER" as "PERSON_NUMBER", "HRT_PROFILES_B"."PROFILE_CODE" as "PROFILE_CODE" from "FUSION"."PER_ALL_PEOPLE_F" "PER_ALL_PEOPLE_F", "FUSION"."HRT_PROFILES_B" "HRT_PROFILES_B" where "HRT_PROFILES_B"."PERSON_ID"="PER_ALL_PEOPLE_F"."PERSON_ID" --and "PER_ALL_PEOPLE_F"."PERSON_NUMBER" ='46403'