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_ASSIGNMENTS_V

Line 419: FROM wsh_delivery_assignments_v wda,

415:
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:

Line 435: wsh_delivery_assignments_v wda,

431: CURSOR c_delivery_empty_containers IS
432: SELECT wnd.delivery_id
433: --wda.delivery_detail_id
434: FROM wsh_new_deliveries wnd,
435: wsh_delivery_assignments_v wda,
436: wsh_delivery_legs wdl
437: WHERE wnd.delivery_id = wda.delivery_id
438: AND wnd.delivery_id = wdl.delivery_id(+)
439: AND wdl.delivery_leg_id IS NULL

Line 443: wsh_delivery_assignments_v wda1

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'
447: ) ;

Line 457: wsh_delivery_assignments_v wda,

453: wdd.delivery_detail_id,
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

Line 466: wsh_delivery_assignments_v wda2

462: wda.delivery_id IS NULL AND
463: NOT EXISTS (
464: SELECT 1
465: FROM
466: wsh_delivery_assignments_v wda2
467: WHERE
468: wda2.parent_delivery_detail_id = wda.delivery_detail_id
469: ) ;
470: */

Line 611: wsh_delivery_assignments_v wda,

607: delivery_sql := 'SELECT
608: wnd.delivery_id,wnd.name
609: FROM
610: wsh_new_deliveries wnd,
611: wsh_delivery_assignments_v wda,
612: wsh_delivery_legs wdl
613: WHERE
614: wda.delivery_id(+) = wnd.delivery_id AND
615: wnd.delivery_id = wdl.delivery_id(+) AND

Line 676: wsh_delivery_assignments_v wda,

672: empty_container_sql := 'SELECT wdd.delivery_detail_id,
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 ';

Line 698: wsh_delivery_assignments_v wda2

694: empty_container_sql := empty_container_sql || '
695: AND NOT EXISTS (
696: SELECT 1
697: FROM
698: wsh_delivery_assignments_v wda2
699: WHERE
700: wda2.parent_delivery_detail_id = wda.delivery_detail_id
701: ) ' ;
702:

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 1801: FROM wsh_delivery_assignments_v

1797: END IF;
1798: END IF;
1799:
1800: DELETE
1801: FROM wsh_delivery_assignments_v
1802: WHERE delivery_detail_id = l_detail_id;
1803:
1804: IF SQL%FOUND THEN
1805: IF l_debug_on THEN

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

1802: WHERE delivery_detail_id = l_detail_id;
1803:
1804: IF SQL%FOUND THEN
1805: IF l_debug_on THEN
1806: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_delivery_assignments_v: DELIVERY_DETAIL_ID=' || l_detail_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1807: END IF;
1808: END IF;
1809:
1810: DELETE

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 1907: FROM wsh_delivery_assignments_v

1903: END IF;
1904: END IF;
1905:
1906: DELETE
1907: FROM wsh_delivery_assignments_v
1908: WHERE delivery_detail_id = l_container_id;
1909:
1910: IF SQL%FOUND THEN
1911: IF l_debug_on THEN

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

1908: WHERE delivery_detail_id = l_container_id;
1909:
1910: IF SQL%FOUND THEN
1911: IF l_debug_on THEN
1912: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_delivery_assignments_v: CONTAINER_ID=' || l_container_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1913: END IF;
1914: END IF;
1915:
1916: DELETE

Line 2136: FROM wsh_delivery_assignments_v wda,

2132:
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;

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 2154: FROM wsh_delivery_assignments_v wda

2150: */
2151:
2152: CURSOR c_containers_for_so(p_order_number varchar2) IS
2153: SELECT DISTINCT wda.parent_delivery_detail_id
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

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 2673: wsh_delivery_assignments_v wda,

2669: FROM wsh_trips wt,
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