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_PAD_INQ_SEG_RULES_FVL

Source

View Text - Preformatted


SELECT xad.application_id application_id ,xad.amb_context_code amb_context_code ,xal.product_rule_type_code product_rule_type_code ,xal.product_rule_code product_rule_code ,xad.line_definition_owner_code line_definition_owner_code ,xad.line_definition_code line_definition_code ,xad.event_class_code event_class_code ,xad.event_type_code event_type_code ,xad.accounting_line_code accounting_line_code ,xad.accounting_line_type_code accounting_line_type_code ,xad.segment_rule_code segment_rule_code ,xst.name segment_rule_name ,xad.segment_rule_type_code segment_rule_type_code ,l5.meaning segment_rule_type_code_dsp ,xsb.accounting_coa_id accounting_coa_id ,ff.id_flex_structure_name accounting_coa_name ,xad.flexfield_segment_code flexfield_segment_code ,l6.meaning flexfield_segment_name FROM xla_line_defn_adr_assgns xad JOIN xla_aad_line_defn_assgns xal ON xad.application_id = xal.application_id AND xad.amb_context_code = xal.amb_context_code AND xad.event_class_code = xal.event_class_code AND xad.event_type_code = xal.event_type_code AND xad.line_definition_owner_code = xal.line_definition_owner_code AND xad.line_definition_code = xal.line_definition_code JOIN xla_seg_rules_b xsb ON xad.application_id = xsb.application_id AND xad.amb_context_code = xsb.amb_context_code AND xad.segment_rule_type_code = xsb.segment_rule_type_code AND xad.segment_rule_code = xsb.segment_rule_code JOIN xla_seg_rules_tl xst ON xsb.application_id = xst.application_id AND xsb.amb_context_code = xst.amb_context_code AND xsb.segment_rule_type_code = xst.segment_rule_type_code AND xsb.segment_rule_code = xst.segment_rule_code AND xst.language = USERENV('LANG') LEFT OUTER JOIN fnd_id_flex_structures_v ff ON xsb.accounting_coa_id = ff.id_flex_num AND ff.application_id = 101 AND ff.id_flex_code = 'GL#' JOIN xla_lookups l5 ON xad.segment_rule_type_code = l5.lookup_code AND l5.lookup_type = 'XLA_OWNER_TYPE' JOIN xla_lookups l6 ON xad.flexfield_segment_code = l6.lookup_code AND l6.lookup_type = 'XLA_FLEXFIELD_SEGMENTS_ALL' WHERE xad.flexfield_segment_code = 'ALL' UNION SELECT xad.application_id application_id ,xad.amb_context_code amb_context_code ,xal.product_rule_type_code product_rule_type_code ,xal.product_rule_code product_rule_code ,xad.line_definition_owner_code line_definition_owner_code ,xad.line_definition_code line_definition_code ,xad.event_class_code event_class_code ,xad.event_type_code event_type_code ,xad.accounting_line_code accounting_line_code ,xad.accounting_line_type_code accounting_line_type_code ,xad.segment_rule_code segment_rule_code ,xst.name segment_rule_name ,xad.segment_rule_type_code segment_rule_type_code ,l5.meaning segment_rule_type_code_dsp ,xsb.accounting_coa_id accounting_coa_id ,ff.id_flex_structure_name accounting_coa_name ,xad.flexfield_segment_code flexfield_segment_code ,fif.segment_name flexfield_segment_name FROM xla_line_defn_adr_assgns xad JOIN xla_aad_line_defn_assgns xal ON xad.application_id = xal.application_id AND xad.amb_context_code = xal.amb_context_code AND xad.event_class_code = xal.event_class_code AND xad.event_type_code = xal.event_type_code AND xad.line_definition_owner_code = xal.line_definition_owner_code AND xad.line_definition_code = xal.line_definition_code JOIN xla_seg_rules_b xsb ON xad.application_id = xsb.application_id AND xad.amb_context_code = xsb.amb_context_code AND xad.segment_rule_type_code = xsb.segment_rule_type_code AND xad.segment_rule_code = xsb.segment_rule_code JOIN xla_seg_rules_tl xst ON xsb.application_id = xst.application_id AND xsb.amb_context_code = xst.amb_context_code AND xsb.segment_rule_type_code = xst.segment_rule_type_code AND xsb.segment_rule_code = xst.segment_rule_code AND xst.language = USERENV('LANG') LEFT OUTER JOIN fnd_id_flex_structures_v ff ON xsb.accounting_coa_id = ff.id_flex_num AND ff.application_id = 101 AND ff.id_flex_code = 'GL#' JOIN fnd_id_flex_segments_vl fif ON xad.flexfield_segment_code = fif.application_column_name AND fif.application_id = 101 AND fif.id_flex_code = 'GL#' AND fif.id_flex_num = xsb.accounting_coa_id JOIN xla_lookups l5 ON xad.segment_rule_type_code = l5.lookup_code AND l5.lookup_type = 'XLA_OWNER_TYPE' WHERE xad.flexfield_segment_code <> 'ALL'

