DBA Data[Home] [Help]

APPS.ARP_PROCESS_CREDIT_UTIL dependencies on AR_ADJUSTMENTS

Line 46: FROM ar_adjustments adj,

42: END IF;
43:
44: SELECT sum(amount)
45: INTO l_amount
46: FROM ar_adjustments adj,
47: ra_cust_trx_types commit_ctt,
48: ra_customer_trx commit_trx
49: WHERE commit_ctt.cust_trx_type_id = commit_trx.cust_trx_type_id
50: AND commit_trx.customer_trx_id = p_commit_ct_id

Line 123: FROM ar_adjustments adj,

119: INTO p_amount,
120: p_line_amount,
121: p_tax_amount,
122: p_freight_amount
123: FROM ar_adjustments adj,
124: ra_cust_trx_types commit_ctt,
125: ra_customer_trx commit_trx
126: WHERE commit_ctt.cust_trx_type_id = commit_trx.cust_trx_type_id
127: AND commit_trx.customer_trx_id = p_commit_ct_id