PER_EXT_DELIVERY_OPTIONS_VL

Details

• Schema: FUSION

• Object owner: PER

• Object type: VIEW

Columns

Name

EXT_DELIVERY_OPTION_ID BASE_DELIVERY_OPTION_NAME DELIVERY_OPTION_NAME DESCRIPTION EXT_DEFINITION_ID DATE_FROM DATE_TO DELIVERY_TYPE BIP_REPORT_NAME BIP_TEMPLATE_NAME OUTPUT_TYPE OUTPUT_NAME OUTPUT_DIRECTORY_NAME FILTER_NODE CALENDAR_CODE BURSTING_NODE OVERRIDE_DELIVERY_OPTION_ID LEGISLATION_CODE LEGISLATIVE_DATA_GROUP_ID ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ENTERPRISE_ID MODULE_ID REP_DOCUMENT_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER PARENT_DELIVERY_OPTION_ID MANDATORY_FLAG SGUID

Query

SQL_Statement

SELECT opt.EXT_DELIVERY_OPTION_ID, opt.BASE_DELIVERY_OPTION_NAME, opttl.DELIVERY_OPTION_NAME, opttl.DESCRIPTION, opt.EXT_DEFINITION_ID, opt.DATE_FROM, opt.DATE_TO, opt.DELIVERY_TYPE, opt.BIP_REPORT_NAME, opt.BIP_TEMPLATE_NAME, opt.OUTPUT_TYPE, opt.OUTPUT_NAME, opt.OUTPUT_DIRECTORY_NAME, opt.FILTER_NODE, opt.CALENDAR_CODE, opt.BURSTING_NODE, opt.OVERRIDE_DELIVERY_OPTION_ID, opt.LEGISLATION_CODE, opt.LEGISLATIVE_DATA_GROUP_ID, opt.ATTRIBUTE_CATEGORY, opt.ATTRIBUTE1, opt.ATTRIBUTE2, opt.ATTRIBUTE3, opt.ATTRIBUTE4, opt.ATTRIBUTE5, opt.ATTRIBUTE_NUMBER1, opt.ATTRIBUTE_NUMBER2, opt.ATTRIBUTE_NUMBER3, opt.ATTRIBUTE_DATE1, opt.ATTRIBUTE_DATE2, opt.ATTRIBUTE_DATE3, opt.ENTERPRISE_ID, opt.MODULE_ID, opt.REP_DOCUMENT_ID, opt.CREATED_BY, opt.CREATION_DATE, opt.LAST_UPDATED_BY, opt.LAST_UPDATE_DATE, opt.LAST_UPDATE_LOGIN, opt.OBJECT_VERSION_NUMBER, opt.PARENT_DELIVERY_OPTION_ID, opt.MANDATORY_FLAG, opt.SGUID SGUID FROM PER_EXT_DELIVERY_OPTIONS_B opt, PER_EXT_DELIVERY_OPTIONS_TL opttl WHERE opt.EXT_DELIVERY_OPTION_ID = opttl.EXT_DELIVERY_OPTION_ID AND opttl.LANGUAGE = USERENV('LANG')