XXE4ARW AI_ONT_RMA_INT_GL_LINES_RW

select distinct 
origl.header_id,
origl.line_id line_id_h,
ooha.order_number,
hp.party_name,
hca.account_number,
ooha.cust_po_number,
ooha.shipping_method_code,
oola.line_id,
oola.line_number,
oola.ordered_item,
oola.shipped_quantity,
oola.unit_selling_price,
oola.tax_value,
origl.gl_post_journal,
origl.gl_post_journal_id,
origl.gl_post_date journal,
origl.interface_status,
origl.error_flag,
origl.complete_flag,
origl.matched_flag,
origl.amount,
gcc_dr.segment1||'-'||gcc_dr.segment2||'-'||gcc_dr.segment3||'-'||gcc_dr.segment4||'-'||gcc_dr.segment5 debit_account,
gcc_cr.segment1||'-'||gcc_cr.segment2||'-'||gcc_cr.segment3||'-'||gcc_cr.segment4||'-'||gcc_cr.segment5 credit_account
from
xyai.xyai_ont_rma_int_gl_lines origl,
oe_order_headers_all ooha,
hz_cust_accounts hca,
hz_parties hp,
oe_order_lines_all oola,
gl_code_combinations gcc_dr,
gl_code_combinations gcc_cr,
where
2=2 and
origl.header_id=ooha.header_id and
origl.line_id=oola.line_id and
hca.cust_account_id=ooha.sold_to_org_id and
hca.party_id=hp.party_id and
origl.cr_ccid=gcc_cr.code_combination_id and
origl.dr_ccid=gcc_dr.code_combination_id

select distinct origl.header_id, origl.line_id line_id_h, ooha.order_number, hp.party_name, hca.account_number, ooha.cust_po_number, ooha.shipping_method_code, oola.line_id, oola.line_number, oola.ordered_item, oola.shipped_quantity, oola.unit_selling_price, oola.tax_value, origl.gl_post_journal, origl.gl_post_journal_id, origl.gl_post_date journal, origl.interface_status, origl.error_flag, origl.complete_flag, origl.matched_flag, origl.amount, gcc_dr.segment1||'-'||gcc_dr.segment2||'-'||gcc_dr.segment3||'-'||gcc_dr.segment4||'-'||gcc_dr.segment5 debit_account, gcc_cr.segment1||'-'||gcc_cr.segment2||'-'||gcc_cr.segment3||'-'||gcc_cr.segment4||'-'||gcc_cr.segment5 credit_account from xyai.xyai_ont_rma_int_gl_lines origl, oe_order_headers_all ooha, hz_cust_accounts hca, hz_parties hp, oe_order_lines_all oola, gl_code_combinations gcc_dr, gl_code_combinations gcc_cr, where 2=2 and origl.header_id=ooha.header_id and origl.line_id=oola.line_id and hca.cust_account_id=ooha.sold_to_org_id and hca.party_id=hp.party_id and origl.cr_ccid=gcc_cr.code_combination_id and origl.dr_ccid=gcc_dr.code_combination_id