OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse       85      0.03       0.03          0          0          0           0
Execute     95      0.07       0.71         52        151        288          61
Fetch       56     42.42     213.03     165790    2639201          0         110
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total      236     42.52     213.79     165842    2639352        288         171

SELECT 
	   98 org_id, 
	   rc.customer_number, 
	   rc.customer_name, 
	   cpa.currency_code cr_limit_curr_code, 
	   cpa.overall_credit_limit credit_limit, 
	   rc.customer_id, 
	   NVL((SELECT SUM(NVL(apt_ndd.amount_due_remaining,0)) 
	   		FROM AR_PAYMENT_SCHEDULES_ALL apt_ndd 
			WHERE 1=1 
			AND apt_ndd.customer_id = rc.customer_id 
			AND apt_ndd.due_date  = 
			   (SELECT MIN(apt_ndd2.due_date) 
			      FROM AR_PAYMENT_SCHEDULES_ALL apt_ndd2 
                              WHERE 1=1 
                                 AND NVL(apt_ndd2.amount_due_remaining,0) <> 0 
                                 AND apt_ndd2.due_date > SYSDATE
                                 AND apt_ndd2.customer_id = rc.customer_id 
                                 AND apt_ndd2.org_id = 98) 
           ),0)Forecast_ndd, 
        NVL(ttl.amount_due_remaining,0) Open_Receivables , 
        NVL((SELECT SUM(ROUND(ool.pricing_quantity,2) * ROUND(ool.unit_selling_price,2)) 
 			 FROM OE_ORDER_LINES_ALL ool, 
			 	  OE_ORDER_HEADERS_ALL ooh 
			 WHERE ooh.sold_to_org_id = rc.customer_id 
			 AND ool.header_id = ooh.header_id 
			 AND ooh.order_category_code = 'ORDER' 
			 AND ool.flow_status_code IN ('PICKED','AWAITING_SHIPPING') 
			 AND ool.org_id = 98 
            ),0) Open_Sales_Orders 
FROM  apps.RA_CUSTOMERS rc, 
      apps.HZ_CUST_PROFILE_AMTS cpa,
      (SELECT customer_id, SUM(ROUND(aps.amount_due_remaining,2)) amount_due_remaining
       FROM AR_PAYMENT_SCHEDULES_ALL aps
       WHERE org_id = 98
       GROUP BY customer_id) TTL
WHERE 1 = 1 
AND cpa.cust_account_id = rc.customer_id 
AND cpa.currency_code = 'JPY' 
AND rc.status = 'A' AND ttl.customer_id(+) = rc.customer_id

 969148  TABLE ACCESS BY INDEX ROWID AR_PAYMENT_SCHEDULES_ALL (Orphan Entry)
 969148  INDEX RANGE SCAN AR_PAYMENT_SCHEDULES_N6 (object id 28914)(Orphan Entry)
     58   SORT AGGREGATE 
  10967  TABLE ACCESS BY INDEX ROWID OE_ORDER_LINES_ALL (Orphan Entry)
1622936  NESTED LOOPS  (Orphan Entry)
 605709  TABLE ACCESS BY INDEX ROWID OE_ORDER_HEADERS_ALL (Orphan Entry)
 615126  INDEX RANGE SCAN OE_ORDER_HEADERS_N2 (object id 41421)(Orphan Entry)
1017169  INDEX RANGE SCAN OE_ORDER_LINES_N1 (object id 41462)(Orphan Entry)
     58   SORT AGGREGATE 
 969148  TABLE ACCESS BY INDEX ROWID AR_PAYMENT_SCHEDULES_ALL (Orphan Entry)
 969148  INDEX RANGE SCAN AR_PAYMENT_SCHEDULES_N6 (object id 28914)(Orphan Entry)
     58   SORT AGGREGATE 
  10967  TABLE ACCESS BY INDEX ROWID OE_ORDER_LINES_ALL (Orphan Entry)
1622936  NESTED LOOPS  (Orphan Entry)
 605709  TABLE ACCESS BY INDEX ROWID OE_ORDER_HEADERS_ALL (Orphan Entry)
 615126  INDEX RANGE SCAN OE_ORDER_HEADERS_N2 (object id 41421)(Orphan Entry)
1017169  INDEX RANGE SCAN OE_ORDER_LINES_N1 (object id 41462)(Orphan Entry)