VIEW: APPS.HRI_TO_TRN_BKG_INT_AJC_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.attended_sccss_indicator / bkg.attended_indicator ) * 100 attended_sccss_pct /* dates and time*/ , bkg.asg_effective_start_date asg_effective_start_date , bkg.asg_effective_end_date asg_effective_end_date , bkg.event_start_date event_start_date , bkg.event_end_date event_end_date /* assignment ids */ , bkg.assignment_id assignment_id , bkg.person_id person_id , bkg.business_group_id business_group_id , bkg.organization_id organization_id , geo.geo_area_id geo_area_code , geo.geo_country_id geo_country_code , geo.geo_region_id geo_region_code , bkg.location_id location_id , jct.job_cat_code job_cat_code , bkg.job_id job_id , bkg.grade_id grade_id , bkg.position_id position_id /* training ids*/ , bkg.activity_id activity_id , bkg.activity_version_id activity_version_id , bkg.event_id event_id , TO_NUMBER( TO_CHAR( bkg.event_end_date ,'YYYY' )) event_end_fii_time_year_id , DECODE( TRUNC( ( TO_CHAR( bkg.event_end_date ,'MM' ) -1 ) / 6 ) , 0, TO_CHAR( bkg.event_end_date ,'YYYY') || '1' , 1, TO_CHAR( bkg.event_end_date ,'YYYY') || '2' ) event_end_fii_time_semiyear_id , TO_NUMBER( TO_CHAR( bkg.event_end_date ,'YYYYQ' ) ) event_end_fii_time_qtr_id , TO_CHAR( bkg.event_end_date ,'YYYY' ) || TRUNC( ( TO_NUMBER( TO_CHAR( bkg.event_end_date ,'MM' ) ) + 1 ) / 2 ) event_end_fii_time_bimonth_id , TO_NUMBER( TO_CHAR( bkg.event_end_date ,'YYYYQMM' ) ) event_end_fii_time_month_id , bkg.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 /* date currency */ , bkg.last_change_date last_change_date , bkg.hr_security_flag_code hr_security_flag_code , bkg.bg_security_flag_code bg_security_flag_code FROM /*------------------------------------*/ HRI_MD_TRN_BKG_INT_ATT_V bkg , HRI_CS_GEO_LOCHR_CT geo , HRI_CS_JOBCAT_V jct WHERE bkg.location_id = geo.location_id AND bkg.job_id = jct.job_id /* filters */ AND bkg.hr_security_flag_code = 'Y'

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.ATTENDED_SCCSS_INDICATOR / BKG.ATTENDED_INDICATOR ) * 100 ATTENDED_SCCSS_PCT /* DATES
AND TIME*/
, BKG.ASG_EFFECTIVE_START_DATE ASG_EFFECTIVE_START_DATE
, BKG.ASG_EFFECTIVE_END_DATE ASG_EFFECTIVE_END_DATE
, BKG.EVENT_START_DATE EVENT_START_DATE
, BKG.EVENT_END_DATE EVENT_END_DATE /* ASSIGNMENT IDS */
, BKG.ASSIGNMENT_ID ASSIGNMENT_ID
, BKG.PERSON_ID PERSON_ID
, BKG.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, BKG.ORGANIZATION_ID ORGANIZATION_ID
, GEO.GEO_AREA_ID GEO_AREA_CODE
, GEO.GEO_COUNTRY_ID GEO_COUNTRY_CODE
, GEO.GEO_REGION_ID GEO_REGION_CODE
, BKG.LOCATION_ID LOCATION_ID
, JCT.JOB_CAT_CODE JOB_CAT_CODE
, BKG.JOB_ID JOB_ID
, BKG.GRADE_ID GRADE_ID
, BKG.POSITION_ID POSITION_ID /* TRAINING IDS*/
, BKG.ACTIVITY_ID ACTIVITY_ID
, BKG.ACTIVITY_VERSION_ID ACTIVITY_VERSION_ID
, BKG.EVENT_ID EVENT_ID
, TO_NUMBER( TO_CHAR( BKG.EVENT_END_DATE
, 'YYYY' )) EVENT_END_FII_TIME_YEAR_ID
, DECODE( TRUNC( ( TO_CHAR( BKG.EVENT_END_DATE
, 'MM' ) -1 ) / 6 )
, 0
, TO_CHAR( BKG.EVENT_END_DATE
, 'YYYY') || '1'
, 1
, TO_CHAR( BKG.EVENT_END_DATE
, 'YYYY') || '2' ) EVENT_END_FII_TIME_SEMIYEAR_ID
, TO_NUMBER( TO_CHAR( BKG.EVENT_END_DATE
, 'YYYYQ' ) ) EVENT_END_FII_TIME_QTR_ID
, TO_CHAR( BKG.EVENT_END_DATE
, 'YYYY' ) || TRUNC( ( TO_NUMBER( TO_CHAR( BKG.EVENT_END_DATE
, 'MM' ) ) + 1 ) / 2 ) EVENT_END_FII_TIME_BIMONTH_ID
, TO_NUMBER( TO_CHAR( BKG.EVENT_END_DATE
, 'YYYYQMM' ) ) EVENT_END_FII_TIME_MONTH_ID
, BKG.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 /* DATE CURRENCY */
, BKG.LAST_CHANGE_DATE LAST_CHANGE_DATE
, BKG.HR_SECURITY_FLAG_CODE HR_SECURITY_FLAG_CODE
, BKG.BG_SECURITY_FLAG_CODE BG_SECURITY_FLAG_CODE
FROM /*------------------------------------*/ HRI_MD_TRN_BKG_INT_ATT_V BKG
, HRI_CS_GEO_LOCHR_CT GEO
, HRI_CS_JOBCAT_V JCT
WHERE BKG.LOCATION_ID = GEO.LOCATION_ID
AND BKG.JOB_ID = JCT.JOB_ID /* FILTERS */
AND BKG.HR_SECURITY_FLAG_CODE = 'Y'