APPS.OKI_LOAD_RBK_PVT dependencies on OKI_SALES_K_HDRS

Line 273: FROM oki_sales_k_hdrs shd

269: , p_authoring_org_id IN NUMBER
270: ) IS
271: SELECT NVL(SUM(base_contract_amount), 0) value
272: , COUNT(shd.chr_id) contract_count
273: FROM oki_sales_k_hdrs shd
274: WHERE shd.is_new_yn IS NULL
275: AND ( shd.date_canceled IS NULL
276: OR shd.date_canceled >= p_qtr_start_date )
277: AND ( shd.date_signed IS NULL

Line 296: FROM oki_sales_k_hdrs shd

292: , p_authoring_org_id IN NUMBER
293: ) IS
294: SELECT NVL(SUM(base_contract_amount), 0) value
295: , COUNT(shd.chr_id) contract_count
296: FROM oki_sales_k_hdrs shd
297: WHERE shd.is_new_yn IS NULL
298: AND shd.date_signed IS NOT NULL
299: AND shd.date_approved IS NOT NULL
300: AND shd.start_date < p_qtr_start_date

Line 319: FROM oki_sales_k_hdrs shd

315:
316: ) IS
317: SELECT NVL(SUM(base_contract_amount), 0) value
318: , COUNT(shd.chr_id) contract_count
319: FROM oki_sales_k_hdrs shd
320: WHERE shd.is_new_yn IS NULL
321: AND shd.date_signed IS NOT NULL
322: AND shd.start_date BETWEEN p_qtr_start_date AND p_qtr_end_date
323: AND GREATEST(shd.date_signed, shd.date_approved) <= p_qtr_end_date

Line 340: FROM oki_sales_k_hdrs shd

336: , p_authoring_org_id IN NUMBER
337: ) IS
338: SELECT NVL(SUM(base_contract_amount), 0) value
339: , COUNT(shd.chr_id) contract_count
340: FROM oki_sales_k_hdrs shd
341: WHERE shd.date_signed <= p_summary_build_date
342: AND shd.date_approved <= p_summary_build_date
343: AND shd.is_new_yn = 'Y'
344: AND shd.start_date BETWEEN p_qtr_start_date

Line 364: FROM oki_sales_k_hdrs shd

360: , p_authoring_org_id IN NUMBER
361: ) IS
362: SELECT NVL(SUM(base_contract_amount), 0) value
363: , COUNT(shd.chr_id) contract_count
364: FROM oki_sales_k_hdrs shd
365: WHERE date_terminated BETWEEN p_qtr_start_date
366: AND p_summary_build_date
367: AND shd.date_signed IS NOT NULL
368: AND shd.date_approved IS NOT NULL

Line 1300: FROM oki_sales_k_hdrs shd

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

Line 1321: FROM oki_sales_k_hdrs shd

1317: , p_qtr_start_date IN DATE
1318: ) IS
1319: SELECT NVL(SUM(base_contract_amount), 0) value
1320: , COUNT(shd.chr_id) contract_count
1321: FROM oki_sales_k_hdrs shd
1322: WHERE shd.is_new_yn IS NULL
1323: AND shd.date_signed IS NOT NULL
1324: AND shd.date_approved IS NOT NULL
1325: AND shd.start_date < p_qtr_start_date

Line 1341: FROM oki_sales_k_hdrs shd

1337: , p_qtr_end_date IN DATE
1338: ) IS
1339: SELECT NVL(SUM(base_contract_amount), 0) value
1340: , COUNT(shd.chr_id) contract_count
1341: FROM oki_sales_k_hdrs shd
1342: WHERE shd.is_new_yn IS NULL
1343: AND shd.date_signed IS NOT NULL
1344: AND shd.start_date BETWEEN p_qtr_start_date AND p_qtr_end_date
1345: AND GREATEST(shd.date_signed, shd.date_approved) <= p_qtr_end_date

Line 1360: FROM oki_sales_k_hdrs shd

1356: , p_qtr_start_date IN DATE
1357: ) IS
1358: SELECT NVL(SUM(base_contract_amount), 0) value
1359: , COUNT(shd.chr_id) contract_count
1360: FROM oki_sales_k_hdrs shd
1361: WHERE shd.date_signed <= p_summary_build_date
1362: AND shd.date_approved <= p_summary_build_date
1363: AND shd.is_new_yn = 'Y'
1364: AND shd.start_date BETWEEN p_qtr_start_date

Line 1382: FROM oki_sales_k_hdrs shd

1378: , p_qtr_start_date IN DATE
1379: ) IS
1380: SELECT NVL(SUM(base_contract_amount), 0) value
1381: , COUNT(shd.chr_id) contract_count
1382: FROM oki_sales_k_hdrs shd
1383: WHERE date_terminated BETWEEN p_qtr_start_date
1384: AND p_summary_build_date
1385: AND shd.date_signed IS NOT NULL
1386: AND shd.date_approved IS NOT NULL