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_AUTOAPPLY_API dependencies on AR_PAYMENT_SCHEDULES

Line 118: customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE,

114: ref_trans_to_receipt_rate AR_CASH_REMIT_REFS.trans_to_receipt_rate%TYPE,
115: cash_receipt_id AR_CASH_RECEIPTS.cash_receipt_id%TYPE,
116: pay_from_customer AR_CASH_RECEIPTS.pay_from_customer%TYPE,
117: cr_customer_site_use_id AR_CASH_RECEIPTS.customer_site_use_id%TYPE,
118: customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE,
119: customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE,
120: customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE,
121: resolved_matching_number AR_PAYMENT_SCHEDULES.trx_number%TYPE,
122: terms_sequence_number AR_PAYMENT_SCHEDULES.terms_sequence_number%TYPE,

Line 119: customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE,

115: cash_receipt_id AR_CASH_RECEIPTS.cash_receipt_id%TYPE,
116: pay_from_customer AR_CASH_RECEIPTS.pay_from_customer%TYPE,
117: cr_customer_site_use_id AR_CASH_RECEIPTS.customer_site_use_id%TYPE,
118: customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE,
119: customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE,
120: customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE,
121: resolved_matching_number AR_PAYMENT_SCHEDULES.trx_number%TYPE,
122: terms_sequence_number AR_PAYMENT_SCHEDULES.terms_sequence_number%TYPE,
123: resolved_matching_date AR_PAYMENT_SCHEDULES.trx_date%TYPE,

Line 120: customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE,

116: pay_from_customer AR_CASH_RECEIPTS.pay_from_customer%TYPE,
117: cr_customer_site_use_id AR_CASH_RECEIPTS.customer_site_use_id%TYPE,
118: customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE,
119: customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE,
120: customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE,
121: resolved_matching_number AR_PAYMENT_SCHEDULES.trx_number%TYPE,
122: terms_sequence_number AR_PAYMENT_SCHEDULES.terms_sequence_number%TYPE,
123: resolved_matching_date AR_PAYMENT_SCHEDULES.trx_date%TYPE,
124: trx_date AR_PAYMENT_SCHEDULES.trx_date%TYPE,

Line 121: resolved_matching_number AR_PAYMENT_SCHEDULES.trx_number%TYPE,

117: cr_customer_site_use_id AR_CASH_RECEIPTS.customer_site_use_id%TYPE,
118: customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE,
119: customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE,
120: customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE,
121: resolved_matching_number AR_PAYMENT_SCHEDULES.trx_number%TYPE,
122: terms_sequence_number AR_PAYMENT_SCHEDULES.terms_sequence_number%TYPE,
123: resolved_matching_date AR_PAYMENT_SCHEDULES.trx_date%TYPE,
124: trx_date AR_PAYMENT_SCHEDULES.trx_date%TYPE,
125: resolved_matching_class AR_PAYMENT_SCHEDULES.class%TYPE,

Line 122: terms_sequence_number AR_PAYMENT_SCHEDULES.terms_sequence_number%TYPE,

118: customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE,
119: customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE,
120: customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE,
121: resolved_matching_number AR_PAYMENT_SCHEDULES.trx_number%TYPE,
122: terms_sequence_number AR_PAYMENT_SCHEDULES.terms_sequence_number%TYPE,
123: resolved_matching_date AR_PAYMENT_SCHEDULES.trx_date%TYPE,
124: trx_date AR_PAYMENT_SCHEDULES.trx_date%TYPE,
125: resolved_matching_class AR_PAYMENT_SCHEDULES.class%TYPE,
126: resolved_match_currency AR_PAYMENT_SCHEDULES.invoice_currency_code%TYPE,

Line 123: resolved_matching_date AR_PAYMENT_SCHEDULES.trx_date%TYPE,

119: customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE,
120: customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE,
121: resolved_matching_number AR_PAYMENT_SCHEDULES.trx_number%TYPE,
122: terms_sequence_number AR_PAYMENT_SCHEDULES.terms_sequence_number%TYPE,
123: resolved_matching_date AR_PAYMENT_SCHEDULES.trx_date%TYPE,
124: trx_date AR_PAYMENT_SCHEDULES.trx_date%TYPE,
125: resolved_matching_class AR_PAYMENT_SCHEDULES.class%TYPE,
126: resolved_match_currency AR_PAYMENT_SCHEDULES.invoice_currency_code%TYPE,
127: amount_due_original AR_PAYMENT_SCHEDULES.amount_due_original%TYPE,

Line 124: trx_date AR_PAYMENT_SCHEDULES.trx_date%TYPE,

