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_SGR_PVT dependencies on OKI_SALES_K_HDRS

Line 15: -- oki_sales_k_hdrs. This program no longer needs

11: -- within a particular threshold. Fixed contracts
12: -- terminated cursor to sum the contracts.
13: -- 17-Oct-2001 mezra Removed the trunc function from all date columns
14: -- since the truncated date is placed into
15: -- oki_sales_k_hdrs. This program no longer needs
16: -- to truncate the dates.
17: -- 10-Oct-2001 mezra Initial version
18: --
19: --------------------------------------------------------------------------------

Line 88: FROM oki_sales_k_hdrs shd

84: ( p_summary_build_date IN DATE
85: ) IS
86: SELECT NVL(SUM(base_contract_amount), 0) base_contract_amount
87: , NVL(SUM(sob_contract_amount), 0) sob_contract_amount
88: FROM oki_sales_k_hdrs shd
89: WHERE shd.date_signed <= p_summary_build_date
90: AND shd.date_approved <= p_summary_build_date
91: AND shd.start_date <= p_summary_build_date
92: AND shd.end_date > p_summary_build_date

Line 110: FROM oki_sales_k_hdrs shd

106: )
107: IS
108: SELECT NVL(SUM(base_contract_amount), 0) base_contract_amount
109: , NVL(SUM(sob_contract_amount), 0) sob_contract_amount
110: FROM oki_sales_k_hdrs shd
111: WHERE shd.date_signed <= p_glpr_qtr_end_date
112: AND shd.date_approved <= p_glpr_qtr_end_date
113: AND shd.end_date BETWEEN p_glpr_qtr_start_date
114: AND p_glpr_qtr_end_date

Line 131: FROM oki_sales_k_hdrs shd

127: )
128: IS
129: SELECT NVL(SUM(base_contract_amount), 0) base_contract_amount
130: , NVL(SUM(sob_contract_amount), 0) sob_contract_amount
131: FROM oki_sales_k_hdrs shd
132: WHERE shd.is_new_yn IS NULL
133: AND shd.date_signed IS NOT NULL
134: AND shd.date_approved IS NOT NULL
135: AND shd.start_date BETWEEN p_glpr_qtr_start_date

Line 154: FROM oki_sales_k_hdrs shd

150: )
151: IS
152: SELECT NVL(SUM(base_contract_amount), 0) base_contract_amount
153: , NVL(SUM(sob_contract_amount), 0) sob_contract_amount
154: FROM oki_sales_k_hdrs shd
155: WHERE shd.is_new_yn IS NULL
156: AND shd.date_signed IS NOT NULL
157: AND shd.date_approved IS NOT NULL
158: AND shd.start_date < p_glpr_qtr_start_date

Line 176: FROM oki_sales_k_hdrs shd

172: )
173: IS
174: SELECT NVL(SUM(base_contract_amount), 0) base_contract_amount
175: , NVL(SUM(sob_contract_amount), 0) sob_contract_amount
176: FROM oki_sales_k_hdrs shd
177: WHERE shd.date_signed <= p_summary_build_date
178: AND shd.date_approved <= p_summary_build_date
179: AND shd.is_new_yn = 'Y'
180: AND shd.start_date BETWEEN p_glpr_qtr_start_date

Line 197: FROM oki_sales_k_hdrs shd

193: )
194: IS
195: SELECT NVL(SUM(base_contract_amount), 0) base_contract_amount
196: , NVL(SUM(sob_contract_amount), 0) sob_contract_amount
197: FROM oki_sales_k_hdrs shd
198: WHERE shd.ste_code = 'CANCELLED'
199: AND shd.is_new_yn IS NULL
200: AND shd.is_latest_yn IS NULL
201: AND shd.start_date BETWEEN p_glpr_qtr_start_date

Line 220: FROM oki_sales_k_hdrs shd

216: base_contract_amount)), 0) base_contract_amount
217: , NVL(SUM((((shd.end_date - shd.date_terminated) /
218: (shd.end_date - shd.start_date)) *
219: sob_contract_amount)), 0) sob_contract_amount
220: FROM oki_sales_k_hdrs shd
221: WHERE date_terminated BETWEEN p_glpr_qtr_start_date
222: AND p_summary_build_date
223: AND shd.base_contract_amount
224: BETWEEN 0 AND oki_load_sgr_pvt.g_problem_k_threshold

Line 449: FROM oki_sales_k_hdrs shd

445: , p_customer_party_id IN NUMBER
446: ) IS
447: SELECT NVL(SUM(base_contract_amount), 0) base_contract_amount
448: , NVL(SUM(sob_contract_amount), 0) sob_contract_amount
449: FROM oki_sales_k_hdrs shd
450: WHERE shd.date_signed <= p_summary_build_date
451: AND shd.date_approved <= p_summary_build_date
452: AND shd.start_date <= p_summary_build_date
453: AND shd.end_date > p_summary_build_date

Line 473: FROM oki_sales_k_hdrs shd

469: )
470: IS
471: SELECT NVL(SUM(base_contract_amount), 0) base_contract_amount
472: , NVL(SUM(sob_contract_amount), 0) sob_contract_amount
473: FROM oki_sales_k_hdrs shd
474: WHERE shd.date_signed <= p_glpr_qtr_end_date
475: AND shd.date_approved <= p_glpr_qtr_end_date
476: AND shd.end_date BETWEEN p_glpr_qtr_start_date
477: AND p_glpr_qtr_end_date

Line 496: FROM oki_sales_k_hdrs shd

492: )
493: IS
494: SELECT NVL(SUM(base_contract_amount), 0) base_contract_amount
495: , NVL(SUM(sob_contract_amount), 0) sob_contract_amount
496: FROM oki_sales_k_hdrs shd
497: WHERE shd.is_new_yn IS NULL
498: AND shd.date_signed IS NOT NULL
499: AND shd.date_approved IS NOT NULL
500: AND shd.start_date BETWEEN p_glpr_qtr_start_date

Line 521: FROM oki_sales_k_hdrs shd

517: )
518: IS
519: SELECT NVL(SUM(base_contract_amount), 0) base_contract_amount
520: , NVL(SUM(sob_contract_amount), 0) sob_contract_amount
521: FROM oki_sales_k_hdrs shd
522: WHERE shd.is_new_yn IS NULL
523: AND shd.date_signed IS NOT NULL
524: AND shd.date_approved IS NOT NULL
525: AND shd.start_date < p_glpr_qtr_start_date

Line 545: FROM oki_sales_k_hdrs shd

541: )
542: IS
543: SELECT NVL(SUM(base_contract_amount), 0) base_contract_amount
544: , NVL(SUM(sob_contract_amount), 0) sob_contract_amount
545: FROM oki_sales_k_hdrs shd
546: WHERE shd.date_signed <= p_summary_build_date
547: AND shd.date_approved <= p_summary_build_date
548: AND shd.is_new_yn = 'Y'
549: AND shd.start_date BETWEEN p_glpr_qtr_start_date

Line 568: FROM oki_sales_k_hdrs shd

564: )
565: IS
566: SELECT NVL(SUM(base_contract_amount), 0) base_contract_amount
567: , NVL(SUM(sob_contract_amount), 0) sob_contract_amount
568: FROM oki_sales_k_hdrs shd
569: WHERE shd.ste_code = 'CANCELLED'
570: AND shd.is_new_yn IS NULL
571: AND shd.is_latest_yn IS NULL
572: AND shd.start_date BETWEEN p_glpr_qtr_start_date

Line 593: FROM oki_sales_k_hdrs shd

589: base_contract_amount)), 0) base_contract_amount
590: , NVL(SUM((((shd.end_date - shd.date_terminated) /
591: (shd.end_date - shd.start_date)) *
592: sob_contract_amount)), 0) sob_contract_amount
593: FROM oki_sales_k_hdrs shd
594: WHERE date_terminated BETWEEN p_glpr_qtr_start_date
595: AND p_summary_build_date
596: AND shd.customer_party_id = p_customer_party_id
597: AND shd.base_contract_amount

Line 606: FROM oki_sales_k_hdrs shd

602: -- Cursor to retrieve the distinct organizations
603: CURSOR l_cst_csr IS
604: SELECT DISTINCT shd.customer_party_id customer_party_id
605: , shd.customer_name customer_name
606: FROM oki_sales_k_hdrs shd
607: ;
608:
609:
610: BEGIN

