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.HRI_MD_TRN_BKG_INT_ATT_B_V

Source

View Text - Preformatted


SELECT bkg.number_of_places number_of_places , bkg.attended_indicator attended_indicator , bkg.attended_sccss_indicator attended_sccss_indicator , bkg.asg_effective_start_date asg_effective_start_date , bkg.asg_effective_end_date asg_effective_end_date , evt.event_start_date event_start_date , evt.event_end_date event_end_date , bkg.assignment_id assignment_id , bkg.person_id person_id , bkg.business_group_id business_group_id , bkg.organization_id organization_id , bkg.location_id location_id , bkg.job_id job_id , bkg.grade_id grade_id , bkg.position_id position_id , evt.activity_id activity_id , evt.activity_version_id activity_version_id , evt.event_id event_id , 'HR YEAR+'|| TO_CHAR( evt.event_end_date, 'YYYY' ) event_end_hr_year_id , 'HR SEMIYEAR+'|| DECODE( TRUNC( ( TO_CHAR( evt.event_end_date, 'MM' ) -1 ) / 6 ) , 0, TO_CHAR( ADD_MONTHS( evt.event_end_date , 1 - TO_CHAR( evt.event_end_date, 'MM' ) ) , 'MON-YYYY' ) , 1, TO_CHAR( ADD_MONTHS( evt.event_end_date , 7 - TO_CHAR( evt.event_end_date, 'MM' ) ) , 'MON-YYYY' ) ) event_end_hr_semiyear_id , 'HR QUARTER+'|| TO_CHAR( evt.event_end_date, 'Q YYYY' ) event_end_hr_quarter_id , 'HR BIMONTH+'|| DECODE( MOD( TO_CHAR( evt.event_end_date, 'MM' ), 2) , 0, TO_CHAR( ADD_MONTHS( evt.event_end_date, -1 ), 'MON-YYYY' ) , 1, TO_CHAR( evt.event_end_date, 'MON-YYYY' ) ) event_end_hr_bimonth_id , 'HR MONTH+'|| TO_CHAR( evt.event_end_date, 'MON-YYYY' )event_end_hr_month_id , TO_CHAR( evt.event_end_date, 'YYYY-MM-DD' ) event_end_hr_day_id , TO_NUMBER( TO_CHAR( evt.event_end_date, 'YYYY' ) ) event_end_fii_time_year_id , DECODE( TRUNC( ( TO_CHAR( evt.event_end_date, 'MM' ) -1 ) / 6 ) , 0, TO_CHAR( evt.event_end_date, 'YYYY') || '1' , 1, TO_CHAR( evt.event_end_date, 'YYYY') || '2' ) event_end_fii_time_semiyear_id , TO_NUMBER( TO_CHAR( evt.event_end_date, 'YYYYQ' ) ) event_end_fii_time_qtr_id , TO_CHAR( TO_CHAR( evt.event_end_date, 'YYYY' )|| TRUNC( ( TO_NUMBER( TO_CHAR( evt.event_end_date, 'MM' ) ) + 1 ) / 2 ) ) event_end_fii_time_bimonth_id , TO_NUMBER( TO_CHAR( evt.event_end_date, 'YYYYQMM' ) ) event_end_fii_time_month_id , evt.event_end_date event_end_fii_time_day_id , bkg.dlgt_booking_id dlgt_booking_id , bkg.booking_status_type_id booking_status_type_id , GREATEST( bkg.last_change_date , evt.last_change_date ) last_change_date FROM HRI_MB_TRN_BKG_INT_V bkg , HRI_CS_TRNEVTACT_B_V evt WHERE bkg.event_id = evt.event_id AND evt.event_end_date < sysdate AND evt.event_type_code <> 'DEVELOPMENT' AND evt.event_offering_id IS NULL AND evt.event_status_code <> 'A' AND bkg.assignment_type_code = 'E' AND bkg.attended_indicator = 1 AND bkg.per_system_status_code IN ( 'ACTIVE_ASSIGN' , 'SUSP_ASSIGN' , 'TERM_ASSIGN' )

View Text - HTML Formatted

