DBA Data[Home] [Help]

APPS.ARP_AUTOAPPLY_API dependencies on AR_CASH_RECOS

Line 135: cons_inv_id AR_CASH_RECOS.cons_inv_id%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,
139: automatch_id AR_CASH_AUTOMATCHES.automatch_id%TYPE,

Line 136: match_score_value AR_CASH_RECOS.match_score_value%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,
139: automatch_id AR_CASH_AUTOMATCHES.automatch_id%TYPE,
140: use_matching_date AR_CASH_AUTOMATCHES.use_matching_date%TYPE,

Line 143: priority AR_CASH_RECOS.priority%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,
143: priority AR_CASH_RECOS.priority%TYPE,
144: receipt_currency_code AR_CASH_RECEIPTS.currency_code%TYPE,
145: receipt_date AR_CASH_RECEIPTS.receipt_date%TYPE,
146: allow_overapplication_flag RA_CUST_TRX_TYPES.allow_overapplication_flag%TYPE,
147: partial_discount_flag RA_TERMS.partial_discount_flag%TYPE,

Line 153: TYPE reco_id_tab IS TABLE OF ar_cash_recos.recommendation_id%TYPE

149: );
150:
151: TYPE selected_recos_table IS TABLE OF selected_recos INDEX BY BINARY_INTEGER;
152:
153: TYPE reco_id_tab IS TABLE OF ar_cash_recos.recommendation_id%TYPE
154: INDEX BY BINARY_INTEGER;
155: TYPE remit_ref_id_tab IS TABLE OF ar_cash_recos.remit_reference_id%TYPE
156: INDEX BY BINARY_INTEGER;
157: TYPE customer_id_tab IS TABLE OF ar_cash_recos.pay_from_customer%TYPE

Line 155: TYPE remit_ref_id_tab IS TABLE OF ar_cash_recos.remit_reference_id%TYPE

151: TYPE selected_recos_table IS TABLE OF selected_recos INDEX BY BINARY_INTEGER;
152:
153: TYPE reco_id_tab IS TABLE OF ar_cash_recos.recommendation_id%TYPE
154: INDEX BY BINARY_INTEGER;
155: TYPE remit_ref_id_tab IS TABLE OF ar_cash_recos.remit_reference_id%TYPE
156: INDEX BY BINARY_INTEGER;
157: TYPE customer_id_tab IS TABLE OF ar_cash_recos.pay_from_customer%TYPE
158: INDEX BY BINARY_INTEGER;
159: TYPE customer_site_use_id_tab IS TABLE OF ar_cash_recos.customer_site_use_id%TYPE

Line 157: TYPE customer_id_tab IS TABLE OF ar_cash_recos.pay_from_customer%TYPE

153: TYPE reco_id_tab IS TABLE OF ar_cash_recos.recommendation_id%TYPE
154: INDEX BY BINARY_INTEGER;
155: TYPE remit_ref_id_tab IS TABLE OF ar_cash_recos.remit_reference_id%TYPE
156: INDEX BY BINARY_INTEGER;
157: TYPE customer_id_tab IS TABLE OF ar_cash_recos.pay_from_customer%TYPE
158: INDEX BY BINARY_INTEGER;
159: TYPE customer_site_use_id_tab IS TABLE OF ar_cash_recos.customer_site_use_id%TYPE
160: INDEX BY BINARY_INTEGER;
161: TYPE resolved_matching_number_tab IS TABLE OF ar_cash_recos.resolved_matching_number%TYPE

Line 159: TYPE customer_site_use_id_tab IS TABLE OF ar_cash_recos.customer_site_use_id%TYPE

155: TYPE remit_ref_id_tab IS TABLE OF ar_cash_recos.remit_reference_id%TYPE
156: INDEX BY BINARY_INTEGER;
157: TYPE customer_id_tab IS TABLE OF ar_cash_recos.pay_from_customer%TYPE
158: INDEX BY BINARY_INTEGER;
159: TYPE customer_site_use_id_tab IS TABLE OF ar_cash_recos.customer_site_use_id%TYPE
160: INDEX BY BINARY_INTEGER;
161: TYPE resolved_matching_number_tab IS TABLE OF ar_cash_recos.resolved_matching_number%TYPE
162: INDEX BY BINARY_INTEGER;
163: TYPE resolved_matching_date_tab IS TABLE OF ar_cash_recos.resolved_matching_date%TYPE

Line 161: TYPE resolved_matching_number_tab IS TABLE OF ar_cash_recos.resolved_matching_number%TYPE

