APPS.INV_PICK_RELEASE_PUB dependencies on WSH_DELIVERY_DETAILS

Line 1313: FROM wsh_delivery_details

1309: --get demand information
1310: BEGIN
1311: SELECT SOURCE_HEADER_ID
1312: INTO l_OE_HEADER_ID
1313: FROM wsh_delivery_details
1314: WHERE move_order_line_id =
1315: l_qtree_line_tbl(l_qtree_line_index).move_order_line_id
1316: AND move_order_line_id is not NULL
1317: AND released_status = 'S';

Line 2578: FROM WSH_DELIVERY_DETAILS

2574:
2575: BEGIN
2576: SELECT *
2577: INTO INV_CACHE.wdd_rec
2578: FROM WSH_DELIVERY_DETAILS
2579: WHERE move_order_line_id = l_mo_line.line_id
2580: AND NVL(released_status, 'Z') NOT IN ('Y','C');
2581: l_return_value := TRUE;
2582: EXCEPTION