120: customer_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE,
121: resolved_matching_number AR_PAYMENT_SCHEDULES.trx_number%TYPE,
122: terms_sequence_number AR_PAYMENT_SCHEDULES.terms_sequence_number%TYPE,
123: resolved_matching_date AR_PAYMENT_SCHEDULES.trx_date%TYPE,
124: trx_date AR_PAYMENT_SCHEDULES.trx_date%TYPE,
125: resolved_matching_class AR_PAYMENT_SCHEDULES.class%TYPE,
126: resolved_match_currency AR_PAYMENT_SCHEDULES.invoice_currency_code%TYPE,
127: amount_due_original AR_PAYMENT_SCHEDULES.amount_due_original%TYPE,
128: amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

Line 125: resolved_matching_class AR_PAYMENT_SCHEDULES.class%TYPE,

121: resolved_matching_number AR_PAYMENT_SCHEDULES.trx_number%TYPE,
122: terms_sequence_number AR_PAYMENT_SCHEDULES.terms_sequence_number%TYPE,
123: resolved_matching_date AR_PAYMENT_SCHEDULES.trx_date%TYPE,
124: trx_date AR_PAYMENT_SCHEDULES.trx_date%TYPE,
125: resolved_matching_class AR_PAYMENT_SCHEDULES.class%TYPE,
126: resolved_match_currency AR_PAYMENT_SCHEDULES.invoice_currency_code%TYPE,
127: amount_due_original AR_PAYMENT_SCHEDULES.amount_due_original%TYPE,
128: amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
129: discount_taken_earned AR_PAYMENT_SCHEDULES.discount_taken_earned%TYPE,

Line 126: resolved_match_currency AR_PAYMENT_SCHEDULES.invoice_currency_code%TYPE,

122: terms_sequence_number AR_PAYMENT_SCHEDULES.terms_sequence_number%TYPE,
123: resolved_matching_date AR_PAYMENT_SCHEDULES.trx_date%TYPE,
124: trx_date AR_PAYMENT_SCHEDULES.trx_date%TYPE,
125: resolved_matching_class AR_PAYMENT_SCHEDULES.class%TYPE,
126: resolved_match_currency AR_PAYMENT_SCHEDULES.invoice_currency_code%TYPE,
127: amount_due_original AR_PAYMENT_SCHEDULES.amount_due_original%TYPE,
128: amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
129: discount_taken_earned AR_PAYMENT_SCHEDULES.discount_taken_earned%TYPE,
130: discount_taken_unearned AR_PAYMENT_SCHEDULES.discount_taken_unearned%TYPE,

Line 127: amount_due_original AR_PAYMENT_SCHEDULES.amount_due_original%TYPE,

123: resolved_matching_date AR_PAYMENT_SCHEDULES.trx_date%TYPE,
124: trx_date AR_PAYMENT_SCHEDULES.trx_date%TYPE,
125: resolved_matching_class AR_PAYMENT_SCHEDULES.class%TYPE,
126: resolved_match_currency AR_PAYMENT_SCHEDULES.invoice_currency_code%TYPE,
127: amount_due_original AR_PAYMENT_SCHEDULES.amount_due_original%TYPE,
128: amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
129: discount_taken_earned AR_PAYMENT_SCHEDULES.discount_taken_earned%TYPE,
130: discount_taken_unearned AR_PAYMENT_SCHEDULES.discount_taken_unearned%TYPE,
131: amount_applied AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

Line 128: amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

124: trx_date AR_PAYMENT_SCHEDULES.trx_date%TYPE,
125: resolved_matching_class AR_PAYMENT_SCHEDULES.class%TYPE,
126: resolved_match_currency AR_PAYMENT_SCHEDULES.invoice_currency_code%TYPE,
127: amount_due_original AR_PAYMENT_SCHEDULES.amount_due_original%TYPE,
128: amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
129: discount_taken_earned AR_PAYMENT_SCHEDULES.discount_taken_earned%TYPE,
130: discount_taken_unearned AR_PAYMENT_SCHEDULES.discount_taken_unearned%TYPE,
131: amount_applied AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
132: trans_to_receipt_rate AR_CASH_REMIT_REFS.trans_to_receipt_rate%TYPE,

Line 129: discount_taken_earned AR_PAYMENT_SCHEDULES.discount_taken_earned%TYPE,

125: resolved_matching_class AR_PAYMENT_SCHEDULES.class%TYPE,
126: resolved_match_currency AR_PAYMENT_SCHEDULES.invoice_currency_code%TYPE,
127: amount_due_original AR_PAYMENT_SCHEDULES.amount_due_original%TYPE,
128: amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
129: discount_taken_earned AR_PAYMENT_SCHEDULES.discount_taken_earned%TYPE,
130: discount_taken_unearned AR_PAYMENT_SCHEDULES.discount_taken_unearned%TYPE,
131: amount_applied AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
132: trans_to_receipt_rate AR_CASH_REMIT_REFS.trans_to_receipt_rate%TYPE,
133: amount_applied_from AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

Line 130: discount_taken_unearned AR_PAYMENT_SCHEDULES.discount_taken_unearned%TYPE,

