1. Tables and Views for HCM
  2. HXT_SCH_PROF_DEFAULT_VIEW

HXT_SCH_PROF_DEFAULT_VIEW

Details

  • Schema: FUSION

  • Object owner: HXT

  • Object type: VIEW

Columns

Name

EFFECTIVE_END_DATE

EFFECTIVE_START_DATE

SETUP_OPTION_VAL_ID

SETUP_OPTION_VAL_CD

TYPE

GROUP_MANAGER_ID

OVER_STAFF_THRESHOLD

UNDER_STAFF_THRESHOLD

FIRST_DAY_OF_WEEK

SCHEDULING_GROUP_ID

CREATION_DATE1

CREATED_BY1

LAST_UPDATE_DATE1

LAST_UPDATE_LOGIN1

LAST_UPDATED_BY1

INCL_MEMBER_ID

GRP_INCL_MEMBER_ID

GRP_ID

SETUP_PROFILE_ASG_ID

ASSIGN_TO

DATE_FROM

DATE_TO

CREATED_BY

CREATION_DATE

DESCRIPTION

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

LAST_UPDATED_BY

NAME

PRECEDENCE

PRODUCT_AREA

SETUP_PROFILE_CD

SETUP_PROFILE_ID

SETUP_PROFILE_ID_TL

Query

SQL_Statement

SELECT SetupOptionValPEO.EFFECTIVE_END_DATE EFFECTIVE_END_DATE,

SetupOptionValPEO.EFFECTIVE_START_DATE EFFECTIVE_START_DATE,

SetupOptionValPEO.SETUP_OPTION_VAL_ID SETUP_OPTION_VAL_ID,

SetupOptionValPEO.SETUP_OPTION_VAL_CD SETUP_OPTION_VAL_CD,

SetupOptionValPEO.TYPE TYPE,

SetupOptionValPEO.VALUE50 GROUP_MANAGER_ID,

SetupOptionValPEO.VALUE51 OVER_STAFF_THRESHOLD,

SetupOptionValPEO.VALUE52 UNDER_STAFF_THRESHOLD,

SetupOptionValPEO.VALUE53 FIRST_DAY_OF_WEEK,

SetupOptionValPEO.VALUE54 SCHEDULING_GROUP_ID,

SetupOptionValPEO.CREATION_DATE CREATION_DATE1,

SetupOptionValPEO.CREATED_BY CREATED_BY1 ,

SetupOptionValPEO.LAST_UPDATE_DATE LAST_UPDATE_DATE1 ,

SetupOptionValPEO.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN1 ,

SetupOptionValPEO.LAST_UPDATED_BY LAST_UPDATED_BY1,

GroupInclMembersPEO.INCL_MEMBER_ID ,

GroupInclMembersPEO.GRP_INCL_MEMBER_ID,

GroupInclMembersPEO.GRP_ID,

SetupProfileAsgPEO.SETUP_PROFILE_ASG_ID,

SetupProfileAsgPEO.ASSIGN_TO,

SetupProfileAsgPEO.DATE_FROM,

SetupProfileAsgPEO.DATE_TO,

SetupProfileViewPEO.CREATED_BY CREATED_BY,

SetupProfileViewPEO.CREATION_DATE CREATION_DATE,

SetupProfileViewPEO.DESCRIPTION DESCRIPTION,

SetupProfileViewPEO.LAST_UPDATE_DATE LAST_UPDATE_DATE,

SetupProfileViewPEO.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

SetupProfileViewPEO.LAST_UPDATED_BY LAST_UPDATED_BY,

SetupProfileViewPEO.NAME NAME,

SetupProfileViewPEO.PRECEDENCE PRECEDENCE,

SetupProfileViewPEO.PRODUCT_AREA PRODUCT_AREA,

SetupProfileViewPEO.SETUP_PROFILE_CD SETUP_PROFILE_CD,

SetupProfileViewPEO.SETUP_PROFILE_ID,

SetupProfileViewPEO.SETUP_PROFILE_ID SETUP_PROFILE_ID_TL

FROM HXT_SETUP_OPTION_VALS SetupOptionValPEO,

HXT_SETUP_PROFILES_VL SetupProfileViewPEO,

HXT_SETUP_PROFILE_ASGS SetupProfileAsgPEO,

HWM_GRP_INCL_MEMBERS GroupInclMembersPEO

WHERE SetupOptionValPEO.SETUP_PROFILE_ID = SetupProfileViewPEO.SETUP_PROFILE_ID

AND SetupOptionValPEO.TYPE = SetupProfileViewPEO.PRODUCT_AREA

AND SetupProfileViewPEO.SETUP_PROFILE_ID = SetupProfileAsgPEO.SETUP_PROFILE_ID

AND SetupProfileAsgPEO.OBJECT_ID = GroupInclMembersPEO.GRP_ID

AND UPPER(SetupProfileAsgPEO.ASSIGN_TO) = UPPER('GROUP')

AND SetupProfileViewPEO.PRODUCT_AREA = 'HTS'

UNION

SELECT TO_DATE('31-12-4712','DD-MM-YYYY') EFFECTIVE_END_DATE,

TO_DATE('01-01-2002','DD-MM-YYYY') EFFECTIVE_START_DATE,

999999999999999 SETUP_OPTION_VAL_ID,

meaning SETUP_OPTION_VAL_CD,

'HTS' TYPE,

NVL(HRC_SESSION_UTIL.GET_USER_PERSONID,-1) GROUP_MANAGER_ID,

1 OVER_STAFF_THRESHOLD,

1 UNDER_STAFF_THRESHOLD,

1 FIRST_DAY_OF_WEEK,

999999999999999 SCHEDULING_GROUP_ID,

sysdate CREATION_DATE1 ,

'HCM_USER10' CREATED_BY1 ,

sysdate LAST_UPDATE_DATE1 ,

'HCM_USER10' LAST_UPDATE_LOGIN1,

'HCM_USER10' LAST_UPDATED_BY1 ,

NVL(HRC_SESSION_UTIL.GET_USER_PERSONID,-1) INCL_MEMBER_ID,

999999999999999 GRP_INCL_MEMBER_ID,

999999999999999 GRP_ID ,

999999999999999 SETUP_PROFILE_ASG_ID,

'GROUP' ASSIGN_TO,

TO_DATE('01-01-2002','DD-MM-YYYY') DATE_FROM,

TO_DATE('31-12-4712','DD-MM-YYYY') DATE_TO,

'HCM_USER10' CREATED_BY,

SYSDATE CREATION_DATE,

meaning DESCRIPTION,

SYSDATE LAST_UPDATE_DATE,

'HCM_USER10' LAST_UPDATE_LOGIN,

'HCM_USER10' LAST_UPDATED_BY,

meaning NAME,

0 PRECEDENCE,

'HTS' PRODUCT_AREA,

meaning SETUP_PROFILE_CD,

999999999999999 SETUP_PROFILE_ID,

999999999999999 SETUP_PROFILE_ID_TL

FROM hcm_lookups

WHERE lookup_type='ORA_HWM_SCH_PROF_DEFAULT_NAME'