SELECT
gjjlv.period_name “Period Name”,
gjb.name “Batch Name”,
gjjlv.header_name “Journal Entry”,
gjjlv.je_source “Source”,
glcc.concatenated_segments “Accounts”,
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”,
arm.name “Payment Method”,
acra.receipt_number “Receipt Num”,
acra.receipt_date “Receipt Date”,
ra.customer_name “Reference”,
gjjlv.created_by “GL Transfer By”
FROM apps.gl_je_journal_lines_v gjjlv,
gl_je_lines gje,
gl_je_headers gjh,
gl_je_batches gjb,
ar_cash_receipts_all acra,
ra_customers ra,
gl_code_combinations_kfv glcc,
ar_receipt_methods arm
WHERE 1=1
and gjh.period_name =:P_PERIOD_NAME
and glcc.code_combination_id=gje.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.line_code_combination_id=glcc.code_combination_id
and gjjlv.line_reference_4=acra.receipt_number
and ra.customer_id=acra.pay_from_customer
and acra.receipt_method_id=arm.receipt_method_id
and gjjlv.subledger_doc_sequence_value=acra.doc_sequence_value
and gjjlv.subledger_doc_sequence_id=acra.doc_sequence_id
Recent Posts
