APPS.OE_SCHEDULE_UTIL dependencies on WSH_DELIVERY_DETAILS
Line 12085: FROM WSH_DELIVERY_DETAILS
12081: END IF;
12082:
12083: SELECT 'Y'
12084: INTO l_found 12085: FROM WSH_DELIVERY_DETAILS 12086: WHERE SOURCE_LINE_ID = p_line_rec.line_id
12087: AND SOURCE_CODE = 'OE'
12088: AND RELEASED_STATUS IN ('Y', 'C');
12089:
Line 16938: FROM WSH_DELIVERY_DETAILS
16934: --
16935: BEGIN
16936: SELECT '1'
16937: INTO l_Pick_status 16938: FROM WSH_DELIVERY_DETAILS 16939: WHERE SOURCE_CODE = 'OE'
16940: AND SOURCE_LINE_ID = p_line_id
16941: AND RELEASED_STATUS IN ('S','Y','C');
16942: