ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 3C2B1559B12E3F3EE063EA08140A089C 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 Y US XXE4ARW AI_ONT_RMA_INT_GL_LINES_RW Imported from Excel4apps Description: Extract of XYAI_ONT_RMA_INT_GL_LINES table. (for RMA Accruals details Application: Excel4apps Reports Wand Source: AI_ONT_RMA_INT_GL_LINES_RW Short Name: AI_ONT_RMA_INT_GL_LINES_RW AI Reports Adcock Ingram 2=2 1 10 2=2 origl.matched_flag is null LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y US Matched Flag 2 20 2=2 origl.interface_status=:interface_status Char POSTED US Interface Status 3 30 2=2 gcc_cr.segment1||'-'||gcc_cr.segment2||'-'||gcc_cr.segment3||'-'||gcc_cr.segment4||'-'||gcc_cr.segment5=:credit_account LOV custom Y select gcc_cr.segment1||'-'||gcc_cr.segment2||'-'||gcc_cr.segment3||'-'||gcc_cr.segment4||'-'||gcc_cr.segment5 value, null description from gl_code_combinations gcc_cr US Credit Account