DBA Data[Home] [Help]

APPS.ARP_BAL_UTIL dependencies on AR_ACTIVITY_DETAILS

Line 2270: from ar_activity_details

2266: arp_util.debug('Line_Level_Activity()+' );
2267:
2268: Select count(customer_Trx_line_id)
2269: INTO l_count
2270: from ar_activity_details
2271: WHERE customer_trx_line_id in
2272: (SELECT customer_trx_line_id
2273: FROM RA_CUSTOMER_TRX_LINES
2274: WHERE customer_trx_id = p_customer_trx_id)

Line 2547: FROM AR_ACTIVITY_DETAILS act,

2543: nvl(sum(nvl(freight_discount,0)),0)
2544: INTO
2545: l_charges_receipts,
2546: l_freight_discount
2547: FROM AR_ACTIVITY_DETAILS act,
2548: ra_customer_trx_lines line
2549: WHERE line.customer_Trx_id = p_customer_trx_id
2550: and line.line_number = p_line_num
2551: and line.line_type = 'LINE'