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 725: ra_cust_trx_types ctt_prev,

721: '' cust_rcpt_reference, /* customer_receipt_reference */
722: '' bank_acct_name2 /* bank_account_name */
723: FROM ar_lookups lu,
724: ra_rules rule,
725: ra_cust_trx_types ctt_prev,
726: ra_cust_trx_types ctt,
727: ra_batch_sources bs,
728: ra_batches batch,
729: fnd_document_sequences doc,

Line 726: ra_cust_trx_types ctt,

722: '' bank_acct_name2 /* bank_account_name */
723: FROM ar_lookups lu,
724: ra_rules rule,
725: ra_cust_trx_types ctt_prev,
726: ra_cust_trx_types ctt,
727: ra_batch_sources bs,
728: ra_batches batch,
729: fnd_document_sequences doc,
730: gl_sets_of_books sob,

Line 906: FROM ra_cust_trx_types ctt,

902: '' reference_type, /* reference_type */
903: to_number('') reference_id, /* reference_id */
904: '' cust_rcpt_reference, /* customer_receipt_reference */
905: '' bank_acct_name2 /* bank_account_name */
906: FROM ra_cust_trx_types ctt,
907: fnd_document_sequences doc,
908: gl_sets_of_books sob,
909: ar_lookups lu,
910: ar_adjustments adj,

Line 1655: ra_cust_trx_types ctt_prev,

1651: ar_vat_tax vt,
1652: ar_lookups lu_line,
1653: ar_lookups lu_line2,
1654: ra_rules rule1,
1655: ra_cust_trx_types ctt_prev,
1656: ra_cust_trx_types ctt,
1657: mtl_system_items mtl,
1658: ra_customer_trx_lines ctl,
1659: ra_customer_trx ct_prev,

Line 1656: ra_cust_trx_types ctt,

1652: ar_lookups lu_line,
1653: ar_lookups lu_line2,
1654: ra_rules rule1,
1655: ra_cust_trx_types ctt_prev,
1656: ra_cust_trx_types ctt,
1657: mtl_system_items mtl,
1658: ra_customer_trx_lines ctl,
1659: ra_customer_trx ct_prev,
1660: ra_customer_trx ct,

Line 1796: ra_cust_trx_types ctt,

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

Line 1917: FROM ra_cust_trx_types ctt,

1913: '', /* contingency_code */
1914: to_date(null), /* expiration_date */
1915: to_number(null), /* expiration_days */
1916: '' /* override_auto_accounting_flag */
1917: FROM ra_cust_trx_types ctt,
1918: ra_customer_trx ct,
1919: ar_adjustments adj
1920: WHERE adj.customer_trx_id = cp_customer_trx_id
1921: and adj.customer_trx_id = ct.customer_trx_id

Line 2286: ra_cust_trx_types ctt,

2282: to_date(null), /* expiration_date */
2283: to_number(null), /* expiration_days */
2284: '' /* override_auto_accounting_flag */
2285: FROM
2286: ra_cust_trx_types ctt,
2287: ar_payment_schedules ps,
2288: ar_cash_receipts cr,
2289: ar_receivable_applications ra,
2290: ra_customer_trx ct

Line 2421: ra_cust_trx_types ctt_cm,

2417: to_date(null), /* expiration_date */
2418: to_number(null), /* expiration_days */
2419: '' /* override_auto_accounting_flag */
2420: FROM
2421: ra_cust_trx_types ctt_cm,
2422: ra_customer_trx ct_cm,
2423: ra_cust_trx_types ctt_inv,
2424: ar_receivable_applications ra,
2425: ra_customer_trx ct_inv

Line 2423: ra_cust_trx_types ctt_inv,

2419: '' /* override_auto_accounting_flag */
2420: FROM
2421: ra_cust_trx_types ctt_cm,
2422: ra_customer_trx ct_cm,
2423: ra_cust_trx_types ctt_inv,
2424: ar_receivable_applications ra,
2425: ra_customer_trx ct_inv
2426: WHERE ctt_cm.cust_trx_type_id = ct_cm.cust_trx_type_id
2427: AND ra.applied_customer_trx_id = ct_inv.customer_trx_id

Line 3053: ra_cust_trx_types ctt

3049: BEGIN
3050: SELECT COUNT(*)
3051: INTO l_commitment_transactions
3052: FROM ra_customer_trx ct,
3053: ra_cust_trx_types ctt
3054: WHERE ct.customer_trx_id = p_entity_id
3055: AND ctt.cust_trx_type_id = ct.cust_trx_type_id
3056: AND
3057: (

Line 3074: l_type ra_cust_trx_types.type%TYPE ;

3070:
3071: -- bug2472294 start
3072: -- Handle non post to gl transaction
3073: DECLARE
3074: l_type ra_cust_trx_types.type%TYPE ;
3075: l_initial_customer_trx_id ra_customer_trx.initial_customer_trx_id%TYPE;
3076: l_post_to_gl ra_cust_trx_types.post_to_gl%TYPE;
3077: l_trx_date ra_customer_trx.trx_date%TYPE;
3078:

Line 3076: l_post_to_gl ra_cust_trx_types.post_to_gl%TYPE;

3072: -- Handle non post to gl transaction
3073: DECLARE
3074: l_type ra_cust_trx_types.type%TYPE ;
3075: l_initial_customer_trx_id ra_customer_trx.initial_customer_trx_id%TYPE;
3076: l_post_to_gl ra_cust_trx_types.post_to_gl%TYPE;
3077: l_trx_date ra_customer_trx.trx_date%TYPE;
3078:
3079: BEGIN
3080:

Line 3090: ra_cust_trx_types ctt

3086: l_initial_customer_trx_id,
3087: l_post_to_gl,
3088: l_trx_date
3089: FROM ra_customer_trx ct,
3090: ra_cust_trx_types ctt
3091: WHERE ct.customer_trx_id = p_entity_id
3092: AND ctt.cust_trx_type_id = ct.cust_trx_type_id ;
3093:
3094: --

Line 4503: FROM ra_cust_trx_types ctt,

4499: CURSOR c_inv( cp_start_gl_date DATE, cp_end_gl_date DATE,
4500: cp_customer_id NUMBER ,
4501: cp_max_trx_id NUMBER) IS
4502: SELECT ct.customer_trx_id customer_trx_id
4503: FROM ra_cust_trx_types ctt,
4504: ra_customer_trx ct,
4505: ar_payment_schedules ps
4506: WHERE ct.initial_customer_trx_id IS NULL
4507: AND ps.customer_trx_id = ct.customer_trx_id