126: resolved_match_currency AR_PAYMENT_SCHEDULES.invoice_currency_code%TYPE,
127: amount_due_original AR_PAYMENT_SCHEDULES.amount_due_original%TYPE,
128: amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
129: discount_taken_earned AR_PAYMENT_SCHEDULES.discount_taken_earned%TYPE,
130: discount_taken_unearned AR_PAYMENT_SCHEDULES.discount_taken_unearned%TYPE,
131: amount_applied AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
132: trans_to_receipt_rate AR_CASH_REMIT_REFS.trans_to_receipt_rate%TYPE,
133: amount_applied_from AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
134: payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE,

Line 131: amount_applied AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

127: amount_due_original AR_PAYMENT_SCHEDULES.amount_due_original%TYPE,
128: amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
129: discount_taken_earned AR_PAYMENT_SCHEDULES.discount_taken_earned%TYPE,
130: discount_taken_unearned AR_PAYMENT_SCHEDULES.discount_taken_unearned%TYPE,
131: amount_applied AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
132: trans_to_receipt_rate AR_CASH_REMIT_REFS.trans_to_receipt_rate%TYPE,
133: amount_applied_from AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
134: payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE,
135: cons_inv_id AR_CASH_RECOS.cons_inv_id%TYPE,

Line 133: amount_applied_from AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

129: discount_taken_earned AR_PAYMENT_SCHEDULES.discount_taken_earned%TYPE,
130: discount_taken_unearned AR_PAYMENT_SCHEDULES.discount_taken_unearned%TYPE,
131: amount_applied AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
132: trans_to_receipt_rate AR_CASH_REMIT_REFS.trans_to_receipt_rate%TYPE,
133: amount_applied_from AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
134: payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE,
135: cons_inv_id AR_CASH_RECOS.cons_inv_id%TYPE,
136: match_score_value AR_CASH_RECOS.match_score_value%TYPE,
137: org_id AR_PAYMENT_SCHEDULES.org_id%TYPE,

Line 134: payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE,

130: discount_taken_unearned AR_PAYMENT_SCHEDULES.discount_taken_unearned%TYPE,
131: amount_applied AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
132: trans_to_receipt_rate AR_CASH_REMIT_REFS.trans_to_receipt_rate%TYPE,
133: amount_applied_from AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
134: payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE,
135: cons_inv_id AR_CASH_RECOS.cons_inv_id%TYPE,
136: match_score_value AR_CASH_RECOS.match_score_value%TYPE,
137: org_id AR_PAYMENT_SCHEDULES.org_id%TYPE,
138: term_id AR_PAYMENT_SCHEDULES.term_id%TYPE,

Line 137: org_id AR_PAYMENT_SCHEDULES.org_id%TYPE,

133: amount_applied_from AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
134: payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE,
135: cons_inv_id AR_CASH_RECOS.cons_inv_id%TYPE,
136: match_score_value AR_CASH_RECOS.match_score_value%TYPE,
137: org_id AR_PAYMENT_SCHEDULES.org_id%TYPE,
138: term_id AR_PAYMENT_SCHEDULES.term_id%TYPE,
139: automatch_id AR_CASH_AUTOMATCHES.automatch_id%TYPE,
140: use_matching_date AR_CASH_AUTOMATCHES.use_matching_date%TYPE,
141: use_matching_amount AR_CASH_AUTOMATCHES.use_matching_amount%TYPE,

Line 138: term_id AR_PAYMENT_SCHEDULES.term_id%TYPE,

134: payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE,
135: cons_inv_id AR_CASH_RECOS.cons_inv_id%TYPE,
136: match_score_value AR_CASH_RECOS.match_score_value%TYPE,
137: org_id AR_PAYMENT_SCHEDULES.org_id%TYPE,
138: term_id AR_PAYMENT_SCHEDULES.term_id%TYPE,
139: automatch_id AR_CASH_AUTOMATCHES.automatch_id%TYPE,
140: use_matching_date AR_CASH_AUTOMATCHES.use_matching_date%TYPE,
141: use_matching_amount AR_CASH_AUTOMATCHES.use_matching_amount%TYPE,
142: auto_match_threshold AR_CASH_AUTOMATCHES.auto_match_threshold%TYPE,

Line 272: , p_inv_curr_code IN ar_payment_schedules.invoice_currency_code%TYPE

268: RETURN NUMBER;
269:
270: FUNCTION get_cross_curr_rate(p_amount_applied IN ar_cash_remit_refs.amount_applied%TYPE
271: , p_amount_applied_from IN ar_cash_remit_refs.amount_applied_from%TYPE
272: , p_inv_curr_code IN ar_payment_schedules.invoice_currency_code%TYPE
273: , p_rec_curr_code IN ar_cash_receipts.currency_code%TYPE)
274: RETURN NUMBER;
275:
276: END ARP_AUTOAPPLY_API;