SELECT hc.cust_account_id ,min(hc.account_number) customer_number ,sum(amount_due_remaining) amount_due_remaining ,sum(aps.amount_due_original) amount_due_original ,count(aps.payment_schedule_id) open_invoices FROM ra_customer_trx_all ra, ra_customer_trx_lines_all rl, ar_payment_schedules_all aps, ra_cust_trx_types_all rt, hz_cust_accounts hc, hz_parties hp, hz_cust_acct_sites_all hcasa_bill, hz_cust_site_uses_all hcsua_bill, hz_party_sites hps_bill, ra_cust_trx_line_gl_dist_all rct WHERE ra.customer_trx_id = rl.customer_trx_id AND ra.customer_trx_id = aps.customer_trx_id AND ra.org_id = aps.org_id AND rct.customer_trx_id = aps.customer_trx_id AND rct.customer_trx_id = ra.customer_trx_id AND rct.customer_trx_id = rl.customer_trx_id […]

Alacaklar faturası oluşturmak için R11 de doğrudan kullanılan program ar_invoice_api_pub.create_single_invoice aşağıda canlı bir uygulama örneğidir. program hata ile tamamlandığıda  aşağıdaki temp tablo aracılığı ile programın hataları  kontrol edilebilir select * from ar_trx_errors_gt;   declare p_trx_header_tbl ar_invoice_api_pub.trx_header_tbl_type; p_trx_lines_tbl ar_invoice_api_pub.trx_line_tbl_type; p_trx_dist_tbl ar_invoice_api_pub.trx_dist_tbl_type; p_trx_salescredits_tbl ar_invoice_api_pub.trx_salescredits_tbl_type; p_batch_source_rec ar_invoice_api_pub.batch_source_rec_type; p_msg_count NUMBER; p_msg_data VARCHAR2 (2000); l_cnt             […]