PSC_COM_AGENCY_COMM_VL

Details

• Schema: FUSION

• Object owner: PSC_CC

• Object type: VIEW

Columns

Name
AGENCY_ID EMAIL_ID ENABLED_FLAG DEFAULT_EMAIL_FLAG EMAIL_ADDRESS_TYPE OFFERING_ID FUNCTIONAL_CATEGORY EXTN_ATTRIBUTE_NUM1 EXTN_ATTRIBUTE_NUM2 EXTN_ATTRIBUTE_NUM3 EXTN_ATTRIBUTE_CHAR1 EXTN_ATTRIBUTE_CHAR2 EXTN_ATTRIBUTE_CHAR3 OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN EMAIL_DESCR LANGUAGE SOURCE_LANG

Query

SQL_Statement

SELECT B.AGENCY_ID, B.EMAIL_ID, B.ENABLED_FLAG, B.DEFAULT_EMAIL_FLAG, B.EMAIL_ADDRESS_TYPE, B.OFFERING_ID, B.FUNCTIONAL_CATEGORY, B.EXTN_ATTRIBUTE_NUM1, B.EXTN_ATTRIBUTE_NUM2, B.EXTN_ATTRIBUTE_NUM3, B.EXTN_ATTRIBUTE_CHAR1, B.EXTN_ATTRIBUTE_CHAR2, B.EXTN_ATTRIBUTE_CHAR3, B.OBJECT_VERSION_NUMBER, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN, TL.EMAIL_DESCR, TL.LANGUAGE, TL.SOURCE_LANG FROM psc_com_agency_comm_b B, psc_com_agency_comm_tl TL WHERE B.AGENCY_ID = TL.AGENCY_ID AND B.EMAIL_ID = TL.EMAIL_ID AND TL.LANGUAGE = USERENV('LANG')