All pastes #435139 Raw Edit

slammin sql

public sql v1 · immutable
·published 2007-04-11 20:02 UTC
rendered paste body
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") AS select	 "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" /