DBA Data[Home] [Help]

APPS.OKE_NUMBER_SEQUENCES_PKG dependencies on OKC_K_HEADERS_B

Line 206: , okc_k_headers_b CH

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
210: AND EH.K_Header_ID = X_K_Header_ID;

Line 282: , okc_k_headers_b CH

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
286: AND ONO.buy_or_sell = CH.buy_or_sell;

Line 294: , okc_k_headers_b CH

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
298: AND ONO.buy_or_sell = CH.buy_or_sell;

Line 482: , okc_k_headers_b CH

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
486: AND ONO.buy_or_sell = CH.buy_or_sell;