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.OKI_LOAD_ETR_PVT dependencies on OKI_SALES_K_HDRS

Line 278: FROM oki_sales_k_hdrs shd

274: ,0 , 1,
275: ( rnwinqtr.value / expiredtilldate.value ) * 100 ) value
276: FROM
277: ( SELECT count(shd.chr_id) value
278: FROM oki_sales_k_hdrs shd
279: WHERE shd.date_signed <= p_qtr_start_date
280: AND shd.end_date BETWEEN p_qtr_start_date
281: AND p_summary_build_date
282: AND ( shd.date_terminated IS NULL

Line 288: FROM oki_sales_k_hdrs shd

284: AND shd.base_contract_amount BETWEEN 0
285: AND oki_utl_pub.g_contract_limit
286: AND shd.authoring_org_id = p_authoring_org_id ) expiredtilldate
287: , ( SELECT count(shd.chr_id) value
288: FROM oki_sales_k_hdrs shd
289: WHERE shd.is_new_yn IS NULL
290: AND shd.date_signed IS NOT NULL
291: AND shd.date_signed BETWEEN p_qtr_start_date
292: AND p_summary_build_date

Line 305: FROM oki_sales_k_hdrs shd

301: , (((k_rnw_qtd.value + all_bklg_qsd.value ) /
302: (k_exp_qtd.value + bklg_k_qsd.value )) * 100)) value
303: FROM
304: ( SELECT COUNT(shd.chr_id) value
305: FROM oki_sales_k_hdrs shd
306: WHERE shd.is_new_yn IS NULL
307: AND shd.date_signed IS NOT NULL
308: AND shd.start_date BETWEEN p_qtr_start_date
309: AND p_summary_build_date

Line 317: FROM oki_sales_k_hdrs shd

313: BETWEEN 0 AND oki_utl_pub.g_contract_limit
314: AND shd.authoring_org_id = p_authoring_org_id
315: ) k_rnw_qtd
316: , ( SELECT COUNT(shd.chr_id) value
317: FROM oki_sales_k_hdrs shd
318: WHERE shd.is_new_yn IS NULL
319: AND shd.date_signed IS NOT NULL
320: AND shd.date_approved IS NOT NULL
321: AND shd.start_date < p_qtr_start_date

Line 329: FROM oki_sales_k_hdrs shd

325: BETWEEN 0 AND oki_utl_pub.g_contract_limit
326: AND shd.authoring_org_id = p_authoring_org_id
327: ) all_bklg_qsd
328: , ( SELECT COUNT(shd.chr_id) value
329: FROM oki_sales_k_hdrs shd
330: WHERE shd.date_signed <= p_qtr_start_date
331: AND shd.date_approved <= p_summary_build_date
332: AND shd.end_date
333: BETWEEN p_qtr_start_date AND p_summary_build_date

Line 340: FROM oki_sales_k_hdrs shd

336: BETWEEN 0 AND oki_utl_pub.g_contract_limit
337: AND shd.authoring_org_id = p_authoring_org_id
338: ) k_exp_qtd
339: , ( SELECT COUNT(shd.chr_id) value
340: FROM oki_sales_k_hdrs shd
341: WHERE shd.is_new_yn IS NULL
342: AND ( shd.date_canceled IS NULL
343: OR shd.date_canceled >= p_qtr_start_date )
344: AND ( shd.date_signed IS NULL

Line 360: FROM oki_sales_k_hdrs shd

356: ( p_qtr_end_date IN DATE
357: ) IS
358: SELECT COUNT(shd.chr_id) contract_count
359: , NVL(SUM(shd.base_contract_amount), 0) value
360: FROM oki_sales_k_hdrs shd
361: WHERE shd.start_date <= p_qtr_end_date
362: AND shd.is_new_yn IS NULL
363: AND shd.date_signed IS NULL
364: AND shd.date_canceled IS NULL

Line 1224: FROM oki_sales_k_hdrs shd

1220: ,0 , 1,
1221: ( rnwinqtr.value / expiredtilldate.value ) * 100 ) value
1222: FROM
1223: ( SELECT count(shd.chr_id) value
1224: FROM oki_sales_k_hdrs shd
1225: WHERE shd.date_signed <= p_qtr_start_date
1226: AND shd.end_date BETWEEN p_qtr_start_date
1227: AND p_summary_build_date
1228: AND ( shd.date_terminated IS NULL

Line 1233: FROM oki_sales_k_hdrs shd

1229: OR shd.date_terminated > p_summary_build_date )
1230: AND shd.base_contract_amount BETWEEN 0
1231: AND oki_utl_pub.g_contract_limit) expiredtilldate
1232: , ( SELECT count(shd.chr_id) value
1233: FROM oki_sales_k_hdrs shd
1234: WHERE shd.is_new_yn IS NULL
1235: AND shd.date_signed IS NOT NULL
1236: AND shd.date_signed BETWEEN p_qtr_start_date
1237: AND p_summary_build_date

Line 1249: FROM oki_sales_k_hdrs shd

1245: , (((k_rnw_qtd.value + all_bklg_qsd.value ) /
1246: (k_exp_qtd.value + bklg_k_qsd.value )) * 100)) value
1247: FROM
1248: ( SELECT COUNT(shd.chr_id) value
1249: FROM oki_sales_k_hdrs shd
1250: WHERE shd.is_new_yn IS NULL
1251: AND shd.date_signed IS NOT NULL
1252: AND shd.start_date BETWEEN p_qtr_start_date
1253: AND p_summary_build_date

Line 1260: FROM oki_sales_k_hdrs shd

1256: AND shd.base_contract_amount
1257: BETWEEN 0 AND oki_utl_pub.g_contract_limit
1258: ) k_rnw_qtd
1259: , ( SELECT COUNT(shd.chr_id) value
1260: FROM oki_sales_k_hdrs shd
1261: WHERE shd.is_new_yn IS NULL
1262: AND shd.date_signed IS NOT NULL
1263: AND shd.date_approved IS NOT NULL
1264: AND shd.start_date < p_qtr_start_date

Line 1271: FROM oki_sales_k_hdrs shd

1267: AND shd.base_contract_amount
1268: BETWEEN 0 AND oki_utl_pub.g_contract_limit
1269: ) all_bklg_qsd
1270: , ( SELECT COUNT(shd.chr_id) value
1271: FROM oki_sales_k_hdrs shd
1272: WHERE shd.date_signed <= p_qtr_start_date
1273: AND shd.date_approved <= p_summary_build_date
1274: AND shd.end_date
1275: BETWEEN p_qtr_start_date AND p_summary_build_date

Line 1281: FROM oki_sales_k_hdrs shd

1277: AND shd.base_contract_amount
1278: BETWEEN 0 AND oki_utl_pub.g_contract_limit
1279: ) k_exp_qtd
1280: , ( SELECT COUNT(shd.chr_id) value
1281: FROM oki_sales_k_hdrs shd
1282: WHERE shd.is_new_yn IS NULL
1283: AND ( shd.date_canceled IS NULL
1284: OR shd.date_canceled >= p_qtr_start_date )
1285: AND ( shd.date_signed IS NULL

Line 1300: FROM oki_sales_k_hdrs shd

1296: ( p_qtr_end_date IN DATE
1297: ) IS
1298: SELECT COUNT(shd.chr_id) contract_count
1299: , NVL(SUM(shd.base_contract_amount), 0) value
1300: FROM oki_sales_k_hdrs shd
1301: WHERE shd.start_date <= p_qtr_end_date
1302: AND shd.is_new_yn IS NULL
1303: AND shd.date_signed IS NULL
1304: AND shd.date_canceled IS NULL