VIEW: APPS.XLA_JE_EXTRACT_V

Source

View Text - Preformatted

SELECT xlah.application_id , xlah.accounting_date , xlah.ledger_id , xlah.ae_header_id , xlah.group_id , xlah.accounting_entry_status_code , xlah.gl_transfer_status_code , xlal.ae_line_num , NVL(xlal.entered_dr,0) - NVL(xlal.entered_cr,0) foreign_amount , NVL(xlal.accounted_dr,0) - NVL(xlal.accounted_cr,0) monetary_amount, gldc.user_conversion_type , xlal.CURRENCY_CONVERSION_RATE , xlal.currency_code , glld.currency_code , SUBSTR(xlal.DESCRIPTION ,1,30) , 'N' , xlal.gl_sl_link_id , xlal.gl_sl_link_table , xlal.code_combination_id , glcc.segment1 , glcc.segment2 , glcc.segment3 , glcc.segment4 , glcc.segment5 , glcc.segment6 , glcc.segment7 , glcc.segment8 , glcc.segment9 , glcc.segment10 , glcc.segment11 , glcc.segment12 , glcc.segment13 , glcc.segment14 , glcc.segment15 , glcc.segment16 , glcc.segment17 , glcc.segment18 , glcc.segment19 , glcc.segment20 , glcc.segment21 , glcc.segment22 , glcc.segment23 , glcc.segment24 , glcc.segment25 , glcc.segment26 , glcc.segment27 , glcc.segment28 , glcc.segment29 , glcc.segment30 , fnap.application_short_name , glld.short_name , glld.short_name , NULL , xlah.event_id , NULL FROM xla_ae_headers xlah , gl_daily_conversion_types gldc, gl_code_combinations glcc , gl_ledgers glld , fnd_application fnap , xla_ae_lines xlal WHERE xlah.ae_header_id = xlal.ae_header_id AND xlah.application_id = xlal.application_id AND xlal.currency_conversion_type = gldc.conversion_type(+) AND xlal.code_combination_id = glcc.code_combination_id AND xlah.application_id = fnap.application_id AND xlah.ledger_id = glld.ledger_id

View Text - HTML Formatted

SELECT XLAH.APPLICATION_ID
, XLAH.ACCOUNTING_DATE
, XLAH.LEDGER_ID
, XLAH.AE_HEADER_ID
, XLAH.GROUP_ID
, XLAH.ACCOUNTING_ENTRY_STATUS_CODE
, XLAH.GL_TRANSFER_STATUS_CODE
, XLAL.AE_LINE_NUM
, NVL(XLAL.ENTERED_DR
, 0) - NVL(XLAL.ENTERED_CR
, 0) FOREIGN_AMOUNT
, NVL(XLAL.ACCOUNTED_DR
, 0) - NVL(XLAL.ACCOUNTED_CR
, 0) MONETARY_AMOUNT
, GLDC.USER_CONVERSION_TYPE
, XLAL.CURRENCY_CONVERSION_RATE
, XLAL.CURRENCY_CODE
, GLLD.CURRENCY_CODE
, SUBSTR(XLAL.DESCRIPTION
, 1
, 30)
, 'N'
, XLAL.GL_SL_LINK_ID
, XLAL.GL_SL_LINK_TABLE
, XLAL.CODE_COMBINATION_ID
, GLCC.SEGMENT1
, GLCC.SEGMENT2
, GLCC.SEGMENT3
, GLCC.SEGMENT4
, GLCC.SEGMENT5
, GLCC.SEGMENT6
, GLCC.SEGMENT7
, GLCC.SEGMENT8
, GLCC.SEGMENT9
, GLCC.SEGMENT10
, GLCC.SEGMENT11
, GLCC.SEGMENT12
, GLCC.SEGMENT13
, GLCC.SEGMENT14
, GLCC.SEGMENT15
, GLCC.SEGMENT16
, GLCC.SEGMENT17
, GLCC.SEGMENT18
, GLCC.SEGMENT19
, GLCC.SEGMENT20
, GLCC.SEGMENT21
, GLCC.SEGMENT22
, GLCC.SEGMENT23
, GLCC.SEGMENT24
, GLCC.SEGMENT25
, GLCC.SEGMENT26
, GLCC.SEGMENT27
, GLCC.SEGMENT28
, GLCC.SEGMENT29
, GLCC.SEGMENT30
, FNAP.APPLICATION_SHORT_NAME
, GLLD.SHORT_NAME
, GLLD.SHORT_NAME
, NULL
, XLAH.EVENT_ID
, NULL
FROM XLA_AE_HEADERS XLAH
, GL_DAILY_CONVERSION_TYPES GLDC
, GL_CODE_COMBINATIONS GLCC
, GL_LEDGERS GLLD
, FND_APPLICATION FNAP
, XLA_AE_LINES XLAL
WHERE XLAH.AE_HEADER_ID = XLAL.AE_HEADER_ID
AND XLAH.APPLICATION_ID = XLAL.APPLICATION_ID
AND XLAL.CURRENCY_CONVERSION_TYPE = GLDC.CONVERSION_TYPE(+)
AND XLAL.CODE_COMBINATION_ID = GLCC.CODE_COMBINATION_ID
AND XLAH.APPLICATION_ID = FNAP.APPLICATION_ID
AND XLAH.LEDGER_ID = GLLD.LEDGER_ID