View Text - HTML Formatted

SELECT XAD.APPLICATION_ID APPLICATION_ID
, XAD.AMB_CONTEXT_CODE AMB_CONTEXT_CODE
, XAL.PRODUCT_RULE_TYPE_CODE PRODUCT_RULE_TYPE_CODE
, XAL.PRODUCT_RULE_CODE PRODUCT_RULE_CODE
, XAD.LINE_DEFINITION_OWNER_CODE LINE_DEFINITION_OWNER_CODE
, XAD.LINE_DEFINITION_CODE LINE_DEFINITION_CODE
, XAD.EVENT_CLASS_CODE EVENT_CLASS_CODE
, XAD.EVENT_TYPE_CODE EVENT_TYPE_CODE
, XAD.ACCOUNTING_LINE_CODE ACCOUNTING_LINE_CODE
, XAD.ACCOUNTING_LINE_TYPE_CODE ACCOUNTING_LINE_TYPE_CODE
, XAD.SEGMENT_RULE_CODE SEGMENT_RULE_CODE
, XST.NAME SEGMENT_RULE_NAME
, XAD.SEGMENT_RULE_TYPE_CODE SEGMENT_RULE_TYPE_CODE
, L5.MEANING SEGMENT_RULE_TYPE_CODE_DSP
, XSB.ACCOUNTING_COA_ID ACCOUNTING_COA_ID
, FF.ID_FLEX_STRUCTURE_NAME ACCOUNTING_COA_NAME
, XAD.FLEXFIELD_SEGMENT_CODE FLEXFIELD_SEGMENT_CODE
, L6.MEANING FLEXFIELD_SEGMENT_NAME
FROM XLA_LINE_DEFN_ADR_ASSGNS XAD JOIN XLA_AAD_LINE_DEFN_ASSGNS XAL ON XAD.APPLICATION_ID = XAL.APPLICATION_ID
AND XAD.AMB_CONTEXT_CODE = XAL.AMB_CONTEXT_CODE
AND XAD.EVENT_CLASS_CODE = XAL.EVENT_CLASS_CODE
AND XAD.EVENT_TYPE_CODE = XAL.EVENT_TYPE_CODE
AND XAD.LINE_DEFINITION_OWNER_CODE = XAL.LINE_DEFINITION_OWNER_CODE
AND XAD.LINE_DEFINITION_CODE = XAL.LINE_DEFINITION_CODE JOIN XLA_SEG_RULES_B XSB ON XAD.APPLICATION_ID = XSB.APPLICATION_ID
AND XAD.AMB_CONTEXT_CODE = XSB.AMB_CONTEXT_CODE
AND XAD.SEGMENT_RULE_TYPE_CODE = XSB.SEGMENT_RULE_TYPE_CODE
AND XAD.SEGMENT_RULE_CODE = XSB.SEGMENT_RULE_CODE JOIN XLA_SEG_RULES_TL XST ON XSB.APPLICATION_ID = XST.APPLICATION_ID
AND XSB.AMB_CONTEXT_CODE = XST.AMB_CONTEXT_CODE
AND XSB.SEGMENT_RULE_TYPE_CODE = XST.SEGMENT_RULE_TYPE_CODE
AND XSB.SEGMENT_RULE_CODE = XST.SEGMENT_RULE_CODE
AND XST.LANGUAGE = USERENV('LANG') LEFT OUTER JOIN FND_ID_FLEX_STRUCTURES_V FF ON XSB.ACCOUNTING_COA_ID = FF.ID_FLEX_NUM
AND FF.APPLICATION_ID = 101
AND FF.ID_FLEX_CODE = 'GL#' JOIN XLA_LOOKUPS L5 ON XAD.SEGMENT_RULE_TYPE_CODE = L5.LOOKUP_CODE
AND L5.LOOKUP_TYPE = 'XLA_OWNER_TYPE' JOIN XLA_LOOKUPS L6 ON XAD.FLEXFIELD_SEGMENT_CODE = L6.LOOKUP_CODE
AND L6.LOOKUP_TYPE = 'XLA_FLEXFIELD_SEGMENTS_ALL'
WHERE XAD.FLEXFIELD_SEGMENT_CODE = 'ALL' UNION SELECT XAD.APPLICATION_ID APPLICATION_ID
, XAD.AMB_CONTEXT_CODE AMB_CONTEXT_CODE
, XAL.PRODUCT_RULE_TYPE_CODE PRODUCT_RULE_TYPE_CODE
, XAL.PRODUCT_RULE_CODE PRODUCT_RULE_CODE
, XAD.LINE_DEFINITION_OWNER_CODE LINE_DEFINITION_OWNER_CODE
, XAD.LINE_DEFINITION_CODE LINE_DEFINITION_CODE
, XAD.EVENT_CLASS_CODE EVENT_CLASS_CODE
, XAD.EVENT_TYPE_CODE EVENT_TYPE_CODE
, XAD.ACCOUNTING_LINE_CODE ACCOUNTING_LINE_CODE
, XAD.ACCOUNTING_LINE_TYPE_CODE ACCOUNTING_LINE_TYPE_CODE
, XAD.SEGMENT_RULE_CODE SEGMENT_RULE_CODE
, XST.NAME SEGMENT_RULE_NAME
, XAD.SEGMENT_RULE_TYPE_CODE SEGMENT_RULE_TYPE_CODE
, L5.MEANING SEGMENT_RULE_TYPE_CODE_DSP
, XSB.ACCOUNTING_COA_ID ACCOUNTING_COA_ID
, FF.ID_FLEX_STRUCTURE_NAME ACCOUNTING_COA_NAME
, XAD.FLEXFIELD_SEGMENT_CODE FLEXFIELD_SEGMENT_CODE
, FIF.SEGMENT_NAME FLEXFIELD_SEGMENT_NAME
FROM XLA_LINE_DEFN_ADR_ASSGNS XAD JOIN XLA_AAD_LINE_DEFN_ASSGNS XAL ON XAD.APPLICATION_ID = XAL.APPLICATION_ID
AND XAD.AMB_CONTEXT_CODE = XAL.AMB_CONTEXT_CODE
AND XAD.EVENT_CLASS_CODE = XAL.EVENT_CLASS_CODE
AND XAD.EVENT_TYPE_CODE = XAL.EVENT_TYPE_CODE
AND XAD.LINE_DEFINITION_OWNER_CODE = XAL.LINE_DEFINITION_OWNER_CODE
AND XAD.LINE_DEFINITION_CODE = XAL.LINE_DEFINITION_CODE JOIN XLA_SEG_RULES_B XSB ON XAD.APPLICATION_ID = XSB.APPLICATION_ID
AND XAD.AMB_CONTEXT_CODE = XSB.AMB_CONTEXT_CODE
AND XAD.SEGMENT_RULE_TYPE_CODE = XSB.SEGMENT_RULE_TYPE_CODE
AND XAD.SEGMENT_RULE_CODE = XSB.SEGMENT_RULE_CODE JOIN XLA_SEG_RULES_TL XST ON XSB.APPLICATION_ID = XST.APPLICATION_ID
AND XSB.AMB_CONTEXT_CODE = XST.AMB_CONTEXT_CODE
AND XSB.SEGMENT_RULE_TYPE_CODE = XST.SEGMENT_RULE_TYPE_CODE
AND XSB.SEGMENT_RULE_CODE = XST.SEGMENT_RULE_CODE
AND XST.LANGUAGE = USERENV('LANG') LEFT OUTER JOIN FND_ID_FLEX_STRUCTURES_V FF ON XSB.ACCOUNTING_COA_ID = FF.ID_FLEX_NUM
AND FF.APPLICATION_ID = 101
AND FF.ID_FLEX_CODE = 'GL#' JOIN FND_ID_FLEX_SEGMENTS_VL FIF ON XAD.FLEXFIELD_SEGMENT_CODE = FIF.APPLICATION_COLUMN_NAME
AND FIF.APPLICATION_ID = 101
AND FIF.ID_FLEX_CODE = 'GL#'
AND FIF.ID_FLEX_NUM = XSB.ACCOUNTING_COA_ID JOIN XLA_LOOKUPS L5 ON XAD.SEGMENT_RULE_TYPE_CODE = L5.LOOKUP_CODE
AND L5.LOOKUP_TYPE = 'XLA_OWNER_TYPE'
WHERE XAD.FLEXFIELD_SEGMENT_CODE <> 'ALL'