PSC_COM_FEATURE_SRCH_VL

Details

• Schema: FUSION

• Object owner: PSC_CC

• Object type: VIEW

Columns

Name
FEATURE_CODE ATTRIBUTE_VALUE OFFERING_ID DISPLAY_NAME DESCRIPTION ATTRIBUTE_TYPE DISPLAY_SEQ PARENT_ATTRIBUTE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER MODULE_ID SEED_DATA_LOCK DELETED_FLAG

Query

SQL_Statement

SELECT B.FEATURE_CODE, B.ATTRIBUTE_VALUE, B.OFFERING_ID, L.DISPLAY_NAME, L.DESCRIPTION, B.ATTRIBUTE_TYPE, B.DISPLAY_SEQ, B.PARENT_ATTRIBUTE, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER , B.MODULE_ID, B.SEED_DATA_LOCK, B.DELETED_FLAG FROM PSC_COM_FEATURE_SRCH_B B, PSC_COM_FEATURE_SRCH_TL L WHERE B.FEATURE_CODE = L.FEATURE_CODE AND B.ATTRIBUTE_VALUE = L.ATTRIBUTE_VALUE AND B.OFFERING_ID = L.OFFERING_ID AND L.LANGUAGE = USERENV('LANG')