MSC_AP_RESOURCES_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
AVAILABLE_24_HOURS_FLAG CAPACITY_UNITS UTILIZATION EFFICIENCY ORGANIZATION_ID RESOURCE_ID RESOURCE_CODE RESOURCE_NAME RESOURCE_DESCRIPTION UNIT_OF_MEASURE ORGANIZATION_CODE WORK_AREA_CODE WORK_AREA_NAME WORK_AREA_DESCRIPTION DEPARTMENT_CODE DEPARTMENT_NAME DEPARTMENT_DESCRIPTION DEPARTMENT_ID DISABLE_DATE CTP_FLAG WORK_AREA_ID LINE_FLAG RESOURCE_TYPE RESOURCE_COST CURRENCY_CODE WCRROWID

Query

SQL_Statement

SELECT wcr.available_24_hours_flag, wcr.resource_quantity capacity_units, wcr.utilization_percentage utilization, wcr.efficiency_percentage efficiency, res.organization_id, res.resource_id, res.resource_code, res.resource_name, res. RESOURCE_DESCRIPTION, res. UOM_CODE UNIT_OF_MEASURE, invOrg.organization_code, wa. WORK_AREA_CODE, wa. WORK_AREA_NAME, wa. WORK_AREA_DESCRIPTION, wc. WORK_CENTER_CODE DEPARTMENT_CODE, wc. WORK_CENTER_NAME DEPARTMENT_NAME, wc. WORK_CENTER_DESCRIPTION DEPARTMENT_DESCRIPTION, wc.work_center_id DEPARTMENT_ID, nvl2(res.INACTIVE_DATE,least(res.INACTIVE_DATE,nvl(wc.INACTIVE_DATE,res.INACTIVE_DATE)),wc.INACTIVE_DATE) DISABLE_DATE , DECODE(wcr.CHECK_CTP_FLAG,'Y',1,'N',2,2) CTP_FLAG, wa.work_area_id work_area_id, 2 AS Line_flag , decode(RESOURCE_TYPE,'EQUIPMENT',1,'LABOR',2,1) RESOURCE_TYPE, cst.total_rate resource_cost , cst.currency_code , wcr.rowid WCRROWID FROM WIS_WC_RESOURCES wcr , WIS_RESOURCES_VL res, WIS_WORK_CENTERS_VL wc, WIS_WORK_AREAS_VL wa , INV_ORG_PARAMETERS invOrg, CST_RESOURCE_RATES_VCP_V cst WHERE Wcr.work_center_id = wc.work_center_id AND wcr.resource_id = res.resource_id AND wc.work_area_id = wa.work_area_id AND res.organization_id = invOrg.organization_id and cst.organization_id(+) = res.organization_id AND res.resource_id = cst.resource_id(+)