PAY_REPORT_BLOCKS_VL

Details

• Schema: FUSION

• Object owner: PAY

• Object type: VIEW

Columns

Name

REPORT_BLOCK_ID REPORT_FORMAT MAIN_BLOCK_FLAG CURSOR_NAME NO_COLUMN_RETURNED USER_ENTITY_ID EXT_DEFINITION_ID MULTI_THREAD_ACT_TYPE MULTI_DBI_ID XML_TAG_NAME REQUIRED_FLAG LEGISLATION_CODE LEGISLATIVE_DATA_GROUP_ID ENTERPRISE_ID LANGUAGE SOURCE_LANG BLOCK_NAME DESCRIPTION LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN CREATED_BY CREATION_DATE OBJECT_VERSION_NUMBER MODULE_ID BASE_BLOCK_NAME INTERLOCK_DBI_ID TEMPLATE_BLOCK_ID CREATOR_TYPE CREATOR_ID SGUID

Query

SQL_Statement

SELECT blk.REPORT_BLOCK_ID REPORT_BLOCK_ID, blk.REPORT_FORMAT report_format, blk.MAIN_BLOCK_FLAG main_block_flag, blk.CURSOR_NAME cursor_name, blk.NO_COLUMN_RETURNED no_column_returned, blk.USER_ENTITY_ID user_entity_id, blk.EXT_DEFINITION_ID ext_definition_id, blk.MULTI_THREAD_ACT_TYPE multi_thread_act_type, blk.MULTI_DBI_ID multi_dbi_id, blk.XML_TAG_NAME xml_tag_name, blk.REQUIRED_FLAG required_flag, blk.LEGISLATION_CODE LEGISLATION_CODE, blk.LEGISLATIVE_DATA_GROUP_ID LEGISLATIVE_DATA_GROUP_ID, blk.ENTERPRISE_ID ENTERPRISE_ID, tl.LANGUAGE LANGUAGE, tl.SOURCE_LANG SOURCE_LANG, tl.BLOCK_NAME BLOCK_NAME, tl.DESCRIPTION DESCRIPTION, blk.LAST_UPDATED_BY LAST_UPDATED_BY, blk.LAST_UPDATE_DATE LAST_UPDATE_DATE, blk.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, blk.CREATED_BY CREATED_BY, blk.CREATION_DATE CREATION_DATE, blk.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, blk.MODULE_ID MODULE_ID, blk.BASE_BLOCK_NAME BASE_BLOCK_NAME, blk.INTERLOCK_DBI_ID INTERLOCK_DBI_ID, blk.TEMPLATE_BLOCK_ID template_block_id, blk.CREATOR_TYPE creator_type, blk.CREATOR_ID creator_id, blk.SGUID SGUID FROM PAY_REPORT_BLOCKS_TL tl, PAY_REPORT_BLOCKS blk WHERE tl.REPORT_BLOCK_ID = blk.REPORT_BLOCK_ID AND tl.LANGUAGE = USERENV('LANG')