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.AP_CREATE_PAY_SCHEDS_PKG dependencies on AP_TERMS

Line 85: (DECODE(ap_terms_lines.due_days,

81: END IF;
82:
83: -- bug2682782 deleted needless least function
84: SELECT NVL(fixed_date,
85: (DECODE(ap_terms_lines.due_days,
86: NULL,TO_DATE(TO_CHAR(LEAST(NVL(ap_terms_lines.due_day_of_month,32),
87: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS(P_Terms_Date,
88: NVL(ap_terms_lines.due_months_forward,0) +
89: DECODE(ap_terms.due_cutoff_day, NULL, 0,

Line 86: NULL,TO_DATE(TO_CHAR(LEAST(NVL(ap_terms_lines.due_day_of_month,32),

82:
83: -- bug2682782 deleted needless least function
84: SELECT NVL(fixed_date,
85: (DECODE(ap_terms_lines.due_days,
86: NULL,TO_DATE(TO_CHAR(LEAST(NVL(ap_terms_lines.due_day_of_month,32),
87: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS(P_Terms_Date,
88: NVL(ap_terms_lines.due_months_forward,0) +
89: DECODE(ap_terms.due_cutoff_day, NULL, 0,
90: DECODE(GREATEST(NVL(ap_terms.due_cutoff_day, 32),

Line 88: NVL(ap_terms_lines.due_months_forward,0) +

84: SELECT NVL(fixed_date,
85: (DECODE(ap_terms_lines.due_days,
86: NULL,TO_DATE(TO_CHAR(LEAST(NVL(ap_terms_lines.due_day_of_month,32),
87: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS(P_Terms_Date,
88: NVL(ap_terms_lines.due_months_forward,0) +
89: DECODE(ap_terms.due_cutoff_day, NULL, 0,
90: DECODE(GREATEST(NVL(ap_terms.due_cutoff_day, 32),
91: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
92: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))

Line 89: DECODE(ap_terms.due_cutoff_day, NULL, 0,

85: (DECODE(ap_terms_lines.due_days,
86: NULL,TO_DATE(TO_CHAR(LEAST(NVL(ap_terms_lines.due_day_of_month,32),
87: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS(P_Terms_Date,
88: NVL(ap_terms_lines.due_months_forward,0) +
89: DECODE(ap_terms.due_cutoff_day, NULL, 0,
90: DECODE(GREATEST(NVL(ap_terms.due_cutoff_day, 32),
91: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
92: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))
93: , 1, 0)))), 'DD')))) || '-' ||

Line 90: DECODE(GREATEST(NVL(ap_terms.due_cutoff_day, 32),

86: NULL,TO_DATE(TO_CHAR(LEAST(NVL(ap_terms_lines.due_day_of_month,32),
87: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS(P_Terms_Date,
88: NVL(ap_terms_lines.due_months_forward,0) +
89: DECODE(ap_terms.due_cutoff_day, NULL, 0,
90: DECODE(GREATEST(NVL(ap_terms.due_cutoff_day, 32),
91: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
92: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))
93: , 1, 0)))), 'DD')))) || '-' ||
94: TO_CHAR(ADD_MONTHS(P_Terms_Date,

Line 95: NVL(ap_terms_lines.due_months_forward,0) +

91: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
92: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))
93: , 1, 0)))), 'DD')))) || '-' ||
94: TO_CHAR(ADD_MONTHS(P_Terms_Date,
95: NVL(ap_terms_lines.due_months_forward,0) +
96: DECODE(ap_terms.due_cutoff_day, NULL, 0,
97: DECODE(GREATEST(NVL(ap_terms.due_cutoff_day, 32),
98: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
99: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD')), 1, 0))),

Line 96: DECODE(ap_terms.due_cutoff_day, NULL, 0,

92: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))
93: , 1, 0)))), 'DD')))) || '-' ||
94: TO_CHAR(ADD_MONTHS(P_Terms_Date,
95: NVL(ap_terms_lines.due_months_forward,0) +
96: DECODE(ap_terms.due_cutoff_day, NULL, 0,
97: DECODE(GREATEST(NVL(ap_terms.due_cutoff_day, 32),
98: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
99: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD')), 1, 0))),
100: 'MON-RR'),'DD-MON-RR'), /*bugfix:5647464 */

Line 97: DECODE(GREATEST(NVL(ap_terms.due_cutoff_day, 32),

93: , 1, 0)))), 'DD')))) || '-' ||
94: TO_CHAR(ADD_MONTHS(P_Terms_Date,
95: NVL(ap_terms_lines.due_months_forward,0) +
96: DECODE(ap_terms.due_cutoff_day, NULL, 0,
97: DECODE(GREATEST(NVL(ap_terms.due_cutoff_day, 32),
98: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
99: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD')), 1, 0))),
100: 'MON-RR'),'DD-MON-RR'), /*bugfix:5647464 */
101: trunc(P_Terms_Date) /*bug 8522014*/ + NVL(ap_terms_lines.due_days,0))))

Line 101: trunc(P_Terms_Date) /bug 8522014/ + NVL(ap_terms_lines.due_days,0))))

97: DECODE(GREATEST(NVL(ap_terms.due_cutoff_day, 32),
98: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
99: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD')), 1, 0))),
100: 'MON-RR'),'DD-MON-RR'), /*bugfix:5647464 */
101: trunc(P_Terms_Date) /*bug 8522014*/ + NVL(ap_terms_lines.due_days,0))))
102: INTO l_due_date
103: FROM ap_terms,
104: ap_terms_lines
105: WHERE ap_terms.term_id = P_Terms_Id

Line 103: FROM ap_terms,

99: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD')), 1, 0))),
100: 'MON-RR'),'DD-MON-RR'), /*bugfix:5647464 */
101: trunc(P_Terms_Date) /*bug 8522014*/ + NVL(ap_terms_lines.due_days,0))))
102: INTO l_due_date
103: FROM ap_terms,
104: ap_terms_lines
105: WHERE ap_terms.term_id = P_Terms_Id
106: AND ap_terms.term_id = ap_terms_lines.term_id
107: AND ap_terms_lines.sequence_num = p_sequence_num;

Line 104: ap_terms_lines

100: 'MON-RR'),'DD-MON-RR'), /*bugfix:5647464 */
101: trunc(P_Terms_Date) /*bug 8522014*/ + NVL(ap_terms_lines.due_days,0))))
102: INTO l_due_date
103: FROM ap_terms,
104: ap_terms_lines
105: WHERE ap_terms.term_id = P_Terms_Id
106: AND ap_terms.term_id = ap_terms_lines.term_id
107: AND ap_terms_lines.sequence_num = p_sequence_num;
108: END IF;

Line 105: WHERE ap_terms.term_id = P_Terms_Id

101: trunc(P_Terms_Date) /*bug 8522014*/ + NVL(ap_terms_lines.due_days,0))))
102: INTO l_due_date
103: FROM ap_terms,
104: ap_terms_lines
105: WHERE ap_terms.term_id = P_Terms_Id
106: AND ap_terms.term_id = ap_terms_lines.term_id
107: AND ap_terms_lines.sequence_num = p_sequence_num;
108: END IF;
109:

Line 106: AND ap_terms.term_id = ap_terms_lines.term_id

102: INTO l_due_date
103: FROM ap_terms,
104: ap_terms_lines
105: WHERE ap_terms.term_id = P_Terms_Id
106: AND ap_terms.term_id = ap_terms_lines.term_id
107: AND ap_terms_lines.sequence_num = p_sequence_num;
108: END IF;
109:
110: l_debug_info := 'In the else part , l_due_date is '||l_due_date;

Line 107: AND ap_terms_lines.sequence_num = p_sequence_num;

103: FROM ap_terms,
104: ap_terms_lines
105: WHERE ap_terms.term_id = P_Terms_Id
106: AND ap_terms.term_id = ap_terms_lines.term_id
107: AND ap_terms_lines.sequence_num = p_sequence_num;
108: END IF;
109:
110: l_debug_info := 'In the else part , l_due_date is '||l_due_date;
111: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 160: l_sequence_num ap_terms_lines.sequence_num%TYPE := 0;

156:
157: l_payment_schedule_index BINARY_INTEGER := 0;
158:
159: l_payment_cross_rate ap_payment_schedules.payment_cross_rate%TYPE;
160: l_sequence_num ap_terms_lines.sequence_num%TYPE := 0;
161: l_sign_due_amount ap_terms_lines.due_amount%TYPE;
162: l_sign_remaining_amount ap_terms_lines.due_amount%TYPE;
163: l_calendar ap_terms_lines.calendar%TYPE;
164: l_terms_calendar ap_terms_lines.calendar%TYPE;

Line 161: l_sign_due_amount ap_terms_lines.due_amount%TYPE;

157: l_payment_schedule_index BINARY_INTEGER := 0;
158:
159: l_payment_cross_rate ap_payment_schedules.payment_cross_rate%TYPE;
160: l_sequence_num ap_terms_lines.sequence_num%TYPE := 0;
161: l_sign_due_amount ap_terms_lines.due_amount%TYPE;
162: l_sign_remaining_amount ap_terms_lines.due_amount%TYPE;
163: l_calendar ap_terms_lines.calendar%TYPE;
164: l_terms_calendar ap_terms_lines.calendar%TYPE;
165: l_due_date ap_other_periods.due_date%TYPE;

Line 162: l_sign_remaining_amount ap_terms_lines.due_amount%TYPE;

158:
159: l_payment_cross_rate ap_payment_schedules.payment_cross_rate%TYPE;
160: l_sequence_num ap_terms_lines.sequence_num%TYPE := 0;
161: l_sign_due_amount ap_terms_lines.due_amount%TYPE;
162: l_sign_remaining_amount ap_terms_lines.due_amount%TYPE;
163: l_calendar ap_terms_lines.calendar%TYPE;
164: l_terms_calendar ap_terms_lines.calendar%TYPE;
165: l_due_date ap_other_periods.due_date%TYPE;
166: l_invoice_sign NUMBER;

Line 163: l_calendar ap_terms_lines.calendar%TYPE;

159: l_payment_cross_rate ap_payment_schedules.payment_cross_rate%TYPE;
160: l_sequence_num ap_terms_lines.sequence_num%TYPE := 0;
161: l_sign_due_amount ap_terms_lines.due_amount%TYPE;
162: l_sign_remaining_amount ap_terms_lines.due_amount%TYPE;
163: l_calendar ap_terms_lines.calendar%TYPE;
164: l_terms_calendar ap_terms_lines.calendar%TYPE;
165: l_due_date ap_other_periods.due_date%TYPE;
166: l_invoice_sign NUMBER;
167: l_pay_sched_total NUMBER := 0; -- 4537932

Line 164: l_terms_calendar ap_terms_lines.calendar%TYPE;

160: l_sequence_num ap_terms_lines.sequence_num%TYPE := 0;
161: l_sign_due_amount ap_terms_lines.due_amount%TYPE;
162: l_sign_remaining_amount ap_terms_lines.due_amount%TYPE;
163: l_calendar ap_terms_lines.calendar%TYPE;
164: l_terms_calendar ap_terms_lines.calendar%TYPE;
165: l_due_date ap_other_periods.due_date%TYPE;
166: l_invoice_sign NUMBER;
167: l_pay_sched_total NUMBER := 0; -- 4537932
168: l_inv_curr_sched_total NUMBER;

Line 244: FROM ap_terms_lines

240: l_debug_info varchar2(2000); --bug 8991699
241:
242: CURSOR c_terms_percent IS
243: SELECT 'Terms are percent type'
244: FROM ap_terms_lines
245: WHERE term_id = P_Terms_Id
246: AND sequence_num = 1
247: AND due_percent IS NOT NULL;
248:

Line 251: FROM ap_terms_lines

247: AND due_percent IS NOT NULL;
248:
249: CURSOR c_terms IS
250: SELECT calendar, sequence_num
251: FROM ap_terms_lines
252: WHERE term_id = p_terms_id
253: ORDER BY sequence_num;
254:
255: CURSOR c_amounts IS

Line 262: FROM ap_terms_lines

258: , due_amount
259: , SIGN(ABS(l_remaining_amount) - ABS(due_amount))
260: , ABS(l_remaining_amount) - ABS(due_amount)
261: , calendar
262: FROM ap_terms_lines
263: WHERE term_id = P_Terms_Id
264: AND sequence_num = l_sequence_num;
265: --
266: BEGIN

Line 413: NVL(ap_terms_lines.discount_percent,0)/100 ,l_precision_pay_curr),

409: NULL, ROUND( l_ins_gross_amount *
410: DECODE(P_Pay_Curr_Invoice_Amount, 0, 0, (l_amount_for_discount/
411: DECODE(P_Pay_Curr_Invoice_Amount, 0, 1,
412: P_Pay_Curr_Invoice_Amount))) *
413: NVL(ap_terms_lines.discount_percent,0)/100 ,l_precision_pay_curr),
414: ROUND(( l_ins_gross_amount *
415: DECODE(P_Pay_Curr_Invoice_Amount, 0, 0,
416: (l_amount_for_discount/
417: DECODE(P_Pay_Curr_Invoice_Amount, 0, 1,

Line 419: NVL(ap_terms_lines.discount_percent,0)/100)

415: DECODE(P_Pay_Curr_Invoice_Amount, 0, 0,
416: (l_amount_for_discount/
417: DECODE(P_Pay_Curr_Invoice_Amount, 0, 1,
418: P_Pay_Curr_Invoice_Amount))) *
419: NVL(ap_terms_lines.discount_percent,0)/100)
420: / l_min_acc_unit_pay_curr) * l_min_acc_unit_pay_curr)
421: , DECODE(l_min_acc_unit_pay_curr,
422: NULL, ROUND( l_ins_gross_amount *
423: DECODE(P_Pay_Curr_Invoice_Amount, 0, 0,

Line 427: NVL(ap_terms_lines.discount_percent_2,0)/100 ,l_precision_pay_curr),

423: DECODE(P_Pay_Curr_Invoice_Amount, 0, 0,
424: (l_amount_for_discount/
425: DECODE(P_Pay_Curr_Invoice_Amount, 0, 1,
426: P_Pay_Curr_Invoice_Amount))) *
427: NVL(ap_terms_lines.discount_percent_2,0)/100 ,l_precision_pay_curr),
428: ROUND(( l_ins_gross_amount *
429: DECODE(P_Pay_Curr_Invoice_Amount, 0, 0,
430: (l_amount_for_discount/
431: DECODE(P_Pay_Curr_Invoice_Amount, 0, 1,

Line 433: NVL(ap_terms_lines.discount_percent_2,0)/100)

429: DECODE(P_Pay_Curr_Invoice_Amount, 0, 0,
430: (l_amount_for_discount/
431: DECODE(P_Pay_Curr_Invoice_Amount, 0, 1,
432: P_Pay_Curr_Invoice_Amount))) *
433: NVL(ap_terms_lines.discount_percent_2,0)/100)
434: / l_min_acc_unit_pay_curr) * l_min_acc_unit_pay_curr)
435: , DECODE(l_min_acc_unit_pay_curr,
436: NULL, ROUND( l_ins_gross_amount *
437: DECODE(P_Pay_Curr_Invoice_Amount, 0, 0,

Line 441: NVL(ap_terms_lines.discount_percent_3,0)/100 ,l_precision_pay_curr),

437: DECODE(P_Pay_Curr_Invoice_Amount, 0, 0,
438: (l_amount_for_discount/
439: DECODE(P_Pay_Curr_Invoice_Amount, 0, 1,
440: P_Pay_Curr_Invoice_Amount))) *
441: NVL(ap_terms_lines.discount_percent_3,0)/100 ,l_precision_pay_curr),
442: ROUND(( l_ins_gross_amount *
443: DECODE(P_Pay_Curr_Invoice_Amount, 0, 0,
444: (l_amount_for_discount/
445: DECODE(P_Pay_Curr_Invoice_Amount, 0, 1,

Line 447: NVL(ap_terms_lines.discount_percent_3,0)/100)

443: DECODE(P_Pay_Curr_Invoice_Amount, 0, 0,
444: (l_amount_for_discount/
445: DECODE(P_Pay_Curr_Invoice_Amount, 0, 1,
446: P_Pay_Curr_Invoice_Amount))) *
447: NVL(ap_terms_lines.discount_percent_3,0)/100)
448: / l_min_acc_unit_pay_curr) * l_min_acc_unit_pay_curr),
449: discount_amount,
450: discount_amount_2,
451: discount_amount_3

Line 456: FROM ap_terms

452: INTO
453: l_disc_amt_by_percent, l_disc_amt_by_percent_2, l_disc_amt_by_percent_3,
454: l_discount_amount, l_discount_amount_2, l_discount_amount_3
455:
456: FROM ap_terms
457: , ap_terms_lines
458: , ap_invoices ai
459: WHERE ap_terms.term_id = ap_terms_lines.term_id
460: AND ap_terms_lines.term_id = P_Terms_Id

Line 457: , ap_terms_lines

453: l_disc_amt_by_percent, l_disc_amt_by_percent_2, l_disc_amt_by_percent_3,
454: l_discount_amount, l_discount_amount_2, l_discount_amount_3
455:
456: FROM ap_terms
457: , ap_terms_lines
458: , ap_invoices ai
459: WHERE ap_terms.term_id = ap_terms_lines.term_id
460: AND ap_terms_lines.term_id = P_Terms_Id
461: AND ap_terms_lines.sequence_num = l_sequence_num

Line 459: WHERE ap_terms.term_id = ap_terms_lines.term_id

455:
456: FROM ap_terms
457: , ap_terms_lines
458: , ap_invoices ai
459: WHERE ap_terms.term_id = ap_terms_lines.term_id
460: AND ap_terms_lines.term_id = P_Terms_Id
461: AND ap_terms_lines.sequence_num = l_sequence_num
462: AND ai.Invoice_Id = P_Invoice_Id;
463:

Line 460: AND ap_terms_lines.term_id = P_Terms_Id

456: FROM ap_terms
457: , ap_terms_lines
458: , ap_invoices ai
459: WHERE ap_terms.term_id = ap_terms_lines.term_id
460: AND ap_terms_lines.term_id = P_Terms_Id
461: AND ap_terms_lines.sequence_num = l_sequence_num
462: AND ai.Invoice_Id = P_Invoice_Id;
463:
464: --Bug 7357218 Quick Pay and Dispute Resolution Project

Line 461: AND ap_terms_lines.sequence_num = l_sequence_num

457: , ap_terms_lines
458: , ap_invoices ai
459: WHERE ap_terms.term_id = ap_terms_lines.term_id
460: AND ap_terms_lines.term_id = P_Terms_Id
461: AND ap_terms_lines.sequence_num = l_sequence_num
462: AND ai.Invoice_Id = P_Invoice_Id;
463:
464: --Bug 7357218 Quick Pay and Dispute Resolution Project
465: --Calculating discount amounts by percent for slab type END

Line 493: , DECODE(ap_terms_lines.discount_days,

489:
490: SELECT P_Invoice_Id,
491: l_sequence_num
492: , l_due_date
493: , DECODE(ap_terms_lines.discount_days,
494: NULL,
495: DECODE(ap_terms_lines.discount_day_of_month, NULL, NULL,
496: TO_DATE(TO_CHAR(LEAST(NVL(ap_terms_lines.discount_day_of_month,32),
497: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS

Line 495: DECODE(ap_terms_lines.discount_day_of_month, NULL, NULL,

491: l_sequence_num
492: , l_due_date
493: , DECODE(ap_terms_lines.discount_days,
494: NULL,
495: DECODE(ap_terms_lines.discount_day_of_month, NULL, NULL,
496: TO_DATE(TO_CHAR(LEAST(NVL(ap_terms_lines.discount_day_of_month,32),
497: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS
498: (P_Terms_Date, NVL(ap_terms_lines.discount_months_forward,0) +
499: DECODE(ap_terms.due_cutoff_day, NULL, 0,

Line 496: TO_DATE(TO_CHAR(LEAST(NVL(ap_terms_lines.discount_day_of_month,32),

492: , l_due_date
493: , DECODE(ap_terms_lines.discount_days,
494: NULL,
495: DECODE(ap_terms_lines.discount_day_of_month, NULL, NULL,
496: TO_DATE(TO_CHAR(LEAST(NVL(ap_terms_lines.discount_day_of_month,32),
497: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS
498: (P_Terms_Date, NVL(ap_terms_lines.discount_months_forward,0) +
499: DECODE(ap_terms.due_cutoff_day, NULL, 0,
500: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),

Line 498: (P_Terms_Date, NVL(ap_terms_lines.discount_months_forward,0) +

494: NULL,
495: DECODE(ap_terms_lines.discount_day_of_month, NULL, NULL,
496: TO_DATE(TO_CHAR(LEAST(NVL(ap_terms_lines.discount_day_of_month,32),
497: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS
498: (P_Terms_Date, NVL(ap_terms_lines.discount_months_forward,0) +
499: DECODE(ap_terms.due_cutoff_day, NULL, 0,
500: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
501: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date), 'DD'))),
502: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),

Line 499: DECODE(ap_terms.due_cutoff_day, NULL, 0,

495: DECODE(ap_terms_lines.discount_day_of_month, NULL, NULL,
496: TO_DATE(TO_CHAR(LEAST(NVL(ap_terms_lines.discount_day_of_month,32),
497: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS
498: (P_Terms_Date, NVL(ap_terms_lines.discount_months_forward,0) +
499: DECODE(ap_terms.due_cutoff_day, NULL, 0,
500: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
501: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date), 'DD'))),
502: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
503: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))

Line 500: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),

496: TO_DATE(TO_CHAR(LEAST(NVL(ap_terms_lines.discount_day_of_month,32),
497: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS
498: (P_Terms_Date, NVL(ap_terms_lines.discount_months_forward,0) +
499: DECODE(ap_terms.due_cutoff_day, NULL, 0,
500: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
501: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date), 'DD'))),
502: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
503: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))
504: , 1, 0)))), 'DD')))) || '-' ||

Line 506: NVL(ap_terms_lines.discount_months_forward,0) +

502: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
503: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))
504: , 1, 0)))), 'DD')))) || '-' ||
505: TO_CHAR(ADD_MONTHS(P_Terms_Date,
506: NVL(ap_terms_lines.discount_months_forward,0) +
507: DECODE(ap_terms.due_cutoff_day, NULL, 0,
508: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
509: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date),'DD'))),
510: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),

Line 507: DECODE(ap_terms.due_cutoff_day, NULL, 0,

503: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))
504: , 1, 0)))), 'DD')))) || '-' ||
505: TO_CHAR(ADD_MONTHS(P_Terms_Date,
506: NVL(ap_terms_lines.discount_months_forward,0) +
507: DECODE(ap_terms.due_cutoff_day, NULL, 0,
508: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
509: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date),'DD'))),
510: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
511: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD')), 1, 0))),

Line 508: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),

504: , 1, 0)))), 'DD')))) || '-' ||
505: TO_CHAR(ADD_MONTHS(P_Terms_Date,
506: NVL(ap_terms_lines.discount_months_forward,0) +
507: DECODE(ap_terms.due_cutoff_day, NULL, 0,
508: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
509: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date),'DD'))),
510: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
511: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD')), 1, 0))),
512: 'MON-RR'),'DD-MON-RR')

Line 514: P_Terms_Date + NVL(ap_terms_lines.discount_days,0)

510: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
511: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD')), 1, 0))),
512: 'MON-RR'),'DD-MON-RR')
513: ),
514: P_Terms_Date + NVL(ap_terms_lines.discount_days,0)
515: )
516: , DECODE(ap_terms_lines.discount_days_2,
517: NULL,DECODE(ap_terms_lines.discount_day_of_month_2,NULL,NULL,
518: TO_DATE(TO_CHAR(LEAST

Line 516: , DECODE(ap_terms_lines.discount_days_2,

512: 'MON-RR'),'DD-MON-RR')
513: ),
514: P_Terms_Date + NVL(ap_terms_lines.discount_days,0)
515: )
516: , DECODE(ap_terms_lines.discount_days_2,
517: NULL,DECODE(ap_terms_lines.discount_day_of_month_2,NULL,NULL,
518: TO_DATE(TO_CHAR(LEAST
519: (NVL(ap_terms_lines.discount_day_of_month_2,32),
520: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS(P_Terms_Date,

Line 517: NULL,DECODE(ap_terms_lines.discount_day_of_month_2,NULL,NULL,

513: ),
514: P_Terms_Date + NVL(ap_terms_lines.discount_days,0)
515: )
516: , DECODE(ap_terms_lines.discount_days_2,
517: NULL,DECODE(ap_terms_lines.discount_day_of_month_2,NULL,NULL,
518: TO_DATE(TO_CHAR(LEAST
519: (NVL(ap_terms_lines.discount_day_of_month_2,32),
520: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS(P_Terms_Date,
521: NVL(ap_terms_lines.discount_months_forward_2,0) +

Line 519: (NVL(ap_terms_lines.discount_day_of_month_2,32),

515: )
516: , DECODE(ap_terms_lines.discount_days_2,
517: NULL,DECODE(ap_terms_lines.discount_day_of_month_2,NULL,NULL,
518: TO_DATE(TO_CHAR(LEAST
519: (NVL(ap_terms_lines.discount_day_of_month_2,32),
520: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS(P_Terms_Date,
521: NVL(ap_terms_lines.discount_months_forward_2,0) +
522: DECODE(ap_terms.due_cutoff_day, NULL, 0,
523: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),

Line 521: NVL(ap_terms_lines.discount_months_forward_2,0) +

517: NULL,DECODE(ap_terms_lines.discount_day_of_month_2,NULL,NULL,
518: TO_DATE(TO_CHAR(LEAST
519: (NVL(ap_terms_lines.discount_day_of_month_2,32),
520: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS(P_Terms_Date,
521: NVL(ap_terms_lines.discount_months_forward_2,0) +
522: DECODE(ap_terms.due_cutoff_day, NULL, 0,
523: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
524: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date), 'DD'))),
525: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),

Line 522: DECODE(ap_terms.due_cutoff_day, NULL, 0,

518: TO_DATE(TO_CHAR(LEAST
519: (NVL(ap_terms_lines.discount_day_of_month_2,32),
520: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS(P_Terms_Date,
521: NVL(ap_terms_lines.discount_months_forward_2,0) +
522: DECODE(ap_terms.due_cutoff_day, NULL, 0,
523: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
524: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date), 'DD'))),
525: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
526: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))

Line 523: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),

519: (NVL(ap_terms_lines.discount_day_of_month_2,32),
520: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS(P_Terms_Date,
521: NVL(ap_terms_lines.discount_months_forward_2,0) +
522: DECODE(ap_terms.due_cutoff_day, NULL, 0,
523: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
524: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date), 'DD'))),
525: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
526: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))
527: , 1, 0)))), 'DD')))) || '-' ||

Line 529: NVL(ap_terms_lines.discount_months_forward_2,0) +

525: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
526: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))
527: , 1, 0)))), 'DD')))) || '-' ||
528: TO_CHAR(ADD_MONTHS(P_Terms_Date,
529: NVL(ap_terms_lines.discount_months_forward_2,0) +
530: DECODE(ap_terms.due_cutoff_day, NULL, 0,
531: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
532: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date),'DD'))),
533: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),

Line 530: DECODE(ap_terms.due_cutoff_day, NULL, 0,

526: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))
527: , 1, 0)))), 'DD')))) || '-' ||
528: TO_CHAR(ADD_MONTHS(P_Terms_Date,
529: NVL(ap_terms_lines.discount_months_forward_2,0) +
530: DECODE(ap_terms.due_cutoff_day, NULL, 0,
531: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
532: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date),'DD'))),
533: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
534: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD')), 1, 0))),

Line 531: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),

527: , 1, 0)))), 'DD')))) || '-' ||
528: TO_CHAR(ADD_MONTHS(P_Terms_Date,
529: NVL(ap_terms_lines.discount_months_forward_2,0) +
530: DECODE(ap_terms.due_cutoff_day, NULL, 0,
531: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
532: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date),'DD'))),
533: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
534: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD')), 1, 0))),
535: 'MON-RR'),'DD-MON-RR')), /*bugfix:5647464 */

Line 536: P_Terms_Date + NVL(ap_terms_lines.discount_days_2,0))

532: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date),'DD'))),
533: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
534: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD')), 1, 0))),
535: 'MON-RR'),'DD-MON-RR')), /*bugfix:5647464 */
536: P_Terms_Date + NVL(ap_terms_lines.discount_days_2,0))
537: , DECODE(ap_terms_lines.discount_days_3,
538: NULL, DECODE(ap_terms_lines.discount_day_of_month_3, NULL,
539: NULL,
540: TO_DATE(TO_CHAR(LEAST

Line 537: , DECODE(ap_terms_lines.discount_days_3,

533: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
534: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD')), 1, 0))),
535: 'MON-RR'),'DD-MON-RR')), /*bugfix:5647464 */
536: P_Terms_Date + NVL(ap_terms_lines.discount_days_2,0))
537: , DECODE(ap_terms_lines.discount_days_3,
538: NULL, DECODE(ap_terms_lines.discount_day_of_month_3, NULL,
539: NULL,
540: TO_DATE(TO_CHAR(LEAST
541: (NVL(ap_terms_lines.discount_day_of_month_3,32),

Line 538: NULL, DECODE(ap_terms_lines.discount_day_of_month_3, NULL,

534: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD')), 1, 0))),
535: 'MON-RR'),'DD-MON-RR')), /*bugfix:5647464 */
536: P_Terms_Date + NVL(ap_terms_lines.discount_days_2,0))
537: , DECODE(ap_terms_lines.discount_days_3,
538: NULL, DECODE(ap_terms_lines.discount_day_of_month_3, NULL,
539: NULL,
540: TO_DATE(TO_CHAR(LEAST
541: (NVL(ap_terms_lines.discount_day_of_month_3,32),
542: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS(P_Terms_Date,

Line 541: (NVL(ap_terms_lines.discount_day_of_month_3,32),

537: , DECODE(ap_terms_lines.discount_days_3,
538: NULL, DECODE(ap_terms_lines.discount_day_of_month_3, NULL,
539: NULL,
540: TO_DATE(TO_CHAR(LEAST
541: (NVL(ap_terms_lines.discount_day_of_month_3,32),
542: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS(P_Terms_Date,
543: NVL(ap_terms_lines.discount_months_forward_3,0) +
544: DECODE(ap_terms.due_cutoff_day, NULL, 0,
545: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),

Line 543: NVL(ap_terms_lines.discount_months_forward_3,0) +

539: NULL,
540: TO_DATE(TO_CHAR(LEAST
541: (NVL(ap_terms_lines.discount_day_of_month_3,32),
542: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS(P_Terms_Date,
543: NVL(ap_terms_lines.discount_months_forward_3,0) +
544: DECODE(ap_terms.due_cutoff_day, NULL, 0,
545: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
546: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date), 'DD'))),
547: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),

Line 544: DECODE(ap_terms.due_cutoff_day, NULL, 0,

540: TO_DATE(TO_CHAR(LEAST
541: (NVL(ap_terms_lines.discount_day_of_month_3,32),
542: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS(P_Terms_Date,
543: NVL(ap_terms_lines.discount_months_forward_3,0) +
544: DECODE(ap_terms.due_cutoff_day, NULL, 0,
545: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
546: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date), 'DD'))),
547: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
548: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))

Line 545: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),

541: (NVL(ap_terms_lines.discount_day_of_month_3,32),
542: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS(P_Terms_Date,
543: NVL(ap_terms_lines.discount_months_forward_3,0) +
544: DECODE(ap_terms.due_cutoff_day, NULL, 0,
545: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
546: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date), 'DD'))),
547: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
548: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))
549: , 1, 0)))), 'DD')))) || '-' ||

Line 551: NVL(ap_terms_lines.discount_months_forward_3,0) +

547: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
548: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))
549: , 1, 0)))), 'DD')))) || '-' ||
550: TO_CHAR(ADD_MONTHS(P_Terms_Date,
551: NVL(ap_terms_lines.discount_months_forward_3,0) +
552: DECODE(ap_terms.due_cutoff_day, NULL, 0,
553: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
554: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date),'DD'))),
555: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),

Line 552: DECODE(ap_terms.due_cutoff_day, NULL, 0,

548: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))
549: , 1, 0)))), 'DD')))) || '-' ||
550: TO_CHAR(ADD_MONTHS(P_Terms_Date,
551: NVL(ap_terms_lines.discount_months_forward_3,0) +
552: DECODE(ap_terms.due_cutoff_day, NULL, 0,
553: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
554: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date),'DD'))),
555: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
556: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD')), 1, 0))),

Line 553: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),

549: , 1, 0)))), 'DD')))) || '-' ||
550: TO_CHAR(ADD_MONTHS(P_Terms_Date,
551: NVL(ap_terms_lines.discount_months_forward_3,0) +
552: DECODE(ap_terms.due_cutoff_day, NULL, 0,
553: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
554: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date),'DD'))),
555: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
556: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD')), 1, 0))),
557: 'MON-RR'),'DD-MON-RR')), /*Bug14071766 : M0N to MON */

Line 558: P_Terms_Date + NVL(ap_terms_lines.discount_days_3,0))

554: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date),'DD'))),
555: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
556: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD')), 1, 0))),
557: 'MON-RR'),'DD-MON-RR')), /*Bug14071766 : M0N to MON */
558: P_Terms_Date + NVL(ap_terms_lines.discount_days_3,0))
559: , SYSDATE
560: , P_Last_Updated_By
561: , NULL
562: , SYSDATE

Line 667: FROM ap_terms

663: T_REMIT_TO_SUPPLIER_ID(l_payment_schedule_index),
664: T_REMIT_TO_SUPPLIER_SITE(l_payment_schedule_index),
665: T_REMIT_TO_SUPPLIER_SITE_ID(l_payment_schedule_index),
666: T_RELATIONSHIP_ID(l_payment_schedule_index)
667: FROM ap_terms
668: , ap_terms_lines
669: , ap_invoices ai
670: WHERE ap_terms.term_id = ap_terms_lines.term_id
671: AND ap_terms_lines.term_id = P_Terms_Id

Line 668: , ap_terms_lines

664: T_REMIT_TO_SUPPLIER_SITE(l_payment_schedule_index),
665: T_REMIT_TO_SUPPLIER_SITE_ID(l_payment_schedule_index),
666: T_RELATIONSHIP_ID(l_payment_schedule_index)
667: FROM ap_terms
668: , ap_terms_lines
669: , ap_invoices ai
670: WHERE ap_terms.term_id = ap_terms_lines.term_id
671: AND ap_terms_lines.term_id = P_Terms_Id
672: AND ap_terms_lines.sequence_num = l_sequence_num

Line 670: WHERE ap_terms.term_id = ap_terms_lines.term_id

666: T_RELATIONSHIP_ID(l_payment_schedule_index)
667: FROM ap_terms
668: , ap_terms_lines
669: , ap_invoices ai
670: WHERE ap_terms.term_id = ap_terms_lines.term_id
671: AND ap_terms_lines.term_id = P_Terms_Id
672: AND ap_terms_lines.sequence_num = l_sequence_num
673: AND ai.Invoice_Id = P_Invoice_Id;
674:

Line 671: AND ap_terms_lines.term_id = P_Terms_Id

667: FROM ap_terms
668: , ap_terms_lines
669: , ap_invoices ai
670: WHERE ap_terms.term_id = ap_terms_lines.term_id
671: AND ap_terms_lines.term_id = P_Terms_Id
672: AND ap_terms_lines.sequence_num = l_sequence_num
673: AND ai.Invoice_Id = P_Invoice_Id;
674:
675: --

Line 672: AND ap_terms_lines.sequence_num = l_sequence_num

668: , ap_terms_lines
669: , ap_invoices ai
670: WHERE ap_terms.term_id = ap_terms_lines.term_id
671: AND ap_terms_lines.term_id = P_Terms_Id
672: AND ap_terms_lines.sequence_num = l_sequence_num
673: AND ai.Invoice_Id = P_Invoice_Id;
674:
675: --
676: l_pay_sched_total := l_pay_sched_total +

Line 772: NVL(ap_terms_lines.discount_percent,0)/100 *

768: --Bug 7357218 Quick Pay and Dispute Resolution Project
769: debug_info := 'Calculating discount amounts by percent for Percent type BEGIN';
770: SELECT DECODE(l_min_acc_unit_pay_curr,NULL,
771: ROUND( l_amount_for_discount *
772: NVL(ap_terms_lines.discount_percent,0)/100 *
773: NVL(ap_terms_lines.due_percent, 0)/100, l_precision_pay_curr),
774: ROUND(( l_amount_for_discount *
775: NVL(ap_terms_lines.discount_percent,0)/100 *
776: NVL(ap_terms_lines.due_percent, 0)/100)

Line 773: NVL(ap_terms_lines.due_percent, 0)/100, l_precision_pay_curr),

769: debug_info := 'Calculating discount amounts by percent for Percent type BEGIN';
770: SELECT DECODE(l_min_acc_unit_pay_curr,NULL,
771: ROUND( l_amount_for_discount *
772: NVL(ap_terms_lines.discount_percent,0)/100 *
773: NVL(ap_terms_lines.due_percent, 0)/100, l_precision_pay_curr),
774: ROUND(( l_amount_for_discount *
775: NVL(ap_terms_lines.discount_percent,0)/100 *
776: NVL(ap_terms_lines.due_percent, 0)/100)
777: / l_min_acc_unit_pay_curr)

Line 775: NVL(ap_terms_lines.discount_percent,0)/100 *

771: ROUND( l_amount_for_discount *
772: NVL(ap_terms_lines.discount_percent,0)/100 *
773: NVL(ap_terms_lines.due_percent, 0)/100, l_precision_pay_curr),
774: ROUND(( l_amount_for_discount *
775: NVL(ap_terms_lines.discount_percent,0)/100 *
776: NVL(ap_terms_lines.due_percent, 0)/100)
777: / l_min_acc_unit_pay_curr)
778: * l_min_acc_unit_pay_curr)
779: , DECODE(l_min_acc_unit_pay_curr,NULL,

Line 776: NVL(ap_terms_lines.due_percent, 0)/100)

772: NVL(ap_terms_lines.discount_percent,0)/100 *
773: NVL(ap_terms_lines.due_percent, 0)/100, l_precision_pay_curr),
774: ROUND(( l_amount_for_discount *
775: NVL(ap_terms_lines.discount_percent,0)/100 *
776: NVL(ap_terms_lines.due_percent, 0)/100)
777: / l_min_acc_unit_pay_curr)
778: * l_min_acc_unit_pay_curr)
779: , DECODE(l_min_acc_unit_pay_curr,NULL,
780: ROUND( l_amount_for_discount *

Line 781: NVL(ap_terms_lines.discount_percent_2,0)/100 *

777: / l_min_acc_unit_pay_curr)
778: * l_min_acc_unit_pay_curr)
779: , DECODE(l_min_acc_unit_pay_curr,NULL,
780: ROUND( l_amount_for_discount *
781: NVL(ap_terms_lines.discount_percent_2,0)/100 *
782: NVL(ap_terms_lines.due_percent, 0)/100, l_precision_pay_curr),
783: ROUND(( l_amount_for_discount *
784: NVL(ap_terms_lines.discount_percent_2,0)/100 *
785: NVL(ap_terms_lines.due_percent, 0)/100)

Line 782: NVL(ap_terms_lines.due_percent, 0)/100, l_precision_pay_curr),

778: * l_min_acc_unit_pay_curr)
779: , DECODE(l_min_acc_unit_pay_curr,NULL,
780: ROUND( l_amount_for_discount *
781: NVL(ap_terms_lines.discount_percent_2,0)/100 *
782: NVL(ap_terms_lines.due_percent, 0)/100, l_precision_pay_curr),
783: ROUND(( l_amount_for_discount *
784: NVL(ap_terms_lines.discount_percent_2,0)/100 *
785: NVL(ap_terms_lines.due_percent, 0)/100)
786: / l_min_acc_unit_pay_curr)*l_min_acc_unit_pay_curr)

Line 784: NVL(ap_terms_lines.discount_percent_2,0)/100 *

780: ROUND( l_amount_for_discount *
781: NVL(ap_terms_lines.discount_percent_2,0)/100 *
782: NVL(ap_terms_lines.due_percent, 0)/100, l_precision_pay_curr),
783: ROUND(( l_amount_for_discount *
784: NVL(ap_terms_lines.discount_percent_2,0)/100 *
785: NVL(ap_terms_lines.due_percent, 0)/100)
786: / l_min_acc_unit_pay_curr)*l_min_acc_unit_pay_curr)
787: , DECODE(l_min_acc_unit_pay_curr,NULL,
788: ROUND( l_amount_for_discount *

Line 785: NVL(ap_terms_lines.due_percent, 0)/100)

781: NVL(ap_terms_lines.discount_percent_2,0)/100 *
782: NVL(ap_terms_lines.due_percent, 0)/100, l_precision_pay_curr),
783: ROUND(( l_amount_for_discount *
784: NVL(ap_terms_lines.discount_percent_2,0)/100 *
785: NVL(ap_terms_lines.due_percent, 0)/100)
786: / l_min_acc_unit_pay_curr)*l_min_acc_unit_pay_curr)
787: , DECODE(l_min_acc_unit_pay_curr,NULL,
788: ROUND( l_amount_for_discount *
789: NVL(ap_terms_lines.discount_percent_3,0)/100 *

Line 789: NVL(ap_terms_lines.discount_percent_3,0)/100 *

785: NVL(ap_terms_lines.due_percent, 0)/100)
786: / l_min_acc_unit_pay_curr)*l_min_acc_unit_pay_curr)
787: , DECODE(l_min_acc_unit_pay_curr,NULL,
788: ROUND( l_amount_for_discount *
789: NVL(ap_terms_lines.discount_percent_3,0)/100 *
790: NVL(ap_terms_lines.due_percent, 0)/100, l_precision_pay_curr),
791: ROUND(( l_amount_for_discount *
792: NVL(ap_terms_lines.discount_percent_3,0)/100 *
793: NVL(ap_terms_lines.due_percent, 0)/100)

Line 790: NVL(ap_terms_lines.due_percent, 0)/100, l_precision_pay_curr),

786: / l_min_acc_unit_pay_curr)*l_min_acc_unit_pay_curr)
787: , DECODE(l_min_acc_unit_pay_curr,NULL,
788: ROUND( l_amount_for_discount *
789: NVL(ap_terms_lines.discount_percent_3,0)/100 *
790: NVL(ap_terms_lines.due_percent, 0)/100, l_precision_pay_curr),
791: ROUND(( l_amount_for_discount *
792: NVL(ap_terms_lines.discount_percent_3,0)/100 *
793: NVL(ap_terms_lines.due_percent, 0)/100)
794: / l_min_acc_unit_pay_curr)*l_min_acc_unit_pay_curr),

Line 792: NVL(ap_terms_lines.discount_percent_3,0)/100 *

788: ROUND( l_amount_for_discount *
789: NVL(ap_terms_lines.discount_percent_3,0)/100 *
790: NVL(ap_terms_lines.due_percent, 0)/100, l_precision_pay_curr),
791: ROUND(( l_amount_for_discount *
792: NVL(ap_terms_lines.discount_percent_3,0)/100 *
793: NVL(ap_terms_lines.due_percent, 0)/100)
794: / l_min_acc_unit_pay_curr)*l_min_acc_unit_pay_curr),
795: discount_amount,
796: discount_amount_2,

Line 793: NVL(ap_terms_lines.due_percent, 0)/100)

789: NVL(ap_terms_lines.discount_percent_3,0)/100 *
790: NVL(ap_terms_lines.due_percent, 0)/100, l_precision_pay_curr),
791: ROUND(( l_amount_for_discount *
792: NVL(ap_terms_lines.discount_percent_3,0)/100 *
793: NVL(ap_terms_lines.due_percent, 0)/100)
794: / l_min_acc_unit_pay_curr)*l_min_acc_unit_pay_curr),
795: discount_amount,
796: discount_amount_2,
797: discount_amount_3

Line 802: FROM ap_terms,

798: INTO
799: l_disc_amt_by_percent, l_disc_amt_by_percent_2, l_disc_amt_by_percent_3,
800: l_discount_amount, l_discount_amount_2, l_discount_amount_3
801:
802: FROM ap_terms,
803: ap_terms_lines,
804: ap_invoices ai
805: WHERE ap_terms.term_id = ap_terms_lines.term_id
806: AND ap_terms_lines.term_id = P_Terms_Id

Line 803: ap_terms_lines,

799: l_disc_amt_by_percent, l_disc_amt_by_percent_2, l_disc_amt_by_percent_3,
800: l_discount_amount, l_discount_amount_2, l_discount_amount_3
801:
802: FROM ap_terms,
803: ap_terms_lines,
804: ap_invoices ai
805: WHERE ap_terms.term_id = ap_terms_lines.term_id
806: AND ap_terms_lines.term_id = P_Terms_Id
807: AND ap_terms_lines.sequence_num = l_sequence_num

Line 805: WHERE ap_terms.term_id = ap_terms_lines.term_id

801:
802: FROM ap_terms,
803: ap_terms_lines,
804: ap_invoices ai
805: WHERE ap_terms.term_id = ap_terms_lines.term_id
806: AND ap_terms_lines.term_id = P_Terms_Id
807: AND ap_terms_lines.sequence_num = l_sequence_num
808: AND ai.invoice_id = P_Invoice_Id;
809:

Line 806: AND ap_terms_lines.term_id = P_Terms_Id

802: FROM ap_terms,
803: ap_terms_lines,
804: ap_invoices ai
805: WHERE ap_terms.term_id = ap_terms_lines.term_id
806: AND ap_terms_lines.term_id = P_Terms_Id
807: AND ap_terms_lines.sequence_num = l_sequence_num
808: AND ai.invoice_id = P_Invoice_Id;
809:
810: --Bug 7357218 Quick Pay and Dispute Resolution Project

Line 807: AND ap_terms_lines.sequence_num = l_sequence_num

803: ap_terms_lines,
804: ap_invoices ai
805: WHERE ap_terms.term_id = ap_terms_lines.term_id
806: AND ap_terms_lines.term_id = P_Terms_Id
807: AND ap_terms_lines.sequence_num = l_sequence_num
808: AND ai.invoice_id = P_Invoice_Id;
809:
810: --Bug 7357218 Quick Pay and Dispute Resolution Project
811: --Calculating discount amounts by percent for Percent type END

Line 838: DECODE(ap_terms_lines.discount_days,

834:
835: SELECT P_Invoice_Id,l_sequence_num
836: , l_due_date
837: , DECODE(l_amount_for_discount, NULL, NULL,
838: DECODE(ap_terms_lines.discount_days,
839: NULL, DECODE(ap_terms_lines.discount_day_of_month, NULL, NULL,
840: TO_DATE(TO_CHAR(LEAST(NVL(ap_terms_lines.discount_day_of_month,32),
841: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS
842: (P_Terms_Date,

Line 839: NULL, DECODE(ap_terms_lines.discount_day_of_month, NULL, NULL,

835: SELECT P_Invoice_Id,l_sequence_num
836: , l_due_date
837: , DECODE(l_amount_for_discount, NULL, NULL,
838: DECODE(ap_terms_lines.discount_days,
839: NULL, DECODE(ap_terms_lines.discount_day_of_month, NULL, NULL,
840: TO_DATE(TO_CHAR(LEAST(NVL(ap_terms_lines.discount_day_of_month,32),
841: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS
842: (P_Terms_Date,
843: NVL(ap_terms_lines.discount_months_forward,0) +

Line 840: TO_DATE(TO_CHAR(LEAST(NVL(ap_terms_lines.discount_day_of_month,32),

836: , l_due_date
837: , DECODE(l_amount_for_discount, NULL, NULL,
838: DECODE(ap_terms_lines.discount_days,
839: NULL, DECODE(ap_terms_lines.discount_day_of_month, NULL, NULL,
840: TO_DATE(TO_CHAR(LEAST(NVL(ap_terms_lines.discount_day_of_month,32),
841: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS
842: (P_Terms_Date,
843: NVL(ap_terms_lines.discount_months_forward,0) +
844: DECODE(ap_terms.due_cutoff_day, NULL, 0,

Line 843: NVL(ap_terms_lines.discount_months_forward,0) +

839: NULL, DECODE(ap_terms_lines.discount_day_of_month, NULL, NULL,
840: TO_DATE(TO_CHAR(LEAST(NVL(ap_terms_lines.discount_day_of_month,32),
841: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS
842: (P_Terms_Date,
843: NVL(ap_terms_lines.discount_months_forward,0) +
844: DECODE(ap_terms.due_cutoff_day, NULL, 0,
845: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
846: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date), 'DD'))),
847: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),

Line 844: DECODE(ap_terms.due_cutoff_day, NULL, 0,

840: TO_DATE(TO_CHAR(LEAST(NVL(ap_terms_lines.discount_day_of_month,32),
841: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS
842: (P_Terms_Date,
843: NVL(ap_terms_lines.discount_months_forward,0) +
844: DECODE(ap_terms.due_cutoff_day, NULL, 0,
845: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
846: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date), 'DD'))),
847: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
848: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))

Line 845: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),

841: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS
842: (P_Terms_Date,
843: NVL(ap_terms_lines.discount_months_forward,0) +
844: DECODE(ap_terms.due_cutoff_day, NULL, 0,
845: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
846: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date), 'DD'))),
847: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
848: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))
849: , 1, 0)))), 'DD')))) || '-' ||

Line 851: NVL(ap_terms_lines.discount_months_forward,0) +

847: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
848: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))
849: , 1, 0)))), 'DD')))) || '-' ||
850: TO_CHAR(ADD_MONTHS(P_Terms_Date,
851: NVL(ap_terms_lines.discount_months_forward,0) +
852: DECODE(ap_terms.due_cutoff_day, NULL, 0,
853: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
854: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date),'DD'))),
855: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),

Line 852: DECODE(ap_terms.due_cutoff_day, NULL, 0,

848: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))
849: , 1, 0)))), 'DD')))) || '-' ||
850: TO_CHAR(ADD_MONTHS(P_Terms_Date,
851: NVL(ap_terms_lines.discount_months_forward,0) +
852: DECODE(ap_terms.due_cutoff_day, NULL, 0,
853: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
854: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date),'DD'))),
855: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
856: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD')), 1, 0))),

