ZBS_COMPTTR_SWOTS_VL

Details

• Schema: FUSION

• Object owner: ZBS

• Object type: VIEW

Columns

Name
COMPTTR_SWOT_ID OBJECT_VERSION_NUMBER PARTY_ID PR_COMPTTR_SWOT_INDUSTRY_ID PR_COMPTTR_SWOT_GEO_ID PR_COMPTTR_SWOT_PRODGRP_ID SWOT_TYPE_CODE CONFLICT_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN USER_LAST_UPDATE_DATE SWOT_DESC_TEXT COMMENTS

Query

SQL_Statement

SELECT ZBS_COMPTTR_SWOTS_B.COMPTTR_SWOT_ID COMPTTR_SWOT_ID, ZBS_COMPTTR_SWOTS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ZBS_COMPTTR_SWOTS_B.PARTY_ID PARTY_ID, ZBS_COMPTTR_SWOTS_B.PR_COMPTTR_SWOT_INDUSTRY_ID PR_COMPTTR_SWOT_INDUSTRY_ID, ZBS_COMPTTR_SWOTS_B.PR_COMPTTR_SWOT_GEO_ID PR_COMPTTR_SWOT_GEO_ID, ZBS_COMPTTR_SWOTS_B.PR_COMPTTR_SWOT_PRODGRP_ID PR_COMPTTR_SWOT_PRODGRP_ID, ZBS_COMPTTR_SWOTS_B.SWOT_TYPE_CODE SWOT_TYPE_CODE, ZBS_COMPTTR_SWOTS_B.CONFLICT_ID CONFLICT_ID, ZBS_COMPTTR_SWOTS_B.CREATED_BY CREATED_BY, ZBS_COMPTTR_SWOTS_B.CREATION_DATE CREATION_DATE, ZBS_COMPTTR_SWOTS_B.LAST_UPDATED_BY LAST_UPDATED_BY, ZBS_COMPTTR_SWOTS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, ZBS_COMPTTR_SWOTS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ZBS_COMPTTR_SWOTS_B.USER_LAST_UPDATE_DATE USER_LAST_UPDATE_DATE, ZBS_COMPTTR_SWOTS_TL.SWOT_DESC_TEXT SWOT_DESC_TEXT, ZBS_COMPTTR_SWOTS_TL.COMMENTS COMMENTS FROM ZBS_COMPTTR_SWOTS_B, ZBS_COMPTTR_SWOTS_TL WHERE ZBS_COMPTTR_SWOTS_B.COMPTTR_SWOT_ID = ZBS_COMPTTR_SWOTS_TL.COMPTTR_SWOT_ID AND ZBS_COMPTTR_SWOTS_TL.LANGUAGE = USERENV('LANG')