225: , CK2.Contract_Number Contract_Number
226: , DECODE( EK.BOA_ID ,
227: NULL , NULL ,
228: CK.Contract_Number ) Order_Number
229: FROM okc_k_headers_all_b CK2
230: , okc_k_headers_all_b CK
231: , oke_k_headers EK
232: WHERE EK.K_Header_ID = C_K_Header_ID
233: AND CK.ID = EK.K_Header_ID
226: , DECODE( EK.BOA_ID ,
227: NULL , NULL ,
228: CK.Contract_Number ) Order_Number
229: FROM okc_k_headers_all_b CK2
230: , okc_k_headers_all_b CK
231: , oke_k_headers EK
232: WHERE EK.K_Header_ID = C_K_Header_ID
233: AND CK.ID = EK.K_Header_ID
234: AND CK2.ID = NVL(EK.BOA_ID , EK.K_Header_ID);
242: , CK2.Contract_Number Contract_Number
243: , DECODE( EK.BOA_ID ,
244: NULL , NULL ,
245: CK.Contract_Number ) Order_Number
246: FROM okc_k_headers_all_b CK2
247: , okc_k_headers_all_b CK
248: , oke_k_headers EK
249: WHERE EK.K_Number_Disp = C_K_Header
250: AND EK.K_Type_Code = C_K_Type
243: , DECODE( EK.BOA_ID ,
244: NULL , NULL ,
245: CK.Contract_Number ) Order_Number
246: FROM okc_k_headers_all_b CK2
247: , okc_k_headers_all_b CK
248: , oke_k_headers EK
249: WHERE EK.K_Number_Disp = C_K_Header
250: AND EK.K_Type_Code = C_K_Type
251: AND CK.ID = EK.K_Header_ID