HRE_TP_REQ_FEEDBACK_INTRCNS

Details

Schema: FUSION
Object owner: HRE
Object type: VIEW

Columns

Name
REFERENCE_ID STATUS_CODE ENGAGEMENT_TYPE ENGAGEMENT_DATE REQUESTED_FOR_PERSON_ID REQUESTED_FOR_ASSIGNMENT_ID CREATED_BY_PERSON_ID CREATED_BY_ASSIGNMENT_ID HIDDEN_FLAG VISIBILITY BUSINESS_GROUP_ID REQUEST_ID CHECKIN_TOPICS_DISCUSSED_COUNT CHECKIN_TOPICS_TOTAL_COUNT OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Name

REFERENCE_ID

STATUS_CODE

ENGAGEMENT_TYPE

ENGAGEMENT_DATE

REQUESTED_FOR_PERSON_ID

REQUESTED_FOR_ASSIGNMENT_ID

CREATED_BY_PERSON_ID

CREATED_BY_ASSIGNMENT_ID

HIDDEN_FLAG

VISIBILITY

BUSINESS_GROUP_ID

REQUEST_ID

CHECKIN_TOPICS_DISCUSSED_COUNT

CHECKIN_TOPICS_TOTAL_COUNT

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

Query

SQL_Statement
SELECT REFERENCE_ID, STATUS_CODE, ENGAGEMENT_TYPE, ENGAGEMENT_DATE, CREATED_FOR_PERSON_ID REQUESTED_FOR_PERSON_ID, CREATED_FOR_ASSIGNMENT_ID REQUESTED_FOR_ASSIGNMENT_ID, CREATED_BY_PERSON_ID, CREATED_BY_ASSIGNMENT_ID, HIDDEN_FLAG, VISIBILITY, BUSINESS_GROUP_ID, REQUEST_ID, CHECKIN_TOPICS_DISCUSSED_COUNT, CHECKIN_TOPICS_TOTAL_COUNT, OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN FROM hre_touchpt_empl_evts_intrcns where ENGAGEMENT_TYPE ='ORA_HRE_FEEDBACK_REQ'

SQL_Statement

SELECT

REFERENCE_ID,

STATUS_CODE,

ENGAGEMENT_TYPE,

ENGAGEMENT_DATE,

CREATED_FOR_PERSON_ID REQUESTED_FOR_PERSON_ID,

CREATED_FOR_ASSIGNMENT_ID REQUESTED_FOR_ASSIGNMENT_ID,

CREATED_BY_PERSON_ID,

CREATED_BY_ASSIGNMENT_ID,

HIDDEN_FLAG,

VISIBILITY,

BUSINESS_GROUP_ID,

REQUEST_ID,

CHECKIN_TOPICS_DISCUSSED_COUNT,

CHECKIN_TOPICS_TOTAL_COUNT,

OBJECT_VERSION_NUMBER,

CREATED_BY,

CREATION_DATE,

LAST_UPDATED_BY,

LAST_UPDATE_DATE,

LAST_UPDATE_LOGIN

FROM

hre_touchpt_empl_evts_intrcns

where

ENGAGEMENT_TYPE ='ORA_HRE_FEEDBACK_REQ'