APPS.AR_PURGE dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 749: ra_cust_trx_line_gl_dist ctlgd,

745: hz_locations remit_loc,
746: iby_trxn_extensions_v iby,
747: ra_salesreps sales,
748: ra_terms term,
749: ra_cust_trx_line_gl_dist ctlgd,
750: ra_customer_trx ct_prev,
751: ra_customer_trx ct
752: WHERE lu.lookup_code (+) = ct.reason_code
753: AND lu.lookup_type (+) = 'INVOICING_REASON'

Line 1797: ra_cust_trx_line_gl_dist ctlgd,

1793: to_number(null), /* expiration_days */
1794: '' /* override_auto_accounting_flag */
1795: FROM
1796: ra_cust_trx_types ctt,
1797: ra_cust_trx_line_gl_dist ctlgd,
1798: ra_customer_trx ct
1799: WHERE ctt.cust_trx_type_id = ct.cust_trx_type_id
1800: AND ctlgd.customer_trx_id = ct.customer_trx_id
1801: AND ctlgd.account_set_flag <> 'Y' /* no acount sets */

Line 2934: from ra_cust_trx_line_gl_dist dist

2930: FOR UPDATE OF lines.customer_trx_id NOWAIT;
2931:
2932: cursor dist_cur is
2933: SELECT 'Found' record_found
2934: from ra_cust_trx_line_gl_dist dist
2935: WHERE dist.customer_trx_id = p_entity_id
2936: FOR UPDATE OF dist.customer_trx_id NOWAIT;
2937:
2938: cursor sales_cur is

Line 2972: ra_cust_trx_line_gl_dist dist,

2968: FROM ra_cust_trx_line_salesreps sales,
2969: ar_receivable_applications ra,
2970: ar_payment_schedules ps,
2971: ar_adjustments adj,
2972: ra_cust_trx_line_gl_dist dist,
2973: ra_customer_trx_lines lines,
2974: ra_customer_trx trx
2975: WHERE trx.customer_trx_id = p_entity_id
2976: AND trx.customer_trx_id = lines.customer_trx_id

Line 3116: FROM ra_cust_trx_line_gl_dist

3112: l_unpurgeable_distributions NUMBER;
3113: BEGIN
3114: SELECT COUNT(*)
3115: INTO l_unpurgeable_distributions
3116: FROM ra_cust_trx_line_gl_dist
3117: WHERE customer_trx_id = p_entity_id
3118: AND account_set_flag = 'N'
3119: AND
3120: (

Line 3281: FROM ra_cust_trx_line_gl_dist

3277: l_unpurgeable_distributions NUMBER;
3278: BEGIN
3279: SELECT COUNT(*)
3280: INTO l_unpurgeable_distributions
3281: FROM ra_cust_trx_line_gl_dist
3282: WHERE customer_trx_id = p_entity_id
3283: AND account_set_flag = 'N'
3284: AND
3285: (

Line 3359: FROM RA_CUST_TRX_LINE_GL_DIST

3355: BEGIN
3356:
3357: SELECT acctd_amount
3358: INTO l_receivable_amount
3359: FROM RA_CUST_TRX_LINE_GL_DIST
3360: WHERE customer_trx_id = p_entity_id
3361: AND account_class = 'REC'
3362: AND latest_rec_flag = 'Y' ;
3363:

Line 3460: DELETE FROM ra_cust_trx_line_gl_dist

3456: --
3457: DELETE FROM ra_customer_trx_lines
3458: WHERE customer_trx_id = p_entity_id;
3459: --
3460: DELETE FROM ra_cust_trx_line_gl_dist
3461: WHERE customer_trx_id = p_entity_id
3462: RETURNING cust_trx_line_gl_dist_id
3463: BULK COLLECT INTO l_gl_dist_key_value_list;
3464:

Line 3472: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',

3468: +---------------------------------*/
3469:
3470: /* ar_mrc_engine.maintain_mrc_data(
3471: p_event_mode => 'DELETE',
3472: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',
3473: p_mode => 'BATCH',
3474: p_key_value_list => l_gl_dist_key_value_list);*/
3475:
3476: --

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

4486: p_worker_number IN NUMBER,
4487: p_customer_id IN NUMBER,
4488: p_short_flag IN VARCHAR2) IS
4489: --
4490: -- Earlier, it was driven from RA_CUST_TRX_LINE_GL_DIST
4491: -- To improve the performance, the code is changed
4492: -- so that it drives from AR_PAYMENT_SCHEDULES.
4493: -- This will not handle the cases where the
4494: -- open_receivable flag for the transaction_type is set