APPS.WSH_FTE_COMP_CONSTRAINT_PKG dependencies on WSH_DELIVERY_DETAILS

Line 91: l_shipping_control wsh_delivery_details.shipping_control%TYPE;

87: j NUMBER;
88: l_initial_pickup_location_id NUMBER;
89: l_ship_from_location_id NUMBER;
90: l_max_line_group_id NUMBER := 0;
91: l_shipping_control wsh_delivery_details.shipping_control%TYPE;
92: l_cc_target_tripstops WSH_FTE_CONSTRAINT_FRAMEWORK.target_tripstop_cc_rec_type;
93: l_delivery_type VARCHAR2(30);
94:
95: CURSOR c_shipping_control(l_detail_id NUMBER ) IS

Line 98: FROM wsh_delivery_details

94:
95: CURSOR c_shipping_control(l_detail_id NUMBER ) IS
96: SELECT NVL(shipping_control,'BUYER'), ship_from_location_id,
97: line_direction, released_status
98: FROM wsh_delivery_details
99: WHERE delivery_detail_Id = l_detail_id;
100:
101: CURSOR c_delivery_shipping_control (l_delivery_id NUMBER) IS
102: SELECT NVL(shipping_control, 'BUYER'),