APPS.OKS_FULFILL dependencies on OKS_SUBSCR_ELEMENTS

Line 97: And EXISTS (Select 1 from OKS_SUBSCR_ELEMENTS sub

93: And okp.rle_code = 'SUBSCRIBER'
94: And okp.object1_id1 = nvl(p_customer_id,okp.object1_id1)
95: And okg.included_chr_id = hdr.id
96: And okg.cgp_parent_id = nvl(p_grp_id,okg.cgp_parent_id)
97: And EXISTS (Select 1 from OKS_SUBSCR_ELEMENTS sub
98: Where sub.dnz_chr_id = hdr.id
99: And sub.dnz_cle_id = line.id
100: And sub.order_header_id is null)
101: /* Commented by sjanakir for Bug# 5568285 (FP Bug for 5442268) */

Line 120: And EXISTS (Select 1 from OKS_SUBSCR_ELEMENTS sub

116: AND st.ste_code in ('ACTIVE','SIGNED','EXPIRED','TERMINATED')
117: AND Hdr.sts_code <> 'QA_HOLD'
118: And line.dnz_chr_id = Hdr.id
119: And line.lse_id = 46
120: And EXISTS (Select 1 from OKS_SUBSCR_ELEMENTS sub
121: Where sub.dnz_chr_id = hdr.id
122: And sub.dnz_cle_id = line.id
123: And sub.order_header_id is null)
124: Order By hdr.id ;

Line 373: And EXISTS (Select 1 from OKS_SUBSCR_ELEMENTS sub

369: And okp.rle_code = 'SUBSCRIBER'
370: And okp.object1_id1 = nvl(p_customer_id,okp.object1_id1)
371: And okg.included_chr_id = hdr.id
372: And okg.cgp_parent_id = nvl(p_grp_id,okg.cgp_parent_id)
373: And EXISTS (Select 1 from OKS_SUBSCR_ELEMENTS sub
374: Where sub.dnz_chr_id = hdr.id
375: And sub.order_header_id is null);
376:
377: Cursor l_fulfill_agg_csr_no_para IS

Line 391: And EXISTS (Select 1 from OKS_SUBSCR_ELEMENTS sub

387: And Hdr.Template_yn = 'N'
388: And Hdr.sts_code = st.CODE
389: AND st.ste_code in ('ACTIVE','SIGNED','EXPIRED','TERMINATED')
390: AND hdr.sts_code <> 'QA_HOLD'
391: And EXISTS (Select 1 from OKS_SUBSCR_ELEMENTS sub
392: Where sub.dnz_chr_id = hdr.id
393: And sub.order_header_id is null);
394: -- Bug 4915691 --
395: