View HLPDTEST.STATEGPS.TEST_TIME_TRACKING_V_7292 | Generated by SchemaSpy |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Tue May 24 01:05 IST 2022 |
View Definition:
SELECT T_GPS_APPLICATIONS.APPLICATION_NAME PROJECT, NULL process, DECODE(T_PROJECT_ACTIVITY.USER_NAME, NULL, T_PROJECT_TASK.USER_NAME, T_PROJECT_ACTIVITY.USER_NAME) RESOURCE_NAME, (T_PROJECT_ACTIVITY.CREATED_DATE) ENTERED_DATE, SUM(T_PROJECT_ACTIVITY.BILLABLE_HOURS) BILLABLE_HOURS, SUM(T_PROJECT_ACTIVITY.NON_BILLABLE_HOURS) NON_BILLABLE_HOURS, SUM(T_PROJECT_ACTIVITY.EXTRA_BILLABLE_HOURS) EXTRA_BILLABLE_HOURS, ee.branch_id BRANCH_ID, t_project_activity.approve STATUS, ee.employee_id, T_GPS_APPLICATIONS.Application_Id PROJECT_ID, TO_NUMBER((SELECT el.employee_id from TAS.t_users u, t_gps_app_properties ap, eis.eis_login el where to_char(u.user_id) = ap.property_value and ap.property_name = 'PROJECT_MANAGER' and u.user_name = el.username and ap.application_id = T_GPS_APPLICATIONS.application_id)) MANAGER_ID, to_number(ee.next_higher_authority) REPORTING_MANAGER_ID FROM STATEGPS.T_PROJECT_ACTIVITY T_PROJECT_ACTIVITY, STATEGPS.T_PROJECT_TASK T_PROJECT_TASK, STATEGPS.T_INSTANCES T_INSTANCES, STATEGPS.T_GPS_APPLICATIONS T_GPS_APPLICATIONS, EIS.EIS_EMPLOYEE ee, EIS.EIS_LOGIN EL WHERE T_PROJECT_TASK.PROJECT_TASK_ID = T_PROJECT_ACTIVITY.PROJECT_TASK_ID AND T_INSTANCES.INSTANCE_ID = T_PROJECT_TASK.INSTANCE_ID AND T_GPS_APPLICATIONS.APPLICATION_ID = T_INSTANCES.APPLICATION_ID and ee.employee_id = el.employee_id AND EL.USERNAME = DECODE(T_PROJECT_ACTIVITY.USER_NAME, NULL, T_PROJECT_TASK.USER_NAME, T_PROJECT_ACTIVITY.USER_NAME) AND T_GPS_APPLICATIONS.VISIBLE_FLAG = 'true' AND el.employee_id = '7292' and T_PROJECT_ACTIVITY.CREATED_DATE between sysdate - 4 and sysdate GROUP BY T_GPS_APPLICATIONS.APPLICATION_NAME, NULL, DECODE(T_PROJECT_ACTIVITY.USER_NAME, NULL, T_PROJECT_TASK.USER_NAME, T_PROJECT_ACTIVITY.USER_NAME), (T_PROJECT_ACTIVITY.CREATED_DATE), ee.firstname || ' ' || ee.middlename || ' ' || ee.lastname, ee.branch_id, t_project_activity.approve, ee.employee_id, T_GPS_APPLICATIONS.Application_Id, NULL, to_number(ee.next_higher_authority)
Possibly Referenced Tables/Views:
![]() ![]() |