DBA Data[Home] [Help]

APPS.OE_SCHEDULE_UTIL dependencies on WSH_DELIVERY_DETAILS

Line 10503: FROM WSH_DELIVERY_DETAILS

10499: END IF;
10500:
10501: SELECT 'Y'
10502: INTO l_found
10503: FROM WSH_DELIVERY_DETAILS
10504: WHERE SOURCE_LINE_ID = p_line_rec.line_id
10505: AND SOURCE_CODE = 'OE'
10506: AND RELEASED_STATUS IN ('Y', 'C');
10507:

Line 14463: FROM WSH_DELIVERY_DETAILS

14459: --
14460: BEGIN
14461: SELECT '1'
14462: INTO l_Pick_status
14463: FROM WSH_DELIVERY_DETAILS
14464: WHERE SOURCE_CODE = 'OE'
14465: AND SOURCE_LINE_ID = p_line_id
14466: AND RELEASED_STATUS IN ('S','Y','C');
14467: