VIEW: APPS.XLA_ACCT_LINE_TYPES_FVL

Source

View Text - Preformatted

SELECT b.rowid row_id ,b.application_id application_id ,b.amb_context_code amb_context_code ,x.application_name application_name ,b.entity_code entity_code ,b.event_class_code event_class_code ,e.name event_class_name ,b.accounting_line_type_code accounting_line_type_code ,l.meaning accounting_line_type_dsp ,b.accounting_line_code accounting_line_code ,t.name name ,t.description description ,b.transaction_coa_id transaction_coa_id ,f1.id_flex_structure_name transaction_coa_name ,b.accounting_entry_type_code accounting_entry_type_code ,b.natural_side_code natural_side_code ,b.gl_transfer_mode_code gl_transfer_mode_code ,b.switch_side_flag switch_side_flag ,b.gain_or_loss_flag gain_or_loss_flag ,b.merge_duplicate_code merge_duplicate_code ,l2.meaning merge_duplicate_dsp ,b.enabled_flag enabled_flag ,b.accounting_class_code accounting_class_code ,NVL(l1.meaning,b.accounting_class_code) accounting_class_dsp ,b.rounding_class_code rounding_class_code ,l3.meaning rounding_class_dsp ,b.business_method_code business_method_code ,b.business_class_code business_class_code ,l4.meaning business_class_name ,b.creation_date creation_date ,b.created_by created_by ,b.last_update_date last_update_date ,b.last_updated_by last_updated_by ,b.last_update_login last_update_login ,b.mpa_option_code mpa_option_code ,b.encumbrance_type_id encumbrance_type_id ,get.encumbrance_type encumbrance_type FROM xla_acct_line_types_b b ,xla_acct_line_types_tl t ,xla_event_classes_tl e ,xla_applications_xvl x ,fnd_id_flex_structures_v f1 ,xla_lookups l ,xla_lookups l1 ,xla_lookups l2 ,xla_lookups l3 ,xla_lookups l4 ,gl_encumbrance_types get WHERE b.application_id = t.application_id AND b.amb_context_code = t.amb_context_code AND b.entity_code = t.entity_code AND b.event_class_code = t.event_class_code AND b.accounting_line_type_code = t.accounting_line_type_code AND b.accounting_line_code = t.accounting_line_code AND t.LANGUAGE = USERENV('LANG') AND b.application_id = x.application_id AND b.application_id = e.application_id AND b.entity_code = e.entity_code AND b.event_class_code = e.event_class_code AND e.LANGUAGE = USERENV('LANG') AND b.accounting_line_type_code = l.lookup_code AND l.lookup_type = 'XLA_OWNER_TYPE' AND b.accounting_class_code = l1.lookup_code(+) AND l1.lookup_type(+) = 'XLA_ACCOUNTING_CLASS' AND b.merge_duplicate_code = l2.lookup_code AND l2.lookup_type = 'XLA_MERGE_MATCHING_TYPE' AND b.rounding_class_code = l3.lookup_code AND l3.lookup_type = 'XLA_ACCOUNTING_CLASS' AND b.transaction_coa_id = f1.id_flex_num(+) AND f1.id_flex_code(+) = 'GL#' AND f1.application_id(+) = 101 AND b.business_class_code = l4.lookup_code (+) AND l4.lookup_type (+) = 'XLA_BUSINESS_FLOW_CLASS' AND get.encumbrance_type_id(+) = b.encumbrance_type_id

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.APPLICATION_ID APPLICATION_ID
, B.AMB_CONTEXT_CODE AMB_CONTEXT_CODE
, X.APPLICATION_NAME APPLICATION_NAME
, B.ENTITY_CODE ENTITY_CODE
, B.EVENT_CLASS_CODE EVENT_CLASS_CODE
, E.NAME EVENT_CLASS_NAME
, B.ACCOUNTING_LINE_TYPE_CODE ACCOUNTING_LINE_TYPE_CODE
, L.MEANING ACCOUNTING_LINE_TYPE_DSP
, B.ACCOUNTING_LINE_CODE ACCOUNTING_LINE_CODE
, T.NAME NAME
, T.DESCRIPTION DESCRIPTION
, B.TRANSACTION_COA_ID TRANSACTION_COA_ID
, F1.ID_FLEX_STRUCTURE_NAME TRANSACTION_COA_NAME
, B.ACCOUNTING_ENTRY_TYPE_CODE ACCOUNTING_ENTRY_TYPE_CODE
, B.NATURAL_SIDE_CODE NATURAL_SIDE_CODE
, B.GL_TRANSFER_MODE_CODE GL_TRANSFER_MODE_CODE
, B.SWITCH_SIDE_FLAG SWITCH_SIDE_FLAG
, B.GAIN_OR_LOSS_FLAG GAIN_OR_LOSS_FLAG
, B.MERGE_DUPLICATE_CODE MERGE_DUPLICATE_CODE
, L2.MEANING MERGE_DUPLICATE_DSP
, B.ENABLED_FLAG ENABLED_FLAG
, B.ACCOUNTING_CLASS_CODE ACCOUNTING_CLASS_CODE
, NVL(L1.MEANING
, B.ACCOUNTING_CLASS_CODE) ACCOUNTING_CLASS_DSP
, B.ROUNDING_CLASS_CODE ROUNDING_CLASS_CODE
, L3.MEANING ROUNDING_CLASS_DSP
, B.BUSINESS_METHOD_CODE BUSINESS_METHOD_CODE
, B.BUSINESS_CLASS_CODE BUSINESS_CLASS_CODE
, L4.MEANING BUSINESS_CLASS_NAME
, B.CREATION_DATE CREATION_DATE
, B.CREATED_BY CREATED_BY
, B.LAST_UPDATE_DATE LAST_UPDATE_DATE
, B.LAST_UPDATED_BY LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, B.MPA_OPTION_CODE MPA_OPTION_CODE
, B.ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID
, GET.ENCUMBRANCE_TYPE ENCUMBRANCE_TYPE
FROM XLA_ACCT_LINE_TYPES_B B
, XLA_ACCT_LINE_TYPES_TL T
, XLA_EVENT_CLASSES_TL E
, XLA_APPLICATIONS_XVL X
, FND_ID_FLEX_STRUCTURES_V F1
, XLA_LOOKUPS L
, XLA_LOOKUPS L1
, XLA_LOOKUPS L2
, XLA_LOOKUPS L3
, XLA_LOOKUPS L4
, GL_ENCUMBRANCE_TYPES GET
WHERE B.APPLICATION_ID = T.APPLICATION_ID
AND B.AMB_CONTEXT_CODE = T.AMB_CONTEXT_CODE
AND B.ENTITY_CODE = T.ENTITY_CODE
AND B.EVENT_CLASS_CODE = T.EVENT_CLASS_CODE
AND B.ACCOUNTING_LINE_TYPE_CODE = T.ACCOUNTING_LINE_TYPE_CODE
AND B.ACCOUNTING_LINE_CODE = T.ACCOUNTING_LINE_CODE
AND T.LANGUAGE = USERENV('LANG')
AND B.APPLICATION_ID = X.APPLICATION_ID
AND B.APPLICATION_ID = E.APPLICATION_ID
AND B.ENTITY_CODE = E.ENTITY_CODE
AND B.EVENT_CLASS_CODE = E.EVENT_CLASS_CODE
AND E.LANGUAGE = USERENV('LANG')
AND B.ACCOUNTING_LINE_TYPE_CODE = L.LOOKUP_CODE
AND L.LOOKUP_TYPE = 'XLA_OWNER_TYPE'
AND B.ACCOUNTING_CLASS_CODE = L1.LOOKUP_CODE(+)
AND L1.LOOKUP_TYPE(+) = 'XLA_ACCOUNTING_CLASS'
AND B.MERGE_DUPLICATE_CODE = L2.LOOKUP_CODE
AND L2.LOOKUP_TYPE = 'XLA_MERGE_MATCHING_TYPE'
AND B.ROUNDING_CLASS_CODE = L3.LOOKUP_CODE
AND L3.LOOKUP_TYPE = 'XLA_ACCOUNTING_CLASS'
AND B.TRANSACTION_COA_ID = F1.ID_FLEX_NUM(+)
AND F1.ID_FLEX_CODE(+) = 'GL#'
AND F1.APPLICATION_ID(+) = 101
AND B.BUSINESS_CLASS_CODE = L4.LOOKUP_CODE (+)
AND L4.LOOKUP_TYPE (+) = 'XLA_BUSINESS_FLOW_CLASS'
AND GET.ENCUMBRANCE_TYPE_ID(+) = B.ENCUMBRANCE_TYPE_ID