VIEW: HR.GHR_MULTI_IA_PROCESS#

Source

View Text - Preformatted

select IA_PROCESS_ID IA_PROCESS_ID, IA_TYPE IA_TYPE, PERSON_ID PERSON_ID, EMPLOYEE_NATIONAL_IDENTIFIER EMPLOYEE_NATIONAL_IDENTIFIER, EMPLOYEE_NUMBER EMPLOYEE_NUMBER, EMPLOYEE_FULL_NAME EMPLOYEE_FULL_NAME, SELECT_FLAG SELECT_FLAG, EFFECTIVE_DATE EFFECTIVE_DATE, NOA_CODE NOA_CODE, NOA_DESC NOA_DESC, ACTION_TYPE ACTION_TYPE, NOA_FAMILY_CODE NOA_FAMILY_CODE, IA_PA_REQUEST_ID IA_PA_REQUEST_ID, PROC_CONC_ID PROC_CONC_ID, STATUS STATUS, PROCESS_PA_REQUEST_ID PROCESS_PA_REQUEST_ID, FIRST_ACTION_LA_CODE1 FIRST_ACTION_LA_CODE1, FIRST_ACTION_LA_CODE2 FIRST_ACTION_LA_CODE2, FIRST_ACTION_LA_DESC1 FIRST_ACTION_LA_DESC1, FIRST_ACTION_LA_DESC2 FIRST_ACTION_LA_DESC2, FIRST_LAC1_INFORMATION1 FIRST_LAC1_INFORMATION1, FIRST_LAC1_INFORMATION2 FIRST_LAC1_INFORMATION2, FIRST_LAC1_INFORMATION3 FIRST_LAC1_INFORMATION3, FIRST_LAC2_INFORMATION1 FIRST_LAC2_INFORMATION1, FIRST_LAC2_INFORMATION2 FIRST_LAC2_INFORMATION2, FIRST_LAC2_INFORMATION3 FIRST_LAC2_INFORMATION3, SECOND_ACTION_LA_CODE1 SECOND_ACTION_LA_CODE1, SECOND_ACTION_LA_CODE2 SECOND_ACTION_LA_CODE2, SECOND_ACTION_LA_DESC1 SECOND_ACTION_LA_DESC1, SECOND_ACTION_LA_DESC2 SECOND_ACTION_LA_DESC2, SECOND_LAC1_INFORMATION1 SECOND_LAC1_INFORMATION1, SECOND_LAC1_INFORMATION2 SECOND_LAC1_INFORMATION2, SECOND_LAC1_INFORMATION3 SECOND_LAC1_INFORMATION3, SECOND_LAC2_INFORMATION1 SECOND_LAC2_INFORMATION1, SECOND_LAC2_INFORMATION2 SECOND_LAC2_INFORMATION2, SECOND_LAC2_INFORMATION3 SECOND_LAC2_INFORMATION3, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, INFORMATION1 INFORMATION1, INFORMATION2 INFORMATION2, INFORMATION3 INFORMATION3, INFORMATION4 INFORMATION4, INFORMATION5 INFORMATION5, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "HR"."GHR_MULTI_IA_PROCESS"

View Text - HTML Formatted

SELECT IA_PROCESS_ID IA_PROCESS_ID
, IA_TYPE IA_TYPE
, PERSON_ID PERSON_ID
, EMPLOYEE_NATIONAL_IDENTIFIER EMPLOYEE_NATIONAL_IDENTIFIER
, EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, EMPLOYEE_FULL_NAME EMPLOYEE_FULL_NAME
, SELECT_FLAG SELECT_FLAG
, EFFECTIVE_DATE EFFECTIVE_DATE
, NOA_CODE NOA_CODE
, NOA_DESC NOA_DESC
, ACTION_TYPE ACTION_TYPE
, NOA_FAMILY_CODE NOA_FAMILY_CODE
, IA_PA_REQUEST_ID IA_PA_REQUEST_ID
, PROC_CONC_ID PROC_CONC_ID
, STATUS STATUS
, PROCESS_PA_REQUEST_ID PROCESS_PA_REQUEST_ID
, FIRST_ACTION_LA_CODE1 FIRST_ACTION_LA_CODE1
, FIRST_ACTION_LA_CODE2 FIRST_ACTION_LA_CODE2
, FIRST_ACTION_LA_DESC1 FIRST_ACTION_LA_DESC1
, FIRST_ACTION_LA_DESC2 FIRST_ACTION_LA_DESC2
, FIRST_LAC1_INFORMATION1 FIRST_LAC1_INFORMATION1
, FIRST_LAC1_INFORMATION2 FIRST_LAC1_INFORMATION2
, FIRST_LAC1_INFORMATION3 FIRST_LAC1_INFORMATION3
, FIRST_LAC2_INFORMATION1 FIRST_LAC2_INFORMATION1
, FIRST_LAC2_INFORMATION2 FIRST_LAC2_INFORMATION2
, FIRST_LAC2_INFORMATION3 FIRST_LAC2_INFORMATION3
, SECOND_ACTION_LA_CODE1 SECOND_ACTION_LA_CODE1
, SECOND_ACTION_LA_CODE2 SECOND_ACTION_LA_CODE2
, SECOND_ACTION_LA_DESC1 SECOND_ACTION_LA_DESC1
, SECOND_ACTION_LA_DESC2 SECOND_ACTION_LA_DESC2
, SECOND_LAC1_INFORMATION1 SECOND_LAC1_INFORMATION1
, SECOND_LAC1_INFORMATION2 SECOND_LAC1_INFORMATION2
, SECOND_LAC1_INFORMATION3 SECOND_LAC1_INFORMATION3
, SECOND_LAC2_INFORMATION1 SECOND_LAC2_INFORMATION1
, SECOND_LAC2_INFORMATION2 SECOND_LAC2_INFORMATION2
, SECOND_LAC2_INFORMATION3 SECOND_LAC2_INFORMATION3
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, INFORMATION1 INFORMATION1
, INFORMATION2 INFORMATION2
, INFORMATION3 INFORMATION3
, INFORMATION4 INFORMATION4
, INFORMATION5 INFORMATION5
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "HR"."GHR_MULTI_IA_PROCESS"