PASI - Query Standard Memo Line

Post date: Aug 22, 2016 6:37:16 AM

SELECT amlat.MEMO_LINE_ID,

amlat.NAME,

amlat.description,

amlab.line_type,

gcc.segment1 || '.' || gcc.segment2 || '.' || gcc.segment3 || '.' || gcc.segment4 || '.' || gcc.segment5 || '.' || gcc.segment6 || '.' || gcc.segment7 || '.' || gcc.segment8 rev_account

FROM ar_memo_lines_all_tl amlat,

ar_memo_lines_all_b amlab,

gl_code_combinations gcc

WHERE 1 = 1

AND amlab.gl_id_rev = gcc.code_combination_id

AND amlat.memo_line_id = amlab.memo_line_id

AND amlab.org_id = '83'