Line 853: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),

849: , 1, 0)))), 'DD')))) || '-' ||
850: TO_CHAR(ADD_MONTHS(P_Terms_Date,
851: NVL(ap_terms_lines.discount_months_forward,0) +
852: DECODE(ap_terms.due_cutoff_day, NULL, 0,
853: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
854: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date),'DD'))),
855: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
856: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD')), 1, 0))),
857: 'MON-RR'),'DD-MON-RR')),

Line 858: P_Terms_Date + NVL(ap_terms_lines.discount_days,0)))

854: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date),'DD'))),
855: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
856: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD')), 1, 0))),
857: 'MON-RR'),'DD-MON-RR')),
858: P_Terms_Date + NVL(ap_terms_lines.discount_days,0)))
859: , DECODE(l_amount_for_discount, NULL, NULL,
860: DECODE(ap_terms_lines.discount_days_2,
861: NULL,DECODE(ap_terms_lines.discount_day_of_month_2,NULL,NULL,
862: TO_DATE(TO_CHAR(LEAST(

Line 860: DECODE(ap_terms_lines.discount_days_2,

856: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD')), 1, 0))),
857: 'MON-RR'),'DD-MON-RR')),
858: P_Terms_Date + NVL(ap_terms_lines.discount_days,0)))
859: , DECODE(l_amount_for_discount, NULL, NULL,
860: DECODE(ap_terms_lines.discount_days_2,
861: NULL,DECODE(ap_terms_lines.discount_day_of_month_2,NULL,NULL,
862: TO_DATE(TO_CHAR(LEAST(
863: NVL(ap_terms_lines.discount_day_of_month_2,32),
864: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS(P_Terms_Date,

Line 861: NULL,DECODE(ap_terms_lines.discount_day_of_month_2,NULL,NULL,

857: 'MON-RR'),'DD-MON-RR')),
858: P_Terms_Date + NVL(ap_terms_lines.discount_days,0)))
859: , DECODE(l_amount_for_discount, NULL, NULL,
860: DECODE(ap_terms_lines.discount_days_2,
861: NULL,DECODE(ap_terms_lines.discount_day_of_month_2,NULL,NULL,
862: TO_DATE(TO_CHAR(LEAST(
863: NVL(ap_terms_lines.discount_day_of_month_2,32),
864: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS(P_Terms_Date,
865: NVL(ap_terms_lines.discount_months_forward_2,0) +

Line 863: NVL(ap_terms_lines.discount_day_of_month_2,32),

859: , DECODE(l_amount_for_discount, NULL, NULL,
860: DECODE(ap_terms_lines.discount_days_2,
861: NULL,DECODE(ap_terms_lines.discount_day_of_month_2,NULL,NULL,
862: TO_DATE(TO_CHAR(LEAST(
863: NVL(ap_terms_lines.discount_day_of_month_2,32),
864: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS(P_Terms_Date,
865: NVL(ap_terms_lines.discount_months_forward_2,0) +
866: DECODE(ap_terms.due_cutoff_day, NULL, 0,
867: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),

Line 865: NVL(ap_terms_lines.discount_months_forward_2,0) +

861: NULL,DECODE(ap_terms_lines.discount_day_of_month_2,NULL,NULL,
862: TO_DATE(TO_CHAR(LEAST(
863: NVL(ap_terms_lines.discount_day_of_month_2,32),
864: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS(P_Terms_Date,
865: NVL(ap_terms_lines.discount_months_forward_2,0) +
866: DECODE(ap_terms.due_cutoff_day, NULL, 0,
867: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
868: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date), 'DD'))),
869: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),

Line 866: DECODE(ap_terms.due_cutoff_day, NULL, 0,

862: TO_DATE(TO_CHAR(LEAST(
863: NVL(ap_terms_lines.discount_day_of_month_2,32),
864: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS(P_Terms_Date,
865: NVL(ap_terms_lines.discount_months_forward_2,0) +
866: DECODE(ap_terms.due_cutoff_day, NULL, 0,
867: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
868: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date), 'DD'))),
869: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
870: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))

Line 867: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),

863: NVL(ap_terms_lines.discount_day_of_month_2,32),
864: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS(P_Terms_Date,
865: NVL(ap_terms_lines.discount_months_forward_2,0) +
866: DECODE(ap_terms.due_cutoff_day, NULL, 0,
867: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
868: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date), 'DD'))),
869: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
870: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))
871: , 1, 0)))), 'DD')))) || '-' ||

Line 873: NVL(ap_terms_lines.discount_months_forward_2,0) +

869: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
870: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))
871: , 1, 0)))), 'DD')))) || '-' ||
872: TO_CHAR(ADD_MONTHS(P_Terms_Date,
873: NVL(ap_terms_lines.discount_months_forward_2,0) +
874: DECODE(ap_terms.due_cutoff_day, NULL, 0,
875: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
876: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date),'DD'))),
877: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),

Line 874: DECODE(ap_terms.due_cutoff_day, NULL, 0,

870: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))
871: , 1, 0)))), 'DD')))) || '-' ||
872: TO_CHAR(ADD_MONTHS(P_Terms_Date,
873: NVL(ap_terms_lines.discount_months_forward_2,0) +
874: DECODE(ap_terms.due_cutoff_day, NULL, 0,
875: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
876: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date),'DD'))),
877: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
878: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD')), 1, 0))),

Line 875: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),

871: , 1, 0)))), 'DD')))) || '-' ||
872: TO_CHAR(ADD_MONTHS(P_Terms_Date,
873: NVL(ap_terms_lines.discount_months_forward_2,0) +
874: DECODE(ap_terms.due_cutoff_day, NULL, 0,
875: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
876: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date),'DD'))),
877: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
878: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD')), 1, 0))),
879: 'MON-RR'),'DD-MON-RR')),

Line 880: P_Terms_Date + NVL(ap_terms_lines.discount_days_2,0)))

876: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date),'DD'))),
877: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
878: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD')), 1, 0))),
879: 'MON-RR'),'DD-MON-RR')),
880: P_Terms_Date + NVL(ap_terms_lines.discount_days_2,0)))
881: , DECODE(l_amount_for_discount, NULL, NULL,
882: DECODE(ap_terms_lines.discount_days_3,
883: NULL,DECODE(ap_terms_lines.discount_day_of_month_3,NULL,NULL,
884: TO_DATE(TO_CHAR(LEAST(

Line 882: DECODE(ap_terms_lines.discount_days_3,

878: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD')), 1, 0))),
879: 'MON-RR'),'DD-MON-RR')),
880: P_Terms_Date + NVL(ap_terms_lines.discount_days_2,0)))
881: , DECODE(l_amount_for_discount, NULL, NULL,
882: DECODE(ap_terms_lines.discount_days_3,
883: NULL,DECODE(ap_terms_lines.discount_day_of_month_3,NULL,NULL,
884: TO_DATE(TO_CHAR(LEAST(
885: NVL(ap_terms_lines.discount_day_of_month_3,32),
886: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS(P_Terms_Date,

Line 883: NULL,DECODE(ap_terms_lines.discount_day_of_month_3,NULL,NULL,

879: 'MON-RR'),'DD-MON-RR')),
880: P_Terms_Date + NVL(ap_terms_lines.discount_days_2,0)))
881: , DECODE(l_amount_for_discount, NULL, NULL,
882: DECODE(ap_terms_lines.discount_days_3,
883: NULL,DECODE(ap_terms_lines.discount_day_of_month_3,NULL,NULL,
884: TO_DATE(TO_CHAR(LEAST(
885: NVL(ap_terms_lines.discount_day_of_month_3,32),
886: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS(P_Terms_Date,
887: NVL(ap_terms_lines.discount_months_forward_3,0) +

Line 885: NVL(ap_terms_lines.discount_day_of_month_3,32),

881: , DECODE(l_amount_for_discount, NULL, NULL,
882: DECODE(ap_terms_lines.discount_days_3,
883: NULL,DECODE(ap_terms_lines.discount_day_of_month_3,NULL,NULL,
884: TO_DATE(TO_CHAR(LEAST(
885: NVL(ap_terms_lines.discount_day_of_month_3,32),
886: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS(P_Terms_Date,
887: NVL(ap_terms_lines.discount_months_forward_3,0) +
888: DECODE(ap_terms.due_cutoff_day, NULL, 0,
889: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),

Line 887: NVL(ap_terms_lines.discount_months_forward_3,0) +

883: NULL,DECODE(ap_terms_lines.discount_day_of_month_3,NULL,NULL,
884: TO_DATE(TO_CHAR(LEAST(
885: NVL(ap_terms_lines.discount_day_of_month_3,32),
886: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS(P_Terms_Date,
887: NVL(ap_terms_lines.discount_months_forward_3,0) +
888: DECODE(ap_terms.due_cutoff_day, NULL, 0,
889: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
890: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date), 'DD'))),
891: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),

Line 888: DECODE(ap_terms.due_cutoff_day, NULL, 0,

884: TO_DATE(TO_CHAR(LEAST(
885: NVL(ap_terms_lines.discount_day_of_month_3,32),
886: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS(P_Terms_Date,
887: NVL(ap_terms_lines.discount_months_forward_3,0) +
888: DECODE(ap_terms.due_cutoff_day, NULL, 0,
889: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
890: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date), 'DD'))),
891: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
892: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))

Line 889: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),

885: NVL(ap_terms_lines.discount_day_of_month_3,32),
886: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS(P_Terms_Date,
887: NVL(ap_terms_lines.discount_months_forward_3,0) +
888: DECODE(ap_terms.due_cutoff_day, NULL, 0,
889: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
890: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date), 'DD'))),
891: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
892: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))
893: , 1, 0)))), 'DD')))) || '-' ||

Line 895: NVL(ap_terms_lines.discount_months_forward_3,0) +

891: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
892: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))
893: , 1, 0)))), 'DD')))) || '-' ||
894: TO_CHAR(ADD_MONTHS(P_Terms_Date,
895: NVL(ap_terms_lines.discount_months_forward_3,0) +
896: DECODE(ap_terms.due_cutoff_day, NULL, 0,
897: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
898: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date),'DD'))),
899: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),

Line 896: DECODE(ap_terms.due_cutoff_day, NULL, 0,

892: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))
893: , 1, 0)))), 'DD')))) || '-' ||
894: TO_CHAR(ADD_MONTHS(P_Terms_Date,
895: NVL(ap_terms_lines.discount_months_forward_3,0) +
896: DECODE(ap_terms.due_cutoff_day, NULL, 0,
897: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
898: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date),'DD'))),
899: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
900: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD')), 1, 0))),

Line 897: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),

893: , 1, 0)))), 'DD')))) || '-' ||
894: TO_CHAR(ADD_MONTHS(P_Terms_Date,
895: NVL(ap_terms_lines.discount_months_forward_3,0) +
896: DECODE(ap_terms.due_cutoff_day, NULL, 0,
897: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
898: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date),'DD'))),
899: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
900: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD')), 1, 0))),
901: 'MON-RR'),'DD-MON-RR')), /*Bug14071766 : M0N to MON */

Line 902: P_Terms_Date + NVL(ap_terms_lines.discount_days_3,0)))

898: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date),'DD'))),
899: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
900: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD')), 1, 0))),
901: 'MON-RR'),'DD-MON-RR')), /*Bug14071766 : M0N to MON */
902: P_Terms_Date + NVL(ap_terms_lines.discount_days_3,0)))
903: , SYSDATE
904: , P_Last_Updated_By
905: , NULL
906: , SYSDATE

Line 911: NVL(ap_terms_lines.due_percent,0)/100,l_precision_pay_curr),

907: , P_Created_By
908: , l_payment_cross_rate
909: , DECODE(l_min_acc_unit_pay_curr,NULL,
910: ROUND(P_Pay_Curr_Invoice_Amount *
911: NVL(ap_terms_lines.due_percent,0)/100,l_precision_pay_curr),
912: ROUND((P_Pay_Curr_Invoice_Amount *
913: NVL(ap_terms_lines.due_percent,0)/100)
914: / l_min_acc_unit_pay_curr)
915: * l_min_acc_unit_pay_curr)

Line 913: NVL(ap_terms_lines.due_percent,0)/100)

909: , DECODE(l_min_acc_unit_pay_curr,NULL,
910: ROUND(P_Pay_Curr_Invoice_Amount *
911: NVL(ap_terms_lines.due_percent,0)/100,l_precision_pay_curr),
912: ROUND((P_Pay_Curr_Invoice_Amount *
913: NVL(ap_terms_lines.due_percent,0)/100)
914: / l_min_acc_unit_pay_curr)
915: * l_min_acc_unit_pay_curr)
916: , NULL ,
917:

Line 957: NVL(ap_terms_lines.due_percent, 0)/100, l_precision_pay_curr),

953: END,
954:
955: DECODE(l_min_acc_unit_pay_curr,NULL,
956: ROUND( P_Pay_Curr_Invoice_Amount *
957: NVL(ap_terms_lines.due_percent, 0)/100, l_precision_pay_curr),
958: ROUND(( P_Pay_Curr_Invoice_Amount *
959: NVL(ap_terms_lines.due_percent, 0)/100)
960: / l_min_acc_unit_pay_curr)*l_min_acc_unit_pay_curr)
961: , 0

Line 959: NVL(ap_terms_lines.due_percent, 0)/100)

955: DECODE(l_min_acc_unit_pay_curr,NULL,
956: ROUND( P_Pay_Curr_Invoice_Amount *
957: NVL(ap_terms_lines.due_percent, 0)/100, l_precision_pay_curr),
958: ROUND(( P_Pay_Curr_Invoice_Amount *
959: NVL(ap_terms_lines.due_percent, 0)/100)
960: / l_min_acc_unit_pay_curr)*l_min_acc_unit_pay_curr)
961: , 0
962: , 'N'
963: , 'N'

Line 1012: FROM ap_terms

1008: T_REMIT_TO_SUPPLIER_ID(l_payment_schedule_index),
1009: T_REMIT_TO_SUPPLIER_SITE(l_payment_schedule_index),
1010: T_REMIT_TO_SUPPLIER_SITE_ID(l_payment_schedule_index),
1011: T_RELATIONSHIP_ID(l_payment_schedule_index)
1012: FROM ap_terms
1013: , ap_terms_lines
1014: , ap_invoices ai
1015: WHERE ap_terms.term_id = ap_terms_lines.term_id
1016: AND ap_terms_lines.term_id = P_Terms_Id

Line 1013: , ap_terms_lines

1009: T_REMIT_TO_SUPPLIER_SITE(l_payment_schedule_index),
1010: T_REMIT_TO_SUPPLIER_SITE_ID(l_payment_schedule_index),
1011: T_RELATIONSHIP_ID(l_payment_schedule_index)
1012: FROM ap_terms
1013: , ap_terms_lines
1014: , ap_invoices ai
1015: WHERE ap_terms.term_id = ap_terms_lines.term_id
1016: AND ap_terms_lines.term_id = P_Terms_Id
1017: AND ap_terms_lines.sequence_num = l_sequence_num

Line 1015: WHERE ap_terms.term_id = ap_terms_lines.term_id

1011: T_RELATIONSHIP_ID(l_payment_schedule_index)
1012: FROM ap_terms
1013: , ap_terms_lines
1014: , ap_invoices ai
1015: WHERE ap_terms.term_id = ap_terms_lines.term_id
1016: AND ap_terms_lines.term_id = P_Terms_Id
1017: AND ap_terms_lines.sequence_num = l_sequence_num
1018: AND ai.invoice_id = P_Invoice_Id;
1019:

Line 1016: AND ap_terms_lines.term_id = P_Terms_Id

1012: FROM ap_terms
1013: , ap_terms_lines
1014: , ap_invoices ai
1015: WHERE ap_terms.term_id = ap_terms_lines.term_id
1016: AND ap_terms_lines.term_id = P_Terms_Id
1017: AND ap_terms_lines.sequence_num = l_sequence_num
1018: AND ai.invoice_id = P_Invoice_Id;
1019:
1020: --

Line 1017: AND ap_terms_lines.sequence_num = l_sequence_num

1013: , ap_terms_lines
1014: , ap_invoices ai
1015: WHERE ap_terms.term_id = ap_terms_lines.term_id
1016: AND ap_terms_lines.term_id = P_Terms_Id
1017: AND ap_terms_lines.sequence_num = l_sequence_num
1018: AND ai.invoice_id = P_Invoice_Id;
1019:
1020: --
1021: l_pay_sched_total := l_pay_sched_total +

Line 1255: -- All amounts in AP_TERMS_LINES will be interpreted to be in the payment

1251: -- ====== ==========
1252: -- P_Invoice_amount invoice currency
1253: -- P_Pay_Curr_Invoice_Amount payment currency
1254: -- P_Amount_For_Discount invoice currency
1255: -- All amounts in AP_TERMS_LINES will be interpreted to be in the payment
1256: -- currency
1257:
1258: l_payment_cross_rate ap_payment_schedules.payment_cross_rate%TYPE;
1259: l_sequence_num ap_terms_lines.sequence_num%TYPE := 0;

Line 1259: l_sequence_num ap_terms_lines.sequence_num%TYPE := 0;

1255: -- All amounts in AP_TERMS_LINES will be interpreted to be in the payment
1256: -- currency
1257:
1258: l_payment_cross_rate ap_payment_schedules.payment_cross_rate%TYPE;
1259: l_sequence_num ap_terms_lines.sequence_num%TYPE := 0;
1260: l_sign_due_amount ap_terms_lines.due_amount%TYPE;
1261: l_sign_remaining_amount ap_terms_lines.due_amount%TYPE;
1262: l_calendar ap_terms_lines.calendar%TYPE; -- for payment terms
1263: l_terms_calendar ap_terms_lines.calendar%TYPE; -- for payment terms

Line 1260: l_sign_due_amount ap_terms_lines.due_amount%TYPE;

1256: -- currency
1257:
1258: l_payment_cross_rate ap_payment_schedules.payment_cross_rate%TYPE;
1259: l_sequence_num ap_terms_lines.sequence_num%TYPE := 0;
1260: l_sign_due_amount ap_terms_lines.due_amount%TYPE;
1261: l_sign_remaining_amount ap_terms_lines.due_amount%TYPE;
1262: l_calendar ap_terms_lines.calendar%TYPE; -- for payment terms
1263: l_terms_calendar ap_terms_lines.calendar%TYPE; -- for payment terms
1264: l_due_date ap_other_periods.due_date%TYPE; -- for payment terms

Line 1261: l_sign_remaining_amount ap_terms_lines.due_amount%TYPE;

1257:
1258: l_payment_cross_rate ap_payment_schedules.payment_cross_rate%TYPE;
1259: l_sequence_num ap_terms_lines.sequence_num%TYPE := 0;
1260: l_sign_due_amount ap_terms_lines.due_amount%TYPE;
1261: l_sign_remaining_amount ap_terms_lines.due_amount%TYPE;
1262: l_calendar ap_terms_lines.calendar%TYPE; -- for payment terms
1263: l_terms_calendar ap_terms_lines.calendar%TYPE; -- for payment terms
1264: l_due_date ap_other_periods.due_date%TYPE; -- for payment terms
1265: l_invoice_sign NUMBER;

Line 1262: l_calendar ap_terms_lines.calendar%TYPE; -- for payment terms

1258: l_payment_cross_rate ap_payment_schedules.payment_cross_rate%TYPE;
1259: l_sequence_num ap_terms_lines.sequence_num%TYPE := 0;
1260: l_sign_due_amount ap_terms_lines.due_amount%TYPE;
1261: l_sign_remaining_amount ap_terms_lines.due_amount%TYPE;
1262: l_calendar ap_terms_lines.calendar%TYPE; -- for payment terms
1263: l_terms_calendar ap_terms_lines.calendar%TYPE; -- for payment terms
1264: l_due_date ap_other_periods.due_date%TYPE; -- for payment terms
1265: l_invoice_sign NUMBER;
1266: l_pay_sched_total NUMBER;

Line 1263: l_terms_calendar ap_terms_lines.calendar%TYPE; -- for payment terms

1259: l_sequence_num ap_terms_lines.sequence_num%TYPE := 0;
1260: l_sign_due_amount ap_terms_lines.due_amount%TYPE;
1261: l_sign_remaining_amount ap_terms_lines.due_amount%TYPE;
1262: l_calendar ap_terms_lines.calendar%TYPE; -- for payment terms
1263: l_terms_calendar ap_terms_lines.calendar%TYPE; -- for payment terms
1264: l_due_date ap_other_periods.due_date%TYPE; -- for payment terms
1265: l_invoice_sign NUMBER;
1266: l_pay_sched_total NUMBER;
1267: l_inv_curr_sched_total NUMBER;

Line 1311: FROM ap_terms_lines

1307: l_net_of_ret_flag ap_invoices.net_of_retainage_flag%TYPE; --bug 8991699
1308:
1309: CURSOR c_terms_percent IS
1310: SELECT 'Terms are percent type'
1311: FROM ap_terms_lines
1312: WHERE term_id = P_Terms_Id
1313: AND sequence_num = 1
1314: AND due_percent IS NOT NULL;
1315:

Line 1320: FROM ap_terms_lines

1316: -- add cursor c_terms for calendar based payment terms
1317:
1318: CURSOR c_terms IS
1319: SELECT calendar, sequence_num
1320: FROM ap_terms_lines
1321: WHERE term_id = p_terms_id
1322: ORDER BY sequence_num;
1323:
1324: --bug 2143298 provides payment terms for credit/debit memo

Line 1332: FROM ap_terms_lines

1328: due_amount ,
1329: SIGN(ABS(l_remaining_amount) - ABS(due_amount)) ,
1330: ABS(l_remaining_amount) - ABS(due_amount) ,
1331: calendar -- change for calendar based payment terms
1332: FROM ap_terms_lines
1333: WHERE term_id = P_Terms_Id
1334: AND sequence_num = l_sequence_num;
1335:
1336: CURSOR c_shed_total IS

Line 1605: NVL(ap_terms_lines.discount_percent,0)/100 ,

1601: DECODE(P_Pay_Curr_Invoice_Amount, 0, 0,
1602: (l_amount_for_discount/
1603: DECODE(P_Pay_Curr_Invoice_Amount, 0, 1,
1604: P_Pay_Curr_Invoice_Amount))) *
1605: NVL(ap_terms_lines.discount_percent,0)/100 ,
1606: l_precision_pay_curr),
1607: ROUND(( l_ins_gross_amount *
1608: DECODE(P_Pay_Curr_Invoice_Amount, 0, 0,
1609: (l_amount_for_discount/

Line 1612: NVL(ap_terms_lines.discount_percent,0)/100)

1608: DECODE(P_Pay_Curr_Invoice_Amount, 0, 0,
1609: (l_amount_for_discount/
1610: DECODE(P_Pay_Curr_Invoice_Amount, 0, 1,
1611: P_Pay_Curr_Invoice_Amount))) *
1612: NVL(ap_terms_lines.discount_percent,0)/100)
1613: / l_min_acc_unit_pay_curr) * l_min_acc_unit_pay_curr)
1614: , DECODE(l_min_acc_unit_pay_curr,
1615: NULL, ROUND( l_ins_gross_amount *
1616: DECODE(P_Pay_Curr_Invoice_Amount, 0, 0,

Line 1620: NVL(ap_terms_lines.discount_percent_2,0)/100 ,

1616: DECODE(P_Pay_Curr_Invoice_Amount, 0, 0,
1617: (l_amount_for_discount/
1618: DECODE(P_Pay_Curr_Invoice_Amount, 0, 1,
1619: P_Pay_Curr_Invoice_Amount))) *
1620: NVL(ap_terms_lines.discount_percent_2,0)/100 ,
1621: l_precision_pay_curr),
1622: ROUND(( l_ins_gross_amount *
1623: DECODE(P_Pay_Curr_Invoice_Amount, 0, 0,
1624: (l_amount_for_discount/

Line 1627: NVL(ap_terms_lines.discount_percent_2,0)/100)

1623: DECODE(P_Pay_Curr_Invoice_Amount, 0, 0,
1624: (l_amount_for_discount/
1625: DECODE(P_Pay_Curr_Invoice_Amount, 0, 1,
1626: P_Pay_Curr_Invoice_Amount))) *
1627: NVL(ap_terms_lines.discount_percent_2,0)/100)
1628: / l_min_acc_unit_pay_curr) * l_min_acc_unit_pay_curr)
1629: , DECODE(l_min_acc_unit_pay_curr,
1630: NULL, ROUND( l_ins_gross_amount *
1631: DECODE(P_Pay_Curr_Invoice_Amount, 0, 0,

Line 1635: NVL(ap_terms_lines.discount_percent_3,0)/100 ,

1631: DECODE(P_Pay_Curr_Invoice_Amount, 0, 0,
1632: (l_amount_for_discount/
1633: DECODE(P_Pay_Curr_Invoice_Amount, 0, 1,
1634: P_Pay_Curr_Invoice_Amount))) *
1635: NVL(ap_terms_lines.discount_percent_3,0)/100 ,
1636: l_precision_pay_curr),
1637: ROUND(( l_ins_gross_amount *
1638: DECODE(P_Pay_Curr_Invoice_Amount, 0, 0,
1639: (l_amount_for_discount/

Line 1642: NVL(ap_terms_lines.discount_percent_3,0)/100)

1638: DECODE(P_Pay_Curr_Invoice_Amount, 0, 0,
1639: (l_amount_for_discount/
1640: DECODE(P_Pay_Curr_Invoice_Amount, 0, 1,
1641: P_Pay_Curr_Invoice_Amount))) *
1642: NVL(ap_terms_lines.discount_percent_3,0)/100)
1643: / l_min_acc_unit_pay_curr) * l_min_acc_unit_pay_curr),
1644: discount_amount,
1645: discount_amount_2,
1646: discount_amount_3

Line 1651: FROM ap_terms

1647: INTO
1648: l_disc_amt_by_percent, l_disc_amt_by_percent_2, l_disc_amt_by_percent_3,
1649: l_discount_amount, l_discount_amount_2, l_discount_amount_3
1650:
1651: FROM ap_terms
1652: , ap_terms_lines
1653: , ap_invoices ai
1654: WHERE ap_terms.term_id = ap_terms_lines.term_id
1655: AND ap_terms_lines.term_id = P_Terms_Id

Line 1652: , ap_terms_lines

1648: l_disc_amt_by_percent, l_disc_amt_by_percent_2, l_disc_amt_by_percent_3,
1649: l_discount_amount, l_discount_amount_2, l_discount_amount_3
1650:
1651: FROM ap_terms
1652: , ap_terms_lines
1653: , ap_invoices ai
1654: WHERE ap_terms.term_id = ap_terms_lines.term_id
1655: AND ap_terms_lines.term_id = P_Terms_Id
1656: AND ap_terms_lines.sequence_num = l_sequence_num

Line 1654: WHERE ap_terms.term_id = ap_terms_lines.term_id

1650:
1651: FROM ap_terms
1652: , ap_terms_lines
1653: , ap_invoices ai
1654: WHERE ap_terms.term_id = ap_terms_lines.term_id
1655: AND ap_terms_lines.term_id = P_Terms_Id
1656: AND ap_terms_lines.sequence_num = l_sequence_num
1657: AND ai.Invoice_Id = P_Invoice_Id;
1658:

Line 1655: AND ap_terms_lines.term_id = P_Terms_Id

1651: FROM ap_terms
1652: , ap_terms_lines
1653: , ap_invoices ai
1654: WHERE ap_terms.term_id = ap_terms_lines.term_id
1655: AND ap_terms_lines.term_id = P_Terms_Id
1656: AND ap_terms_lines.sequence_num = l_sequence_num
1657: AND ai.Invoice_Id = P_Invoice_Id;
1658:
1659: --Bug 7357218 Quick Pay and Dispute Resolution Project

Line 1656: AND ap_terms_lines.sequence_num = l_sequence_num

1652: , ap_terms_lines
1653: , ap_invoices ai
1654: WHERE ap_terms.term_id = ap_terms_lines.term_id
1655: AND ap_terms_lines.term_id = P_Terms_Id
1656: AND ap_terms_lines.sequence_num = l_sequence_num
1657: AND ai.Invoice_Id = P_Invoice_Id;
1658:
1659: --Bug 7357218 Quick Pay and Dispute Resolution Project
1660: --Calculating discount amounts by percent for slab type END

Line 1729: DECODE(ap_terms_lines.discount_days,

1725: SELECT
1726: P_Invoice_Id,
1727: l_sequence_num,
1728: l_due_date, -- change for payment terms
1729: DECODE(ap_terms_lines.discount_days,
1730: NULL, DECODE(ap_terms_lines.discount_day_of_month, NULL, NULL,
1731: TO_DATE(TO_CHAR(LEAST(NVL(ap_terms_lines.discount_day_of_month,32),
1732: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS
1733: (P_Terms_Date, NVL(ap_terms_lines.discount_months_forward,0) +

Line 1730: NULL, DECODE(ap_terms_lines.discount_day_of_month, NULL, NULL,

1726: P_Invoice_Id,
1727: l_sequence_num,
1728: l_due_date, -- change for payment terms
1729: DECODE(ap_terms_lines.discount_days,
1730: NULL, DECODE(ap_terms_lines.discount_day_of_month, NULL, NULL,
1731: TO_DATE(TO_CHAR(LEAST(NVL(ap_terms_lines.discount_day_of_month,32),
1732: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS
1733: (P_Terms_Date, NVL(ap_terms_lines.discount_months_forward,0) +
1734: DECODE(ap_terms.due_cutoff_day, NULL, 0,

Line 1731: TO_DATE(TO_CHAR(LEAST(NVL(ap_terms_lines.discount_day_of_month,32),

1727: l_sequence_num,
1728: l_due_date, -- change for payment terms
1729: DECODE(ap_terms_lines.discount_days,
1730: NULL, DECODE(ap_terms_lines.discount_day_of_month, NULL, NULL,
1731: TO_DATE(TO_CHAR(LEAST(NVL(ap_terms_lines.discount_day_of_month,32),
1732: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS
1733: (P_Terms_Date, NVL(ap_terms_lines.discount_months_forward,0) +
1734: DECODE(ap_terms.due_cutoff_day, NULL, 0,
1735: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),

Line 1733: (P_Terms_Date, NVL(ap_terms_lines.discount_months_forward,0) +

1729: DECODE(ap_terms_lines.discount_days,
1730: NULL, DECODE(ap_terms_lines.discount_day_of_month, NULL, NULL,
1731: TO_DATE(TO_CHAR(LEAST(NVL(ap_terms_lines.discount_day_of_month,32),
1732: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS
1733: (P_Terms_Date, NVL(ap_terms_lines.discount_months_forward,0) +
1734: DECODE(ap_terms.due_cutoff_day, NULL, 0,
1735: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
1736: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date), 'DD'))),
1737: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),

Line 1734: DECODE(ap_terms.due_cutoff_day, NULL, 0,

1730: NULL, DECODE(ap_terms_lines.discount_day_of_month, NULL, NULL,
1731: TO_DATE(TO_CHAR(LEAST(NVL(ap_terms_lines.discount_day_of_month,32),
1732: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS
1733: (P_Terms_Date, NVL(ap_terms_lines.discount_months_forward,0) +
1734: DECODE(ap_terms.due_cutoff_day, NULL, 0,
1735: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
1736: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date), 'DD'))),
1737: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
1738: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))

Line 1735: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),

1731: TO_DATE(TO_CHAR(LEAST(NVL(ap_terms_lines.discount_day_of_month,32),
1732: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS
1733: (P_Terms_Date, NVL(ap_terms_lines.discount_months_forward,0) +
1734: DECODE(ap_terms.due_cutoff_day, NULL, 0,
1735: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
1736: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date), 'DD'))),
1737: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
1738: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))
1739: , 1, 0)))), 'DD')))) || '-' ||

Line 1741: NVL(ap_terms_lines.discount_months_forward,0) +

1737: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
1738: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))
1739: , 1, 0)))), 'DD')))) || '-' ||
1740: TO_CHAR(ADD_MONTHS(P_Terms_Date,
1741: NVL(ap_terms_lines.discount_months_forward,0) +
1742: DECODE(ap_terms.due_cutoff_day, NULL, 0,
1743: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
1744: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date),'DD'))),
1745: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),

Line 1742: DECODE(ap_terms.due_cutoff_day, NULL, 0,

1738: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))
1739: , 1, 0)))), 'DD')))) || '-' ||
1740: TO_CHAR(ADD_MONTHS(P_Terms_Date,
1741: NVL(ap_terms_lines.discount_months_forward,0) +
1742: DECODE(ap_terms.due_cutoff_day, NULL, 0,
1743: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
1744: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date),'DD'))),
1745: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
1746: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD')), 1, 0))), 'MON-RR'),'DD-MON-RR')), /*bugfix:5647464 */