Line 1531: FROM oki_sales_k_hdrs shd

1527: , p_authoring_org_id IN NUMBER
1528: ) IS
1529: SELECT NVL(SUM(base_contract_amount), 0) base_contract_amount
1530: , NVL(SUM(sob_contract_amount), 0) sob_contract_amount
1531: FROM oki_sales_k_hdrs shd
1532: WHERE shd.date_signed <= p_summary_build_date
1533: AND shd.date_approved <= p_summary_build_date
1534: AND shd.start_date <= p_summary_build_date
1535: AND shd.end_date > p_summary_build_date

Line 1555: FROM oki_sales_k_hdrs shd

1551: )
1552: IS
1553: SELECT NVL(SUM(base_contract_amount), 0) base_contract_amount
1554: , NVL(SUM(sob_contract_amount), 0) sob_contract_amount
1555: FROM oki_sales_k_hdrs shd
1556: WHERE shd.date_signed <= p_glpr_qtr_end_date
1557: AND shd.date_approved <= p_glpr_qtr_end_date
1558: AND shd.end_date BETWEEN p_glpr_qtr_start_date
1559: AND p_glpr_qtr_end_date

Line 1578: FROM oki_sales_k_hdrs shd

1574: )
1575: IS
1576: SELECT NVL(SUM(base_contract_amount), 0) base_contract_amount
1577: , NVL(SUM(sob_contract_amount), 0) sob_contract_amount
1578: FROM oki_sales_k_hdrs shd
1579: WHERE shd.is_new_yn IS NULL
1580: AND shd.date_signed IS NOT NULL
1581: AND shd.date_approved IS NOT NULL
1582: AND shd.start_date BETWEEN p_glpr_qtr_start_date

Line 1603: FROM oki_sales_k_hdrs shd

1599: )
1600: IS
1601: SELECT NVL(SUM(base_contract_amount), 0) base_contract_amount
1602: , NVL(SUM(sob_contract_amount), 0) sob_contract_amount
1603: FROM oki_sales_k_hdrs shd
1604: WHERE shd.is_new_yn IS NULL
1605: AND shd.date_signed IS NOT NULL
1606: AND shd.date_approved IS NOT NULL
1607: AND shd.start_date < p_glpr_qtr_start_date

Line 1627: FROM oki_sales_k_hdrs shd

1623: )
1624: IS
1625: SELECT NVL(SUM(base_contract_amount), 0) base_contract_amount
1626: , NVL(SUM(sob_contract_amount), 0) sob_contract_amount
1627: FROM oki_sales_k_hdrs shd
1628: WHERE shd.date_signed <= p_summary_build_date
1629: AND shd.date_approved <= p_summary_build_date
1630: AND shd.is_new_yn = 'Y'
1631: AND shd.start_date BETWEEN p_glpr_qtr_start_date

Line 1650: FROM oki_sales_k_hdrs shd

1646: )
1647: IS
1648: SELECT NVL(SUM(base_contract_amount), 0) base_contract_amount
1649: , NVL(SUM(sob_contract_amount), 0) sob_contract_amount
1650: FROM oki_sales_k_hdrs shd
1651: WHERE shd.ste_code = 'CANCELLED'
1652: AND shd.is_new_yn IS NULL
1653: AND shd.is_latest_yn IS NULL
1654: AND shd.start_date BETWEEN p_glpr_qtr_start_date

Line 1675: FROM oki_sales_k_hdrs shd

1671: base_contract_amount)), 0) base_contract_amount
1672: , NVL(SUM((((shd.end_date - shd.date_terminated) /
1673: (shd.end_date - shd.start_date)) *
1674: sob_contract_amount)), 0) sob_contract_amount
1675: FROM oki_sales_k_hdrs shd
1676: WHERE date_terminated BETWEEN p_glpr_qtr_start_date
1677: AND p_summary_build_date
1678: AND shd.authoring_org_id = p_authoring_org_id
1679: AND shd.base_contract_amount

Line 1688: FROM oki_sales_k_hdrs shd

