DBA Data[Home] [Help]

APPS.ARP_AUTOAPPLY_API dependencies on AR_CASH_RECEIPTS

Line 115: cash_receipt_id AR_CASH_RECEIPTS.cash_receipt_id%TYPE,

111: remit_reference_id AR_CASH_REMIT_REFS.remit_reference_id%TYPE,
112: ref_amount_applied AR_CASH_REMIT_REFS.amount_applied%TYPE,
113: ref_amount_applied_from AR_CASH_REMIT_REFS.amount_applied_from%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,

Line 116: pay_from_customer AR_CASH_RECEIPTS.pay_from_customer%TYPE,

112: ref_amount_applied AR_CASH_REMIT_REFS.amount_applied%TYPE,
113: ref_amount_applied_from AR_CASH_REMIT_REFS.amount_applied_from%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,

Line 117: cr_customer_site_use_id AR_CASH_RECEIPTS.customer_site_use_id%TYPE,

113: ref_amount_applied_from AR_CASH_REMIT_REFS.amount_applied_from%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,

Line 144: receipt_currency_code AR_CASH_RECEIPTS.currency_code%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,
148: reco_num NUMBER

Line 145: receipt_date AR_CASH_RECEIPTS.receipt_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,
148: reco_num NUMBER
149: );

Line 273: , p_rec_curr_code IN ar_cash_receipts.currency_code%TYPE)

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;