APPS.WSH_ITM_EXPORT_SCREENING dependencies on WSH_NEW_DELIVERIES

Line 441: ' WSH_NEW_DELIVERIES WND, '||

437: ' WND.ORGANIZATION_ID AS ORGANIZATION_ID, '||
438: ' MTL.MASTER_ORGANIZATION_ID AS MASTER_ORGANIZATION_ID '||
439: ' FROM '||
440: ' WSH_EXCEPTIONS WE , '||
441: ' WSH_NEW_DELIVERIES WND, '||
442: ' MTL_PARAMETERS MTL '||
443: ' WHERE '||
444: ' WE.STATUS <> ''CLOSED'' '||
445: ' AND WND.ORGANIZATION_ID = MTL.ORGANIZATION_ID '||

Line 791: FROM WSH_NEW_DELIVERIES

787: -- Get the ORGANIZATION_IF of the delivery
788: -- and setting the TRADING_PARTNER_ID.
789: BEGIN
790: SELECT ORGANIZATION_ID INTO l_tranx_history_rec.trading_partner_id
791: FROM WSH_NEW_DELIVERIES
792: WHERE DELIVERY_ID = l_num_delivery_id_tab(k);
793:
794: EXCEPTION
795: WHEN NO_DATA_FOUND THEN