APPS.OKS_FULFILL dependencies on OKC_STATUSES_B

Line 82: ,OKC_STATUSES_B st

78: FROM
79: OKC_K_GRPINGS okg
80: ,OKC_K_PARTY_ROLES_B okp
81: ,OKC_K_HEADERS_B Hdr
82: ,OKC_STATUSES_B st
83: ,OKC_K_LINES_B line
84: Where Hdr.scs_code = 'SUBSCRIPTION'
85: And Hdr.Template_yn = 'N'
86: And Hdr.sts_code = st.CODE

Line 111: ,OKC_STATUSES_B st

107: SELECT hdr.id id
108: , line.id line_id
109: FROM
110: OKC_K_HEADERS_B Hdr
111: ,OKC_STATUSES_B st
112: ,OKC_K_LINES_B line
113: Where Hdr.scs_code = 'SUBSCRIPTION'
114: And Hdr.Template_yn = 'N'
115: And Hdr.sts_code = st.CODE

Line 361: ,OKC_STATUSES_B ST

357: From
358: OKC_K_GRPINGS okg
359: ,OKC_K_PARTY_ROLES_B okp
360: ,OKC_K_HEADERS_B Hdr
361: ,OKC_STATUSES_B ST
362: Where Hdr.scs_code = 'SUBSCRIPTION'
363: And Hdr.Template_yn = 'N'
364: And Hdr.sts_code = st.CODE
365: AND st.ste_code in ('ACTIVE','SIGNED','EXPIRED','TERMINATED')

Line 385: ,OKC_STATUSES_B ST

381: stddev(hdr.id) stdid,
382: count(*) total
383: From
384: OKC_K_HEADERS_B Hdr
385: ,OKC_STATUSES_B ST
386: Where Hdr.scs_code = 'SUBSCRIPTION'
387: And Hdr.Template_yn = 'N'
388: And Hdr.sts_code = st.CODE
389: AND st.ste_code in ('ACTIVE','SIGNED','EXPIRED','TERMINATED')