APPS.OKS_FULFILL dependencies on OKC_K_LINES_B

Line 73: -- Added condition to fetch line id from OKC_K_LINES_B

69:
70: -- Bug 4915691 --
71: -- Added logic to filter data based on Subscr elements
72: -- processed for a Subscription line
73: -- Added condition to fetch line id from OKC_K_LINES_B
74:
75: CURSOR chr_csr IS
76: SELECT hdr.id id
77: , line.id line_id

Line 83: ,OKC_K_LINES_B line

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
87: AND st.ste_code in ('ACTIVE','SIGNED','EXPIRED','TERMINATED')

Line 112: ,OKC_K_LINES_B line

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
116: AND st.ste_code in ('ACTIVE','SIGNED','EXPIRED','TERMINATED')