VIEW: APPS.XLA_PROD_SEG_RULES_FVL

Source

View Text - Preformatted

SELECT a.rowid row_id ,a.application_id application_id ,a.amb_context_code amb_context_code ,a.product_rule_type_code product_rule_type_code ,a.product_rule_code product_rule_code ,a.entity_code entity_code ,a.event_class_code event_class_code ,a.event_type_code event_type_code ,a.accounting_line_type_code accounting_line_type_code ,a.accounting_line_code accounting_line_code ,a.flexfield_segment_code flexfield_segment_code ,f.segment_name flexfield_segment_name ,f.segment_num flexfield_segment_num ,a.segment_rule_type_code segment_rule_type_code ,a.segment_rule_code segment_rule_code ,s.name segment_rule_name ,l.meaning segment_rule_type_code_dsp ,a.creation_date creation_date ,a.created_by created_by ,a.last_update_date last_update_date ,a.last_updated_by last_updated_by ,a.last_update_login last_update_login FROM xla_prod_seg_rules a ,xla_seg_rules_tl s ,fnd_id_flex_segments_vl f ,xla_product_rules_b lt ,xla_lookups l WHERE a.application_id = s.application_id AND a.amb_context_code = s.amb_context_code AND a.segment_rule_type_code = s.segment_rule_type_code AND a.segment_rule_code = s.segment_rule_code AND s.language = USERENV('LANG') AND s.segment_rule_type_code = l.lookup_code AND l.lookup_type = 'XLA_OWNER_TYPE' AND a.flexfield_segment_code = f.application_column_name AND f.application_id = 101 AND f.id_flex_code = 'GL#' AND f.id_flex_num = lt.accounting_coa_id AND a.application_id = lt.application_id AND a.amb_context_code = lt.amb_context_code AND a.product_rule_type_code = lt.product_rule_type_code AND a.product_rule_code = lt.product_rule_code AND a.flexfield_segment_code <> 'ALL' UNION SELECT a.rowid row_id ,a.application_id application_id ,a.amb_context_code amb_context_code ,a.product_rule_type_code product_rule_type_code ,a.product_rule_code product_rule_code ,a.entity_code entity_code ,a.event_class_code event_class_code ,a.event_type_code event_type_code ,a.accounting_line_type_code accounting_line_type_code ,a.accounting_line_code accounting_line_code ,a.flexfield_segment_code flexfield_segment_code ,l2.meaning flexfield_segment_name ,-1 flexfield_segment_num ,a.segment_rule_type_code segment_rule_type_code ,a.segment_rule_code segment_rule_code ,s.name segment_rule_name ,l.meaning segment_rule_type_code_dsp ,a.creation_date creation_date ,a.created_by created_by ,a.last_update_date last_update_date ,a.last_updated_by last_updated_by ,a.last_update_login last_update_login FROM xla_prod_seg_rules a ,xla_seg_rules_tl s ,xla_lookups l2 ,xla_lookups l WHERE a.application_id = s.application_id AND a.amb_context_code = s.amb_context_code AND a.segment_rule_type_code = s.segment_rule_type_code AND a.segment_rule_code = s.segment_rule_code AND s.language = USERENV('LANG') AND s.segment_rule_type_code = l.lookup_code AND l.lookup_type = 'XLA_OWNER_TYPE' AND a.flexfield_segment_code = l2.lookup_code AND l2.lookup_type = 'XLA_FLEXFIELD_SEGMENTS_ALL' AND a.flexfield_segment_code = 'ALL'

View Text - HTML Formatted

SELECT A.ROWID ROW_ID
, A.APPLICATION_ID APPLICATION_ID
, A.AMB_CONTEXT_CODE AMB_CONTEXT_CODE
, A.PRODUCT_RULE_TYPE_CODE PRODUCT_RULE_TYPE_CODE
, A.PRODUCT_RULE_CODE PRODUCT_RULE_CODE
, A.ENTITY_CODE ENTITY_CODE
, A.EVENT_CLASS_CODE EVENT_CLASS_CODE
, A.EVENT_TYPE_CODE EVENT_TYPE_CODE
, A.ACCOUNTING_LINE_TYPE_CODE ACCOUNTING_LINE_TYPE_CODE
, A.ACCOUNTING_LINE_CODE ACCOUNTING_LINE_CODE
, A.FLEXFIELD_SEGMENT_CODE FLEXFIELD_SEGMENT_CODE
, F.SEGMENT_NAME FLEXFIELD_SEGMENT_NAME
, F.SEGMENT_NUM FLEXFIELD_SEGMENT_NUM
, A.SEGMENT_RULE_TYPE_CODE SEGMENT_RULE_TYPE_CODE
, A.SEGMENT_RULE_CODE SEGMENT_RULE_CODE
, S.NAME SEGMENT_RULE_NAME
, L.MEANING SEGMENT_RULE_TYPE_CODE_DSP
, A.CREATION_DATE CREATION_DATE
, A.CREATED_BY CREATED_BY
, A.LAST_UPDATE_DATE LAST_UPDATE_DATE
, A.LAST_UPDATED_BY LAST_UPDATED_BY
, A.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM XLA_PROD_SEG_RULES A
, XLA_SEG_RULES_TL S
, FND_ID_FLEX_SEGMENTS_VL F
, XLA_PRODUCT_RULES_B LT
, XLA_LOOKUPS L
WHERE A.APPLICATION_ID = S.APPLICATION_ID
AND A.AMB_CONTEXT_CODE = S.AMB_CONTEXT_CODE
AND A.SEGMENT_RULE_TYPE_CODE = S.SEGMENT_RULE_TYPE_CODE
AND A.SEGMENT_RULE_CODE = S.SEGMENT_RULE_CODE
AND S.LANGUAGE = USERENV('LANG')
AND S.SEGMENT_RULE_TYPE_CODE = L.LOOKUP_CODE
AND L.LOOKUP_TYPE = 'XLA_OWNER_TYPE'
AND A.FLEXFIELD_SEGMENT_CODE = F.APPLICATION_COLUMN_NAME
AND F.APPLICATION_ID = 101
AND F.ID_FLEX_CODE = 'GL#'
AND F.ID_FLEX_NUM = LT.ACCOUNTING_COA_ID
AND A.APPLICATION_ID = LT.APPLICATION_ID
AND A.AMB_CONTEXT_CODE = LT.AMB_CONTEXT_CODE
AND A.PRODUCT_RULE_TYPE_CODE = LT.PRODUCT_RULE_TYPE_CODE
AND A.PRODUCT_RULE_CODE = LT.PRODUCT_RULE_CODE
AND A.FLEXFIELD_SEGMENT_CODE <> 'ALL' UNION SELECT A.ROWID ROW_ID
, A.APPLICATION_ID APPLICATION_ID
, A.AMB_CONTEXT_CODE AMB_CONTEXT_CODE
, A.PRODUCT_RULE_TYPE_CODE PRODUCT_RULE_TYPE_CODE
, A.PRODUCT_RULE_CODE PRODUCT_RULE_CODE
, A.ENTITY_CODE ENTITY_CODE
, A.EVENT_CLASS_CODE EVENT_CLASS_CODE
, A.EVENT_TYPE_CODE EVENT_TYPE_CODE
, A.ACCOUNTING_LINE_TYPE_CODE ACCOUNTING_LINE_TYPE_CODE
, A.ACCOUNTING_LINE_CODE ACCOUNTING_LINE_CODE
, A.FLEXFIELD_SEGMENT_CODE FLEXFIELD_SEGMENT_CODE
, L2.MEANING FLEXFIELD_SEGMENT_NAME
, -1 FLEXFIELD_SEGMENT_NUM
, A.SEGMENT_RULE_TYPE_CODE SEGMENT_RULE_TYPE_CODE
, A.SEGMENT_RULE_CODE SEGMENT_RULE_CODE
, S.NAME SEGMENT_RULE_NAME
, L.MEANING SEGMENT_RULE_TYPE_CODE_DSP
, A.CREATION_DATE CREATION_DATE
, A.CREATED_BY CREATED_BY
, A.LAST_UPDATE_DATE LAST_UPDATE_DATE
, A.LAST_UPDATED_BY LAST_UPDATED_BY
, A.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM XLA_PROD_SEG_RULES A
, XLA_SEG_RULES_TL S
, XLA_LOOKUPS L2
, XLA_LOOKUPS L
WHERE A.APPLICATION_ID = S.APPLICATION_ID
AND A.AMB_CONTEXT_CODE = S.AMB_CONTEXT_CODE
AND A.SEGMENT_RULE_TYPE_CODE = S.SEGMENT_RULE_TYPE_CODE
AND A.SEGMENT_RULE_CODE = S.SEGMENT_RULE_CODE
AND S.LANGUAGE = USERENV('LANG')
AND S.SEGMENT_RULE_TYPE_CODE = L.LOOKUP_CODE
AND L.LOOKUP_TYPE = 'XLA_OWNER_TYPE'
AND A.FLEXFIELD_SEGMENT_CODE = L2.LOOKUP_CODE
AND L2.LOOKUP_TYPE = 'XLA_FLEXFIELD_SEGMENTS_ALL'
AND A.FLEXFIELD_SEGMENT_CODE = 'ALL'