eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: XLA.XLA_SEG_RULE_DETAILS#

Source

View Text - Preformatted


select SEGMENT_RULE_DETAIL_ID SEGMENT_RULE_DETAIL_ID, APPLICATION_ID APPLICATION_ID, AMB_CONTEXT_CODE AMB_CONTEXT_CODE, SEGMENT_RULE_TYPE_CODE SEGMENT_RULE_TYPE_CODE, SEGMENT_RULE_CODE SEGMENT_RULE_CODE, USER_SEQUENCE USER_SEQUENCE, VALUE_TYPE_CODE VALUE_TYPE_CODE, VALUE_SOURCE_APPLICATION_ID VALUE_SOURCE_APPLICATION_ID, VALUE_SOURCE_TYPE_CODE VALUE_SOURCE_TYPE_CODE, VALUE_SOURCE_CODE VALUE_SOURCE_CODE, VALUE_CONSTANT VALUE_CONSTANT, VALUE_CODE_COMBINATION_ID VALUE_CODE_COMBINATION_ID, VALUE_MAPPING_SET_CODE VALUE_MAPPING_SET_CODE, VALUE_FLEXFIELD_SEGMENT_CODE VALUE_FLEXFIELD_SEGMENT_CODE, INPUT_SOURCE_APPLICATION_ID INPUT_SOURCE_APPLICATION_ID, INPUT_SOURCE_TYPE_CODE INPUT_SOURCE_TYPE_CODE, INPUT_SOURCE_CODE INPUT_SOURCE_CODE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, VALUE_SEGMENT_RULE_APPL_ID VALUE_SEGMENT_RULE_APPL_ID, VALUE_SEGMENT_RULE_TYPE_CODE VALUE_SEGMENT_RULE_TYPE_CODE, VALUE_SEGMENT_RULE_CODE VALUE_SEGMENT_RULE_CODE, VALUE_ADR_VERSION_NUM VALUE_ADR_VERSION_NUM, ZD_EDITION_NAME ZD_EDITION_NAME from "XLA"."XLA_SEG_RULE_DETAILS"

View Text - HTML Formatted

SELECT SEGMENT_RULE_DETAIL_ID SEGMENT_RULE_DETAIL_ID
, APPLICATION_ID APPLICATION_ID
, AMB_CONTEXT_CODE AMB_CONTEXT_CODE
, SEGMENT_RULE_TYPE_CODE SEGMENT_RULE_TYPE_CODE
, SEGMENT_RULE_CODE SEGMENT_RULE_CODE
, USER_SEQUENCE USER_SEQUENCE
, VALUE_TYPE_CODE VALUE_TYPE_CODE
, VALUE_SOURCE_APPLICATION_ID VALUE_SOURCE_APPLICATION_ID
, VALUE_SOURCE_TYPE_CODE VALUE_SOURCE_TYPE_CODE
, VALUE_SOURCE_CODE VALUE_SOURCE_CODE
, VALUE_CONSTANT VALUE_CONSTANT
, VALUE_CODE_COMBINATION_ID VALUE_CODE_COMBINATION_ID
, VALUE_MAPPING_SET_CODE VALUE_MAPPING_SET_CODE
, VALUE_FLEXFIELD_SEGMENT_CODE VALUE_FLEXFIELD_SEGMENT_CODE
, INPUT_SOURCE_APPLICATION_ID INPUT_SOURCE_APPLICATION_ID
, INPUT_SOURCE_TYPE_CODE INPUT_SOURCE_TYPE_CODE
, INPUT_SOURCE_CODE INPUT_SOURCE_CODE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, VALUE_SEGMENT_RULE_APPL_ID VALUE_SEGMENT_RULE_APPL_ID
, VALUE_SEGMENT_RULE_TYPE_CODE VALUE_SEGMENT_RULE_TYPE_CODE
, VALUE_SEGMENT_RULE_CODE VALUE_SEGMENT_RULE_CODE
, VALUE_ADR_VERSION_NUM VALUE_ADR_VERSION_NUM
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "XLA"."XLA_SEG_RULE_DETAILS"