APPS.OKI_LOAD_ENR_PVT dependencies on OKI_SALES_K_HDRS

Line 291: , oki_sales_k_hdrs shd

287: -- display number in correct number format
288: , COUNT(DISTINCT (shd.chr_id )) contract_count
289: FROM /*11510 change removed oki_expired_lines oel */
290: oki_cov_prd_lines cpl
291: , oki_sales_k_hdrs shd
292: , oki_k_salesreps slr
293: WHERE shd.chr_id = /*oel*/cpl.chr_id
294: /*11510 changes start */
295: AND cpl.is_exp_not_renewed_yn = 'Y'

Line 313: FROM oki_sales_k_hdrs shd

309: , NULL customer_name /*11510 change null out shd.customer_name */
310: , shd.authoring_org_id authoring_org_id
311: , NULL authoring_org_name /*11510 change null out shd.organization_name */
312: , shd.scs_code scs_code
313: FROM oki_sales_k_hdrs shd
314: ;
315:
316:
317: BEGIN

Line 508: , oki_sales_k_hdrs shd

504: -- display number in correct number format
505: , COUNT(DISTINCT (shd.chr_id )) contract_count
506: FROM /*11510 change removed oki_expired_lines oel added oki_cov_prd_lines */
507: oki_cov_prd_lines cpl
508: , oki_sales_k_hdrs shd
509: , oki_k_salesreps slr
510: WHERE shd.chr_id = cpl.chr_id
511: /*11510 change start*/
512: AND cpl.is_exp_not_renewed_yn = 'Y'

Line 527: FROM oki_sales_k_hdrs shd

523: CURSOR l_cust_id_csr IS
524: SELECT DISTINCT(shd.customer_party_id) customer_id
525: , NULL customer_name /*11510 change null out shd.customer_name */
526: , shd.scs_code
527: FROM oki_sales_k_hdrs shd
528: ;
529:
530:
531: BEGIN

Line 715: , oki_sales_k_hdrs shd

711: -- display number in correct number format
712: , COUNT(DISTINCT (shd.chr_id )) contract_count
713: FROM /*11510 change removed oki_expired_lines oel*/
714: oki_cov_prd_lines cpl
715: , oki_sales_k_hdrs shd
716: WHERE shd.chr_id = cpl.chr_id
717: /*11510 change start*/
718: AND cpl.is_exp_not_renewed_yn = 'Y'
719: /*11510 change end*/

Line 731: FROM oki_sales_k_hdrs shd

727: SELECT DISTINCT(shd.customer_party_id) customer_id
728: , NULL customer_name /*11510 change null out customer name*/
729: , shd.authoring_org_id authoring_org_id
730: , NULL authoring_org_name /*11510 change null out authoring_org_name*/
731: FROM oki_sales_k_hdrs shd
732: ;
733:
734:
735: BEGIN