157: TYPE customer_id_tab IS TABLE OF ar_cash_recos.pay_from_customer%TYPE
158: INDEX BY BINARY_INTEGER;
159: TYPE customer_site_use_id_tab IS TABLE OF ar_cash_recos.customer_site_use_id%TYPE
160: INDEX BY BINARY_INTEGER;
161: TYPE resolved_matching_number_tab IS TABLE OF ar_cash_recos.resolved_matching_number%TYPE
162: INDEX BY BINARY_INTEGER;
163: TYPE resolved_matching_date_tab IS TABLE OF ar_cash_recos.resolved_matching_date%TYPE
164: INDEX BY BINARY_INTEGER;
165: TYPE resolved_matching_class_tab IS TABLE OF ar_cash_recos.resolved_matching_class%TYPE

Line 163: TYPE resolved_matching_date_tab IS TABLE OF ar_cash_recos.resolved_matching_date%TYPE

159: TYPE customer_site_use_id_tab IS TABLE OF ar_cash_recos.customer_site_use_id%TYPE
160: INDEX BY BINARY_INTEGER;
161: TYPE resolved_matching_number_tab IS TABLE OF ar_cash_recos.resolved_matching_number%TYPE
162: INDEX BY BINARY_INTEGER;
163: TYPE resolved_matching_date_tab IS TABLE OF ar_cash_recos.resolved_matching_date%TYPE
164: INDEX BY BINARY_INTEGER;
165: TYPE resolved_matching_class_tab IS TABLE OF ar_cash_recos.resolved_matching_class%TYPE
166: INDEX BY BINARY_INTEGER;
167: TYPE resolved_match_currency_tab IS TABLE OF ar_cash_recos.resolved_match_currency%TYPE

Line 165: TYPE resolved_matching_class_tab IS TABLE OF ar_cash_recos.resolved_matching_class%TYPE

161: TYPE resolved_matching_number_tab IS TABLE OF ar_cash_recos.resolved_matching_number%TYPE
162: INDEX BY BINARY_INTEGER;
163: TYPE resolved_matching_date_tab IS TABLE OF ar_cash_recos.resolved_matching_date%TYPE
164: INDEX BY BINARY_INTEGER;
165: TYPE resolved_matching_class_tab IS TABLE OF ar_cash_recos.resolved_matching_class%TYPE
166: INDEX BY BINARY_INTEGER;
167: TYPE resolved_match_currency_tab IS TABLE OF ar_cash_recos.resolved_match_currency%TYPE
168: INDEX BY BINARY_INTEGER;
169: TYPE match_resolved_using_tab IS TABLE OF ar_cash_recos.match_resolved_using%TYPE

Line 167: TYPE resolved_match_currency_tab IS TABLE OF ar_cash_recos.resolved_match_currency%TYPE

163: TYPE resolved_matching_date_tab IS TABLE OF ar_cash_recos.resolved_matching_date%TYPE
164: INDEX BY BINARY_INTEGER;
165: TYPE resolved_matching_class_tab IS TABLE OF ar_cash_recos.resolved_matching_class%TYPE
166: INDEX BY BINARY_INTEGER;
167: TYPE resolved_match_currency_tab IS TABLE OF ar_cash_recos.resolved_match_currency%TYPE
168: INDEX BY BINARY_INTEGER;
169: TYPE match_resolved_using_tab IS TABLE OF ar_cash_recos.match_resolved_using%TYPE
170: INDEX BY BINARY_INTEGER;
171: TYPE cons_inv_id_tab IS TABLE OF ar_cash_recos.cons_inv_id%TYPE

Line 169: TYPE match_resolved_using_tab IS TABLE OF ar_cash_recos.match_resolved_using%TYPE

165: TYPE resolved_matching_class_tab IS TABLE OF ar_cash_recos.resolved_matching_class%TYPE
166: INDEX BY BINARY_INTEGER;
167: TYPE resolved_match_currency_tab IS TABLE OF ar_cash_recos.resolved_match_currency%TYPE
168: INDEX BY BINARY_INTEGER;
169: TYPE match_resolved_using_tab IS TABLE OF ar_cash_recos.match_resolved_using%TYPE
170: INDEX BY BINARY_INTEGER;
171: TYPE cons_inv_id_tab IS TABLE OF ar_cash_recos.cons_inv_id%TYPE
172: INDEX BY BINARY_INTEGER;
173: TYPE match_score_value_tab IS TABLE OF ar_cash_recos.match_score_value%TYPE

Line 171: TYPE cons_inv_id_tab IS TABLE OF ar_cash_recos.cons_inv_id%TYPE

167: TYPE resolved_match_currency_tab IS TABLE OF ar_cash_recos.resolved_match_currency%TYPE
168: INDEX BY BINARY_INTEGER;
169: TYPE match_resolved_using_tab IS TABLE OF ar_cash_recos.match_resolved_using%TYPE
170: INDEX BY BINARY_INTEGER;
171: TYPE cons_inv_id_tab IS TABLE OF ar_cash_recos.cons_inv_id%TYPE
172: INDEX BY BINARY_INTEGER;
173: TYPE match_score_value_tab IS TABLE OF ar_cash_recos.match_score_value%TYPE
174: INDEX BY BINARY_INTEGER;
175: TYPE match_reason_code_tab IS TABLE OF ar_cash_recos.match_reason_code%TYPE

Line 173: TYPE match_score_value_tab IS TABLE OF ar_cash_recos.match_score_value%TYPE

169: TYPE match_resolved_using_tab IS TABLE OF ar_cash_recos.match_resolved_using%TYPE
170: INDEX BY BINARY_INTEGER;
171: TYPE cons_inv_id_tab IS TABLE OF ar_cash_recos.cons_inv_id%TYPE
172: INDEX BY BINARY_INTEGER;
173: TYPE match_score_value_tab IS TABLE OF ar_cash_recos.match_score_value%TYPE
174: INDEX BY BINARY_INTEGER;
175: TYPE match_reason_code_tab IS TABLE OF ar_cash_recos.match_reason_code%TYPE
176: INDEX BY BINARY_INTEGER;
177: TYPE org_id_tab IS TABLE OF ar_cash_recos.org_id%TYPE

Line 175: TYPE match_reason_code_tab IS TABLE OF ar_cash_recos.match_reason_code%TYPE

171: TYPE cons_inv_id_tab IS TABLE OF ar_cash_recos.cons_inv_id%TYPE
172: INDEX BY BINARY_INTEGER;
173: TYPE match_score_value_tab IS TABLE OF ar_cash_recos.match_score_value%TYPE
174: INDEX BY BINARY_INTEGER;
175: TYPE match_reason_code_tab IS TABLE OF ar_cash_recos.match_reason_code%TYPE
176: INDEX BY BINARY_INTEGER;
177: TYPE org_id_tab IS TABLE OF ar_cash_recos.org_id%TYPE
178: INDEX BY BINARY_INTEGER;
179: TYPE automatch_id_tab IS TABLE OF ar_cash_recos.automatch_id%TYPE

Line 177: TYPE org_id_tab IS TABLE OF ar_cash_recos.org_id%TYPE

173: TYPE match_score_value_tab IS TABLE OF ar_cash_recos.match_score_value%TYPE
174: INDEX BY BINARY_INTEGER;
175: TYPE match_reason_code_tab IS TABLE OF ar_cash_recos.match_reason_code%TYPE
176: INDEX BY BINARY_INTEGER;
177: TYPE org_id_tab IS TABLE OF ar_cash_recos.org_id%TYPE
178: INDEX BY BINARY_INTEGER;
179: TYPE automatch_id_tab IS TABLE OF ar_cash_recos.automatch_id%TYPE
180: INDEX BY BINARY_INTEGER;
181: TYPE priority_tab IS TABLE OF ar_cash_recos.priority%TYPE

Line 179: TYPE automatch_id_tab IS TABLE OF ar_cash_recos.automatch_id%TYPE

175: TYPE match_reason_code_tab IS TABLE OF ar_cash_recos.match_reason_code%TYPE
176: INDEX BY BINARY_INTEGER;
177: TYPE org_id_tab IS TABLE OF ar_cash_recos.org_id%TYPE
178: INDEX BY BINARY_INTEGER;
179: TYPE automatch_id_tab IS TABLE OF ar_cash_recos.automatch_id%TYPE
180: INDEX BY BINARY_INTEGER;
181: TYPE priority_tab IS TABLE OF ar_cash_recos.priority%TYPE
182: INDEX BY BINARY_INTEGER;
183:

Line 181: TYPE priority_tab IS TABLE OF ar_cash_recos.priority%TYPE

177: TYPE org_id_tab IS TABLE OF ar_cash_recos.org_id%TYPE
178: INDEX BY BINARY_INTEGER;
179: TYPE automatch_id_tab IS TABLE OF ar_cash_recos.automatch_id%TYPE
180: INDEX BY BINARY_INTEGER;
181: TYPE priority_tab IS TABLE OF ar_cash_recos.priority%TYPE
182: INDEX BY BINARY_INTEGER;
183:
184:
185: TYPE reco_num_tab IS TABLE OF ar_cash_reco_lines.line_number%TYPE