APPS.OKE_DELIVERABLE_UTILS dependencies on OKC_K_LINES_B

Line 26: select id , id , 99999 from okc_k_lines_b ) a

22: , oke_k_deliverables_b kd
23: , ( select cle_id , cle_id_ascendant , level_sequence
24: from okc_ancestrys
25: union all
26: select id , id , 99999 from okc_k_lines_b ) a
27: WHERE kd.deliverable_id = C_Deliverable_ID
28: AND pr.rle_code = C_Role_Code
29: AND pr.dnz_chr_id = kd.k_header_id
30: AND a.cle_id = kd.k_line_id

Line 70: select id , id , 99999 from okc_k_lines_b ) a

66: , oke_k_deliverables_b kd
67: , ( select cle_id , cle_id_ascendant , level_sequence
68: from okc_ancestrys
69: union all
70: select id , id , 99999 from okc_k_lines_b ) a
71: WHERE kd.deliverable_id = C_Deliverable_ID
72: AND kt.term_code = C_Term_Code
73: AND kt.k_header_id = kd.k_header_id
74: AND a.cle_id = kd.k_line_id

Line 111: , okc_k_lines_b L

107: SELECT Rtrim(Ltrim(H.Contract_Number, ' '), ' ') K_Number
108: , Rtrim(Ltrim(L.Line_Number, ' '), ' ') L_Number
109: , Rtrim(Ltrim(D.Deliverable_Num, ' '), ' ') D_Number
110: FROM okc_k_headers_all_b H
111: , okc_k_lines_b L
112: , oke_k_deliverables_b D
113: WHERE D.Deliverable_ID = P_Deliverable_ID
114: AND L.ID = D.K_Line_ID
115: AND H.ID = D.K_Header_ID;