PAY_TAX_CALC_STMT_ELEMENTS_VL

Details

• Schema: FUSION

• Object owner: PAY

• Object type: VIEW

Columns

Name

TCS_ELEMENT_ID TCS_BASE_ELEMENT_NAME LEGISLATION_CODE ELEMENT_USAGE ELEMENT_TYPE SEQUENCE PARENT_TCS_ELEMENT_ID TAX_TYPE TAX_SUB_TYPE ACTIVE_FLAG VALIDATION_EXPRESSION CALCULATION_EXPRESSION DISPLAY FORMAT TCS_ELEMENT_NAME CALC_LOGIC_DISPLAY MODULE_ID SGUID ENTERPRISE_ID OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATE_LOGIN LAST_UPDATED_BY SEED_DATA_SOURCE ORA_SEED_SET1 ORA_SEED_SET2

Query

SQL_Statement

SELECT tcs.TCS_ELEMENT_ID TCS_ELEMENT_ID, tcs.TCS_BASE_ELEMENT_NAME TCS_BASE_ELEMENT_NAME, tcs.LEGISLATION_CODE LEGISLATION_CODE, tcs.ELEMENT_USAGE ELEMENT_USAGE, tcs.ELEMENT_TYPE ELEMENT_TYPE, tcs.SEQUENCE SEQUENCE, tcs.PARENT_TCS_ELEMENT_ID PARENT_TCS_ELEMENT_ID, tcs.TAX_TYPE TAX_TYPE, tcs.TAX_SUB_TYPE TAX_SUB_TYPE, tcs.ACTIVE_FLAG ACTIVE_FLAG, tcs.VALIDATION_EXPRESSION VALIDATION_EXPRESSION, tcs.CALCULATION_EXPRESSION CALCULATION_EXPRESSION, tcs.DISPLAY DISPLAY, tcs.FORMAT FORMAT, tcstl.TCS_ELEMENT_NAME TCS_ELEMENT_NAME, tcstl.CALC_LOGIC_DISPLAY CALC_LOGIC_DISPLAY, tcs.MODULE_ID MODULE_ID, tcs.SGUID SGUID, tcs.ENTERPRISE_ID ENTERPRISE_ID, tcs.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, tcs.CREATED_BY CREATED_BY, tcs.CREATION_DATE CREATION_DATE, tcs.LAST_UPDATE_DATE LAST_UPDATE_DATE, tcs.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, tcs.LAST_UPDATED_BY LAST_UPDATED_BY, tcs.SEED_DATA_SOURCE SEED_DATA_SOURCE, tcs.ORA_SEED_SET1 ORA_SEED_SET1, tcs.ORA_SEED_SET2 ORA_SEED_SET2 FROM PAY_TAX_CALC_STMT_ELEMENTS tcs, PAY_TAX_CALC_STMT_ELEMENTS_TL tcstl WHERE tcs.TCS_ELEMENT_ID = tcstl.tcs_ELEMENT_ID AND tcstl.LANGUAGE = USERENV('LANG')