1684: -- Cursor to retrieve the distinct organizations
1685: CURSOR l_org_csr IS
1686: SELECT DISTINCT shd.authoring_org_id authoring_org_id
1687: , shd.organization_name authoring_org_name
1688: FROM oki_sales_k_hdrs shd
1689: ;
1690:
1691:
1692: BEGIN

Line 3555: FROM oki_sales_k_hdrs shd

3551: ( p_summary_build_date IN DATE
3552: ) IS
3553: SELECT NVL(SUM(base_contract_amount), 0) base_contract_amount
3554: , NVL(SUM(sob_contract_amount), 0) sob_contract_amount
3555: FROM oki_sales_k_hdrs shd
3556: WHERE shd.date_signed <= p_summary_build_date
3557: AND shd.date_approved <= p_summary_build_date
3558: AND shd.start_date <= p_summary_build_date
3559: AND shd.end_date > p_summary_build_date

Line 3575: FROM oki_sales_k_hdrs shd

3571: )
3572: IS
3573: SELECT NVL(SUM(base_contract_amount), 0) base_contract_amount
3574: , NVL(SUM(sob_contract_amount), 0) sob_contract_amount
3575: FROM oki_sales_k_hdrs shd
3576: WHERE shd.date_signed <= p_glpr_qtr_end_date
3577: AND shd.date_approved <= p_glpr_qtr_end_date
3578: AND shd.end_date BETWEEN p_glpr_qtr_start_date
3579: AND p_glpr_qtr_end_date

Line 3594: FROM oki_sales_k_hdrs shd

3590: )
3591: IS
3592: SELECT NVL(SUM(base_contract_amount), 0) base_contract_amount
3593: , NVL(SUM(sob_contract_amount), 0) sob_contract_amount
3594: FROM oki_sales_k_hdrs shd
3595: WHERE shd.is_new_yn IS NULL
3596: AND shd.date_signed IS NOT NULL
3597: AND shd.date_approved IS NOT NULL
3598: AND shd.start_date BETWEEN p_glpr_qtr_start_date

Line 3615: FROM oki_sales_k_hdrs shd

3611: )
3612: IS
3613: SELECT NVL(SUM(base_contract_amount), 0) base_contract_amount
3614: , NVL(SUM(sob_contract_amount), 0) sob_contract_amount
3615: FROM oki_sales_k_hdrs shd
3616: WHERE shd.is_new_yn IS NULL
3617: AND shd.date_signed IS NOT NULL
3618: AND shd.date_approved IS NOT NULL
3619: AND shd.start_date < p_glpr_qtr_start_date

Line 3635: FROM oki_sales_k_hdrs shd

3631: )
3632: IS
3633: SELECT NVL(SUM(base_contract_amount), 0) base_contract_amount
3634: , NVL(SUM(sob_contract_amount), 0) sob_contract_amount
3635: FROM oki_sales_k_hdrs shd
3636: WHERE shd.date_signed <= p_summary_build_date
3637: AND shd.date_approved <= p_summary_build_date
3638: AND shd.is_new_yn = 'Y'
3639: AND shd.start_date BETWEEN p_glpr_qtr_start_date

Line 3654: FROM oki_sales_k_hdrs shd

3650: )
3651: IS
3652: SELECT NVL(SUM(base_contract_amount), 0) base_contract_amount
3653: , NVL(SUM(sob_contract_amount), 0) sob_contract_amount
3654: FROM oki_sales_k_hdrs shd
3655: WHERE shd.ste_code = 'CANCELLED'
3656: AND shd.is_new_yn IS NULL
3657: AND shd.is_latest_yn IS NULL
3658: AND shd.start_date BETWEEN p_glpr_qtr_start_date

Line 3675: FROM oki_sales_k_hdrs shd

3671: base_contract_amount) base_contract_amount
3672: , (((shd.end_date - shd.date_terminated) /
3673: (shd.end_date - shd.start_date)) *
3674: sob_contract_amount) sob_contract_amount
3675: FROM oki_sales_k_hdrs shd
3676: WHERE date_terminated BETWEEN p_glpr_qtr_start_date
3677: AND p_summary_build_date
3678: ;
3679: rec_l_trmn_rnwl_csr l_trmn_rnwl_csr%ROWTYPE ;