1. Tables and Views for HCM
  2. HXT_SCH_ASGS_DEFAULT_VIEW

HXT_SCH_ASGS_DEFAULT_VIEW

Details

  • Schema: FUSION

  • Object owner: HXT

  • Object type: VIEW

Columns

Name

SETUP_PROFILE_ASG_ID

SETUP_PROFILE_ASG_CD

ASSIGN_TO

OBJECT_ID

DATE_FROM

DATE_TO

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

GRP_INCL_MEMBER_ID

GRP_ID

INCL_MEMBER_ID

SETUP_PROFILE_ID

PRODUCT_AREA

PROFILE_CREATED_BY

PROFILE_CREATION_DATE

PROFILE_DESCRIPTION

PROFILE_T_SETUP_PROFILE_ID

PROFILE_LAST_UPDATE_DATE

PROFILE_LAST_UPDATE_LOGIN

PROFILE_LAST_UPDATED_BY

PROFILE_NAME

PROFILE_PRECEDENCE

SETUP_PROFILE_CD

Query

SQL_Statement

SELECT SetupProfileAsgPEO.SETUP_PROFILE_ASG_ID,

SetupProfileAsgPEO.SETUP_PROFILE_ASG_CD,

SetupProfileAsgPEO.ASSIGN_TO,

SetupProfileAsgPEO.OBJECT_ID,

SetupProfileAsgPEO.DATE_FROM,

SetupProfileAsgPEO.DATE_TO,

SetupProfileAsgPEO.CREATED_BY,

SetupProfileAsgPEO.CREATION_DATE,

SetupProfileAsgPEO.LAST_UPDATED_BY,

SetupProfileAsgPEO.LAST_UPDATE_DATE,

SetupProfileAsgPEO.LAST_UPDATE_LOGIN,

GroupInclMembersPEO.GRP_INCL_MEMBER_ID,

GroupInclMembersPEO.GRP_ID,

GroupInclMembersPEO.INCL_MEMBER_ID,

SetupProfileViewPEO.SETUP_PROFILE_ID,

SetupProfileViewPEO.PRODUCT_AREA,

SetupProfileViewPEO.CREATED_BY PROFILE_CREATED_BY,

SetupProfileViewPEO.CREATION_DATE PROFILE_CREATION_DATE,

SetupProfileViewPEO.DESCRIPTION PROFILE_DESCRIPTION,

SetupProfileViewPEO.SETUP_PROFILE_ID PROFILE_T_SETUP_PROFILE_ID,

SetupProfileViewPEO.LAST_UPDATE_DATE PROFILE_LAST_UPDATE_DATE,

SetupProfileViewPEO.LAST_UPDATE_LOGIN PROFILE_LAST_UPDATE_LOGIN,

SetupProfileViewPEO.LAST_UPDATED_BY PROFILE_LAST_UPDATED_BY,

SetupProfileViewPEO.NAME PROFILE_NAME,

SetupProfileViewPEO.PRECEDENCE PROFILE_PRECEDENCE,

SetupProfileViewPEO.SETUP_PROFILE_CD

FROM HXT_SETUP_PROFILE_ASGS SetupProfileAsgPEO,

HWM_GRP_INCL_MEMBERS GroupInclMembersPEO,

HXT_SETUP_PROFILES_VL SetupProfileViewPEO

WHERE ((SetupProfileAsgPEO.OBJECT_ID = GroupInclMembersPEO.GRP_ID)

AND (SetupProfileAsgPEO.SETUP_PROFILE_ID = SetupProfileViewPEO.SETUP_PROFILE_ID))

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

AND (SetupProfileViewPEO.PRODUCT_AREA = 'HTS' ) )

UNION

SELECT 999999999999999 SETUP_PROFILE_ASG_ID,

meaning SETUP_PROFILE_ASG_CD,

'GROUP' ASSIGN_TO,

999999999999999 OBJECT_ID,

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 ,

'HCM_USER10' LAST_UPDATED_BY ,

SYSDATE LAST_UPDATE_DATE,

'HCM_USER10' LAST_UPDATE_LOGIN,

999999999999999 GRP_INCL_MEMBER_ID,

999999999999999 GRP_ID ,

NVL(HRC_SESSION_UTIL.GET_USER_PERSONID,-1) INCL_MEMBER_ID ,

999999999999999 SETUP_PROFILE_ID,

'HTS' PRODUCT_AREA,

'HCM_USER10' PROFILE_CREATED_BY,

SYSDATE PROFILE_CREATION_DATE,

meaning PROFILE_DESCRIPTION ,

999999999999999 PROFILE_T_SETUP_PROFILE_ID ,

SYSDATE PROFILE_LAST_UPDATE_DATE ,

'HCM_USER10' PROFILE_LAST_UPDATE_LOGIN ,

'HCM_USER10' PROFILE_LAST_UPDATED_BY ,

meaning PROFILE_NAME,

0 PROFILE_PRECEDENCE,

meaning SETUP_PROFILE_CD

FROM hcm_lookups

WHERE lookup_type='ORA_HWM_SCH_PROF_DEFAULT_NAME'