Oracle EBS AR 事务处理到期余额总计API
declare -- Local variables here i integer; x_line_original NUMBER; x_line_remaining NUMBER; x_tax_original NUMBER; x_tax_remaining NUMBER; x_freight_orginal NUMBER; x_freight_remaining NUMBER; x_charges_original NUMBER; x_charges_remaining NUMBER; x_total_original NUMBER; x_total_remaining NUMBER; begin -- Test statements here mo_global.init('AR'); mo_global.set_policy_context('S',104); ARP_BAL_UTIL.get_summary_trx_balances(p_customer_trx_id => 10002 ,p_open_receivables_flag =>ra_cust_trx_types_all.accounting_affect_flag --未结应收款 ,p_line_original => x_line_original ,p_line_remaining => x_line_remaining ,p_tax_original => x_tax_original ,p_freight_original => x_freight_orginal ,p_freight_remaining => x_freight_remaining ,p_tax_remaining => x_tax_remaining ,p_charges_original => x_charges_original ,p_charges_remaining => x_charges_remaining ,p_total_original => x_total_original ,p_total_remaining => x_total_remaining); dbms_output.put_line('x_line_original:'||x_line_original); dbms_output.put_line('x_line_remaining:'||x_line_remaining); dbms_output.put_line('x_tax_original:'||x_tax_original); dbms_output.put_line('x_tax_remaining:'||x_tax_remaining); dbms_output.put_line('x_freight_orginal:'||x_freight_orginal); dbms_output.put_line('x_freight_remaining:'||x_freight_remaining); dbms_output.put_line('x_charges_original:'||x_charges_original); dbms_output.put_line('x_charges_remaining:'||x_charges_remaining); dbms_output.put_line('x_total_original:'||x_total_original); dbms_output.put_line('x_total_remaining:'||x_total_remaining); end;
土豆君