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.

VIEW: APPS.XLA_SEG_RULES_FVL

Source

View Text - Preformatted


SELECT srb.rowid row_id ,srb.application_id application_id ,srb.amb_context_code amb_context_code ,apl.application_name application_name ,srb.segment_rule_type_code segment_rule_type_code ,lkp.meaning segment_rule_type_dsp ,srb.segment_rule_code segment_rule_code ,srl.name name ,srl.description description ,srb.transaction_coa_id transaction_coa_id ,flx1.id_flex_structure_name transaction_coa_name ,srb.accounting_coa_id accounting_coa_id ,flx2.id_flex_structure_name accounting_coa_name ,srb.flexfield_segment_code flexfield_segment_code ,null flexfield_segment_name ,srb.flexfield_assign_mode_code flexfield_assign_mode_code ,srb.enabled_flag enabled_flag ,srb.flex_value_set_id flex_value_set_id ,null flex_value_set_name ,srb.creation_date creation_date ,srb.created_by created_by ,srb.last_update_date last_update_date ,srb.last_updated_by last_updated_by ,srb.last_update_login last_update_login FROM xla_seg_rules_b srb ,xla_seg_rules_tl srl ,fnd_application_tl apl ,fnd_id_flex_structures_tl flx1 ,fnd_id_flex_structures_tl flx2 ,xla_lookups lkp WHERE srb.application_id = srl.application_id AND srb.amb_context_code = srl.amb_context_code AND srb.segment_rule_type_code = srl.segment_rule_type_code AND srb.segment_rule_code = srl.segment_rule_code AND srl.language = USERENV('LANG') AND srb.application_id = apl.application_id AND apl.language = USERENV('LANG') AND srb.segment_rule_type_code = lkp.lookup_code AND lkp.lookup_type = 'XLA_OWNER_TYPE' AND srb.transaction_coa_id = flx1.id_flex_num(+) AND flx1.id_flex_code(+) = 'GL#' AND flx1.application_id(+) = 101 AND flx1.language (+) = USERENV('LANG') AND srb.accounting_coa_id = flx2.id_flex_num(+) AND flx2.id_flex_code(+) = 'GL#' AND flx2.application_id(+) = 101 AND flx2.language (+) = USERENV('LANG') AND srb.flexfield_assign_mode_code = 'A' UNION SELECT srb.rowid row_id ,srb.application_id application_id ,srb.amb_context_code amb_context_code ,apl.application_name application_name ,srb.segment_rule_type_code segment_rule_type_code ,lkp.meaning segment_rule_type_dsp ,srb.segment_rule_code segment_rule_code ,srl.name name ,srl.description description ,srb.transaction_coa_id transaction_coa_id ,flx1.id_flex_structure_name transaction_coa_name ,srb.accounting_coa_id accounting_coa_id ,flx2.id_flex_structure_name accounting_coa_name ,srb.flexfield_segment_code flexfield_segment_code ,sat.segment_name flexfield_segment_name ,srb.flexfield_assign_mode_code flexfield_assign_mode_code ,srb.enabled_flag enabled_flag ,srb.flex_value_set_id flex_value_set_id ,null flex_value_set_name ,srb.creation_date creation_date ,srb.created_by created_by ,srb.last_update_date last_update_date ,srb.last_updated_by last_updated_by ,srb.last_update_login last_update_login FROM xla_seg_rules_b srb ,xla_seg_rules_tl srl ,fnd_application_tl apl ,fnd_id_flex_structures_tl flx1 ,fnd_id_flex_structures_tl flx2 ,xla_lookups lkp ,fnd_id_flex_segments_vl sat WHERE srb.application_id = srl.application_id AND srb.amb_context_code = srl.amb_context_code AND srb.segment_rule_type_code = srl.segment_rule_type_code AND srb.segment_rule_code = srl.segment_rule_code AND srl.language = USERENV('LANG') AND srb.application_id = apl.application_id AND apl.language = USERENV('LANG') AND srb.segment_rule_type_code = lkp.lookup_code AND lkp.lookup_type = 'XLA_OWNER_TYPE' AND srb.transaction_coa_id = flx1.id_flex_num(+) AND flx1.id_flex_code(+) = 'GL#' AND flx1.application_id(+) = 101 AND flx1.language (+) = USERENV('LANG') AND srb.accounting_coa_id = flx2.id_flex_num(+) AND flx2.id_flex_code(+) = 'GL#' AND flx2.application_id(+) = 101 AND flx2.language (+) = USERENV('LANG') AND srb.flexfield_segment_code = sat.application_column_name AND sat.application_id = 101 AND sat.id_flex_code = 'GL#' AND sat.id_flex_num = srb.accounting_coa_id AND srb.flexfield_assign_mode_code = 'S' AND srb.accounting_coa_id IS NOT NULL UNION SELECT srb.rowid row_id ,srb.application_id application_id ,srb.amb_context_code amb_context_code ,apl.application_name application_name ,srb.segment_rule_type_code segment_rule_type_code ,lkp.meaning segment_rule_type_dsp ,srb.segment_rule_code segment_rule_code ,srl.name name ,srl.description description ,srb.transaction_coa_id transaction_coa_id ,flx1.id_flex_structure_name transaction_coa_name ,srb.accounting_coa_id accounting_coa_id ,null accounting_coa_name ,srb.flexfield_segment_code flexfield_segment_code ,sat.segment_prompt flexfield_segment_name ,srb.flexfield_assign_mode_code flexfield_assign_mode_code ,srb.enabled_flag enabled_flag ,srb.flex_value_set_id flex_value_set_id ,null flex_value_set_name ,srb.creation_date creation_date ,srb.created_by created_by ,srb.last_update_date last_update_date ,srb.last_updated_by last_updated_by ,srb.last_update_login last_update_login FROM xla_seg_rules_b srb ,xla_seg_rules_tl srl ,fnd_application_tl apl ,fnd_id_flex_structures_tl flx1 ,xla_lookups lkp ,fnd_segment_attribute_types sat WHERE srb.application_id = srl.application_id AND srb.amb_context_code = srl.amb_context_code AND srb.segment_rule_type_code = srl.segment_rule_type_code AND srb.segment_rule_code = srl.segment_rule_code AND srl.language = USERENV('LANG') AND srb.application_id = apl.application_id AND apl.language = USERENV('LANG') AND srb.segment_rule_type_code = lkp.lookup_code AND lkp.lookup_type = 'XLA_OWNER_TYPE' AND srb.transaction_coa_id = flx1.id_flex_num(+) AND flx1.id_flex_code(+) = 'GL#' AND flx1.application_id(+) = 101 AND flx1.language (+) = USERENV('LANG') AND srb.flexfield_segment_code = sat.segment_attribute_type AND sat.application_id = 101 AND sat.id_flex_code = 'GL#' AND srb.flexfield_assign_mode_code = 'S' AND srb.accounting_coa_id IS NULL UNION SELECT srb.rowid row_id ,srb.application_id application_id ,srb.amb_context_code amb_context_code ,apl.application_name application_name ,srb.segment_rule_type_code segment_rule_type_code ,lkp.meaning segment_rule_type_dsp ,srb.segment_rule_code segment_rule_code ,srl.name name ,srl.description description ,srb.transaction_coa_id transaction_coa_id ,flx1.id_flex_structure_name transaction_coa_name ,srb.accounting_coa_id accounting_coa_id ,null accounting_coa_name ,srb.flexfield_segment_code flexfield_segment_code ,null flexfield_segment_name ,srb.flexfield_assign_mode_code flexfield_assign_mode_code ,srb.enabled_flag enabled_flag ,srb.flex_value_set_id flex_value_set_id ,flx.flex_value_set_name flex_value_set_name ,srb.creation_date creation_date ,srb.created_by created_by ,srb.last_update_date last_update_date ,srb.last_updated_by last_updated_by ,srb.last_update_login last_update_login FROM xla_seg_rules_b srb ,xla_seg_rules_tl srl ,fnd_application_tl apl ,fnd_id_flex_structures_tl flx1 ,xla_lookups lkp ,fnd_flex_value_sets flx WHERE srb.application_id = srl.application_id AND srb.amb_context_code = srl.amb_context_code AND srb.segment_rule_type_code = srl.segment_rule_type_code AND srb.segment_rule_code = srl.segment_rule_code AND srl.language = USERENV('LANG') AND srb.application_id = apl.application_id AND apl.language = USERENV('LANG') AND srb.segment_rule_type_code = lkp.lookup_code AND lkp.lookup_type = 'XLA_OWNER_TYPE' AND srb.transaction_coa_id = flx1.id_flex_num(+) AND flx1.id_flex_code(+) = 'GL#' AND flx1.application_id(+) = 101 AND flx1.language (+) = USERENV('LANG') AND srb.flexfield_assign_mode_code = 'V' AND srb.flex_value_set_id = flx.flex_value_set_id

