eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_PURGE dependencies on WSH_DELIVERY_DETAILS

Line 420: wsh_delivery_details wdd

416: CURSOR c_details_for_del(p_deliveryid NUMBER) IS
417: SELECT wda.delivery_detail_id,
418: wdd.container_flag
419: FROM wsh_delivery_assignments_v wda,
420: wsh_delivery_details wdd
421: WHERE wda.delivery_id = p_deliveryid
422: AND wda.delivery_detail_id = wdd.delivery_detail_id;
423:
424:

Line 442: FROM wsh_delivery_details wdd,

438: AND wnd.delivery_id = wdl.delivery_id(+)
439: AND wdl.delivery_leg_id IS NULL
440: AND NOT EXISTS (
441: SELECT 1
442: FROM wsh_delivery_details wdd,
443: wsh_delivery_assignments_v wda1
444: WHERE wdd.delivery_Detail_id = wda1.delivery_detail_id
445: AND wda1.delivery_id = wnd.delivery_id
446: AND wdd.container_flag = 'N'

Line 458: wsh_delivery_details wdd

454: 'EMPTYLPNS'
455: --wdd.container_name dd_lpn_number,
456: FROM
457: wsh_delivery_assignments_v wda,
458: wsh_delivery_details wdd
459: WHERE
460: wda.delivery_detail_id = wdd.delivery_detail_id AND
461: wdd.container_flag = 'Y'AND
462: wda.delivery_id IS NULL AND

Line 677: wsh_delivery_details wdd

673: ''EMPTYLPNS''
674: --wdd.container_name dd_lpn_number,
675: FROM
676: wsh_delivery_assignments_v wda,
677: wsh_delivery_details wdd
678: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
679: AND wdd.container_flag = ''Y''
680: AND wda.delivery_id IS NULL ';
681:

Line 1741: wsh_delivery_assignments_v, WSH_DELIVERY_DETAILS

1737: Output: Return Status - success or failure
1738: ==============================================================================
1739: Logic: i) Delete records from the following tables:
1740: WSH_FREIGHT_COSTS, WSH_SERIAL_NUMBERS, WSH_EXCEPTIONS,
1741: wsh_delivery_assignments_v, WSH_DELIVERY_DETAILS
1742: -----------------------------------------------------------------------------*/
1743: PROCEDURE Purge_Delivery_Details(p_tbl_del_detail_purge_set Del_Detail_ID_Tbl_Type,
1744: x_return_status OUT NOCOPY VARCHAR2
1745: )IS

Line 1811: FROM wsh_delivery_details

1807: END IF;
1808: END IF;
1809:
1810: DELETE
1811: FROM wsh_delivery_details
1812: WHERE delivery_detail_id = l_detail_id;
1813:
1814: IF SQL%FOUND THEN
1815: IF l_debug_on THEN

Line 1816: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_delivery_details: DELIVERY_DETAIL_ID=' || l_detail_id, WSH_DEBUG_SV.C_PROC_LEVEL);

1812: WHERE delivery_detail_id = l_detail_id;
1813:
1814: IF SQL%FOUND THEN
1815: IF l_debug_on THEN
1816: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_delivery_details: DELIVERY_DETAIL_ID=' || l_detail_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1817: END IF;
1818: END IF;
1819: END LOOP;
1820:

Line 1849: wsh_delivery_assignments_v, WSH_DELIVERY_DETAILS

1845: Input: Table of Record Types for Container Ids
1846: Output: Return Status - success or failure
1847: ==============================================================================
1848: Logic: i) Delete records from the following tables:
1849: wsh_delivery_assignments_v, WSH_DELIVERY_DETAILS
1850: -----------------------------------------------------------------------------*/
1851: PROCEDURE Purge_Containers(p_tbl_containers_purge_set Container_ID_Tbl_Type,
1852: x_return_status OUT NOCOPY VARCHAR2
1853: )IS

Line 1917: FROM wsh_delivery_details

1913: END IF;
1914: END IF;
1915:
1916: DELETE
1917: FROM wsh_delivery_details
1918: WHERE delivery_detail_id = l_container_id
1919: RETURNING lpn_id INTO l_lpn_id;
1920:
1921: IF SQL%FOUND THEN

Line 1923: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_delivery_details: CONTAINER_ID=' || l_container_id, WSH_DEBUG_SV.C_PROC_LEVEL);

1919: RETURNING lpn_id INTO l_lpn_id;
1920:
1921: IF SQL%FOUND THEN
1922: IF l_debug_on THEN
1923: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_delivery_details: CONTAINER_ID=' || l_container_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1924: END IF;
1925: END IF;
1926:
1927: IF l_lpn_id IS NOT NULL THEN -- Populate the LPN IDs in the table

Line 2137: wsh_delivery_details wdd

2133: --Get Containers for Sales Orders
2134: /*CURSOR c_containers_for_so(order_number varchar2) IS
2135: SELECT distinct wda.parent_delivery_detail_id
2136: FROM wsh_delivery_assignments_v wda,
2137: wsh_delivery_details wdd
2138: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
2139: AND wdd.source_header_number = order_number
2140: AND wda.parent_delivery_detail_id IS NOT NULL;
2141: */

Line 2145: FROM wsh_delivery_assignments_v wda ,wsh_Delivery_Details wdd

2141: */
2142:
2143: /*CURSOR c_containers_for_so(order_number varchar2) IS
2144: SELECT DISTINCT wda.parent_delivery_detail_id
2145: FROM wsh_delivery_assignments_v wda ,wsh_Delivery_Details wdd
2146: WHERE wda.parent_delivery_detail_id is not null
2147: AND wdd.delivery_Detail_id = wda.delivery_detail_id
2148: CONNECT BY PRIOR wda.delivery_detail_id = wda.parent_delivery_detail_id
2149: START WITH wdd.source_header_number =order_number;

Line 2158: wsh_delivery_assignments_v wda1, wsh_delivery_Details wdd

2154: FROM wsh_delivery_assignments_v wda
2155: WHERE wda.parent_delivery_detail_id is not null
2156: CONNECT BY PRIOR wda.delivery_detail_id = wda.parent_delivery_detail_id
2157: START WITH wda.delivery_id IN (select wda1.delivery_id from
2158: wsh_delivery_assignments_v wda1, wsh_delivery_Details wdd
2159: WHERE wda1.delivery_Detail_id = wdd.delivery_Detail_id
2160: and wdd.source_header_number = p_order_number);
2161:
2162: BEGIN

Line 2674: wsh_delivery_details wdd

2670: wsh_trip_stops wts,
2671: wsh_delivery_legs wdl,
2672: wsh_new_deliveries wnd,
2673: wsh_delivery_assignments_v wda,
2674: wsh_delivery_details wdd
2675: WHERE wt.trip_id = wts.trip_id
2676: AND wts.stop_id = wdl.pick_up_stop_id
2677: AND wdl.delivery_id = wnd.delivery_id
2678: AND wda.delivery_id = wnd.delivery_id