View: XLA_ACCT_LINE_TYPES_FVL

Product:	XLA - Subledger Accounting
Description:
Implementation/DBA Data:	APPS.XLA_ACCT_LINE_TYPES_FVL

View Text

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

Columns