DBA Data[Home] [Help]

APPS.OKE_NUMBER_SEQUENCES_PKG dependencies on OKE_K_DELIVERABLES_B

Line 490: FROM oke_k_deliverables_b d

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

Line 495: FROM oke_k_deliverables_b

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'