eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_PURGE dependencies on RA_CUST_TRX_TYPES

Line 954: ra_cust_trx_types ctt,

950: '' tax_exemption_number, /* customer_exemption_number */
951: '' item_exception_rate, /* item_exception_rate */
952: '' meaning /* item_exception_reason */
953: FROM
954: ra_cust_trx_types ctt,
955: ar_payment_schedules ps,
956: ar_cash_receipts cr,
957: ar_receivable_applications ra,
958: ra_customer_trx ct,

Line 1642: ra_cust_trx_types ctt_prev,

1638: '' cust_rcpt_reference, /* customer_receipt_reference */
1639: '' bank_acct_name2 /* bank_account_name */
1640: FROM ar_lookups lu,
1641: ra_rules rule,
1642: ra_cust_trx_types ctt_prev,
1643: ra_cust_trx_types ctt,
1644: ra_batch_sources bs,
1645: ra_batches batch,
1646: fnd_document_sequences doc,

Line 1643: ra_cust_trx_types ctt,

1639: '' bank_acct_name2 /* bank_account_name */
1640: FROM ar_lookups lu,
1641: ra_rules rule,
1642: ra_cust_trx_types ctt_prev,
1643: ra_cust_trx_types ctt,
1644: ra_batch_sources bs,
1645: ra_batches batch,
1646: fnd_document_sequences doc,
1647: gl_sets_of_books sob,

Line 1823: FROM ra_cust_trx_types ctt,

1819: '' reference_type, /* reference_type */
1820: to_number('') reference_id, /* reference_id */
1821: '' cust_rcpt_reference, /* customer_receipt_reference */
1822: '' bank_acct_name2 /* bank_account_name */
1823: FROM ra_cust_trx_types ctt,
1824: fnd_document_sequences doc,
1825: gl_sets_of_books sob,
1826: ar_lookups lu,
1827: ar_adjustments adj,

Line 2572: ra_cust_trx_types ctt_prev,

2568: ar_vat_tax vt,
2569: ar_lookups lu_line,
2570: ar_lookups lu_line2,
2571: ra_rules rule1,
2572: ra_cust_trx_types ctt_prev,
2573: ra_cust_trx_types ctt,
2574: mtl_system_items mtl,
2575: ra_customer_trx_lines ctl,
2576: ra_customer_trx ct_prev,

Line 2573: ra_cust_trx_types ctt,

2569: ar_lookups lu_line,
2570: ar_lookups lu_line2,
2571: ra_rules rule1,
2572: ra_cust_trx_types ctt_prev,
2573: ra_cust_trx_types ctt,
2574: mtl_system_items mtl,
2575: ra_customer_trx_lines ctl,
2576: ra_customer_trx ct_prev,
2577: ra_customer_trx ct,

Line 2713: ra_cust_trx_types ctt,

2709: to_date(null), /* expiration_date */
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

Line 2834: FROM ra_cust_trx_types ctt,

2830: '', /* contingency_code */
2831: to_date(null), /* expiration_date */
2832: to_number(null), /* expiration_days */
2833: '' /* override_auto_accounting_flag */
2834: FROM ra_cust_trx_types ctt,
2835: ra_customer_trx ct,
2836: ar_adjustments adj
2837: WHERE adj.customer_trx_id = cp_customer_trx_id
2838: and adj.customer_trx_id = ct.customer_trx_id

Line 3203: ra_cust_trx_types ctt,

3199: to_date(null), /* expiration_date */
3200: to_number(null), /* expiration_days */
3201: '' /* override_auto_accounting_flag */
3202: FROM
3203: ra_cust_trx_types ctt,
3204: ar_payment_schedules ps,
3205: ar_cash_receipts cr,
3206: ar_receivable_applications ra,
3207: ra_customer_trx ct

Line 3338: ra_cust_trx_types ctt_cm,

3334: to_date(null), /* expiration_date */
3335: to_number(null), /* expiration_days */
3336: '' /* override_auto_accounting_flag */
3337: FROM
3338: ra_cust_trx_types ctt_cm,
3339: ra_customer_trx ct_cm,
3340: ra_cust_trx_types ctt_inv,
3341: ar_receivable_applications ra,
3342: ra_customer_trx ct_inv

Line 3340: ra_cust_trx_types ctt_inv,

3336: '' /* override_auto_accounting_flag */
3337: FROM
3338: ra_cust_trx_types ctt_cm,
3339: ra_customer_trx ct_cm,
3340: ra_cust_trx_types ctt_inv,
3341: ar_receivable_applications ra,
3342: ra_customer_trx ct_inv
3343: WHERE ctt_cm.cust_trx_type_id = ct_cm.cust_trx_type_id
3344: AND ra.applied_customer_trx_id = ct_inv.customer_trx_id

Line 3970: ra_cust_trx_types ctt

3966: BEGIN
3967: SELECT COUNT(*)
3968: INTO l_commitment_transactions
3969: FROM ra_customer_trx ct,
3970: ra_cust_trx_types ctt
3971: WHERE ct.customer_trx_id = p_entity_id
3972: AND ctt.cust_trx_type_id = ct.cust_trx_type_id
3973: AND
3974: (

Line 3991: l_type ra_cust_trx_types.type%TYPE ;

3987:
3988: -- bug2472294 start
3989: -- Handle non post to gl transaction
3990: DECLARE
3991: l_type ra_cust_trx_types.type%TYPE ;
3992: l_initial_customer_trx_id ra_customer_trx.initial_customer_trx_id%TYPE;
3993: l_post_to_gl ra_cust_trx_types.post_to_gl%TYPE;
3994: l_trx_date ra_customer_trx.trx_date%TYPE;
3995:

Line 3993: l_post_to_gl ra_cust_trx_types.post_to_gl%TYPE;

3989: -- Handle non post to gl transaction
3990: DECLARE
3991: l_type ra_cust_trx_types.type%TYPE ;
3992: l_initial_customer_trx_id ra_customer_trx.initial_customer_trx_id%TYPE;
3993: l_post_to_gl ra_cust_trx_types.post_to_gl%TYPE;
3994: l_trx_date ra_customer_trx.trx_date%TYPE;
3995:
3996: BEGIN
3997:

Line 4007: ra_cust_trx_types ctt

4003: l_initial_customer_trx_id,
4004: l_post_to_gl,
4005: l_trx_date
4006: FROM ra_customer_trx ct,
4007: ra_cust_trx_types ctt
4008: WHERE ct.customer_trx_id = p_entity_id
4009: AND ctt.cust_trx_type_id = ct.cust_trx_type_id ;
4010:
4011: --

Line 5508: FROM ra_cust_trx_types ctt,

5504: CURSOR c_inv( cp_start_gl_date DATE, cp_end_gl_date DATE,
5505: cp_customer_id NUMBER ,
5506: cp_max_trx_id NUMBER) IS
5507: SELECT ct.customer_trx_id customer_trx_id
5508: FROM ra_cust_trx_types ctt,
5509: ra_customer_trx ct,
5510: ar_payment_schedules ps
5511: WHERE ct.initial_customer_trx_id IS NULL
5512: AND ps.customer_trx_id = ct.customer_trx_id