APPS.AR_ADJVALIDATE_PVT dependencies on RA_CUSTOMER_TRX_LINES

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 3639: ra_customer_trx_lines ctl

3635: ard.ref_account_class,
3636: ard.activity_bucket,
3637: ctl.line_type
3638: FROM ar_distributions ard,
3639: ra_customer_trx_lines ctl
3640: WHERE ctl.customer_trx_id = p_customer_trx_id
3641: AND ctl.customer_trx_line_id = ard.ref_customer_trx_line_id
3642: AND (ctl.customer_trx_line_id = p_customer_trx_line_id
3643: OR

Line 3657: ra_customer_trx_lines ctll

3653: (SELECT SUM(ctlgd.AMOUNT) sum_orig,
3654: SUM(ctlgd.ACCTD_AMOUNT) sum_acctd_orig,
3655: ctlgd.customer_trx_line_id
3656: FROM ra_cust_trx_line_gl_dist ctlgd,
3657: ra_customer_trx_lines ctll
3658: WHERE ctlgd.customer_trx_id = p_customer_trx_id
3659: AND ctlgd.customer_trx_line_id = ctll.customer_trx_line_id
3660: AND (ctll.customer_trx_line_id = p_customer_trx_line_id
3661: OR

Line 3667: ra_customer_trx_lines ctl1

3663: AND ctll.line_type = 'TAX'
3664: )
3665: )
3666: GROUP BY ctlgd.customer_trx_line_id) b,
3667: ra_customer_trx_lines ctl1
3668: WHERE a.ref_customer_trx_line_id (+) = b.customer_trx_line_id
3669: and b.customer_trx_line_id=ctl1.customer_trx_line_id
3670: GROUP BY b.customer_trx_line_id,
3671: b.sum_orig,

Line 4073: ra_customer_trx_lines lines

4069: l_line_org,
4070: l_tax_org,
4071: l_invoice_currency_code
4072: FROM ra_customer_trx ct,
4073: ra_customer_trx_lines lines
4074: WHERE (lines.customer_Trx_line_id = p_adj_rec.customer_trx_line_id or
4075: lines.link_to_cust_trx_line_id = p_adj_rec.customer_trx_line_id)
4076: AND ct.customer_Trx_id = lines.customer_trx_id;
4077: