APPS.CE_CSH_FCST_POP dependencies on AP_TERMS_LINES

Line 3115: (select nvl(src.amount,0) - sum(t.due_amount) from ap_terms_lines t where t.term_id = src.term_id),

3111: ||to_char(CE_CASH_FCST.G_lead_time)|| ',
3112: null,
3113: null,
3114: round(-(nvl(decode(src.due_amount, 0,
3115: (select nvl(src.amount,0) - sum(t.due_amount) from ap_terms_lines t where t.term_id = src.term_id),
3116: src.due_amount),(nvl(src.amount,0) * (nvl(src.due_percent,100)/100)))) * ' || CE_CASH_FCST.G_rp_exchange_rate
3117: ||','||CE_CASH_FCST.G_precision||'),
3118: -(nvl(decode(src.due_amount, 0,
3119: (select nvl(src.amount,0) - sum(t.due_amount) from ap_terms_lines t where t.term_id = src.term_id),

Line 3119: (select nvl(src.amount,0) - sum(t.due_amount) from ap_terms_lines t where t.term_id = src.term_id),

3115: (select nvl(src.amount,0) - sum(t.due_amount) from ap_terms_lines t where t.term_id = src.term_id),
3116: src.due_amount),(nvl(src.amount,0) * (nvl(src.due_percent,100)/100)))) * ' || CE_CASH_FCST.G_rp_exchange_rate
3117: ||','||CE_CASH_FCST.G_precision||'),
3118: -(nvl(decode(src.due_amount, 0,
3119: (select nvl(src.amount,0) - sum(t.due_amount) from ap_terms_lines t where t.term_id = src.term_id),
3120: src.due_amount),(nvl(src.amount,0) * (nvl(src.due_percent,100)/100))))';
3121: ELSE
3122: -- 5609517: Remove ORDERED hint as suggested by apps perf team
3123: -- select_clause_2 := 'SELECT /*+ ORDERED USE_MERGE(src)*/ CE_FORECAST_TRX_CELLS_S.nextval,

Line 3150: (select nvl(src.amount,0) - sum(t.due_amount) from ap_terms_lines t where t.term_id = src.term_id),

3146: ||to_char(CE_CASH_FCST.G_lead_time)|| ',
3147: null,
3148: null,
3149: round(-(nvl(decode(src.due_amount, 0,
3150: (select nvl(src.amount,0) - sum(t.due_amount) from ap_terms_lines t where t.term_id = src.term_id),
3151: src.due_amount),(nvl(src.amount,0) * (nvl(src.due_percent,100)/100))) * curr.exchange_rate)'
3152: ||','||CE_CASH_FCST.G_precision||'),
3153: -(nvl(decode(src.due_amount, 0,
3154: (select nvl(src.amount,0) - sum(t.due_amount) from ap_terms_lines t where t.term_id = src.term_id),

Line 3154: (select nvl(src.amount,0) - sum(t.due_amount) from ap_terms_lines t where t.term_id = src.term_id),

3150: (select nvl(src.amount,0) - sum(t.due_amount) from ap_terms_lines t where t.term_id = src.term_id),
3151: src.due_amount),(nvl(src.amount,0) * (nvl(src.due_percent,100)/100))) * curr.exchange_rate)'
3152: ||','||CE_CASH_FCST.G_precision||'),
3153: -(nvl(decode(src.due_amount, 0,
3154: (select nvl(src.amount,0) - sum(t.due_amount) from ap_terms_lines t where t.term_id = src.term_id),
3155: src.due_amount),(nvl(src.amount,0) * (nvl(src.due_percent,100)/100))))';
3156: END IF;
3157:
3158: select_clause_3 := Get_Select_Clause;

Line 3252: from ap_terms_lines t

3248:
3249: if C_req_rec.due_amount = 0 THEN
3250: select nvl(C_req_rec.amount,0) - sum(t.due_amount)
3251: INTO remain_amount
3252: from ap_terms_lines t
3253: where t.term_id = C_req_rec.term_id;
3254:
3255: cep_standard.debug('remain_amount = ' || to_char(remain_amount));
3256:

Line 3564: from ap_terms_lines t

3560:
3561: if C_req_rec.due_amount = 0 THEN
3562: select nvl(C_req_rec.amount,0) - sum(t.due_amount)
3563: INTO remain_amount
3564: from ap_terms_lines t
3565: where t.term_id = C_req_rec.term_id;
3566:
3567: cep_standard.debug('remain_amount = ' || to_char(remain_amount));
3568: