[Home] [Help]
4741: IF x_movement_transaction.document_source_type = 'SO'
4742: THEN
4743: SELECT initial_pickup_date
4744: INTO l_transaction_date
4745: FROM wsh_delivery_details_ob_grp_v wdd
4746: , wsh_new_deliveries_ob_grp_v wnd
4747: , wsh_delivery_assignments wda
4748: WHERE wnd.delivery_id = wda.delivery_id
4749: AND wda.delivery_detail_id = wdd.delivery_detail_id