APPS.OE_SHIPPING_INTEGRATION_PVT dependencies on WSH_DELIVERY_LINE_STATUS_V

Line 57: FROM WSH_DELIVERY_LINE_STATUS_V

53: END IF;
54:
55: SELECT PICK_STATUS
56: INTO l_release_status
57: FROM WSH_DELIVERY_LINE_STATUS_V
58: WHERE SOURCE_CODE = 'OE'
59: AND SOURCE_LINE_ID = OE_LINE_SECURITY.g_record.line_id
60: AND PICK_STATUS = 'S';
61: IF l_release_status = 'S' THEN

Line 116: FROM WSH_DELIVERY_LINE_STATUS_V

112: BEGIN
113:
114: SELECT PICK_STATUS
115: INTO l_pick_status
116: FROM WSH_DELIVERY_LINE_STATUS_V
117: WHERE SOURCE_CODE = 'OE'
118: AND SOURCE_LINE_ID = OE_LINE_SECURITY.g_record.line_id
119: AND PICK_STATUS = 'Y';
120: