HHR_VLTR_NEWSLETTER_VL

Details

• Schema: FUSION

• Object owner: HHR

• Object type: VIEW

Columns

Name
ID NEWSLETTER_TYPE RECIPIENT_TYPE RECIPIENTS SUBJECT CONTENT CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN LAST_UPDATE_DATE MEANING RECIPIENT_TYPE_MEANING

Query

SQL_Statement

SELECT A.ID ID, A.NEWSLETTER_TYPE NEWSLETTER_TYPE, A.RECIPIENT_TYPE RECIPIENT_TYPE, A.RECIPIENTS RECIPIENTS, B.SUBJECT SUBJECT, B.CONTENT CONTENT, A.CREATED_BY CREATED_BY, A.CREATION_DATE CREATION_DATE, A.LAST_UPDATED_BY LAST_UPDATED_BY, A.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, A.LAST_UPDATE_DATE LAST_UPDATE_DATE, C.MEANING, D.MEANING RECIPIENT_TYPE_MEANING FROM HHR_VLTR_NEWSLETTER_B A, HHR_VLTR_NEWSLETTER_TL B, FND_COMMON_LOOKUPS C, FND_COMMON_LOOKUPS D WHERE A.ID = B.ID AND A.NEWSLETTER_TYPE = C.LOOKUP_CODE AND C.LOOKUP_TYPE='ORA_HHR_NEWSLETTER_TYPE' AND A.RECIPIENT_TYPE = D.LOOKUP_CODE AND D.LOOKUP_TYPE='ORA_HHR_NWSLTTR_RCPNT_TYPE' AND B.LANGUAGE = USERENV('LANG')