View Text - HTML Formatted

SELECT SRB.ROWID ROW_ID
, SRB.APPLICATION_ID APPLICATION_ID
, SRB.AMB_CONTEXT_CODE AMB_CONTEXT_CODE
, APL.APPLICATION_NAME APPLICATION_NAME
, SRB.SEGMENT_RULE_TYPE_CODE SEGMENT_RULE_TYPE_CODE
, LKP.MEANING SEGMENT_RULE_TYPE_DSP
, SRB.SEGMENT_RULE_CODE SEGMENT_RULE_CODE
, SRL.NAME NAME
, SRL.DESCRIPTION DESCRIPTION
, SRB.TRANSACTION_COA_ID TRANSACTION_COA_ID
, FLX1.ID_FLEX_STRUCTURE_NAME TRANSACTION_COA_NAME
, SRB.ACCOUNTING_COA_ID ACCOUNTING_COA_ID
, FLX2.ID_FLEX_STRUCTURE_NAME ACCOUNTING_COA_NAME
, SRB.FLEXFIELD_SEGMENT_CODE FLEXFIELD_SEGMENT_CODE
, NULL FLEXFIELD_SEGMENT_NAME
, SRB.FLEXFIELD_ASSIGN_MODE_CODE FLEXFIELD_ASSIGN_MODE_CODE
, SRB.ENABLED_FLAG ENABLED_FLAG
, SRB.FLEX_VALUE_SET_ID FLEX_VALUE_SET_ID
, NULL FLEX_VALUE_SET_NAME
, SRB.CREATION_DATE CREATION_DATE
, SRB.CREATED_BY CREATED_BY
, SRB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SRB.LAST_UPDATED_BY LAST_UPDATED_BY
, SRB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM XLA_SEG_RULES_B SRB
, XLA_SEG_RULES_TL SRL
, FND_APPLICATION_TL APL
, FND_ID_FLEX_STRUCTURES_TL FLX1
, FND_ID_FLEX_STRUCTURES_TL FLX2
, XLA_LOOKUPS LKP
WHERE SRB.APPLICATION_ID = SRL.APPLICATION_ID
AND SRB.AMB_CONTEXT_CODE = SRL.AMB_CONTEXT_CODE
AND SRB.SEGMENT_RULE_TYPE_CODE = SRL.SEGMENT_RULE_TYPE_CODE
AND SRB.SEGMENT_RULE_CODE = SRL.SEGMENT_RULE_CODE
AND SRL.LANGUAGE = USERENV('LANG')
AND SRB.APPLICATION_ID = APL.APPLICATION_ID
AND APL.LANGUAGE = USERENV('LANG')
AND SRB.SEGMENT_RULE_TYPE_CODE = LKP.LOOKUP_CODE
AND LKP.LOOKUP_TYPE = 'XLA_OWNER_TYPE'
AND SRB.TRANSACTION_COA_ID = FLX1.ID_FLEX_NUM(+)
AND FLX1.ID_FLEX_CODE(+) = 'GL#'
AND FLX1.APPLICATION_ID(+) = 101
AND FLX1.LANGUAGE (+) = USERENV('LANG')
AND SRB.ACCOUNTING_COA_ID = FLX2.ID_FLEX_NUM(+)
AND FLX2.ID_FLEX_CODE(+) = 'GL#'
AND FLX2.APPLICATION_ID(+) = 101
AND FLX2.LANGUAGE (+) = USERENV('LANG')
AND SRB.FLEXFIELD_ASSIGN_MODE_CODE = 'A' UNION SELECT SRB.ROWID ROW_ID
, SRB.APPLICATION_ID APPLICATION_ID
, SRB.AMB_CONTEXT_CODE AMB_CONTEXT_CODE
, APL.APPLICATION_NAME APPLICATION_NAME
, SRB.SEGMENT_RULE_TYPE_CODE SEGMENT_RULE_TYPE_CODE
, LKP.MEANING SEGMENT_RULE_TYPE_DSP
, SRB.SEGMENT_RULE_CODE SEGMENT_RULE_CODE
, SRL.NAME NAME
, SRL.DESCRIPTION DESCRIPTION
, SRB.TRANSACTION_COA_ID TRANSACTION_COA_ID
, FLX1.ID_FLEX_STRUCTURE_NAME TRANSACTION_COA_NAME
, SRB.ACCOUNTING_COA_ID ACCOUNTING_COA_ID
, FLX2.ID_FLEX_STRUCTURE_NAME ACCOUNTING_COA_NAME
, SRB.FLEXFIELD_SEGMENT_CODE FLEXFIELD_SEGMENT_CODE
, SAT.SEGMENT_NAME FLEXFIELD_SEGMENT_NAME
, SRB.FLEXFIELD_ASSIGN_MODE_CODE FLEXFIELD_ASSIGN_MODE_CODE
, SRB.ENABLED_FLAG ENABLED_FLAG
, SRB.FLEX_VALUE_SET_ID FLEX_VALUE_SET_ID
, NULL FLEX_VALUE_SET_NAME
, SRB.CREATION_DATE CREATION_DATE
, SRB.CREATED_BY CREATED_BY
, SRB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SRB.LAST_UPDATED_BY LAST_UPDATED_BY
, SRB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM XLA_SEG_RULES_B SRB
, XLA_SEG_RULES_TL SRL
, FND_APPLICATION_TL APL
, FND_ID_FLEX_STRUCTURES_TL FLX1
, FND_ID_FLEX_STRUCTURES_TL FLX2
, XLA_LOOKUPS LKP
, FND_ID_FLEX_SEGMENTS_VL SAT
WHERE SRB.APPLICATION_ID = SRL.APPLICATION_ID
AND SRB.AMB_CONTEXT_CODE = SRL.AMB_CONTEXT_CODE
AND SRB.SEGMENT_RULE_TYPE_CODE = SRL.SEGMENT_RULE_TYPE_CODE
AND SRB.SEGMENT_RULE_CODE = SRL.SEGMENT_RULE_CODE
AND SRL.LANGUAGE = USERENV('LANG')
AND SRB.APPLICATION_ID = APL.APPLICATION_ID
AND APL.LANGUAGE = USERENV('LANG')
AND SRB.SEGMENT_RULE_TYPE_CODE = LKP.LOOKUP_CODE
AND LKP.LOOKUP_TYPE = 'XLA_OWNER_TYPE'
AND SRB.TRANSACTION_COA_ID = FLX1.ID_FLEX_NUM(+)
AND FLX1.ID_FLEX_CODE(+) = 'GL#'
AND FLX1.APPLICATION_ID(+) = 101
AND FLX1.LANGUAGE (+) = USERENV('LANG')
AND SRB.ACCOUNTING_COA_ID = FLX2.ID_FLEX_NUM(+)
AND FLX2.ID_FLEX_CODE(+) = 'GL#'
AND FLX2.APPLICATION_ID(+) = 101
AND FLX2.LANGUAGE (+) = USERENV('LANG')
AND SRB.FLEXFIELD_SEGMENT_CODE = SAT.APPLICATION_COLUMN_NAME
AND SAT.APPLICATION_ID = 101
AND SAT.ID_FLEX_CODE = 'GL#'
AND SAT.ID_FLEX_NUM = SRB.ACCOUNTING_COA_ID
AND SRB.FLEXFIELD_ASSIGN_MODE_CODE = 'S'
AND SRB.ACCOUNTING_COA_ID IS NOT NULL UNION SELECT SRB.ROWID ROW_ID
, SRB.APPLICATION_ID APPLICATION_ID
, SRB.AMB_CONTEXT_CODE AMB_CONTEXT_CODE
, APL.APPLICATION_NAME APPLICATION_NAME
, SRB.SEGMENT_RULE_TYPE_CODE SEGMENT_RULE_TYPE_CODE
, LKP.MEANING SEGMENT_RULE_TYPE_DSP
, SRB.SEGMENT_RULE_CODE SEGMENT_RULE_CODE
, SRL.NAME NAME
, SRL.DESCRIPTION DESCRIPTION
, SRB.TRANSACTION_COA_ID TRANSACTION_COA_ID
, FLX1.ID_FLEX_STRUCTURE_NAME TRANSACTION_COA_NAME
, SRB.ACCOUNTING_COA_ID ACCOUNTING_COA_ID
, NULL ACCOUNTING_COA_NAME
, SRB.FLEXFIELD_SEGMENT_CODE FLEXFIELD_SEGMENT_CODE
, SAT.SEGMENT_PROMPT FLEXFIELD_SEGMENT_NAME
, SRB.FLEXFIELD_ASSIGN_MODE_CODE FLEXFIELD_ASSIGN_MODE_CODE
, SRB.ENABLED_FLAG ENABLED_FLAG
, SRB.FLEX_VALUE_SET_ID FLEX_VALUE_SET_ID
, NULL FLEX_VALUE_SET_NAME
, SRB.CREATION_DATE CREATION_DATE
, SRB.CREATED_BY CREATED_BY
, SRB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SRB.LAST_UPDATED_BY LAST_UPDATED_BY
, SRB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM XLA_SEG_RULES_B SRB
, XLA_SEG_RULES_TL SRL
, FND_APPLICATION_TL APL
, FND_ID_FLEX_STRUCTURES_TL FLX1
, XLA_LOOKUPS LKP
, FND_SEGMENT_ATTRIBUTE_TYPES SAT
WHERE SRB.APPLICATION_ID = SRL.APPLICATION_ID
AND SRB.AMB_CONTEXT_CODE = SRL.AMB_CONTEXT_CODE
AND SRB.SEGMENT_RULE_TYPE_CODE = SRL.SEGMENT_RULE_TYPE_CODE
AND SRB.SEGMENT_RULE_CODE = SRL.SEGMENT_RULE_CODE
AND SRL.LANGUAGE = USERENV('LANG')
AND SRB.APPLICATION_ID = APL.APPLICATION_ID
AND APL.LANGUAGE = USERENV('LANG')
AND SRB.SEGMENT_RULE_TYPE_CODE = LKP.LOOKUP_CODE
AND LKP.LOOKUP_TYPE = 'XLA_OWNER_TYPE'
AND SRB.TRANSACTION_COA_ID = FLX1.ID_FLEX_NUM(+)
AND FLX1.ID_FLEX_CODE(+) = 'GL#'
AND FLX1.APPLICATION_ID(+) = 101
AND FLX1.LANGUAGE (+) = USERENV('LANG')
AND SRB.FLEXFIELD_SEGMENT_CODE = SAT.SEGMENT_ATTRIBUTE_TYPE
AND SAT.APPLICATION_ID = 101
AND SAT.ID_FLEX_CODE = 'GL#'
AND SRB.FLEXFIELD_ASSIGN_MODE_CODE = 'S'
AND SRB.ACCOUNTING_COA_ID IS NULL UNION SELECT SRB.ROWID ROW_ID
, SRB.APPLICATION_ID APPLICATION_ID
, SRB.AMB_CONTEXT_CODE AMB_CONTEXT_CODE
, APL.APPLICATION_NAME APPLICATION_NAME
, SRB.SEGMENT_RULE_TYPE_CODE SEGMENT_RULE_TYPE_CODE
, LKP.MEANING SEGMENT_RULE_TYPE_DSP
, SRB.SEGMENT_RULE_CODE SEGMENT_RULE_CODE
, SRL.NAME NAME
, SRL.DESCRIPTION DESCRIPTION
, SRB.TRANSACTION_COA_ID TRANSACTION_COA_ID
, FLX1.ID_FLEX_STRUCTURE_NAME TRANSACTION_COA_NAME
, SRB.ACCOUNTING_COA_ID ACCOUNTING_COA_ID
, NULL ACCOUNTING_COA_NAME
, SRB.FLEXFIELD_SEGMENT_CODE FLEXFIELD_SEGMENT_CODE
, NULL FLEXFIELD_SEGMENT_NAME
, SRB.FLEXFIELD_ASSIGN_MODE_CODE FLEXFIELD_ASSIGN_MODE_CODE
, SRB.ENABLED_FLAG ENABLED_FLAG
, SRB.FLEX_VALUE_SET_ID FLEX_VALUE_SET_ID
, FLX.FLEX_VALUE_SET_NAME FLEX_VALUE_SET_NAME
, SRB.CREATION_DATE CREATION_DATE
, SRB.CREATED_BY CREATED_BY
, SRB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SRB.LAST_UPDATED_BY LAST_UPDATED_BY
, SRB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM XLA_SEG_RULES_B SRB
, XLA_SEG_RULES_TL SRL
, FND_APPLICATION_TL APL
, FND_ID_FLEX_STRUCTURES_TL FLX1
, XLA_LOOKUPS LKP
, FND_FLEX_VALUE_SETS FLX
WHERE SRB.APPLICATION_ID = SRL.APPLICATION_ID
AND SRB.AMB_CONTEXT_CODE = SRL.AMB_CONTEXT_CODE
AND SRB.SEGMENT_RULE_TYPE_CODE = SRL.SEGMENT_RULE_TYPE_CODE
AND SRB.SEGMENT_RULE_CODE = SRL.SEGMENT_RULE_CODE
AND SRL.LANGUAGE = USERENV('LANG')
AND SRB.APPLICATION_ID = APL.APPLICATION_ID
AND APL.LANGUAGE = USERENV('LANG')
AND SRB.SEGMENT_RULE_TYPE_CODE = LKP.LOOKUP_CODE
AND LKP.LOOKUP_TYPE = 'XLA_OWNER_TYPE'
AND SRB.TRANSACTION_COA_ID = FLX1.ID_FLEX_NUM(+)
AND FLX1.ID_FLEX_CODE(+) = 'GL#'
AND FLX1.APPLICATION_ID(+) = 101
AND FLX1.LANGUAGE (+) = USERENV('LANG')
AND SRB.FLEXFIELD_ASSIGN_MODE_CODE = 'V'
AND SRB.FLEX_VALUE_SET_ID = FLX.FLEX_VALUE_SET_ID