Line 1743: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),

1739: , 1, 0)))), 'DD')))) || '-' ||
1740: TO_CHAR(ADD_MONTHS(P_Terms_Date,
1741: NVL(ap_terms_lines.discount_months_forward,0) +
1742: DECODE(ap_terms.due_cutoff_day, NULL, 0,
1743: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
1744: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date),'DD'))),
1745: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
1746: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD')), 1, 0))), 'MON-RR'),'DD-MON-RR')), /*bugfix:5647464 */
1747: P_Terms_Date + NVL(ap_terms_lines.discount_days,0)),

Line 1747: P_Terms_Date + NVL(ap_terms_lines.discount_days,0)),

1743: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
1744: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date),'DD'))),
1745: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
1746: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD')), 1, 0))), 'MON-RR'),'DD-MON-RR')), /*bugfix:5647464 */
1747: P_Terms_Date + NVL(ap_terms_lines.discount_days,0)),
1748: DECODE(ap_terms_lines.discount_days_2,
1749: NULL,DECODE(ap_terms_lines.discount_day_of_month_2,NULL,NULL,
1750: TO_DATE(TO_CHAR(LEAST
1751: (NVL(ap_terms_lines.discount_day_of_month_2,32),

Line 1748: DECODE(ap_terms_lines.discount_days_2,

1744: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date),'DD'))),
1745: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
1746: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD')), 1, 0))), 'MON-RR'),'DD-MON-RR')), /*bugfix:5647464 */
1747: P_Terms_Date + NVL(ap_terms_lines.discount_days,0)),
1748: DECODE(ap_terms_lines.discount_days_2,
1749: NULL,DECODE(ap_terms_lines.discount_day_of_month_2,NULL,NULL,
1750: TO_DATE(TO_CHAR(LEAST
1751: (NVL(ap_terms_lines.discount_day_of_month_2,32),
1752: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS(P_Terms_Date,

Line 1749: NULL,DECODE(ap_terms_lines.discount_day_of_month_2,NULL,NULL,

1745: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
1746: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD')), 1, 0))), 'MON-RR'),'DD-MON-RR')), /*bugfix:5647464 */
1747: P_Terms_Date + NVL(ap_terms_lines.discount_days,0)),
1748: DECODE(ap_terms_lines.discount_days_2,
1749: NULL,DECODE(ap_terms_lines.discount_day_of_month_2,NULL,NULL,
1750: TO_DATE(TO_CHAR(LEAST
1751: (NVL(ap_terms_lines.discount_day_of_month_2,32),
1752: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS(P_Terms_Date,
1753: NVL(ap_terms_lines.discount_months_forward_2,0) +

Line 1751: (NVL(ap_terms_lines.discount_day_of_month_2,32),

1747: P_Terms_Date + NVL(ap_terms_lines.discount_days,0)),
1748: DECODE(ap_terms_lines.discount_days_2,
1749: NULL,DECODE(ap_terms_lines.discount_day_of_month_2,NULL,NULL,
1750: TO_DATE(TO_CHAR(LEAST
1751: (NVL(ap_terms_lines.discount_day_of_month_2,32),
1752: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS(P_Terms_Date,
1753: NVL(ap_terms_lines.discount_months_forward_2,0) +
1754: DECODE(ap_terms.due_cutoff_day, NULL, 0,
1755: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),

Line 1753: NVL(ap_terms_lines.discount_months_forward_2,0) +

1749: NULL,DECODE(ap_terms_lines.discount_day_of_month_2,NULL,NULL,
1750: TO_DATE(TO_CHAR(LEAST
1751: (NVL(ap_terms_lines.discount_day_of_month_2,32),
1752: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS(P_Terms_Date,
1753: NVL(ap_terms_lines.discount_months_forward_2,0) +
1754: DECODE(ap_terms.due_cutoff_day, NULL, 0,
1755: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
1756: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date), 'DD'))),
1757: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),

Line 1754: DECODE(ap_terms.due_cutoff_day, NULL, 0,

1750: TO_DATE(TO_CHAR(LEAST
1751: (NVL(ap_terms_lines.discount_day_of_month_2,32),
1752: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS(P_Terms_Date,
1753: NVL(ap_terms_lines.discount_months_forward_2,0) +
1754: DECODE(ap_terms.due_cutoff_day, NULL, 0,
1755: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
1756: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date), 'DD'))),
1757: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
1758: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))

Line 1755: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),

1751: (NVL(ap_terms_lines.discount_day_of_month_2,32),
1752: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS(P_Terms_Date,
1753: NVL(ap_terms_lines.discount_months_forward_2,0) +
1754: DECODE(ap_terms.due_cutoff_day, NULL, 0,
1755: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
1756: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date), 'DD'))),
1757: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
1758: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))
1759: , 1, 0)))), 'DD')))) || '-' ||

Line 1761: NVL(ap_terms_lines.discount_months_forward_2,0) +

1757: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
1758: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))
1759: , 1, 0)))), 'DD')))) || '-' ||
1760: TO_CHAR(ADD_MONTHS(P_Terms_Date,
1761: NVL(ap_terms_lines.discount_months_forward_2,0) +
1762: DECODE(ap_terms.due_cutoff_day, NULL, 0,
1763: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
1764: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date),'DD'))),
1765: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),

Line 1762: DECODE(ap_terms.due_cutoff_day, NULL, 0,

1758: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))
1759: , 1, 0)))), 'DD')))) || '-' ||
1760: TO_CHAR(ADD_MONTHS(P_Terms_Date,
1761: NVL(ap_terms_lines.discount_months_forward_2,0) +
1762: DECODE(ap_terms.due_cutoff_day, NULL, 0,
1763: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
1764: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date),'DD'))),
1765: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
1766: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD')), 1, 0))), 'MON-RR'),'DD-MON-RR')), /*bugfix:5647464 */

Line 1763: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),

1759: , 1, 0)))), 'DD')))) || '-' ||
1760: TO_CHAR(ADD_MONTHS(P_Terms_Date,
1761: NVL(ap_terms_lines.discount_months_forward_2,0) +
1762: DECODE(ap_terms.due_cutoff_day, NULL, 0,
1763: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
1764: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date),'DD'))),
1765: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
1766: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD')), 1, 0))), 'MON-RR'),'DD-MON-RR')), /*bugfix:5647464 */
1767: P_Terms_Date + NVL(ap_terms_lines.discount_days_2,0)),

Line 1767: P_Terms_Date + NVL(ap_terms_lines.discount_days_2,0)),

1763: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
1764: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date),'DD'))),
1765: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
1766: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD')), 1, 0))), 'MON-RR'),'DD-MON-RR')), /*bugfix:5647464 */
1767: P_Terms_Date + NVL(ap_terms_lines.discount_days_2,0)),
1768: DECODE(ap_terms_lines.discount_days_3,
1769: NULL, DECODE(ap_terms_lines.discount_day_of_month_3, NULL,NULL,
1770: TO_DATE(TO_CHAR(LEAST
1771: (NVL(ap_terms_lines.discount_day_of_month_3,32),

Line 1768: DECODE(ap_terms_lines.discount_days_3,

1764: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date),'DD'))),
1765: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
1766: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD')), 1, 0))), 'MON-RR'),'DD-MON-RR')), /*bugfix:5647464 */
1767: P_Terms_Date + NVL(ap_terms_lines.discount_days_2,0)),
1768: DECODE(ap_terms_lines.discount_days_3,
1769: NULL, DECODE(ap_terms_lines.discount_day_of_month_3, NULL,NULL,
1770: TO_DATE(TO_CHAR(LEAST
1771: (NVL(ap_terms_lines.discount_day_of_month_3,32),
1772: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS(P_Terms_Date,

Line 1769: NULL, DECODE(ap_terms_lines.discount_day_of_month_3, NULL,NULL,

1765: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
1766: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD')), 1, 0))), 'MON-RR'),'DD-MON-RR')), /*bugfix:5647464 */
1767: P_Terms_Date + NVL(ap_terms_lines.discount_days_2,0)),
1768: DECODE(ap_terms_lines.discount_days_3,
1769: NULL, DECODE(ap_terms_lines.discount_day_of_month_3, NULL,NULL,
1770: TO_DATE(TO_CHAR(LEAST
1771: (NVL(ap_terms_lines.discount_day_of_month_3,32),
1772: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS(P_Terms_Date,
1773: NVL(ap_terms_lines.discount_months_forward_3,0) +

Line 1771: (NVL(ap_terms_lines.discount_day_of_month_3,32),

1767: P_Terms_Date + NVL(ap_terms_lines.discount_days_2,0)),
1768: DECODE(ap_terms_lines.discount_days_3,
1769: NULL, DECODE(ap_terms_lines.discount_day_of_month_3, NULL,NULL,
1770: TO_DATE(TO_CHAR(LEAST
1771: (NVL(ap_terms_lines.discount_day_of_month_3,32),
1772: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS(P_Terms_Date,
1773: NVL(ap_terms_lines.discount_months_forward_3,0) +
1774: DECODE(ap_terms.due_cutoff_day, NULL, 0,
1775: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),

Line 1773: NVL(ap_terms_lines.discount_months_forward_3,0) +

1769: NULL, DECODE(ap_terms_lines.discount_day_of_month_3, NULL,NULL,
1770: TO_DATE(TO_CHAR(LEAST
1771: (NVL(ap_terms_lines.discount_day_of_month_3,32),
1772: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS(P_Terms_Date,
1773: NVL(ap_terms_lines.discount_months_forward_3,0) +
1774: DECODE(ap_terms.due_cutoff_day, NULL, 0,
1775: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
1776: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date), 'DD'))),
1777: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),

Line 1774: DECODE(ap_terms.due_cutoff_day, NULL, 0,

1770: TO_DATE(TO_CHAR(LEAST
1771: (NVL(ap_terms_lines.discount_day_of_month_3,32),
1772: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS(P_Terms_Date,
1773: NVL(ap_terms_lines.discount_months_forward_3,0) +
1774: DECODE(ap_terms.due_cutoff_day, NULL, 0,
1775: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
1776: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date), 'DD'))),
1777: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
1778: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))

Line 1775: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),

1771: (NVL(ap_terms_lines.discount_day_of_month_3,32),
1772: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS(P_Terms_Date,
1773: NVL(ap_terms_lines.discount_months_forward_3,0) +
1774: DECODE(ap_terms.due_cutoff_day, NULL, 0,
1775: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
1776: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date), 'DD'))),
1777: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
1778: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))
1779: , 1, 0)))), 'DD')))) || '-' ||

Line 1781: NVL(ap_terms_lines.discount_months_forward_3,0) +

1777: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
1778: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))
1779: , 1, 0)))), 'DD')))) || '-' ||
1780: TO_CHAR(ADD_MONTHS(P_Terms_Date,
1781: NVL(ap_terms_lines.discount_months_forward_3,0) +
1782: DECODE(ap_terms.due_cutoff_day, NULL, 0,
1783: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
1784: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date),'DD'))),
1785: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),

Line 1782: DECODE(ap_terms.due_cutoff_day, NULL, 0,

1778: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))
1779: , 1, 0)))), 'DD')))) || '-' ||
1780: TO_CHAR(ADD_MONTHS(P_Terms_Date,
1781: NVL(ap_terms_lines.discount_months_forward_3,0) +
1782: DECODE(ap_terms.due_cutoff_day, NULL, 0,
1783: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
1784: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date),'DD'))),
1785: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
1786: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD')), 1, 0))), 'MON-RR'),'DD-MON-RR')), /*bugfix:5647464 */

Line 1783: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),

1779: , 1, 0)))), 'DD')))) || '-' ||
1780: TO_CHAR(ADD_MONTHS(P_Terms_Date,
1781: NVL(ap_terms_lines.discount_months_forward_3,0) +
1782: DECODE(ap_terms.due_cutoff_day, NULL, 0,
1783: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
1784: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date),'DD'))),
1785: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
1786: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD')), 1, 0))), 'MON-RR'),'DD-MON-RR')), /*bugfix:5647464 */
1787: P_Terms_Date + NVL(ap_terms_lines.discount_days_3,0)),

Line 1787: P_Terms_Date + NVL(ap_terms_lines.discount_days_3,0)),

1783: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
1784: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date),'DD'))),
1785: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
1786: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD')), 1, 0))), 'MON-RR'),'DD-MON-RR')), /*bugfix:5647464 */
1787: P_Terms_Date + NVL(ap_terms_lines.discount_days_3,0)),
1788: SYSDATE,
1789: P_Last_Updated_By,
1790: NULL,
1791: SYSDATE,

Line 1867: FROM ap_terms,

1863: ,ai.remit_to_supplier_id
1864: ,ai.remit_to_supplier_site
1865: ,ai.remit_to_supplier_site_id
1866: ,ai.relationship_id
1867: FROM ap_terms,
1868: ap_terms_lines,
1869: ap_invoices ai,
1870: ap_recurring_payments arp --bug 5332569
1871: WHERE ap_terms.term_id = ap_terms_lines.term_id

Line 1868: ap_terms_lines,

1864: ,ai.remit_to_supplier_site
1865: ,ai.remit_to_supplier_site_id
1866: ,ai.relationship_id
1867: FROM ap_terms,
1868: ap_terms_lines,
1869: ap_invoices ai,
1870: ap_recurring_payments arp --bug 5332569
1871: WHERE ap_terms.term_id = ap_terms_lines.term_id
1872: AND ap_terms_lines.term_id = P_Terms_Id

Line 1871: WHERE ap_terms.term_id = ap_terms_lines.term_id

1867: FROM ap_terms,
1868: ap_terms_lines,
1869: ap_invoices ai,
1870: ap_recurring_payments arp --bug 5332569
1871: WHERE ap_terms.term_id = ap_terms_lines.term_id
1872: AND ap_terms_lines.term_id = P_Terms_Id
1873: AND ap_terms_lines.sequence_num = l_sequence_num
1874: AND ai.Invoice_Id = P_Invoice_Id
1875: AND ai.recurring_payment_id = arp.recurring_payment_id(+); --bug 5332569

Line 1872: AND ap_terms_lines.term_id = P_Terms_Id

