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'
Select * from HR_LOOKUPS WHERE LOOKUP_TYPE = 'PER_SUPERVISOR_TYPE'
select pd.name department_name , paaf.assignment_number from per_all_assignments_m paaf , per_departments pd where pd.organization_id(+) = paaf.organization_id
SELECT COUNT(*) FROM ( SELECT TRUNC(SYSDATE,'MM') + LEVEL - 1 AS day FROM dual CONNECT BY LEVEL <= ADD_MONTHS(TRUNC(SYSDATE,'MM'),1) - TRUNC(SYSDATE,'MM')
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,
The members are stored in WLF_ASSIGNMENT_RECORDS_F table where all other course/offering/specialization assignments are kept.
WITH ORG_TREE AS ( SELECT /*+ materialize */ DISTINCT * FROM ( SELECT ( SELECT p.name FROM hr_all_organization_units_vl p WHERE p.organization_id = ot.parent_organization_id AND rownum = 1
SELECT SeniorityDateSetUp.seniority_date_code, HcmLookup.MEANING,SeniorityDateSetUp.SENIORITY_VERSION FROM fusion.per_seniority_dates_setup SeniorityDateSetUp, fusion.HCM_LOOKUPS HcmLookup
SELECT BANK_BRANCH_NAME, BANK_NAME, BRANCH_NUMBER , EFT_SWIFT_CODE FROM CE_BANK_BRANCHES_V WHERE BANK_HOME_COUNTRY = 'GB' ORDER BY BANK_NAME, BANK_BRANCH_NAME
SELECT BANK_NAME FROM CE_BANKS_V WHERE HOME_COUNTRY = 'GB' ORDER BY BANK_NAME