[Home] [Help]
1188: CLOSE c_cust_active;
1189:
1190: /* Populate GT table for use in HWM and Largest INV subroutines */
1191: FORALL i IN p_cust_id.FIRST .. p_cust_id.LAST
1192: INSERT INTO ar_cust_search_gt
1193: (customer_id)
1194: VALUES(p_cust_id(i));
1195:
1196: /* FOR i IN p_cust_id.FIRST .. p_cust_id.LAST
2063: from ( select ps.customer_id, ps.customer_site_use_id,
2064: ps.invoice_currency_code, ps.customer_trx_id,
2065: ps.trx_date, SUM(ps.amount_due_original) amount
2066: from ar_payment_schedules_all ps,
2067: ar_cust_search_gt gt
2068: where ps.customer_id = gt.customer_id
2069: and ps.class = '||''''||'INV'||''''||
2070: ' and trx_date >= add_months(sysdate, -24)
2071: group by ps.customer_id, ps.customer_site_use_id,
2181: /* 7518998 - Changed first subquery to UNION ALL, forced
2182: ra rows to be CASH, and completely removed CM app subquery */
2183: text_select :=
2184: 'with cust_list as
2185: (select /*+ cardinality(g,1) */ customer_id from ar_cust_search_gt g)
2186: select customer_id, customer_site_use_id, invoice_currency_code,
2187: as_of_date , cum_balance
2188: from (
2189: select customer_id, customer_site_use_id, invoice_currency_code,
2451: 'ACTIVE', t_cust_id);
2452:
2453: load_trx_summary(t_cust_id);
2454:
2455: /* Following two procedures use ar_cust_search_gt content */
2456: /* p_skip_secondary_processes gives us an easy way to determine
2457: which of these processes is consuming the most time. This would
2458: be a simple way to bypass these if the customer was absolutely not
2459: using them */