CMP_TCS_PER_PERD_SEC_V

Details

• Schema: FUSION

• Object owner: CMP

• Object type: VIEW

Columns

Name

PER_PERD_ID STMT_ID STMT_PERD_ID PERD_RUN_ID PERSON_ID END_DATE START_DATE AVAILABILITY_DATE XCHG_RATE_DATE ONE_LEGAL_ENTITY_ID LEGAL_ENTITY_ID BUSINESS_GROUP_ID REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN LOCAL_CURRENCY_CODE OTHER_CURRENCY_CODE PDF_LOCAL_CURR_FLAG PDF_LOCAL_CURR_AVLBL PDF_OTHER_CURR_FLAG PDF_OTHER_CURR_CODE PDF_OTHER_CURR_AVLBL HIDE_OL_DRILL_SECTIONS_FLAG DISPLAY_JOB_FLAG DISPLAY_POSITION_FLAG FEEDBACK_ENABLED_FLAG HIDE_WELCOME_FLAG HIDE_PDF_ITEM_DETAILS_FLAG XCHANGE_RATE_MISSING_FLAG CURR_SWITCHER_DEFAULT NNMNTRY_SUMMARY_FLAG MNTRY_SUMMARY_FLAG

Query

SQL_Statement

SELECT PER_PERD_ID, STMT_ID, STMT_PERD_ID, PERD_RUN_ID, PERSON_ID, END_DATE, START_DATE , AVAILABILITY_DATE , XCHG_RATE_DATE , ONE_LEGAL_ENTITY_ID, LEGAL_ENTITY_ID, BUSINESS_GROUP_ID, REQUEST_ID, JOB_DEFINITION_NAME, JOB_DEFINITION_PACKAGE, CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, LOCAL_CURRENCY_CODE, OTHER_CURRENCY_CODE, PDF_LOCAL_CURR_FLAG, PDF_LOCAL_CURR_AVLBL, PDF_OTHER_CURR_FLAG, PDF_OTHER_CURR_CODE, PDF_OTHER_CURR_AVLBL, HIDE_OL_DRILL_SECTIONS_FLAG, DISPLAY_JOB_FLAG, DISPLAY_POSITION_FLAG, FEEDBACK_ENABLED_FLAG , HIDE_WELCOME_FLAG, HIDE_PDF_ITEM_DETAILS_FLAG, XCHANGE_RATE_MISSING_FLAG , CURR_SWITCHER_DEFAULT , NNMNTRY_SUMMARY_FLAG, MNTRY_SUMMARY_FLAG FROM cmp_tcs_per_perd