eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PER_SECURITY_PROFILES_V

Source

View Text - Preformatted


SELECT PSP.ROWID ROW_ID , PSP.SECURITY_PROFILE_ID , PSP.BUSINESS_GROUP_ID , PBG.NAME BUSINESS_GROUP_NAME , PSP.POSITION_ID , hr_general.decode_position_latest_name(PSP.POSITION_ID) TOP_POSITION , PSP.ORGANIZATION_ID , ORGTL.NAME TOP_ORGANIZATION , PSP.POSITION_STRUCTURE_ID , PPS.NAME POSITION_HIERARCHY , PSV.POS_STRUCTURE_VERSION_ID , PSP.ORGANIZATION_STRUCTURE_ID , OST.NAME ORGANIZATION_HIERARCHY , OSV.ORG_STRUCTURE_VERSION_ID , PSP.INCLUDE_TOP_ORGANIZATION_FLAG , PSP.INCLUDE_TOP_POSITION_FLAG , PSP.SECURITY_PROFILE_NAME , PSP.VIEW_ALL_APPLICANTS_FLAG , PSP.VIEW_ALL_EMPLOYEES_FLAG , PSP.VIEW_ALL_CWK_FLAG , PSP.VIEW_ALL_CONTACTS_FLAG , PSP.VIEW_ALL_CANDIDATES_FLAG , PSP.VIEW_ALL_FLAG , PSP.VIEW_ALL_ORGANIZATIONS_FLAG , PSP.VIEW_ALL_PAYROLLS_FLAG , PSP.VIEW_ALL_POSITIONS_FLAG , PSP.INCLUDE_EXCLUDE_PAYROLL_FLAG , PSP.REPORTING_ORACLE_USERNAME , PSP.ALLOW_GRANTED_USERS_FLAG , PSP.RESTRICT_BY_SUPERVISOR_FLAG , PSP.SUPERVISOR_LEVELS , PSP.EXCLUDE_SECONDARY_ASGS_FLAG , PSP.EXCLUDE_PERSON_FLAG , PER.FULL_NAME , PSP.NAMED_PERSON_ID , PSP.CUSTOM_RESTRICTION_FLAG , PSP.RESTRICTION_TEXT , PSP.EXCLUDE_BUSINESS_GROUPS_FLAG , PSP.REQUEST_ID , PSP.PROGRAM_APPLICATION_ID , PSP.PROGRAM_ID , PSP.PROGRAM_UPDATE_DATE , PSP.LAST_UPDATE_DATE , PSP.LAST_UPDATED_BY , PSP.LAST_UPDATE_LOGIN , PSP.CREATED_BY , PSP.CREATION_DATE , PSP.ORG_SECURITY_MODE , PSP.RESTRICT_ON_INDIVIDUAL_ASG , PSP.TOP_ORGANIZATION_METHOD , PSP.TOP_POSITION_METHOD FROM PER_SECURITY_PROFILES PSP , PER_ALL_PEOPLE_F PER , PER_BUSINESS_GROUPS_PERF PBG , PER_ORGANIZATION_STRUCTURES OST , PER_ORG_STRUCTURE_VERSIONS OSV , PER_POSITION_STRUCTURES PPS , PER_POS_STRUCTURE_VERSIONS PSV , HR_ALL_ORGANIZATION_UNITS ORG , HR_ALL_ORGANIZATION_UNITS_TL ORGTL WHERE PSP.BUSINESS_GROUP_ID + 0 = PBG.BUSINESS_GROUP_ID (+) AND PSP.ORGANIZATION_STRUCTURE_ID = OST.ORGANIZATION_STRUCTURE_ID (+) AND PSP.ORGANIZATION_STRUCTURE_ID = OSV.ORGANIZATION_STRUCTURE_ID (+) AND sysdate BETWEEN OSV.DATE_FROM (+) AND NVL(OSV.DATE_TO (+), TO_DATE('4712/12/31', 'YYYY/MM/DD')) AND PSP.POSITION_STRUCTURE_ID = PPS.POSITION_STRUCTURE_ID (+) AND PSP.POSITION_STRUCTURE_ID = PSV.POSITION_STRUCTURE_ID (+) AND sysdate BETWEEN PSV.DATE_FROM (+) AND NVL(PSV.DATE_TO (+), TO_DATE('4712/12/31', 'YYYY//MM/DD')) AND PSP.ORGANIZATION_ID = ORG.ORGANIZATION_ID (+) AND ORG.organization_id = ORGTL.organization_id (+) AND decode(orgtl.organization_id,null,'1',ORGTL.language) = decode(orgtl.organization_id,null,'1',userenv('LANG')) AND PSP.NAMED_PERSON_ID=PER.PERSON_ID(+) AND sysdate BETWEEN PER.EFFECTIVE_START_DATE (+) AND NVL(PER.EFFECTIVE_END_DATE (+), TO_DATE('4712/12/31', 'YYYY//MM/DD'))

View Text - HTML Formatted

