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_TO_WMV_CNT_X_V

Source

View Text - Preformatted


SELECT wmv.primary_asg_indicator primary_asg_indicator , wmv.asg_indicator asg_indicator , CASE WHEN wmt.ID = 'FTE' THEN NVL( wmv.fte,0 ) WHEN wmt.ID = 'HEAD' THEN NVL( wmv.head,0 ) ELSE 0 END wmv /* Metric UOM Ids */ , wmt.id wmt_code /* Asg Ids*/ , wmv.assignment_id assignment_id , wmv.person_id person_id , wmv.business_group_id business_group_id , wmv.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 , wmv.location_id location_id , wmv.job_id job_id , wmv.grade_id grade_id , wmv.position_id position_id , wmv.assignment_status_type_id assignment_status_type_id , wmv.assignment_type_code assignment_type_code , wmv.per_system_status_code per_system_status_code , wmv.pay_system_status_code pay_system_status_code FROM /*------------------------------------*/ hri_md_wmv_x_v wmv , hri_cs_geo_lochr_ct geo , hri_cl_wmt_x_v wmt WHERE wmv.location_id = geo.location_id AND wmv.hr_security_flag_code = 'Y' AND wmv.assignment_type_code = 'E' WITH READ ONLY

View Text - HTML Formatted

SELECT WMV.PRIMARY_ASG_INDICATOR PRIMARY_ASG_INDICATOR
, WMV.ASG_INDICATOR ASG_INDICATOR
, CASE WHEN WMT.ID = 'FTE' THEN NVL( WMV.FTE
, 0 ) WHEN WMT.ID = 'HEAD' THEN NVL( WMV.HEAD
, 0 ) ELSE 0 END WMV /* METRIC UOM IDS */
, WMT.ID WMT_CODE /* ASG IDS*/
, WMV.ASSIGNMENT_ID ASSIGNMENT_ID
, WMV.PERSON_ID PERSON_ID
, WMV.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, WMV.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
, WMV.LOCATION_ID LOCATION_ID
, WMV.JOB_ID JOB_ID
, WMV.GRADE_ID GRADE_ID
, WMV.POSITION_ID POSITION_ID
, WMV.ASSIGNMENT_STATUS_TYPE_ID ASSIGNMENT_STATUS_TYPE_ID
, WMV.ASSIGNMENT_TYPE_CODE ASSIGNMENT_TYPE_CODE
, WMV.PER_SYSTEM_STATUS_CODE PER_SYSTEM_STATUS_CODE
, WMV.PAY_SYSTEM_STATUS_CODE PAY_SYSTEM_STATUS_CODE
FROM /*------------------------------------*/ HRI_MD_WMV_X_V WMV
, HRI_CS_GEO_LOCHR_CT GEO
, HRI_CL_WMT_X_V WMT
WHERE WMV.LOCATION_ID = GEO.LOCATION_ID
AND WMV.HR_SECURITY_FLAG_CODE = 'Y'
AND WMV.ASSIGNMENT_TYPE_CODE = 'E' WITH READ ONLY