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.ARP_MAINTAIN_PS2 dependencies on RA_CUSTOMER_TRX

Line 70: trx_number ra_customer_trx.trx_number%type,

66:
67: TYPE select_ips_rec_type IS RECORD
68: (
69: customer_trx_id NUMBER(15),
70: trx_number ra_customer_trx.trx_number%type,
71: cust_trx_type_id NUMBER(15),
72: trx_type ra_cust_trx_types.type%type,
73: trx_date DATE,
74: gl_date DATE,

Line 78: currency_code ra_customer_trx.invoice_currency_code%type,

74: gl_date DATE,
75: customer_id NUMBER(15),
76: site_use_id NUMBER(15),
77: reversed_cash_receipt_id NUMBER(15),
78: currency_code ra_customer_trx.invoice_currency_code%type,
79: precision NUMBER,
80: min_acc_unit NUMBER,
81: exchange_rate_type ra_customer_trx.exchange_rate_type%type,
82: exchange_rate NUMBER,

Line 81: exchange_rate_type ra_customer_trx.exchange_rate_type%type,

77: reversed_cash_receipt_id NUMBER(15),
78: currency_code ra_customer_trx.invoice_currency_code%type,
79: precision NUMBER,
80: min_acc_unit NUMBER,
81: exchange_rate_type ra_customer_trx.exchange_rate_type%type,
82: exchange_rate NUMBER,
83: exchange_date DATE,
84: term_id NUMBER(15),
85: first_installment_code ra_terms.first_installment_code%type,

Line 100: trx_number ra_customer_trx.trx_number%type,

96:
97: TYPE select_ira_rec_type IS RECORD
98: (
99: customer_trx_id NUMBER(15),
100: trx_number ra_customer_trx.trx_number%type,
101: cust_trx_type_id NUMBER(15),
102: post_to_gl_flag ra_cust_trx_types.post_to_gl%type,
103: credit_method ra_customer_trx.credit_method_for_installments%type,
104: trx_date DATE,

Line 103: credit_method ra_customer_trx.credit_method_for_installments%type,

99: customer_trx_id NUMBER(15),
100: trx_number ra_customer_trx.trx_number%type,
101: cust_trx_type_id NUMBER(15),
102: post_to_gl_flag ra_cust_trx_types.post_to_gl%type,
103: credit_method ra_customer_trx.credit_method_for_installments%type,
104: trx_date DATE,
105: gl_date DATE,
106: customer_id NUMBER(15),
107: site_use_id NUMBER(15),

Line 108: currency_code ra_customer_trx.invoice_currency_code%type,

104: trx_date DATE,
105: gl_date DATE,
106: customer_id NUMBER(15),
107: site_use_id NUMBER(15),
108: currency_code ra_customer_trx.invoice_currency_code%type,
109: precision NUMBER,
110: min_acc_unit NUMBER,
111: exchange_rate_type ra_customer_trx.exchange_rate_type%type,
112: exchange_rate NUMBER,

Line 111: exchange_rate_type ra_customer_trx.exchange_rate_type%type,

107: site_use_id NUMBER(15),
108: currency_code ra_customer_trx.invoice_currency_code%type,
109: precision NUMBER,
110: min_acc_unit NUMBER,
111: exchange_rate_type ra_customer_trx.exchange_rate_type%type,
112: exchange_rate NUMBER,
113: exchange_date DATE,
114: rec_acctd_amount NUMBER,
115: total_cm_line_amount NUMBER,

Line 149: ps_currency_code ra_customer_trx.invoice_currency_code%type,

145: adjusted_trx_id NUMBER(15),
146: subsequent_trx_id NUMBER(15),
147: commitment_trx_id NUMBER(15),
148: commitment_type ra_cust_trx_types.type%type,
149: ps_currency_code ra_customer_trx.invoice_currency_code%type,
150: ps_exchange_rate NUMBER,
151: ps_precision NUMBER,
152: ps_min_acc_unit NUMBER,
153: code_combination_id NUMBER(15),

Line 183: ps_currency_code ra_customer_trx.invoice_currency_code%type,

179: precision NUMBER,
180: min_acc_unit NUMBER,
181: adjusted_trx_id NUMBER(15),
182: invoice_trx_id NUMBER(15),
183: ps_currency_code ra_customer_trx.invoice_currency_code%type,
184: ps_exchange_rate NUMBER,
185: ps_precision NUMBER,
186: ps_min_acc_unit NUMBER,
187: commitment_code NUMBER(15),

Line 530: ra_customer_trx ct,

526: FROM
527: ra_terms t,
528: ra_terms_lines tl,
529: ra_cust_trx_types ctt,
530: ra_customer_trx ct,
531: ra_cust_trx_line_gl_dist ctlgd,
532: fnd_currencies c,
533: ra_customer_trx_lines ctl
534: WHERE ct.customer_trx_id = :customer_trx_id

Line 533: ra_customer_trx_lines ctl

529: ra_cust_trx_types ctt,
530: ra_customer_trx ct,
531: ra_cust_trx_line_gl_dist ctlgd,
532: fnd_currencies c,
533: ra_customer_trx_lines ctl
534: WHERE ct.customer_trx_id = :customer_trx_id
535: AND ctl.customer_trx_id = ctlgd.customer_trx_id
536: AND ctlgd.account_class = ''REC''
537: AND ctlgd.latest_rec_flag = ''Y''

Line 1589: ra_customer_trx ct,

1585: ar_payment_schedules ps,
1586: ar_adjustments adj,
1587: ra_cust_trx_types ctt,
1588: ra_cust_trx_line_gl_dist ctlgd,
1589: ra_customer_trx ct,
1590: fnd_currencies c,
1591: fnd_currencies c_inv,
1592: ra_customer_trx ct_inv,
1593: ra_cust_trx_line_gl_dist ctlgd_inv,

Line 1592: ra_customer_trx ct_inv,

1588: ra_cust_trx_line_gl_dist ctlgd,
1589: ra_customer_trx ct,
1590: fnd_currencies c,
1591: fnd_currencies c_inv,
1592: ra_customer_trx ct_inv,
1593: ra_cust_trx_line_gl_dist ctlgd_inv,
1594: ra_customer_trx_lines ctl
1595: WHERE ct.customer_trx_id = :customer_trx_id
1596: and ctl.customer_trx_id = ct.customer_trx_id

Line 1594: ra_customer_trx_lines ctl

1590: fnd_currencies c,
1591: fnd_currencies c_inv,
1592: ra_customer_trx ct_inv,
1593: ra_cust_trx_line_gl_dist ctlgd_inv,
1594: ra_customer_trx_lines ctl
1595: WHERE ct.customer_trx_id = :customer_trx_id
1596: and ctl.customer_trx_id = ct.customer_trx_id
1597: AND ct.cust_trx_type_id = ctt.cust_trx_type_id
1598: AND ctt.type = ''CM''

Line 2854: from ra_customer_trx ct

2850:
2851: /*Bug :2246098-Used a bind var for insert*/
2852:
2853: select ct.default_ussgl_transaction_code into l_ussgl_transaction_code
2854: from ra_customer_trx ct
2855: WHERE ct.customer_trx_id=p_select_rec.customer_trx_id;
2856:
2857: dbms_sql.bind_variable( p_insert_ra_c,
2858: 'user_id',

Line 3634: ra_customer_trx ct_com,

3630: ar_adjustments adj,
3631: fnd_currencies c,
3632: ra_terms t,
3633: ra_terms_lines tl,
3634: ra_customer_trx ct_com,
3635: ra_customer_trx_lines ctl_com,
3636: ra_customer_trx ct_ps,
3637: fnd_currencies c_ps,
3638: ra_customer_trx_lines ctl,

Line 3635: ra_customer_trx_lines ctl_com,

3631: fnd_currencies c,
3632: ra_terms t,
3633: ra_terms_lines tl,
3634: ra_customer_trx ct_com,
3635: ra_customer_trx_lines ctl_com,
3636: ra_customer_trx ct_ps,
3637: fnd_currencies c_ps,
3638: ra_customer_trx_lines ctl,
3639: ra_customer_trx ct,

Line 3636: ra_customer_trx ct_ps,

3632: ra_terms t,
3633: ra_terms_lines tl,
3634: ra_customer_trx ct_com,
3635: ra_customer_trx_lines ctl_com,
3636: ra_customer_trx ct_ps,
3637: fnd_currencies c_ps,
3638: ra_customer_trx_lines ctl,
3639: ra_customer_trx ct,
3640: ra_cust_trx_line_gl_dist ctlgd

Line 3638: ra_customer_trx_lines ctl,

3634: ra_customer_trx ct_com,
3635: ra_customer_trx_lines ctl_com,
3636: ra_customer_trx ct_ps,
3637: fnd_currencies c_ps,
3638: ra_customer_trx_lines ctl,
3639: ra_customer_trx ct,
3640: ra_cust_trx_line_gl_dist ctlgd
3641: WHERE ct.customer_trx_id = :customer_trx_id
3642: and ctl.customer_trx_id = ct.customer_trx_id

Line 3639: ra_customer_trx ct,

3635: ra_customer_trx_lines ctl_com,
3636: ra_customer_trx ct_ps,
3637: fnd_currencies c_ps,
3638: ra_customer_trx_lines ctl,
3639: ra_customer_trx ct,
3640: ra_cust_trx_line_gl_dist ctlgd
3641: WHERE ct.customer_trx_id = :customer_trx_id
3642: and ctl.customer_trx_id = ct.customer_trx_id
3643: and ctlgd.customer_trx_id = ct.customer_trx_id

Line 3649: from ra_customer_trx trx

3645: and ctlgd.latest_rec_flag = ''Y''
3646: and ctl.line_type = ''LINE''
3647: and exists
3648: (select ''x''
3649: from ra_customer_trx trx
3650: where trx.customer_trx_id = ctl.customer_trx_id)
3651: and ctl.initial_customer_trx_line_id is not null
3652: and ct.invoice_currency_code = c.currency_code
3653: and ct.cust_trx_type_id = ctt.cust_trx_type_id

Line 4190: from ra_customer_trx_lines instead. */

4186: /* Bug 3570404
4187: Guarantees use SELECT in build_ups_sql differently.
4188: The joins to PS are for the GUAR rather than the target
4189: invoice. This means that we have to use the line totals
4190: from ra_customer_trx_lines instead. */
4191: l_line_remaining := p_select_rec.total_line_amount;
4192:
4193: /* Following columns are not used for GUARs - but
4194: I choose to initialize them for clarity */

Line 5211: ra_customer_trx ct_com,

5207: ar_adjustments adj,
5208: ar_adjustments adjd,
5209: fnd_currencies c,
5210: fnd_currencies c_ps,
5211: ra_customer_trx ct_com,
5212: ra_customer_trx ct_inv,
5213: ra_customer_trx_lines ctl,
5214: ra_customer_trx ct,
5215: ra_cust_trx_line_gl_dist ctlgd

Line 5212: ra_customer_trx ct_inv,

5208: ar_adjustments adjd,
5209: fnd_currencies c,
5210: fnd_currencies c_ps,
5211: ra_customer_trx ct_com,
5212: ra_customer_trx ct_inv,
5213: ra_customer_trx_lines ctl,
5214: ra_customer_trx ct,
5215: ra_cust_trx_line_gl_dist ctlgd
5216: WHERE ct.customer_trx_id = :customer_trx_id

Line 5213: ra_customer_trx_lines ctl,

5209: fnd_currencies c,
5210: fnd_currencies c_ps,
5211: ra_customer_trx ct_com,
5212: ra_customer_trx ct_inv,
5213: ra_customer_trx_lines ctl,
5214: ra_customer_trx ct,
5215: ra_cust_trx_line_gl_dist ctlgd
5216: WHERE ct.customer_trx_id = :customer_trx_id
5217: and ctl.customer_trx_id = ct.customer_trx_id

Line 5214: ra_customer_trx ct,

5210: fnd_currencies c_ps,
5211: ra_customer_trx ct_com,
5212: ra_customer_trx ct_inv,
5213: ra_customer_trx_lines ctl,
5214: ra_customer_trx ct,
5215: ra_cust_trx_line_gl_dist ctlgd
5216: WHERE ct.customer_trx_id = :customer_trx_id
5217: and ctl.customer_trx_id = ct.customer_trx_id
5218: and ctlgd.customer_trx_id = ct.customer_trx_id

Line 5224: from ra_customer_trx h

5220: and ctlgd.latest_rec_flag = ''Y''
5221: and ctl.line_type = ''LINE''
5222: and exists
5223: (select ''x''
5224: from ra_customer_trx h
5225: where h.customer_trx_id = ctl.customer_trx_id)
5226: and ct.invoice_currency_code = c.currency_code
5227: and ct.cust_trx_type_id = ctt.cust_trx_type_id
5228: and ctt.type = ''CM''

Line 5917: ra_customer_trx ocm

5913:
5914: select nvl(sum(adj.line_adjusted),0)
5915: into l_cm_adjustment_total
5916: from ar_adjustments adj,
5917: ra_customer_trx ocm
5918: where adj.customer_trx_id = p_select_rec.adjusted_trx_id
5919: and adj.subsequent_trx_id = ocm.customer_trx_id
5920: and ocm.previous_customer_trx_id = p_select_rec.invoice_trx_id;
5921: