SLA Accounting Class Codes

SLA  Accounting Class Codes 
 ------------------------------------------------------------

SELECT DECODE (xalt_tl.name,
'Expense - Transfer From', 'Expense',
'Expense - Transfer To', 'Expense',
'Inventory - Transfer From', 'Inventory',
'Inventory - Transfer To', 'Inventory',
xalt_tl.name) acct_class_name,
xalt_b.entity_code,
xalt_b.EVENT_CLASS_CODE,
xec_tl.name,
DECODE (xalt_b.accounting_line_code,
'INV_SUB_FROM', 'INV',
'INV_SUB_TO', 'INV',
'EXP_SUB_FROM', 'EXP',
'EXP_SUB_TO', 'EXP',
xalt_b.accounting_line_code) accounting_line_code
FROM APPS.XLA_ACCT_LINE_TYPES_B xalt_b,
APPS.XLA_ACCT_LINE_TYPES_TL xalt_tl,
APPS.XLA_EVENT_CLASSES_TL xec_tl
WHERE xalt_b.application_id = xalt_tl.application_id
AND xalt_b.application_id = 555 -- OPM
AND xalt_b.AMB_CONTEXT_CODE = xalt_tl.AMB_CONTEXT_CODE
AND xalt_b.entity_code = xalt_tl.entity_code
AND xalt_b.EVENT_CLASS_CODE = xalt_tl.event_class_code
AND xalt_b.accounting_line_type_code = xalt_tl.accounting_line_type_code
AND xalt_b.ACCOUNTING_LINE_CODE = xalt_tl.ACCOUNTING_LINE_CODE
AND xalt_tl.LANGUAGE = USERENV ('LANG')
AND XALT_TL.SOURCE_LANG = USERENV ('LANG')
AND XEC_TL.LANGUAGE = USERENV ('LANG')
AND XALT_B.APPLICATION_ID = XEC_TL.APPLICATION_ID
AND XALT_B.ENTITY_CODE = XEC_TL.ENTITY_CODE
AND XALT_B.EVENT_CLASS_CODE = XEC_TL.EVENT_CLASS_CODE
AND XEC_TL.SOURCE_LANG = USERENV ('LANG')
AND XEC_TL.LANGUAGE = USERENV ('LANG')
GROUP BY
DECODE (xalt_tl.name,
'Expense - Transfer From', 'Expense',
'Expense - Transfer To', 'Expense',
'Inventory - Transfer From', 'Inventory',
'Inventory - Transfer To', 'Inventory',
xalt_tl.name),
xalt_b.entity_code,
xalt_b.EVENT_CLASS_CODE,
xec_tl.name,
DECODE (XALT_B.ACCOUNTING_LINE_CODE,
'INV_SUB_FROM', 'INV',
'INV_SUB_TO', 'INV',
'EXP_SUB_FROM', 'EXP',
'EXP_SUB_TO', 'EXP',
XALT_B.ACCOUNTING_LINE_CODE)