APPS.AR_PURGE dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 1666: ra_cust_trx_line_gl_dist ctlgd,

1662: hz_locations remit_loc,
1663: iby_trxn_extensions_v iby,
1664: ra_salesreps sales,
1665: ra_terms term,
1666: ra_cust_trx_line_gl_dist ctlgd,
1667: ra_customer_trx ct_prev,
1668: ra_customer_trx ct
1669: WHERE lu.lookup_code (+) = ct.reason_code
1670: AND lu.lookup_type (+) = 'INVOICING_REASON'

Line 2714: ra_cust_trx_line_gl_dist ctlgd,

2710: to_number(null), /* expiration_days */
2711: '' /* override_auto_accounting_flag */
2712: FROM
2713: ra_cust_trx_types ctt,
2714: ra_cust_trx_line_gl_dist ctlgd,
2715: ra_customer_trx ct
2716: WHERE ctt.cust_trx_type_id = ct.cust_trx_type_id
2717: AND ctlgd.customer_trx_id = ct.customer_trx_id
2718: AND ctlgd.account_set_flag <> 'Y' /* no acount sets */

Line 3851: from ra_cust_trx_line_gl_dist dist

3847: FOR UPDATE OF lines.customer_trx_id NOWAIT;
3848:
3849: cursor dist_cur is
3850: SELECT 'Found' record_found
3851: from ra_cust_trx_line_gl_dist dist
3852: WHERE dist.customer_trx_id = p_entity_id
3853: FOR UPDATE OF dist.customer_trx_id NOWAIT;
3854:
3855: cursor sales_cur is

Line 3889: ra_cust_trx_line_gl_dist dist,

3885: FROM ra_cust_trx_line_salesreps sales,
3886: ar_receivable_applications ra,
3887: ar_payment_schedules ps,
3888: ar_adjustments adj,
3889: ra_cust_trx_line_gl_dist dist,
3890: ra_customer_trx_lines lines,
3891: ra_customer_trx trx
3892: WHERE trx.customer_trx_id = p_entity_id
3893: AND trx.customer_trx_id = lines.customer_trx_id

Line 4033: FROM ra_cust_trx_line_gl_dist

4029: l_unpurgeable_distributions NUMBER;
4030: BEGIN
4031: SELECT COUNT(*)
4032: INTO l_unpurgeable_distributions
4033: FROM ra_cust_trx_line_gl_dist
4034: WHERE customer_trx_id = p_entity_id
4035: AND account_set_flag = 'N'
4036: AND
4037: (

Line 4198: FROM ra_cust_trx_line_gl_dist

4194: l_unpurgeable_distributions NUMBER;
4195: BEGIN
4196: SELECT COUNT(*)
4197: INTO l_unpurgeable_distributions
4198: FROM ra_cust_trx_line_gl_dist
4199: WHERE customer_trx_id = p_entity_id
4200: AND account_set_flag = 'N'
4201: AND
4202: (

Line 4276: FROM RA_CUST_TRX_LINE_GL_DIST

4272: BEGIN
4273:
4274: SELECT acctd_amount
4275: INTO l_receivable_amount
4276: FROM RA_CUST_TRX_LINE_GL_DIST
4277: WHERE customer_trx_id = p_entity_id
4278: AND account_class = 'REC'
4279: AND latest_rec_flag = 'Y' ;
4280:

Line 4372: DELETE FROM ra_cust_trx_line_gl_dist

4368: --
4369: DELETE FROM ra_customer_trx_lines
4370: WHERE customer_trx_id = p_entity_id;
4371: --
4372: DELETE FROM ra_cust_trx_line_gl_dist
4373: WHERE customer_trx_id = p_entity_id;
4374:
4375: --
4376: -- bug 1404679 : to prevent ORA-1403 error when client uses AX,

Line 5495: -- Earlier, it was driven from RA_CUST_TRX_LINE_GL_DIST

5491: p_worker_number IN NUMBER,
5492: p_customer_id IN NUMBER,
5493: p_short_flag IN VARCHAR2) IS
5494: --
5495: -- Earlier, it was driven from RA_CUST_TRX_LINE_GL_DIST
5496: -- To improve the performance, the code is changed
5497: -- so that it drives from AR_PAYMENT_SCHEDULES.
5498: -- This will not handle the cases where the
5499: -- open_receivable flag for the transaction_type is set