	GET_LOG_2017_Q4

Item Location

GET_LOG_2017_Q4

Columns

Name
ACTION
EMP_FNAME
EMP_LNAME
EMPLOYEE_ID
LOG_DATE
MESSAGE
STATUS
TITLE

Source Code

CREATE VIEW Get_Log_2017_Q4 (Log_date, Action, Title, Message, Employee_Id,EMP_FNAME,EMP_LNAME,STATUS)
	AS SELECT 
      Log_date,
      Action, 
      Title,
      Message,
      Employee_Id,
      EMP_FNAME,
      EMP_LNAME,
      STATUS
      
		FROM
			APPLOG AL
    INNER JOIN Employee  e ON E.EMP_ID = AL.Employee_Id
     where Log_date 
      between to_date('01.10.2017' , 'DD.MM.YYYY') and 
      last_day(to_date('31.12.2017' ,'DD.MM.YYYY'))

References
The items listed in the matrix below are called / used by the View “GET_LOG_2017_Q4”

Name	Types	Description
<DEFAULT SCHEMA>.APPLOG	Table	Table
DERIVEDTABLE	Table	Table
<DEFAULT SCHEMA>.EMPLOYEE	Table	Table
LAST_DAY	Function	PL/SQL System Function
TO_DATE	Function	PL/SQL System Function
<DEFAULT SCHEMA>.APPLOG.EMPLOYEE_ID	Column	Column
<DEFAULT SCHEMA>.EMPLOYEE.EMP_ID	Primary Key	Column

Impact Analysis
The items listed in the matrix below are using / calling the View “GET_LOG_2017_Q4”

Name	Types	Description
<DEFAULT SCHEMA>.GET_LOG_2017	View	View
<DEFAULT SCHEMA>.GET_LOG_2017.Select	Select Statement	SELECT Log_date, Action, Title, Message, Employee_Id, EMP_FNAME,