APPS.OKE_NUMBER_SEQUENCES_PKG dependencies on OKE_K_HEADERS

Line 205: , oke_k_headers EH

201: SELECT ChgReq_Num_Mode Num_Mode
202: , ChgReq_Num_Increment Incr
203: , ChgReq_Num_Width Width
204: FROM oke_number_options O
205: , oke_k_headers EH
206: , okc_k_headers_b CH
207: WHERE O.K_Type_Code = EH.K_Type_Code
208: AND O.Buy_Or_Sell = CH.Buy_Or_Sell
209: AND CH.ID = EH.K_Header_ID

Line 281: , oke_k_headers EH

277: SELECT ONO.Line_Num_Start_Number
278: , ONO.Line_Num_Increment
279: , ONO.Line_Num_Width
280: FROM oke_number_options ONO
281: , oke_k_headers EH
282: , okc_k_headers_b CH
283: WHERE EH.k_header_id = X_K_Header_ID
284: AND CH.id = EH.k_header_id
285: AND ONO.k_type_code = EH.k_type_code

Line 293: , oke_k_headers EH

289: SELECT ONO.SubLine_Num_Start_Number
290: , ONO.SubLine_Num_Increment
291: , ONO.SubLine_Num_Width
292: FROM oke_number_options ONO
293: , oke_k_headers EH
294: , okc_k_headers_b CH
295: WHERE EH.k_header_id = X_K_Header_ID
296: AND CH.id = EH.k_header_id
297: AND ONO.k_type_code = EH.k_type_code

Line 481: , oke_k_headers EH

477: SELECT ONO.Delv_Num_Start_Number
478: , ONO.Delv_Num_Increment
479: , ONO.Delv_Num_Width
480: FROM oke_number_options ONO
481: , oke_k_headers EH
482: , okc_k_headers_b CH
483: WHERE EH.k_header_id = X_K_Header_ID
484: AND CH.id = EH.k_header_id
485: AND ONO.k_type_code = EH.k_type_code