APPS.FV_DUE_DATE_CALCULATION dependencies on AP_TERMS_LINES

Line 25: ap_terms_lines apl,

21: api.invoice_date
22: FROM
23: ap_invoices api,
24: ap_terms apt,
25: ap_terms_lines apl,
26: fv_terms_types fvt,
27: --ap_invoice_distributions aid,
28: ap_payment_schedules aps
29: WHERE api.cancelled_amount IS NULL

Line 56: FROM ap_terms_lines

52: FROM ap_payment_schedules aps2
53: WHERE aps2.invoice_id = api.invoice_id
54: AND checkrun_id IS NULL) -- modified for bug 5454497
55: AND 1 = ( SELECT COUNT(*)
56: FROM ap_terms_lines
57: WHERE term_id = apt.term_id)
58: AND api.invoice_id = aps.invoice_id
59: AND (NOT EXISTS ( SELECT 'x'
60: FROM fv_inv_selected_duedate fiv

Line 203: v_due_days ap_terms_lines.due_days%TYPE;

199: v_transaction_date rcv_transactions.transaction_date%TYPE;
200: v_transaction_id rcv_transactions.transaction_id%TYPE;
201: v_quantity rcv_transactions.quantity%TYPE;
202: v_quantity_billed po_line_locations.quantity_billed%TYPE;
203: v_due_days ap_terms_lines.due_days%TYPE;
204: --v_receipt_acceptance_days
205: --financials_system_parameters.receipt_acceptance_days%TYPE;
206: v_vendor_id NUMBER;
207: v_pay_thru_date ap_invoice_selection_criteria.pay_thru_date%TYPE;

Line 249: v_discount_days_2 ap_terms_lines.discount_days_2%TYPE;

245: l_module_name VARCHAR2(200);
246: l_save_date DATE;
247: v_second_disc_date ap_payment_schedules.second_discount_date%TYPE;
248: v_third_disc_date ap_payment_schedules.third_discount_date%TYPE;
249: v_discount_days_2 ap_terms_lines.discount_days_2%TYPE;
250: v_discount_days_3 ap_terms_lines.discount_days_3%TYPE;
251: v_new_second_disc_date date;
252: v_new_third_disc_date date;
253: v_2_disc_date_flag varchar2(1);

Line 250: v_discount_days_3 ap_terms_lines.discount_days_3%TYPE;

246: l_save_date DATE;
247: v_second_disc_date ap_payment_schedules.second_discount_date%TYPE;
248: v_third_disc_date ap_payment_schedules.third_discount_date%TYPE;
249: v_discount_days_2 ap_terms_lines.discount_days_2%TYPE;
250: v_discount_days_3 ap_terms_lines.discount_days_3%TYPE;
251: v_new_second_disc_date date;
252: v_new_third_disc_date date;
253: v_2_disc_date_flag varchar2(1);
254: v_3_disc_date_flag varchar2(1);

Line 340: FROM AP_TERMS_LINES

336: INTO v_due_days,
337: v_discount_days,
338: v_discount_days_2,
339: v_discount_days_3
340: FROM AP_TERMS_LINES
341: WHERE term_id = v_terms_id;
342:
343:
344: FND_FILE.PUT_LINE(FND_FILE.LOG,'Due days are '|| v_due_days);

Line 1013: errbuf := 'No Due date defined in AP_TERMS_LINES';

1009:
1010: WHEN NO_DATA_FOUND THEN
1011: retcode := -1;
1012: IF(x_err_code = 1) THEN
1013: errbuf := 'No Due date defined in AP_TERMS_LINES';
1014: ELSIF(x_err_code = 2) THEN
1015: errbuf := 'Receipt acceptance days is not defined in
1016: FINANCIAL_SYSTEM_PARAMETERS' ;
1017: ELSIF(x_err_code = 5) THEN