Friday, 7 August 2015

GL to FA link in oracle apps R12

/* 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

No comments:

Post a Comment