486: AND ONO.buy_or_sell = CH.buy_or_sell;
487:
488: CURSOR DlvNum IS
489: SELECT Deliverable_Num
490: FROM oke_k_deliverables_b d
491: WHERE K_Header_ID = X_K_Header_ID
492: AND K_Line_ID = X_K_Line_ID
493: AND ltrim(Deliverable_Num,'0') = (
494: SELECT to_char(max(to_number(Deliverable_Num)))
491: WHERE K_Header_ID = X_K_Header_ID
492: AND K_Line_ID = X_K_Line_ID
493: AND ltrim(Deliverable_Num,'0') = (
494: SELECT to_char(max(to_number(Deliverable_Num)))
495: FROM oke_k_deliverables_b
496: WHERE K_Header_ID = d.K_Header_ID
497: AND K_Line_ID = d.K_Line_ID
498: AND OKE_NUMBER_SEQUENCES_PKG.Value_Is_Numeric
499: (Deliverable_Num) = 'Y'