CREATE OR REPLACE FORCE VIEW "LABOR_TRACKING_REPORT" ("RECORD_ID", "RACFID", "PROJECT", "TASK", "RECORD_C_E", "YEAR", "WEEK", "HOURS_MON", "HOURS_TUE", "HOURS_WED", "HOURS_THU", "HOURS_FRI", "HOURS_SAT", "HOURS_SUN", "RESOURCE_ID", "PROJECT_LEAD", "PROJECT_DEPT", "RS_NAME", "RS_MANAGER", "RS_DEPT_ID") ASselect "FBU_LT_RECORDS"."RECORD_ID" as "RECORD_ID", "FBU_LT_RECORDS"."RACFID" as "RACFID", "FBU_PROJECTS"."PROJECT_DESC" as "PROJECT", "FBU_LT_TASKS"."TASK" as "TASK", FBU_LT_CHOOSE_CAP_EXP("PROJECT", "TASK") "RECORD_C_E", "FBU_LT_RECORDS"."YEAR" as "YEAR", "FBU_LT_RECORDS"."WEEK" as "WEEK", "FBU_LT_RECORDS"."HOURS_MON" as "HOURS_MON", "FBU_LT_RECORDS"."HOURS_TUE" as "HOURS_TUE", "FBU_LT_RECORDS"."HOURS_WED" as "HOURS_WED", "FBU_LT_RECORDS"."HOURS_THU" as "HOURS_THU", "FBU_LT_RECORDS"."HOURS_FRI" as "HOURS_FRI", "FBU_LT_RECORDS"."HOURS_SAT" as "HOURS_SAT", "FBU_LT_RECORDS"."HOURS_SUN" as "HOURS_SUN", "FBU_LT_RECORDS"."RESOURCE_ID" as "RESOURCE_ID", "FBU_PROJECTS"."PROJECT_LEAD" as "PROJECT_LEAD", "FBU_PROJECTS"."PROJECT_DEPT" as "PROJECT_DEPT", "FBU_RESOURCE"."RS_NAME" as "RS_NAME", "FBU_RESOURCE"."RS_MANAGER" as "RS_MANAGER", "FBU_RESOURCE"."RS_DEPT_ID" as "RS_DEPT_ID" from "FBU_DEPT" "FBU_DEPT", "FBU_RESOURCE" "FBU_RESOURCE", "FBU_PROJECTS" "FBU_PROJECTS", "FBU_LT_TASKS" "FBU_LT_TASKS", "FBU_LT_RECORDS" "FBU_LT_RECORDS" where "FBU_LT_RECORDS"."PROJECT"="FBU_PROJECTS"."PROJECT_ID" and "FBU_LT_RECORDS"."RESOURCE_ID"="FBU_RESOURCE"."RS_RESOURCE_ID" and "FBU_LT_RECORDS"."TASK"="FBU_LT_TASKS"."ID"/