SELECT BKG.NUMBER_OF_PLACES NUMBER_OF_PLACES
, BKG.ATTENDED_INDICATOR ATTENDED_INDICATOR
, BKG.ATTENDED_SCCSS_INDICATOR ATTENDED_SCCSS_INDICATOR
, BKG.ASG_EFFECTIVE_START_DATE ASG_EFFECTIVE_START_DATE
, BKG.ASG_EFFECTIVE_END_DATE ASG_EFFECTIVE_END_DATE
, EVT.EVENT_START_DATE EVENT_START_DATE
, EVT.EVENT_END_DATE EVENT_END_DATE
, BKG.ASSIGNMENT_ID ASSIGNMENT_ID
, BKG.PERSON_ID PERSON_ID
, BKG.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, BKG.ORGANIZATION_ID ORGANIZATION_ID
, BKG.LOCATION_ID LOCATION_ID
, BKG.JOB_ID JOB_ID
, BKG.GRADE_ID GRADE_ID
, BKG.POSITION_ID POSITION_ID
, EVT.ACTIVITY_ID ACTIVITY_ID
, EVT.ACTIVITY_VERSION_ID ACTIVITY_VERSION_ID
, EVT.EVENT_ID EVENT_ID
, 'HR YEAR+'|| TO_CHAR( EVT.EVENT_END_DATE
, 'YYYY' ) EVENT_END_HR_YEAR_ID
, 'HR SEMIYEAR+'|| DECODE( TRUNC( ( TO_CHAR( EVT.EVENT_END_DATE
, 'MM' ) -1 ) / 6 )
, 0
, TO_CHAR( ADD_MONTHS( EVT.EVENT_END_DATE
, 1 - TO_CHAR( EVT.EVENT_END_DATE
, 'MM' ) )
, 'MON-YYYY' )
, 1
, TO_CHAR( ADD_MONTHS( EVT.EVENT_END_DATE
, 7 - TO_CHAR( EVT.EVENT_END_DATE
, 'MM' ) )
, 'MON-YYYY' ) ) EVENT_END_HR_SEMIYEAR_ID
, 'HR QUARTER+'|| TO_CHAR( EVT.EVENT_END_DATE
, 'Q YYYY' ) EVENT_END_HR_QUARTER_ID
, 'HR BIMONTH+'|| DECODE( MOD( TO_CHAR( EVT.EVENT_END_DATE
, 'MM' )
, 2)
, 0
, TO_CHAR( ADD_MONTHS( EVT.EVENT_END_DATE
, -1 )
, 'MON-YYYY' )
, 1
, TO_CHAR( EVT.EVENT_END_DATE
, 'MON-YYYY' ) ) EVENT_END_HR_BIMONTH_ID
, 'HR MONTH+'|| TO_CHAR( EVT.EVENT_END_DATE
, 'MON-YYYY' )EVENT_END_HR_MONTH_ID
, TO_CHAR( EVT.EVENT_END_DATE
, 'YYYY-MM-DD' ) EVENT_END_HR_DAY_ID
, TO_NUMBER( TO_CHAR( EVT.EVENT_END_DATE
, 'YYYY' ) ) EVENT_END_FII_TIME_YEAR_ID
, DECODE( TRUNC( ( TO_CHAR( EVT.EVENT_END_DATE
, 'MM' ) -1 ) / 6 )
, 0
, TO_CHAR( EVT.EVENT_END_DATE
, 'YYYY') || '1'
, 1
, TO_CHAR( EVT.EVENT_END_DATE
, 'YYYY') || '2' ) EVENT_END_FII_TIME_SEMIYEAR_ID
, TO_NUMBER( TO_CHAR( EVT.EVENT_END_DATE
, 'YYYYQ' ) ) EVENT_END_FII_TIME_QTR_ID
, TO_CHAR( TO_CHAR( EVT.EVENT_END_DATE
, 'YYYY' )|| TRUNC( ( TO_NUMBER( TO_CHAR( EVT.EVENT_END_DATE
, 'MM' ) ) + 1 ) / 2 ) ) EVENT_END_FII_TIME_BIMONTH_ID
, TO_NUMBER( TO_CHAR( EVT.EVENT_END_DATE
, 'YYYYQMM' ) ) EVENT_END_FII_TIME_MONTH_ID
, EVT.EVENT_END_DATE EVENT_END_FII_TIME_DAY_ID
, BKG.DLGT_BOOKING_ID DLGT_BOOKING_ID
, BKG.BOOKING_STATUS_TYPE_ID BOOKING_STATUS_TYPE_ID
, GREATEST( BKG.LAST_CHANGE_DATE
, EVT.LAST_CHANGE_DATE ) LAST_CHANGE_DATE
FROM HRI_MB_TRN_BKG_INT_V BKG
, HRI_CS_TRNEVTACT_B_V EVT
WHERE BKG.EVENT_ID = EVT.EVENT_ID
AND EVT.EVENT_END_DATE < SYSDATE
AND EVT.EVENT_TYPE_CODE <> 'DEVELOPMENT'
AND EVT.EVENT_OFFERING_ID IS NULL
AND EVT.EVENT_STATUS_CODE <> 'A'
AND BKG.ASSIGNMENT_TYPE_CODE = 'E'
AND BKG.ATTENDED_INDICATOR = 1
AND BKG.PER_SYSTEM_STATUS_CODE IN ( 'ACTIVE_ASSIGN'
, 'SUSP_ASSIGN'
, 'TERM_ASSIGN' )