HWR_VLTR_VOL_PROJ_REL_VL
Details
-
Schema: FUSION
-
Object owner: HHR
-
Object type: VIEW
Columns
Name |
---|
ID SOURCE_ID CONVERSATION_ID PROJECT_ID NUM_MINORS PROJECT_NAME START_DATE END_DATE PROJECT_LEAD_ID PROJECT_CREATED_BY SUBSCRIPTION_DATE SUBSCRIPTION_ENDDATE VERSION CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN STATUS T_SIZE T_STYLE MAXIMUM_PARTICIPANT_NUMBER MAXIMUM_GUEST_NUMBER REGISTRATION_DEADLINE HCM_PERSON_ID PROJECT_LEAD_PERSON_ID |
Query
SQL_Statement |
---|
SELECT B.ID ID, B.SOURCE_ID SOURCE_ID, B.CONVERSATION_ID CONVERSATION_ID, B.PROJECT_ID PROJECT_ID, B.NUM_MINORS NUM_MINORS, A.PROJECT_NAME PROJECT_NAME, A.START_DATE START_DATE, A.END_DATE END_DATE, A.PROJECT_LEAD_ID PROJECT_LEAD_ID, A.CREATED_BY PROJECT_CREATED_BY, B.SUBSCRIPTION_DATE SUBSCRIPTION_DATE, B.SUBSCRIPTION_ENDDATE SUBSCRIPTION_ENDDATE, B.VERSION VERSION, B.CREATED_BY CREATED_BY, B.CREATION_DATE CREATION_DATE, B.LAST_UPDATED_BY LAST_UPDATED_BY, B.LAST_UPDATE_DATE LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, B.STATUS STATUS, B.T_SIZE T_SIZE , B.T_STYLE T_STYLE, A.MAXIMUM_PARTICIPANT_NUMBER MAXIMUM_PARTICIPANT_NUMBER, A.MAXIMUM_GUEST_NUMBER MAXIMUM_GUEST_NUMBER, A.REGISTRATION_DEADLINE REGISTRATION_DEADLINE, B.HCM_PERSON_ID, A.PROJECT_LEAD_PERSON_ID PROJECT_LEAD_PERSON_ID FROM HWR_VLTR_VOL_PROJ_REL_B B, HWR_VLTR_PROJECT_VL A WHERE A.PROJECT_ID = B.PROJECT_ID |