SELECT PSP.ROWID ROW_ID
, PSP.SECURITY_PROFILE_ID
, PSP.BUSINESS_GROUP_ID
, PBG.NAME BUSINESS_GROUP_NAME
, PSP.POSITION_ID
, HR_GENERAL.DECODE_POSITION_LATEST_NAME(PSP.POSITION_ID) TOP_POSITION
, PSP.ORGANIZATION_ID
, ORGTL.NAME TOP_ORGANIZATION
, PSP.POSITION_STRUCTURE_ID
, PPS.NAME POSITION_HIERARCHY
, PSV.POS_STRUCTURE_VERSION_ID
, PSP.ORGANIZATION_STRUCTURE_ID
, OST.NAME ORGANIZATION_HIERARCHY
, OSV.ORG_STRUCTURE_VERSION_ID
, PSP.INCLUDE_TOP_ORGANIZATION_FLAG
, PSP.INCLUDE_TOP_POSITION_FLAG
, PSP.SECURITY_PROFILE_NAME
, PSP.VIEW_ALL_APPLICANTS_FLAG
, PSP.VIEW_ALL_EMPLOYEES_FLAG
, PSP.VIEW_ALL_CWK_FLAG
, PSP.VIEW_ALL_CONTACTS_FLAG
, PSP.VIEW_ALL_CANDIDATES_FLAG
, PSP.VIEW_ALL_FLAG
, PSP.VIEW_ALL_ORGANIZATIONS_FLAG
, PSP.VIEW_ALL_PAYROLLS_FLAG
, PSP.VIEW_ALL_POSITIONS_FLAG
, PSP.INCLUDE_EXCLUDE_PAYROLL_FLAG
, PSP.REPORTING_ORACLE_USERNAME
, PSP.ALLOW_GRANTED_USERS_FLAG
, PSP.RESTRICT_BY_SUPERVISOR_FLAG
, PSP.SUPERVISOR_LEVELS
, PSP.EXCLUDE_SECONDARY_ASGS_FLAG
, PSP.EXCLUDE_PERSON_FLAG
, PER.FULL_NAME
, PSP.NAMED_PERSON_ID
, PSP.CUSTOM_RESTRICTION_FLAG
, PSP.RESTRICTION_TEXT
, PSP.EXCLUDE_BUSINESS_GROUPS_FLAG
, PSP.REQUEST_ID
, PSP.PROGRAM_APPLICATION_ID
, PSP.PROGRAM_ID
, PSP.PROGRAM_UPDATE_DATE
, PSP.LAST_UPDATE_DATE
, PSP.LAST_UPDATED_BY
, PSP.LAST_UPDATE_LOGIN
, PSP.CREATED_BY
, PSP.CREATION_DATE
, PSP.ORG_SECURITY_MODE
, PSP.RESTRICT_ON_INDIVIDUAL_ASG
, PSP.TOP_ORGANIZATION_METHOD
, PSP.TOP_POSITION_METHOD
FROM PER_SECURITY_PROFILES PSP
, PER_ALL_PEOPLE_F PER
, PER_BUSINESS_GROUPS_PERF PBG
, PER_ORGANIZATION_STRUCTURES OST
, PER_ORG_STRUCTURE_VERSIONS OSV
, PER_POSITION_STRUCTURES PPS
, PER_POS_STRUCTURE_VERSIONS PSV
, HR_ALL_ORGANIZATION_UNITS ORG
, HR_ALL_ORGANIZATION_UNITS_TL ORGTL
WHERE PSP.BUSINESS_GROUP_ID + 0 = PBG.BUSINESS_GROUP_ID (+)
AND PSP.ORGANIZATION_STRUCTURE_ID = OST.ORGANIZATION_STRUCTURE_ID (+)
AND PSP.ORGANIZATION_STRUCTURE_ID = OSV.ORGANIZATION_STRUCTURE_ID (+)
AND SYSDATE BETWEEN OSV.DATE_FROM (+)
AND NVL(OSV.DATE_TO (+)
, TO_DATE('4712/12/31'
, 'YYYY/MM/DD'))
AND PSP.POSITION_STRUCTURE_ID = PPS.POSITION_STRUCTURE_ID (+)
AND PSP.POSITION_STRUCTURE_ID = PSV.POSITION_STRUCTURE_ID (+)
AND SYSDATE BETWEEN PSV.DATE_FROM (+)
AND NVL(PSV.DATE_TO (+)
, TO_DATE('4712/12/31'
, 'YYYY//MM/DD'))
AND PSP.ORGANIZATION_ID = ORG.ORGANIZATION_ID (+)
AND ORG.ORGANIZATION_ID = ORGTL.ORGANIZATION_ID (+)
AND DECODE(ORGTL.ORGANIZATION_ID
, NULL
, '1'
, ORGTL.LANGUAGE) = DECODE(ORGTL.ORGANIZATION_ID
, NULL
, '1'
, USERENV('LANG'))
AND PSP.NAMED_PERSON_ID=PER.PERSON_ID(+)
AND SYSDATE BETWEEN PER.EFFECTIVE_START_DATE (+)
AND NVL(PER.EFFECTIVE_END_DATE (+)
, TO_DATE('4712/12/31'
, 'YYYY//MM/DD'))