/* Formatted on 8/7/2015 12:48:29 PM (QP5 v5.240.12305.39446) */
SELECT gjjlv.period_name period_name,
gjb.name batch_name,
gjjlv.header_name Journal_Entry,
gjjlv.je_source Source,
gjjlv.line_entered_dr Entered_Debit,
gjjlv.line_entered_cr Entered_credit,
gjjlv.line_accounted_dr Accounted_Debit,
gjjlv.line_accounted_cr Accounted_Credit,
gjjlv.currency_code Currency,
fasv.TRX_TYPE_NAME Trans_Type,
fasv.TRX_NUMBER_DISPLAYED Transaction_Number,
fasv.TRX_DATE Transaction_Date,
fasv.ASSET_NUMBER Reference,
glcc.CONCATENATED_SEGMENTS,
gjjlv.created_by
FROM apps.GL_JE_JOURNAL_LINES_V gjjlv,
gl_je_lines gje,
apps.fa_ael_gl_v fasv,
gl_je_headers gjh,
gl_je_batches gjb,
apps.gl_code_combinations_kfv glcc
WHERE gjh.period_name BETWEEN 'SEP-2014' AND 'OCT-2014'
AND glcc.code_combination_id = gje.code_combination_id
AND glcc.code_combination_id = fasv.code_combination_id
AND gjh.JE_BATCH_ID = gjb.JE_BATCH_ID
AND gjh.JE_HEADER_ID = gje.JE_HEADER_ID
AND gjh.period_name = gjb.default_period_name
AND gjh.period_name = gje.period_name
AND gjjlv.period_name = gjh.period_name
AND gjjlv.je_batch_id = gjh.je_batch_id
AND gjjlv.je_header_id = gjh.je_header_id
AND gjjlv.LINE_JE_LINE_NUM = gje.je_line_num
AND gjjlv.je_header_id = fasv.je_header_id
AND glcc.segment1 = '22'
GL_INTERFACE table column
REFERENCE21(REFERENCE_1):TRANSACTION_HEADER_ID
REFERENCE22(REFERENCE_2):ASSET_ID
REFERENCE23(REFERENCE_3):DISTRIBUTION_ID
REFERENCE24(REFERENCE_4):ADJUSTMENT_LINE_ID
REFERENCE25(REFERENCE_5):BOOK_TYPE_CODE
REFERENCE26(REFERENCE_6):PERIOD_COUNTER
REFERENCE27(REFERENCE_7):FA_TRANSFER_TO_GL
REFERENCE28(REFERENCE_8):ADJUSTMENT_TYPE / LOOKUP_CODE
REFERENCE29(REFERENCE_9):CJE_ID
SELECT gjjlv.period_name period_name,
gjb.name batch_name,
gjjlv.header_name Journal_Entry,
gjjlv.je_source Source,
gjjlv.line_entered_dr Entered_Debit,
gjjlv.line_entered_cr Entered_credit,
gjjlv.line_accounted_dr Accounted_Debit,
gjjlv.line_accounted_cr Accounted_Credit,
gjjlv.currency_code Currency,
fasv.TRX_TYPE_NAME Trans_Type,
fasv.TRX_NUMBER_DISPLAYED Transaction_Number,
fasv.TRX_DATE Transaction_Date,
fasv.ASSET_NUMBER Reference,
glcc.CONCATENATED_SEGMENTS,
gjjlv.created_by
FROM apps.GL_JE_JOURNAL_LINES_V gjjlv,
gl_je_lines gje,
apps.fa_ael_gl_v fasv,
gl_je_headers gjh,
gl_je_batches gjb,
apps.gl_code_combinations_kfv glcc
WHERE gjh.period_name BETWEEN 'SEP-2014' AND 'OCT-2014'
AND glcc.code_combination_id = gje.code_combination_id
AND glcc.code_combination_id = fasv.code_combination_id
AND gjh.JE_BATCH_ID = gjb.JE_BATCH_ID
AND gjh.JE_HEADER_ID = gje.JE_HEADER_ID
AND gjh.period_name = gjb.default_period_name
AND gjh.period_name = gje.period_name
AND gjjlv.period_name = gjh.period_name
AND gjjlv.je_batch_id = gjh.je_batch_id
AND gjjlv.je_header_id = gjh.je_header_id
AND gjjlv.LINE_JE_LINE_NUM = gje.je_line_num
AND gjjlv.je_header_id = fasv.je_header_id
AND glcc.segment1 = '22'
GL_INTERFACE table column
REFERENCE21(REFERENCE_1):TRANSACTION_HEADER_ID
REFERENCE22(REFERENCE_2):ASSET_ID
REFERENCE23(REFERENCE_3):DISTRIBUTION_ID
REFERENCE24(REFERENCE_4):ADJUSTMENT_LINE_ID
REFERENCE25(REFERENCE_5):BOOK_TYPE_CODE
REFERENCE26(REFERENCE_6):PERIOD_COUNTER
REFERENCE27(REFERENCE_7):FA_TRANSFER_TO_GL
REFERENCE28(REFERENCE_8):ADJUSTMENT_TYPE / LOOKUP_CODE
REFERENCE29(REFERENCE_9):CJE_ID
No comments:
Post a Comment