DBA Data[Home] [Help]

APPS.OKE_FORM_DD250 dependencies on OKC_K_HEADERS_ALL_B

Line 229: FROM okc_k_headers_all_b CK2

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

Line 230: , okc_k_headers_all_b CK

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);

Line 246: FROM okc_k_headers_all_b CK2

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

Line 247: , okc_k_headers_all_b CK

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