APPS.OKI_UTL_PVT dependencies on OKI_SALES_K_HDRS

Line 77: FROM oki_sales_k_hdrs shd

73: p_start_date IN DATE
74: ) RETURN g_tactk_all_csr_row IS
75: SELECT NVL(SUM(cpl.base_price_negotiated), 0) value
76: , COUNT(DISTINCT(shd.chr_id)) contract_count
77: FROM oki_sales_k_hdrs shd
78: , oki_cov_prd_lines cpl
79: WHERE shd.chr_id = cpl.chr_id
80: AND cpl.sts_code = 'ACTIVE'
81: AND shd.date_signed <= p_start_date

Line 100: FROM oki_sales_k_hdrs shd

96: ) RETURN g_tactk_by_org_csr_row IS
97: SELECT NVL(SUM(cpl.base_price_negotiated), 0) value
98: , COUNT(DISTINCT cpl.chr_id) contract_count
99: , shd.authoring_org_id authoring_org_id
100: FROM oki_sales_k_hdrs shd
101: , oki_cov_prd_lines cpl
102: WHERE shd.chr_id = cpl.chr_id
103: AND cpl.sts_code = 'ACTIVE'
104: AND shd.date_signed <= p_start_date

Line 124: FROM oki_sales_k_hdrs shd

120: p_qtr_end_date IN DATE
121: ) RETURN g_rnwl_oppty_all_csr_row IS
122: SELECT NVL(SUM(shd.base_contract_amount), 0) value
123: , COUNT(shd.chr_id) contract_count
124: FROM oki_sales_k_hdrs shd
125: WHERE shd.start_date <= p_qtr_end_date
126: AND shd.is_new_yn IS NULL
127: AND shd.date_signed IS NULL
128: AND shd.date_canceled IS NULL

Line 142: FROM oki_sales_k_hdrs shd

138: , p_authoring_org_id IN NUMBER
139: ) RETURN g_rnwl_oppty_by_org_csr_row IS
140: SELECT NVL(SUM(shd.base_contract_amount), 0) value
141: , COUNT(shd.chr_id) contract_count
142: FROM oki_sales_k_hdrs shd
143: WHERE shd.start_date <= p_qtr_end_date
144: AND shd.is_new_yn IS NULL
145: AND shd.date_signed IS NULL
146: AND shd.date_canceled IS NULL

Line 162: FROM oki_sales_k_hdrs shd

158: , p_qtr_end_date IN DATE
159: ) RETURN g_k_exp_in_qtr_all_csr_row IS
160: SELECT NVL(SUM(base_contract_amount), 0) value
161: , COUNT(shd.chr_id) contract_count
162: FROM oki_sales_k_hdrs shd
163: WHERE shd.date_signed <= p_qtr_start_date
164: AND shd.date_approved <= p_qtr_end_date
165: AND shd.end_date BETWEEN p_qtr_start_date AND p_qtr_end_date
166: AND shd.date_terminated IS NULL

Line 180: FROM oki_sales_k_hdrs shd

176: , p_authoring_org_id IN NUMBER
177: ) RETURN g_k_exp_in_qtr_by_org_csr_row IS
178: SELECT NVL(SUM(base_contract_amount), 0) value
179: , COUNT(shd.chr_id) contract_count
180: FROM oki_sales_k_hdrs shd
181: WHERE shd.date_signed <= p_qtr_start_date
182: AND shd.date_approved <= p_qtr_end_date
183: AND shd.end_date BETWEEN p_qtr_start_date AND p_qtr_end_date
184: AND shd.date_terminated IS NULL

Line 200: FROM oki_sales_k_hdrs shd

196:
197: ) IS
198: SELECT NVL(SUM(base_contract_amount), 0) value
199: , COUNT(shd.chr_id) contract_count
200: FROM oki_sales_k_hdrs shd
201: WHERE shd.is_new_yn IS NULL
202: AND shd.date_signed IS NOT NULL
203: AND shd.start_date BETWEEN p_qtr_start_date AND p_qtr_end_date
204: AND GREATEST(shd.date_signed, shd.date_approved) <= p_qtr_end_date

Line 218: FROM oki_sales_k_hdrs shd

214:
215: CURSOR g_org_csr RETURN g_org_csr_row IS
216: SELECT DISTINCT shd.authoring_org_id authoring_org_id
217: , NULL organization_name
218: FROM oki_sales_k_hdrs shd
219: ;
220:
221: -- Retrieve the bin metadata
222: CURSOR g_bin_disp_lkup_csr