DBA Data[Home] [Help]

APPS.AR_ADJVALIDATE_PVT dependencies on RA_CUSTOMER_TRX

Line 1710: FROM RA_CUSTOMER_TRX_LINES

1706: l_count := 0 ;
1707: BEGIN
1708: SELECT count(*)
1709: INTO l_count
1710: FROM RA_CUSTOMER_TRX_LINES
1711: WHERE customer_trx_id = p_adj_rec.customer_trx_id AND
1712: customer_trx_line_id = p_adj_rec.customer_trx_line_id ;
1713:
1714: EXCEPTION

Line 3833: FROM ra_customer_trx ct,

3829: l_tax_remaining,
3830: l_line_org,
3831: l_tax_org,
3832: l_invoice_currency_code
3833: FROM ra_customer_trx ct,
3834: ra_customer_trx_lines lines
3835: WHERE (lines.customer_Trx_line_id = p_adj_rec.customer_trx_line_id or
3836: lines.link_to_cust_trx_line_id = p_adj_rec.customer_trx_line_id)
3837: AND ct.customer_Trx_id = lines.customer_trx_id;

Line 3834: ra_customer_trx_lines lines

3830: l_line_org,
3831: l_tax_org,
3832: l_invoice_currency_code
3833: FROM ra_customer_trx ct,
3834: ra_customer_trx_lines lines
3835: WHERE (lines.customer_Trx_line_id = p_adj_rec.customer_trx_line_id or
3836: lines.link_to_cust_trx_line_id = p_adj_rec.customer_trx_line_id)
3837: AND ct.customer_Trx_id = lines.customer_trx_id;
3838: