VIEW: APPS.EDW_HR_PERM_ASSIGN_LCV

Source

View Text - Preformatted

SELECT assignment_pk ,all_fk ,sprvsr_lvl1_fk ,name ,person_dp ,business_group ,person_num ,full_name ,last_name ,start_date ,end_date ,employee_flag ,applicant_flag ,buyer_flag ,planner_flag ,sales_rep_flag ,sys_gen_flag ,instance ,person_id ,salesrep_id ,planner_code ,organization_id ,effective_start_date ,effective_end_date ,first_name ,middle_names ,previous_last_name ,known_as ,title ,name_suffix ,name_prefix ,email_address ,marital_status ,rehire_rcmmndtn ,crrspndnc_language ,date_emp_data_vrfd ,disability_flag ,resume_updated_date ,resume_exists ,gender ,internal_location ,mailstop ,fast_path_employee ,national_identifier ,date_of_birth ,fte_capacity ,student_status ,town_of_birth ,region_of_birth ,country_of_birth ,nationality ,global_person_id ,creation_date ,last_update_date ,null ,null ,null ,null ,null FROM edwbv_hr_perm_assign_lcv

View Text - HTML Formatted

SELECT ASSIGNMENT_PK
, ALL_FK
, SPRVSR_LVL1_FK
, NAME
, PERSON_DP
, BUSINESS_GROUP
, PERSON_NUM
, FULL_NAME
, LAST_NAME
, START_DATE
, END_DATE
, EMPLOYEE_FLAG
, APPLICANT_FLAG
, BUYER_FLAG
, PLANNER_FLAG
, SALES_REP_FLAG
, SYS_GEN_FLAG
, INSTANCE
, PERSON_ID
, SALESREP_ID
, PLANNER_CODE
, ORGANIZATION_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, FIRST_NAME
, MIDDLE_NAMES
, PREVIOUS_LAST_NAME
, KNOWN_AS
, TITLE
, NAME_SUFFIX
, NAME_PREFIX
, EMAIL_ADDRESS
, MARITAL_STATUS
, REHIRE_RCMMNDTN
, CRRSPNDNC_LANGUAGE
, DATE_EMP_DATA_VRFD
, DISABILITY_FLAG
, RESUME_UPDATED_DATE
, RESUME_EXISTS
, GENDER
, INTERNAL_LOCATION
, MAILSTOP
, FAST_PATH_EMPLOYEE
, NATIONAL_IDENTIFIER
, DATE_OF_BIRTH
, FTE_CAPACITY
, STUDENT_STATUS
, TOWN_OF_BIRTH
, REGION_OF_BIRTH
, COUNTRY_OF_BIRTH
, NATIONALITY
, GLOBAL_PERSON_ID
, CREATION_DATE
, LAST_UPDATE_DATE
, NULL
, NULL
, NULL
, NULL
, NULL
FROM EDWBV_HR_PERM_ASSIGN_LCV