PSC_BL_TAX_CLSCOLS_F_VL

Details

• Schema: FUSION

• Object owner: PSC_BL

• Object type: VIEW

Columns

Name
AGENCY_ID TAX_CLASS_CODE EFFECTIVE_START_DATE EFFECTIVE_END_DATE COLUMN_NAME SEQUENCE_NUM DESCRIPTION ORIGINAL_FLAG RENEWAL_FLAG AMEND_FLAG ATTACH_FLAG TIMELINE_FLAG ENABLED_FLAG OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT B.AGENCY_ID, B.TAX_CLASS_CODE, B.EFFECTIVE_START_DATE, B.EFFECTIVE_END_DATE, B.COLUMN_NAME, B.SEQUENCE_NUM, L.DESCRIPTION, B.ORIGINAL_FLAG, B.RENEWAL_FLAG, B.AMEND_FLAG, B.ATTACH_FLAG, B.TIMELINE_FLAG, B.ENABLED_FLAG, B.OBJECT_VERSION_NUMBER, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN FROM PSC_BL_TAX_CLSCOLS_F_B B, PSC_BL_TAX_CLSCOLS_F_TL L WHERE B.AGENCY_ID = L.AGENCY_ID AND B.TAX_CLASS_CODE = L.TAX_CLASS_CODE AND B.EFFECTIVE_START_DATE = L.EFFECTIVE_START_DATE AND B.EFFECTIVE_END_DATE = L.EFFECTIVE_END_DATE AND B.COLUMN_NAME = L.COLUMN_NAME AND L.LANGUAGE = USERENV('LANG')