DBA Data[Home] [Help]

APPS.ARP_BAL_UTIL dependencies on AR_ACTIVITY_DETAILS

Line 2357: from ar_activity_details

2353: arp_util.debug('Line_Level_Activity()+' );
2354:
2355: Select count(customer_Trx_line_id)
2356: INTO l_count
2357: from ar_activity_details
2358: WHERE customer_trx_line_id in
2359: (SELECT customer_trx_line_id
2360: FROM RA_CUSTOMER_TRX_LINES
2361: WHERE customer_trx_id = p_customer_trx_id)

Line 2634: FROM AR_ACTIVITY_DETAILS act,

2630: nvl(sum(nvl(freight_discount,0)),0)
2631: INTO
2632: l_charges_receipts,
2633: l_freight_discount
2634: FROM AR_ACTIVITY_DETAILS act,
2635: ra_customer_trx_lines line
2636: WHERE line.customer_Trx_id = p_customer_trx_id
2637: and line.line_number = p_line_num
2638: and line.line_type = 'LINE'