APPS.WSH_ITM_EXPORT_SCREENING dependencies on WSH_NEW_DELIVERIES

Line 428: ' WSH_NEW_DELIVERIES WND, '||

424: ' WND.ORGANIZATION_ID AS ORGANIZATION_ID, '||
425: ' MTL.MASTER_ORGANIZATION_ID AS MASTER_ORGANIZATION_ID '||
426: ' FROM '||
427: ' WSH_EXCEPTIONS WE , '||
428: ' WSH_NEW_DELIVERIES WND, '||
429: ' MTL_PARAMETERS MTL '||
430: ' WHERE '||
431: ' WE.STATUS <> ''CLOSED'' '||
432: ' AND WND.ORGANIZATION_ID = MTL.ORGANIZATION_ID '||

Line 778: FROM WSH_NEW_DELIVERIES

774: -- Get the ORGANIZATION_IF of the delivery
775: -- and setting the TRADING_PARTNER_ID.
776: BEGIN
777: SELECT ORGANIZATION_ID INTO l_tranx_history_rec.trading_partner_id
778: FROM WSH_NEW_DELIVERIES
779: WHERE DELIVERY_ID = l_num_delivery_id_tab(k);
780:
781: EXCEPTION
782: WHEN NO_DATA_FOUND THEN