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_CUST_TRX_TYPES

Line 72: trx_type ra_cust_trx_types.type%type,

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,
75: customer_id NUMBER(15),
76: site_use_id NUMBER(15),

Line 102: post_to_gl_flag ra_cust_trx_types.post_to_gl%type,

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,
105: gl_date DATE,
106: customer_id NUMBER(15),

Line 140: post_to_gl_flag ra_cust_trx_types.post_to_gl%type,

136: TYPE select_ups_rec_type IS RECORD
137: (
138: set_of_books_id NUMBER(15),
139: customer_trx_id NUMBER(15),
140: post_to_gl_flag ra_cust_trx_types.post_to_gl%type,
141: trx_date DATE,
142: gl_date DATE,
143: precision NUMBER,
144: min_acc_unit NUMBER,

Line 148: commitment_type ra_cust_trx_types.type%type,

144: min_acc_unit NUMBER,
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,

Line 163: allocate_tax_freight ra_cust_trx_types_all.allocate_tax_freight%type,

159: acctd_amt_due_rem NUMBER,
160: line_remaining NUMBER,
161: amount_adjusted NUMBER,
162: percent NUMBER,
163: allocate_tax_freight ra_cust_trx_types_all.allocate_tax_freight%type,
164: adjustment_type ar_adjustments_all.type%type,
165: tax_remaining NUMBER,
166: freight_remaining NUMBER,
167: total_tax_amount NUMBER,

Line 176: post_to_gl_flag ra_cust_trx_types.post_to_gl%type,

172: TYPE select_iad_rec_type IS RECORD
173: (
174: set_of_books_id NUMBER(15),
175: customer_trx_id NUMBER(15),
176: post_to_gl_flag ra_cust_trx_types.post_to_gl%type,
177: trx_date DATE,
178: gl_date DATE,
179: precision NUMBER,
180: min_acc_unit NUMBER,

Line 204: allocate_tax_freight ra_cust_trx_types.allocate_tax_freight%type,

200: ps_tax_remaining NUMBER,
201: ps_freight_original NUMBER,
202: ps_freight_remaining NUMBER,
203: ps_amount_adjusted NUMBER,
204: allocate_tax_freight ra_cust_trx_types.allocate_tax_freight%type,
205: adjustment_type ar_adjustments.type%type,
206: total_cm_tax_amount NUMBER,
207: total_cm_frt_amount NUMBER,
208: -- total_inv_line_adj NUMBER,

Line 521: ra_cust_trx_types ctt,

517: ct.reversed_cash_receipt_id /* Bug3328690 */
518: FROM
519: ra_terms t,
520: ra_terms_lines tl,
521: ra_cust_trx_types ctt,
522: ra_customer_trx ct,
523: ra_cust_trx_line_gl_dist ctlgd,
524: fnd_currencies c,
525: ra_customer_trx_lines ctl

Line 1579: ra_cust_trx_types ctt,

1575: FROM
1576: ar_receivable_applications ra,
1577: ar_payment_schedules ps,
1578: ar_adjustments adj,
1579: ra_cust_trx_types ctt,
1580: ra_cust_trx_line_gl_dist ctlgd,
1581: ra_customer_trx ct,
1582: fnd_currencies c,
1583: fnd_currencies c_inv,

Line 3617: ra_cust_trx_types ctt,

3613: nvl(ps.freight_remaining, 0),
3614: ARPT_SQL_FUNC_UTIL.get_sum_of_trx_lines(ctl.customer_trx_id, ''TAX''),
3615: ARPT_SQL_FUNC_UTIL.get_sum_of_trx_lines(ctl.customer_trx_id, ''FREIGHT'')
3616: FROM
3617: ra_cust_trx_types ctt,
3618: ra_cust_trx_types ctt_com,
3619: ra_cust_trx_line_gl_dist ctlgd_com,
3620: ar_payment_schedules ps,
3621: ar_receivable_applications ra,

Line 3618: ra_cust_trx_types ctt_com,

3614: ARPT_SQL_FUNC_UTIL.get_sum_of_trx_lines(ctl.customer_trx_id, ''TAX''),
3615: ARPT_SQL_FUNC_UTIL.get_sum_of_trx_lines(ctl.customer_trx_id, ''FREIGHT'')
3616: FROM
3617: ra_cust_trx_types ctt,
3618: ra_cust_trx_types ctt_com,
3619: ra_cust_trx_line_gl_dist ctlgd_com,
3620: ar_payment_schedules ps,
3621: ar_receivable_applications ra,
3622: ar_adjustments adj,

Line 5192: ra_cust_trx_types ctt_com,

5188: NVL(ps.freight_remaining, 0),
5189: NVL(ps.tax_original, 0),
5190: NVL(ps.freight_original, 0)
5191: FROM
5192: ra_cust_trx_types ctt_com,
5193: ra_cust_trx_types ctt,
5194: ra_cust_trx_line_gl_dist ctlgd_com,
5195: ar_payment_schedules ps,
5196: ar_payment_schedules ps_inv,

Line 5193: ra_cust_trx_types ctt,

5189: NVL(ps.tax_original, 0),
5190: NVL(ps.freight_original, 0)
5191: FROM
5192: ra_cust_trx_types ctt_com,
5193: ra_cust_trx_types ctt,
5194: ra_cust_trx_line_gl_dist ctlgd_com,
5195: ar_payment_schedules ps,
5196: ar_payment_schedules ps_inv,
5197: ar_receivable_applications ra,

Line 5777: b. IF ra_cust_trx_types.allocate_tax_freight = 'Y'

5773: a. LINE
5774: i. CALCULATE adj total for lines
5775: ii. IF it >= current amount adjusted, REVERSE existing adj
5776: iii.ELSE DISTRIBUTE amount across terms
5777: b. IF ra_cust_trx_types.allocate_tax_freight = 'Y'
5778: i. TAX
5779: A. CALCULATE adj total for tax
5780: B. If adj >= current amount adjusted, REVERSE existing adj
5781: C. ELSE DISTRIBUTE amount across terms