DBA Data[Home] [Help]

APPS.OKE_FORM_DD250 dependencies on OKE_K_HEADERS

Line 33: from oke_k_headers_v

29: l_org_id NUMBER; -- for MOAC
30:
31: cursor c_org is
32: select authoring_org_id
33: from oke_k_headers_v
34: where k_header_id =P_form_Header_id;
35:
36:
37: BEGIN

Line 231: , oke_k_headers EK

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

Line 248: , oke_k_headers EK

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
252: AND CK.Buy_Or_Sell = C_Buy_Or_Sell