DBA Data[Home] [Help]

APPS.OKE_FORM_DD250 dependencies on WSH_DELIVERY_LEGS

Line 604: , wsh_delivery_legs WDL

600: -- , WDI.BOL_Issue_Office BOL_Issue_Office
601: -- , WDI.BOL_Issued_By BOL_Issued_By
602: -- , WDI.BOL_Date_Issued BOL_Date_Issued
603: FROM wsh_document_instances WDI
604: , wsh_delivery_legs WDL
605: WHERE WDL.Delivery_ID = P_Delivery_ID
606: AND WDI.Entity_ID = WDL.Delivery_Leg_ID
607: AND WDI.Entity_Name = 'WSH_DELIVERY_LEGS'
608: AND WDI.Status <> 'CANCELLED'

Line 607: AND WDI.Entity_Name = 'WSH_DELIVERY_LEGS'

603: FROM wsh_document_instances WDI
604: , wsh_delivery_legs WDL
605: WHERE WDL.Delivery_ID = P_Delivery_ID
606: AND WDI.Entity_ID = WDL.Delivery_Leg_ID
607: AND WDI.Entity_Name = 'WSH_DELIVERY_LEGS'
608: AND WDI.Status <> 'CANCELLED'
609: ORDER BY WDL.Sequence_Number;
610:
611: BillLadingRec BillLading%RowType;