APPS.INV_SHIPPING_TRANSACTION_PUB dependencies on STANDARD
Line 2319: AND d1.delivery_type = 'STANDARD'
2315: WHERE d1.delivery_id <> l_delivery_id
2316: AND s1.stop_id = dl1.pick_up_stop_id
2317: AND d1.delivery_id = dl1.delivery_id
2318: AND d1.status_code = 'OP' 2319: AND d1.delivery_type = 'STANDARD' 2320: AND s2.trip_id = s1.trip_id
2321: AND s2.stop_id = dl2.pick_up_stop_id
2322: AND dl2.delivery_id = l_delivery_id
2323: AND rownum = 1;