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'
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;