1868: ap_terms_lines,
1869: ap_invoices ai,
1870: ap_recurring_payments arp --bug 5332569
1871: WHERE ap_terms.term_id = ap_terms_lines.term_id
1872: AND ap_terms_lines.term_id = P_Terms_Id
1873: AND ap_terms_lines.sequence_num = l_sequence_num
1874: AND ai.Invoice_Id = P_Invoice_Id
1875: AND ai.recurring_payment_id = arp.recurring_payment_id(+); --bug 5332569
1876:

Line 1873: AND ap_terms_lines.sequence_num = l_sequence_num

1869: ap_invoices ai,
1870: ap_recurring_payments arp --bug 5332569
1871: WHERE ap_terms.term_id = ap_terms_lines.term_id
1872: AND ap_terms_lines.term_id = P_Terms_Id
1873: AND ap_terms_lines.sequence_num = l_sequence_num
1874: AND ai.Invoice_Id = P_Invoice_Id
1875: AND ai.recurring_payment_id = arp.recurring_payment_id(+); --bug 5332569
1876:
1877: l_debug_info := 'After Insert into ap_payment_schedules- term type is not percent'; --bug 8991699

Line 1939: NVL(ap_terms_lines.discount_percent,0)/100 *

1935: debug_info := 'Calculating discount amounts by percent for pecent type BEGIN';
1936:
1937: SELECT DECODE(l_min_acc_unit_pay_curr,NULL,
1938: ROUND( l_amount_for_discount *
1939: NVL(ap_terms_lines.discount_percent,0)/100 *
1940: NVL(ap_terms_lines.due_percent, 0)/100,
1941: l_precision_pay_curr),
1942: ROUND(( l_amount_for_discount *
1943: NVL(ap_terms_lines.discount_percent,0)/100 *

Line 1940: NVL(ap_terms_lines.due_percent, 0)/100,

1936:
1937: SELECT DECODE(l_min_acc_unit_pay_curr,NULL,
1938: ROUND( l_amount_for_discount *
1939: NVL(ap_terms_lines.discount_percent,0)/100 *
1940: NVL(ap_terms_lines.due_percent, 0)/100,
1941: l_precision_pay_curr),
1942: ROUND(( l_amount_for_discount *
1943: NVL(ap_terms_lines.discount_percent,0)/100 *
1944: NVL(ap_terms_lines.due_percent, 0)/100)

Line 1943: NVL(ap_terms_lines.discount_percent,0)/100 *

1939: NVL(ap_terms_lines.discount_percent,0)/100 *
1940: NVL(ap_terms_lines.due_percent, 0)/100,
1941: l_precision_pay_curr),
1942: ROUND(( l_amount_for_discount *
1943: NVL(ap_terms_lines.discount_percent,0)/100 *
1944: NVL(ap_terms_lines.due_percent, 0)/100)
1945: / l_min_acc_unit_pay_curr)
1946: * l_min_acc_unit_pay_curr)
1947: , DECODE(l_min_acc_unit_pay_curr,NULL,

Line 1944: NVL(ap_terms_lines.due_percent, 0)/100)

1940: NVL(ap_terms_lines.due_percent, 0)/100,
1941: l_precision_pay_curr),
1942: ROUND(( l_amount_for_discount *
1943: NVL(ap_terms_lines.discount_percent,0)/100 *
1944: NVL(ap_terms_lines.due_percent, 0)/100)
1945: / l_min_acc_unit_pay_curr)
1946: * l_min_acc_unit_pay_curr)
1947: , DECODE(l_min_acc_unit_pay_curr,NULL,
1948: ROUND( l_amount_for_discount *

Line 1949: NVL(ap_terms_lines.discount_percent_2,0)/100 *

1945: / l_min_acc_unit_pay_curr)
1946: * l_min_acc_unit_pay_curr)
1947: , DECODE(l_min_acc_unit_pay_curr,NULL,
1948: ROUND( l_amount_for_discount *
1949: NVL(ap_terms_lines.discount_percent_2,0)/100 *
1950: NVL(ap_terms_lines.due_percent, 0)/100,
1951: l_precision_pay_curr),
1952: ROUND(( l_amount_for_discount *
1953: NVL(ap_terms_lines.discount_percent_2,0)/100 *

Line 1950: NVL(ap_terms_lines.due_percent, 0)/100,

1946: * l_min_acc_unit_pay_curr)
1947: , DECODE(l_min_acc_unit_pay_curr,NULL,
1948: ROUND( l_amount_for_discount *
1949: NVL(ap_terms_lines.discount_percent_2,0)/100 *
1950: NVL(ap_terms_lines.due_percent, 0)/100,
1951: l_precision_pay_curr),
1952: ROUND(( l_amount_for_discount *
1953: NVL(ap_terms_lines.discount_percent_2,0)/100 *
1954: NVL(ap_terms_lines.due_percent, 0)/100)

Line 1953: NVL(ap_terms_lines.discount_percent_2,0)/100 *

1949: NVL(ap_terms_lines.discount_percent_2,0)/100 *
1950: NVL(ap_terms_lines.due_percent, 0)/100,
1951: l_precision_pay_curr),
1952: ROUND(( l_amount_for_discount *
1953: NVL(ap_terms_lines.discount_percent_2,0)/100 *
1954: NVL(ap_terms_lines.due_percent, 0)/100)
1955: / l_min_acc_unit_pay_curr)
1956: * l_min_acc_unit_pay_curr)
1957: ,DECODE(l_min_acc_unit_pay_curr,NULL,

Line 1954: NVL(ap_terms_lines.due_percent, 0)/100)

1950: NVL(ap_terms_lines.due_percent, 0)/100,
1951: l_precision_pay_curr),
1952: ROUND(( l_amount_for_discount *
1953: NVL(ap_terms_lines.discount_percent_2,0)/100 *
1954: NVL(ap_terms_lines.due_percent, 0)/100)
1955: / l_min_acc_unit_pay_curr)
1956: * l_min_acc_unit_pay_curr)
1957: ,DECODE(l_min_acc_unit_pay_curr,NULL,
1958: ROUND( l_amount_for_discount *

Line 1959: NVL(ap_terms_lines.discount_percent_3,0)/100 *

1955: / l_min_acc_unit_pay_curr)
1956: * l_min_acc_unit_pay_curr)
1957: ,DECODE(l_min_acc_unit_pay_curr,NULL,
1958: ROUND( l_amount_for_discount *
1959: NVL(ap_terms_lines.discount_percent_3,0)/100 *
1960: NVL(ap_terms_lines.due_percent, 0)/100,
1961: l_precision_pay_curr),
1962: ROUND(( l_amount_for_discount *
1963: NVL(ap_terms_lines.discount_percent_3,0)/100 *

Line 1960: NVL(ap_terms_lines.due_percent, 0)/100,

1956: * l_min_acc_unit_pay_curr)
1957: ,DECODE(l_min_acc_unit_pay_curr,NULL,
1958: ROUND( l_amount_for_discount *
1959: NVL(ap_terms_lines.discount_percent_3,0)/100 *
1960: NVL(ap_terms_lines.due_percent, 0)/100,
1961: l_precision_pay_curr),
1962: ROUND(( l_amount_for_discount *
1963: NVL(ap_terms_lines.discount_percent_3,0)/100 *
1964: NVL(ap_terms_lines.due_percent, 0)/100)

Line 1963: NVL(ap_terms_lines.discount_percent_3,0)/100 *

1959: NVL(ap_terms_lines.discount_percent_3,0)/100 *
1960: NVL(ap_terms_lines.due_percent, 0)/100,
1961: l_precision_pay_curr),
1962: ROUND(( l_amount_for_discount *
1963: NVL(ap_terms_lines.discount_percent_3,0)/100 *
1964: NVL(ap_terms_lines.due_percent, 0)/100)
1965: / l_min_acc_unit_pay_curr)
1966: * l_min_acc_unit_pay_curr),
1967: discount_amount,

Line 1964: NVL(ap_terms_lines.due_percent, 0)/100)

1960: NVL(ap_terms_lines.due_percent, 0)/100,
1961: l_precision_pay_curr),
1962: ROUND(( l_amount_for_discount *
1963: NVL(ap_terms_lines.discount_percent_3,0)/100 *
1964: NVL(ap_terms_lines.due_percent, 0)/100)
1965: / l_min_acc_unit_pay_curr)
1966: * l_min_acc_unit_pay_curr),
1967: discount_amount,
1968: discount_amount_2,

Line 1974: FROM ap_terms,

1970: INTO
1971: l_disc_amt_by_percent, l_disc_amt_by_percent_2, l_disc_amt_by_percent_3,
1972: l_discount_amount, l_discount_amount_2, l_discount_amount_3
1973:
1974: FROM ap_terms,
1975: ap_terms_lines,
1976: ap_invoices ai,
1977: ap_recurring_payments arp
1978: WHERE ap_terms.term_id = ap_terms_lines.term_id

Line 1975: ap_terms_lines,

1971: l_disc_amt_by_percent, l_disc_amt_by_percent_2, l_disc_amt_by_percent_3,
1972: l_discount_amount, l_discount_amount_2, l_discount_amount_3
1973:
1974: FROM ap_terms,
1975: ap_terms_lines,
1976: ap_invoices ai,
1977: ap_recurring_payments arp
1978: WHERE ap_terms.term_id = ap_terms_lines.term_id
1979: AND ap_terms_lines.term_id = P_Terms_Id

Line 1978: WHERE ap_terms.term_id = ap_terms_lines.term_id

1974: FROM ap_terms,
1975: ap_terms_lines,
1976: ap_invoices ai,
1977: ap_recurring_payments arp
1978: WHERE ap_terms.term_id = ap_terms_lines.term_id
1979: AND ap_terms_lines.term_id = P_Terms_Id
1980: AND ap_terms_lines.sequence_num = l_sequence_num
1981: AND ai.Invoice_Id = P_Invoice_Id
1982: AND ai.recurring_payment_id = arp.recurring_payment_id(+);

Line 1979: AND ap_terms_lines.term_id = P_Terms_Id

1975: ap_terms_lines,
1976: ap_invoices ai,
1977: ap_recurring_payments arp
1978: WHERE ap_terms.term_id = ap_terms_lines.term_id
1979: AND ap_terms_lines.term_id = P_Terms_Id
1980: AND ap_terms_lines.sequence_num = l_sequence_num
1981: AND ai.Invoice_Id = P_Invoice_Id
1982: AND ai.recurring_payment_id = arp.recurring_payment_id(+);
1983:

Line 1980: AND ap_terms_lines.sequence_num = l_sequence_num

1976: ap_invoices ai,
1977: ap_recurring_payments arp
1978: WHERE ap_terms.term_id = ap_terms_lines.term_id
1979: AND ap_terms_lines.term_id = P_Terms_Id
1980: AND ap_terms_lines.sequence_num = l_sequence_num
1981: AND ai.Invoice_Id = P_Invoice_Id
1982: AND ai.recurring_payment_id = arp.recurring_payment_id(+);
1983:
1984: --Bug 7357218 Quick Pay and Dispute Resolution Project

Line 2049: l_sequence_num, -- ap_terms_lines.sequence_num

2045: ,remit_to_supplier_site_id
2046: ,relationship_id)
2047: SELECT
2048: P_Invoice_Id,
2049: l_sequence_num, -- ap_terms_lines.sequence_num
2050: l_due_date, -- change for payment terms
2051: DECODE(l_amount_for_discount, NULL, NULL,
2052: DECODE(ap_terms_lines.discount_days, NULL,
2053: DECODE(ap_terms_lines.discount_day_of_month,

Line 2052: DECODE(ap_terms_lines.discount_days, NULL,

2048: P_Invoice_Id,
2049: l_sequence_num, -- ap_terms_lines.sequence_num
2050: l_due_date, -- change for payment terms
2051: DECODE(l_amount_for_discount, NULL, NULL,
2052: DECODE(ap_terms_lines.discount_days, NULL,
2053: DECODE(ap_terms_lines.discount_day_of_month,
2054: NULL, NULL, TO_DATE(TO_CHAR(LEAST(NVL(
2055: ap_terms_lines.discount_day_of_month,32),
2056: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS

Line 2053: DECODE(ap_terms_lines.discount_day_of_month,

2049: l_sequence_num, -- ap_terms_lines.sequence_num
2050: l_due_date, -- change for payment terms
2051: DECODE(l_amount_for_discount, NULL, NULL,
2052: DECODE(ap_terms_lines.discount_days, NULL,
2053: DECODE(ap_terms_lines.discount_day_of_month,
2054: NULL, NULL, TO_DATE(TO_CHAR(LEAST(NVL(
2055: ap_terms_lines.discount_day_of_month,32),
2056: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS
2057: (P_Terms_Date,

Line 2055: ap_terms_lines.discount_day_of_month,32),

2051: DECODE(l_amount_for_discount, NULL, NULL,
2052: DECODE(ap_terms_lines.discount_days, NULL,
2053: DECODE(ap_terms_lines.discount_day_of_month,
2054: NULL, NULL, TO_DATE(TO_CHAR(LEAST(NVL(
2055: ap_terms_lines.discount_day_of_month,32),
2056: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS
2057: (P_Terms_Date,
2058: NVL(ap_terms_lines.discount_months_forward,0) +
2059: DECODE(ap_terms.due_cutoff_day, NULL, 0,

Line 2058: NVL(ap_terms_lines.discount_months_forward,0) +

2054: NULL, NULL, TO_DATE(TO_CHAR(LEAST(NVL(
2055: ap_terms_lines.discount_day_of_month,32),
2056: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS
2057: (P_Terms_Date,
2058: NVL(ap_terms_lines.discount_months_forward,0) +
2059: DECODE(ap_terms.due_cutoff_day, NULL, 0,
2060: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
2061: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date), 'DD'))),
2062: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),

Line 2059: DECODE(ap_terms.due_cutoff_day, NULL, 0,

2055: ap_terms_lines.discount_day_of_month,32),
2056: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS
2057: (P_Terms_Date,
2058: NVL(ap_terms_lines.discount_months_forward,0) +
2059: DECODE(ap_terms.due_cutoff_day, NULL, 0,
2060: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
2061: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date), 'DD'))),
2062: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
2063: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))

Line 2060: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),

2056: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS
2057: (P_Terms_Date,
2058: NVL(ap_terms_lines.discount_months_forward,0) +
2059: DECODE(ap_terms.due_cutoff_day, NULL, 0,
2060: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
2061: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date), 'DD'))),
2062: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
2063: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))
2064: , 1, 0)))), 'DD')))) || '-' ||

Line 2066: NVL(ap_terms_lines.discount_months_forward,0) +

2062: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
2063: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))
2064: , 1, 0)))), 'DD')))) || '-' ||
2065: TO_CHAR(ADD_MONTHS(P_Terms_Date,
2066: NVL(ap_terms_lines.discount_months_forward,0) +
2067: DECODE(ap_terms.due_cutoff_day, NULL, 0,
2068: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
2069: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date),'DD'))),
2070: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),

Line 2067: DECODE(ap_terms.due_cutoff_day, NULL, 0,

2063: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))
2064: , 1, 0)))), 'DD')))) || '-' ||
2065: TO_CHAR(ADD_MONTHS(P_Terms_Date,
2066: NVL(ap_terms_lines.discount_months_forward,0) +
2067: DECODE(ap_terms.due_cutoff_day, NULL, 0,
2068: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
2069: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date),'DD'))),
2070: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
2071: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD')), 1, 0))),

Line 2068: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),

2064: , 1, 0)))), 'DD')))) || '-' ||
2065: TO_CHAR(ADD_MONTHS(P_Terms_Date,
2066: NVL(ap_terms_lines.discount_months_forward,0) +
2067: DECODE(ap_terms.due_cutoff_day, NULL, 0,
2068: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
2069: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date),'DD'))),
2070: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
2071: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD')), 1, 0))),
2072: 'MON-RR'),'DD-MON-RR')), /*bugfix:5647464 */

Line 2073: P_Terms_Date + NVL(ap_terms_lines.discount_days,0))),

2069: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date),'DD'))),
2070: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
2071: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD')), 1, 0))),
2072: 'MON-RR'),'DD-MON-RR')), /*bugfix:5647464 */
2073: P_Terms_Date + NVL(ap_terms_lines.discount_days,0))),
2074: DECODE(l_amount_for_discount, NULL, NULL,
2075: DECODE(ap_terms_lines.discount_days_2,
2076: NULL,DECODE(ap_terms_lines.discount_day_of_month_2,NULL,NULL,
2077: TO_DATE(TO_CHAR(LEAST(

Line 2075: DECODE(ap_terms_lines.discount_days_2,

2071: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD')), 1, 0))),
2072: 'MON-RR'),'DD-MON-RR')), /*bugfix:5647464 */
2073: P_Terms_Date + NVL(ap_terms_lines.discount_days,0))),
2074: DECODE(l_amount_for_discount, NULL, NULL,
2075: DECODE(ap_terms_lines.discount_days_2,
2076: NULL,DECODE(ap_terms_lines.discount_day_of_month_2,NULL,NULL,
2077: TO_DATE(TO_CHAR(LEAST(
2078: NVL(ap_terms_lines.discount_day_of_month_2,32),
2079: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS(P_Terms_Date,

Line 2076: NULL,DECODE(ap_terms_lines.discount_day_of_month_2,NULL,NULL,

2072: 'MON-RR'),'DD-MON-RR')), /*bugfix:5647464 */
2073: P_Terms_Date + NVL(ap_terms_lines.discount_days,0))),
2074: DECODE(l_amount_for_discount, NULL, NULL,
2075: DECODE(ap_terms_lines.discount_days_2,
2076: NULL,DECODE(ap_terms_lines.discount_day_of_month_2,NULL,NULL,
2077: TO_DATE(TO_CHAR(LEAST(
2078: NVL(ap_terms_lines.discount_day_of_month_2,32),
2079: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS(P_Terms_Date,
2080: NVL(ap_terms_lines.discount_months_forward_2,0) +

Line 2078: NVL(ap_terms_lines.discount_day_of_month_2,32),

2074: DECODE(l_amount_for_discount, NULL, NULL,
2075: DECODE(ap_terms_lines.discount_days_2,
2076: NULL,DECODE(ap_terms_lines.discount_day_of_month_2,NULL,NULL,
2077: TO_DATE(TO_CHAR(LEAST(
2078: NVL(ap_terms_lines.discount_day_of_month_2,32),
2079: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS(P_Terms_Date,
2080: NVL(ap_terms_lines.discount_months_forward_2,0) +
2081: DECODE(ap_terms.due_cutoff_day, NULL, 0,
2082: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),

Line 2080: NVL(ap_terms_lines.discount_months_forward_2,0) +

2076: NULL,DECODE(ap_terms_lines.discount_day_of_month_2,NULL,NULL,
2077: TO_DATE(TO_CHAR(LEAST(
2078: NVL(ap_terms_lines.discount_day_of_month_2,32),
2079: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS(P_Terms_Date,
2080: NVL(ap_terms_lines.discount_months_forward_2,0) +
2081: DECODE(ap_terms.due_cutoff_day, NULL, 0,
2082: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
2083: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date), 'DD'))),
2084: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),

Line 2081: DECODE(ap_terms.due_cutoff_day, NULL, 0,

2077: TO_DATE(TO_CHAR(LEAST(
2078: NVL(ap_terms_lines.discount_day_of_month_2,32),
2079: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS(P_Terms_Date,
2080: NVL(ap_terms_lines.discount_months_forward_2,0) +
2081: DECODE(ap_terms.due_cutoff_day, NULL, 0,
2082: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
2083: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date), 'DD'))),
2084: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
2085: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))

Line 2082: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),

2078: NVL(ap_terms_lines.discount_day_of_month_2,32),
2079: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS(P_Terms_Date,
2080: NVL(ap_terms_lines.discount_months_forward_2,0) +
2081: DECODE(ap_terms.due_cutoff_day, NULL, 0,
2082: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
2083: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date), 'DD'))),
2084: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
2085: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))
2086: , 1, 0)))), 'DD')))) || '-' ||

Line 2088: NVL(ap_terms_lines.discount_months_forward_2,0) +

2084: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
2085: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))
2086: , 1, 0)))), 'DD')))) || '-' ||
2087: TO_CHAR(ADD_MONTHS(P_Terms_Date,
2088: NVL(ap_terms_lines.discount_months_forward_2,0) +
2089: DECODE(ap_terms.due_cutoff_day, NULL, 0,
2090: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
2091: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date),'DD'))),
2092: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),

Line 2089: DECODE(ap_terms.due_cutoff_day, NULL, 0,

2085: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))
2086: , 1, 0)))), 'DD')))) || '-' ||
2087: TO_CHAR(ADD_MONTHS(P_Terms_Date,
2088: NVL(ap_terms_lines.discount_months_forward_2,0) +
2089: DECODE(ap_terms.due_cutoff_day, NULL, 0,
2090: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
2091: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date),'DD'))),
2092: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
2093: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD')), 1, 0))),

Line 2090: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),

2086: , 1, 0)))), 'DD')))) || '-' ||
2087: TO_CHAR(ADD_MONTHS(P_Terms_Date,
2088: NVL(ap_terms_lines.discount_months_forward_2,0) +
2089: DECODE(ap_terms.due_cutoff_day, NULL, 0,
2090: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
2091: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date),'DD'))),
2092: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
2093: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD')), 1, 0))),
2094: 'MON-RR'),'DD-MON-RR')), /*bugfix:5647464 */

Line 2095: P_Terms_Date + NVL(ap_terms_lines.discount_days_2,0))),

2091: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date),'DD'))),
2092: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
2093: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD')), 1, 0))),
2094: 'MON-RR'),'DD-MON-RR')), /*bugfix:5647464 */
2095: P_Terms_Date + NVL(ap_terms_lines.discount_days_2,0))),
2096: DECODE(l_amount_for_discount, NULL, NULL,
2097: DECODE(ap_terms_lines.discount_days_3,
2098: NULL,DECODE(ap_terms_lines.discount_day_of_month_3,NULL,NULL,
2099: TO_DATE(TO_CHAR(LEAST(

Line 2097: DECODE(ap_terms_lines.discount_days_3,

2093: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD')), 1, 0))),
2094: 'MON-RR'),'DD-MON-RR')), /*bugfix:5647464 */
2095: P_Terms_Date + NVL(ap_terms_lines.discount_days_2,0))),
2096: DECODE(l_amount_for_discount, NULL, NULL,
2097: DECODE(ap_terms_lines.discount_days_3,
2098: NULL,DECODE(ap_terms_lines.discount_day_of_month_3,NULL,NULL,
2099: TO_DATE(TO_CHAR(LEAST(
2100: NVL(ap_terms_lines.discount_day_of_month_3,32),
2101: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS(P_Terms_Date,

Line 2098: NULL,DECODE(ap_terms_lines.discount_day_of_month_3,NULL,NULL,

2094: 'MON-RR'),'DD-MON-RR')), /*bugfix:5647464 */
2095: P_Terms_Date + NVL(ap_terms_lines.discount_days_2,0))),
2096: DECODE(l_amount_for_discount, NULL, NULL,
2097: DECODE(ap_terms_lines.discount_days_3,
2098: NULL,DECODE(ap_terms_lines.discount_day_of_month_3,NULL,NULL,
2099: TO_DATE(TO_CHAR(LEAST(
2100: NVL(ap_terms_lines.discount_day_of_month_3,32),
2101: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS(P_Terms_Date,
2102: NVL(ap_terms_lines.discount_months_forward_3,0) +

Line 2100: NVL(ap_terms_lines.discount_day_of_month_3,32),

2096: DECODE(l_amount_for_discount, NULL, NULL,
2097: DECODE(ap_terms_lines.discount_days_3,
2098: NULL,DECODE(ap_terms_lines.discount_day_of_month_3,NULL,NULL,
2099: TO_DATE(TO_CHAR(LEAST(
2100: NVL(ap_terms_lines.discount_day_of_month_3,32),
2101: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS(P_Terms_Date,
2102: NVL(ap_terms_lines.discount_months_forward_3,0) +
2103: DECODE(ap_terms.due_cutoff_day, NULL, 0,
2104: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),

Line 2102: NVL(ap_terms_lines.discount_months_forward_3,0) +

2098: NULL,DECODE(ap_terms_lines.discount_day_of_month_3,NULL,NULL,
2099: TO_DATE(TO_CHAR(LEAST(
2100: NVL(ap_terms_lines.discount_day_of_month_3,32),
2101: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS(P_Terms_Date,
2102: NVL(ap_terms_lines.discount_months_forward_3,0) +
2103: DECODE(ap_terms.due_cutoff_day, NULL, 0,
2104: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
2105: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date), 'DD'))),
2106: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),

Line 2103: DECODE(ap_terms.due_cutoff_day, NULL, 0,

2099: TO_DATE(TO_CHAR(LEAST(
2100: NVL(ap_terms_lines.discount_day_of_month_3,32),
2101: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS(P_Terms_Date,
2102: NVL(ap_terms_lines.discount_months_forward_3,0) +
2103: DECODE(ap_terms.due_cutoff_day, NULL, 0,
2104: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
2105: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date), 'DD'))),
2106: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
2107: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))

Line 2104: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),

2100: NVL(ap_terms_lines.discount_day_of_month_3,32),
2101: TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS(P_Terms_Date,
2102: NVL(ap_terms_lines.discount_months_forward_3,0) +
2103: DECODE(ap_terms.due_cutoff_day, NULL, 0,
2104: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
2105: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date), 'DD'))),
2106: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
2107: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))
2108: , 1, 0)))), 'DD')))) || '-' ||

Line 2110: NVL(ap_terms_lines.discount_months_forward_3,0) +

2106: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
2107: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))
2108: , 1, 0)))), 'DD')))) || '-' ||
2109: TO_CHAR(ADD_MONTHS(P_Terms_Date,
2110: NVL(ap_terms_lines.discount_months_forward_3,0) +
2111: DECODE(ap_terms.due_cutoff_day, NULL, 0,
2112: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
2113: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date),'DD'))),
2114: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),

Line 2111: DECODE(ap_terms.due_cutoff_day, NULL, 0,

2107: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))
2108: , 1, 0)))), 'DD')))) || '-' ||
2109: TO_CHAR(ADD_MONTHS(P_Terms_Date,
2110: NVL(ap_terms_lines.discount_months_forward_3,0) +
2111: DECODE(ap_terms.due_cutoff_day, NULL, 0,
2112: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
2113: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date),'DD'))),
2114: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
2115: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD')), 1, 0))),

Line 2112: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),

2108: , 1, 0)))), 'DD')))) || '-' ||
2109: TO_CHAR(ADD_MONTHS(P_Terms_Date,
2110: NVL(ap_terms_lines.discount_months_forward_3,0) +
2111: DECODE(ap_terms.due_cutoff_day, NULL, 0,
2112: DECODE(GREATEST(LEAST(NVL(ap_terms.due_cutoff_day, 32),
2113: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date),'DD'))),
2114: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
2115: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD')), 1, 0))),
2116: 'MON-RR'),'DD-MON-RR')), /*bugfix:5647464 */

Line 2117: P_Terms_Date + NVL(ap_terms_lines.discount_days_3,0))),

2113: TO_NUMBER(TO_CHAR(LAST_DAY(P_Terms_Date),'DD'))),
2114: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD'))),
2115: TO_NUMBER(TO_CHAR(P_Terms_Date, 'DD')), 1, 0))),
2116: 'MON-RR'),'DD-MON-RR')), /*bugfix:5647464 */
2117: P_Terms_Date + NVL(ap_terms_lines.discount_days_3,0))),
2118: SYSDATE,
2119: P_Last_Updated_By,
2120: NULL,
2121: SYSDATE,

Line 2126: NVL(ap_terms_lines.due_percent,0)/100,

2122: P_Last_Updated_By,--bug4563272
2123: l_payment_cross_rate,
2124: DECODE(l_min_acc_unit_pay_curr,NULL,
2125: ROUND(P_Pay_Curr_Invoice_Amount *
2126: NVL(ap_terms_lines.due_percent,0)/100,
2127: l_precision_pay_curr),
2128: ROUND((P_Pay_Curr_Invoice_Amount *
2129: NVL(ap_terms_lines.due_percent,0)/100)
2130: / l_min_acc_unit_pay_curr)

Line 2129: NVL(ap_terms_lines.due_percent,0)/100)

2125: ROUND(P_Pay_Curr_Invoice_Amount *
2126: NVL(ap_terms_lines.due_percent,0)/100,
2127: l_precision_pay_curr),
2128: ROUND((P_Pay_Curr_Invoice_Amount *
2129: NVL(ap_terms_lines.due_percent,0)/100)
2130: / l_min_acc_unit_pay_curr)
2131: * l_min_acc_unit_pay_curr),
2132:
2133: --Bug 7357218 Quick Pay and Dispute Resolution Project

Line 2172: NVL(ap_terms_lines.due_percent, 0)/100,

2168: END,
2169:
2170: DECODE(l_min_acc_unit_pay_curr,NULL,
2171: ROUND( P_Pay_Curr_Invoice_Amount *
2172: NVL(ap_terms_lines.due_percent, 0)/100,
2173: l_precision_pay_curr),
2174: ROUND(( P_Pay_Curr_Invoice_Amount *
2175: NVL(ap_terms_lines.due_percent, 0)/100)
2176: / l_min_acc_unit_pay_curr)

Line 2175: NVL(ap_terms_lines.due_percent, 0)/100)

2171: ROUND( P_Pay_Curr_Invoice_Amount *
2172: NVL(ap_terms_lines.due_percent, 0)/100,
2173: l_precision_pay_curr),
2174: ROUND(( P_Pay_Curr_Invoice_Amount *
2175: NVL(ap_terms_lines.due_percent, 0)/100)
2176: / l_min_acc_unit_pay_curr)
2177: * l_min_acc_unit_pay_curr),
2178: 0,
2179: NVL(l_Payment_Priority,P_Payment_priority),

Line 2207: FROM ap_terms,

2203: ,ai.remit_to_supplier_id
2204: ,ai.remit_to_supplier_site
2205: ,ai.remit_to_supplier_site_id
2206: ,ai.relationship_id
2207: FROM ap_terms,
2208: ap_terms_lines,
2209: ap_invoices ai,
2210: ap_recurring_payments arp
2211: WHERE ap_terms.term_id = ap_terms_lines.term_id

Line 2208: ap_terms_lines,

2204: ,ai.remit_to_supplier_site
2205: ,ai.remit_to_supplier_site_id
2206: ,ai.relationship_id
2207: FROM ap_terms,
2208: ap_terms_lines,
2209: ap_invoices ai,
2210: ap_recurring_payments arp
2211: WHERE ap_terms.term_id = ap_terms_lines.term_id
2212: AND ap_terms_lines.term_id = P_Terms_Id

Line 2211: WHERE ap_terms.term_id = ap_terms_lines.term_id

2207: FROM ap_terms,
2208: ap_terms_lines,
2209: ap_invoices ai,
2210: ap_recurring_payments arp
2211: WHERE ap_terms.term_id = ap_terms_lines.term_id
2212: AND ap_terms_lines.term_id = P_Terms_Id
2213: AND ap_terms_lines.sequence_num = l_sequence_num
2214: AND ai.invoice_id = P_Invoice_Id
2215: AND ai.recurring_payment_id = arp.recurring_payment_id(+);

Line 2212: AND ap_terms_lines.term_id = P_Terms_Id

2208: ap_terms_lines,
2209: ap_invoices ai,
2210: ap_recurring_payments arp
2211: WHERE ap_terms.term_id = ap_terms_lines.term_id
2212: AND ap_terms_lines.term_id = P_Terms_Id
2213: AND ap_terms_lines.sequence_num = l_sequence_num
2214: AND ai.invoice_id = P_Invoice_Id
2215: AND ai.recurring_payment_id = arp.recurring_payment_id(+);
2216:

Line 2213: AND ap_terms_lines.sequence_num = l_sequence_num

2209: ap_invoices ai,
2210: ap_recurring_payments arp
2211: WHERE ap_terms.term_id = ap_terms_lines.term_id
2212: AND ap_terms_lines.term_id = P_Terms_Id
2213: AND ap_terms_lines.sequence_num = l_sequence_num
2214: AND ai.invoice_id = P_Invoice_Id
2215: AND ai.recurring_payment_id = arp.recurring_payment_id(+);
2216:
2217: l_debug_info := 'l_due_date'||to_char(l_due_date,'dd-mm-yyyy')||'Insert into ap_payment_schedules : term type is percent';