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