[Home] [Help]
3902: IF x_movement_transaction.document_source_type = 'SO'
3903: THEN
3904: SELECT initial_pickup_date
3905: INTO l_transaction_date
3906: FROM wsh_delivery_details_ob_grp_v wdd
3907: , wsh_new_deliveries_ob_grp_v wnd
3908: , wsh_delivery_assignments wda
3909: WHERE wnd.delivery_id = wda.delivery_id
3910: AND wda.delivery_detail_id = wdd.delivery_detail_id