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.CE_CSH_FCST_POP dependencies on AP_TERMS_LINES

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

3035: ||to_char(CE_CASH_FCST.G_lead_time)|| ',
3036: null,
3037: null,
3038: round(-(nvl(decode(src.due_amount, 0,
3039: (select nvl(src.amount,0) - sum(t.due_amount) from ap_terms_lines t where t.term_id = src.term_id),
3040: src.due_amount),(nvl(src.amount,0) * (nvl(src.due_percent,100)/100)))) * ' || CE_CASH_FCST.G_rp_exchange_rate
3041: ||','||CE_CASH_FCST.G_precision||'),
3042: -(nvl(decode(src.due_amount, 0,
3043: (select nvl(src.amount,0) - sum(t.due_amount) from ap_terms_lines t where t.term_id = src.term_id),

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

3039: (select nvl(src.amount,0) - sum(t.due_amount) from ap_terms_lines t where t.term_id = src.term_id),
3040: src.due_amount),(nvl(src.amount,0) * (nvl(src.due_percent,100)/100)))) * ' || CE_CASH_FCST.G_rp_exchange_rate
3041: ||','||CE_CASH_FCST.G_precision||'),
3042: -(nvl(decode(src.due_amount, 0,
3043: (select nvl(src.amount,0) - sum(t.due_amount) from ap_terms_lines t where t.term_id = src.term_id),
3044: src.due_amount),(nvl(src.amount,0) * (nvl(src.due_percent,100)/100))))';
3045: ELSE
3046: -- 5609517: Remove ORDERED hint as suggested by apps perf team
3047: -- select_clause_2 := 'SELECT /*+ ORDERED USE_MERGE(src)*/ CE_FORECAST_TRX_CELLS_S.nextval,

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

3070: ||to_char(CE_CASH_FCST.G_lead_time)|| ',
3071: null,
3072: null,
3073: round(-(nvl(decode(src.due_amount, 0,
3074: (select nvl(src.amount,0) - sum(t.due_amount) from ap_terms_lines t where t.term_id = src.term_id),
3075: src.due_amount),(nvl(src.amount,0) * (nvl(src.due_percent,100)/100))) * curr.exchange_rate)'
3076: ||','||CE_CASH_FCST.G_precision||'),
3077: -(nvl(decode(src.due_amount, 0,
3078: (select nvl(src.amount,0) - sum(t.due_amount) from ap_terms_lines t where t.term_id = src.term_id),

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

3074: (select nvl(src.amount,0) - sum(t.due_amount) from ap_terms_lines t where t.term_id = src.term_id),
3075: src.due_amount),(nvl(src.amount,0) * (nvl(src.due_percent,100)/100))) * curr.exchange_rate)'
3076: ||','||CE_CASH_FCST.G_precision||'),
3077: -(nvl(decode(src.due_amount, 0,
3078: (select nvl(src.amount,0) - sum(t.due_amount) from ap_terms_lines t where t.term_id = src.term_id),
3079: src.due_amount),(nvl(src.amount,0) * (nvl(src.due_percent,100)/100))))';
3080: END IF;
3081:
3082: select_clause_3 := Get_Select_Clause;

Line 3176: from ap_terms_lines t

3172:
3173: if C_req_rec.due_amount = 0 THEN
3174: select nvl(C_req_rec.amount,0) - sum(t.due_amount)
3175: INTO remain_amount
3176: from ap_terms_lines t
3177: where t.term_id = C_req_rec.term_id;
3178:
3179: cep_standard.debug('remain_amount = ' || to_char(remain_amount));
3180:

Line 3488: from ap_terms_lines t

3484:
3485: if C_req_rec.due_amount = 0 THEN
3486: select nvl(C_req_rec.amount,0) - sum(t.due_amount)
3487: INTO remain_amount
3488: from ap_terms_lines t
3489: where t.term_id = C_req_rec.term_id;
3490:
3491: cep_standard.debug('remain_amount = ' || to_char(remain_amount));
3492: