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 428: wsh_delivery_details wdd

424: CURSOR c_details_for_del(p_deliveryid NUMBER) IS
425: SELECT wda.delivery_detail_id,
426: wdd.container_flag
427: FROM wsh_delivery_assignments_v wda,
428: wsh_delivery_details wdd
429: WHERE wda.delivery_id = p_deliveryid
430: AND wda.delivery_detail_id = wdd.delivery_detail_id
431: UNION
432: SELECT wdd_can.delivery_detail_id,

Line 435: wsh_delivery_details wdd,

431: UNION
432: SELECT wdd_can.delivery_detail_id,
433: 'N'
434: FROM wsh_delivery_assignments_v wda,
435: wsh_delivery_details wdd,
436: wsh_delivery_details wdd_can
437: WHERE wda.delivery_id = p_deliveryid
438: AND wda.delivery_detail_id = wdd.delivery_detail_id
439: AND wdd_can.source_line_id = wdd.source_line_id

Line 436: wsh_delivery_details wdd_can

432: SELECT wdd_can.delivery_detail_id,
433: 'N'
434: FROM wsh_delivery_assignments_v wda,
435: wsh_delivery_details wdd,
436: wsh_delivery_details wdd_can
437: WHERE wda.delivery_id = p_deliveryid
438: AND wda.delivery_detail_id = wdd.delivery_detail_id
439: AND wdd_can.source_line_id = wdd.source_line_id
440: AND wdd.source_code = 'OE'

Line 462: FROM wsh_delivery_details wdd,

458: AND wnd.delivery_id = wdl.delivery_id(+)
459: AND wdl.delivery_leg_id IS NULL
460: AND NOT EXISTS (
461: SELECT 1
462: FROM wsh_delivery_details wdd,
463: wsh_delivery_assignments_v wda1
464: WHERE wdd.delivery_Detail_id = wda1.delivery_detail_id
465: AND wda1.delivery_id = wnd.delivery_id
466: AND wdd.container_flag = 'N'

Line 478: wsh_delivery_details wdd

474: 'EMPTYLPNS'
475: --wdd.container_name dd_lpn_number,
476: FROM
477: wsh_delivery_assignments_v wda,
478: wsh_delivery_details wdd
479: WHERE
480: wda.delivery_detail_id = wdd.delivery_detail_id AND
481: wdd.container_flag = 'Y'AND
482: wda.delivery_id IS NULL AND

Line 649: wsh_delivery_details dd

645: -- We can add these filtering columns to the view wsh_purge_set_v and scan directly and this sub-query can be flushed out.
646: trip_sql := trip_sql ||
647: ' AND NOT EXISTS
648: ( SELECT 1 FROM
649: wsh_delivery_details dd
650: WHERE
651: dd.delivery_detail_id = inner.dd_id AND
652: (
653: Nvl(dd.released_status,''N'') NOT IN (''C'',''L'') OR

Line 752: wsh_delivery_details wdd

748: ''EMPTYLPNS''
749: --wdd.container_name dd_lpn_number,
750: FROM
751: wsh_delivery_assignments_v wda,
752: wsh_delivery_details wdd
753: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
754: AND wdd.container_flag = ''Y''
755: AND wda.delivery_id IS NULL ';
756:

Line 928: FROM wsh_delivery_details wdd

924: END IF;
925:
926: --Bug 12397111 - Start
927: cancel_wdd_sql := 'SELECT wdd.delivery_detail_id
928: FROM wsh_delivery_details wdd
929: WHERE wdd.source_code = ''OE''
930: AND wdd.released_status = ''D''
931: AND NOT EXISTS
932: ( SELECT 1

Line 933: FROM wsh_delivery_details det

929: WHERE wdd.source_code = ''OE''
930: AND wdd.released_status = ''D''
931: AND NOT EXISTS
932: ( SELECT 1
933: FROM wsh_delivery_details det
934: WHERE det.source_code = ''OE''
935: AND det.source_line_id = wdd.source_line_id
936: AND det.released_status <> ''D'' )
937: AND NOT EXISTS

Line 1866: wsh_delivery_assignments_v, WSH_DELIVERY_DETAILS

1862: Output: Return Status - success or failure
1863: ==============================================================================
1864: Logic: i) Delete records from the following tables:
1865: WSH_FREIGHT_COSTS, WSH_SERIAL_NUMBERS, WSH_EXCEPTIONS,
1866: wsh_delivery_assignments_v, WSH_DELIVERY_DETAILS
1867: -----------------------------------------------------------------------------*/
1868: PROCEDURE Purge_Delivery_Details(p_tbl_del_detail_purge_set Del_Detail_ID_Tbl_Type,
1869: x_return_status OUT NOCOPY VARCHAR2
1870: )IS

Line 1936: FROM wsh_delivery_details

1932: END IF;
1933: END IF;
1934:
1935: DELETE
1936: FROM wsh_delivery_details
1937: WHERE delivery_detail_id = l_detail_id;
1938:
1939: IF SQL%FOUND THEN
1940: IF l_debug_on THEN

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

1937: WHERE delivery_detail_id = l_detail_id;
1938:
1939: IF SQL%FOUND THEN
1940: IF l_debug_on THEN
1941: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_delivery_details: DELIVERY_DETAIL_ID=' || l_detail_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1942: END IF;
1943: END IF;
1944: END LOOP;
1945:

Line 1974: wsh_delivery_assignments_v, WSH_DELIVERY_DETAILS

1970: Input: Table of Record Types for Container Ids
1971: Output: Return Status - success or failure
1972: ==============================================================================
1973: Logic: i) Delete records from the following tables:
1974: wsh_delivery_assignments_v, WSH_DELIVERY_DETAILS
1975: -----------------------------------------------------------------------------*/
1976: PROCEDURE Purge_Containers(p_tbl_containers_purge_set Container_ID_Tbl_Type,
1977: x_return_status OUT NOCOPY VARCHAR2
1978: )IS

Line 2042: FROM wsh_delivery_details

2038: END IF;
2039: END IF;
2040:
2041: DELETE
2042: FROM wsh_delivery_details
2043: WHERE delivery_detail_id = l_container_id
2044: RETURNING lpn_id INTO l_lpn_id;
2045:
2046: IF SQL%FOUND THEN

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

2044: RETURNING lpn_id INTO l_lpn_id;
2045:
2046: IF SQL%FOUND THEN
2047: IF l_debug_on THEN
2048: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_delivery_details: CONTAINER_ID=' || l_container_id, WSH_DEBUG_SV.C_PROC_LEVEL);
2049: END IF;
2050: END IF;
2051:
2052: IF l_lpn_id IS NOT NULL THEN -- Populate the LPN IDs in the table

Line 2263: wsh_delivery_details wdd

2259: --Get Containers for Sales Orders
2260: /*CURSOR c_containers_for_so(order_number varchar2) IS
2261: SELECT distinct wda.parent_delivery_detail_id
2262: FROM wsh_delivery_assignments_v wda,
2263: wsh_delivery_details wdd
2264: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
2265: AND wdd.source_header_number = order_number
2266: AND wda.parent_delivery_detail_id IS NOT NULL;
2267: */

Line 2271: FROM wsh_delivery_assignments_v wda ,wsh_Delivery_Details wdd

2267: */
2268:
2269: /*CURSOR c_containers_for_so(order_number varchar2) IS
2270: SELECT DISTINCT wda.parent_delivery_detail_id
2271: FROM wsh_delivery_assignments_v wda ,wsh_Delivery_Details wdd
2272: WHERE wda.parent_delivery_detail_id is not null
2273: AND wdd.delivery_Detail_id = wda.delivery_detail_id
2274: CONNECT BY PRIOR wda.delivery_detail_id = wda.parent_delivery_detail_id
2275: START WITH wdd.source_header_number =order_number;

Line 2284: wsh_delivery_assignments_v wda1, wsh_delivery_Details wdd

2280: FROM wsh_delivery_assignments_v wda
2281: WHERE wda.parent_delivery_detail_id is not null
2282: CONNECT BY PRIOR wda.delivery_detail_id = wda.parent_delivery_detail_id
2283: START WITH wda.delivery_id IN (select wda1.delivery_id from
2284: wsh_delivery_assignments_v wda1, wsh_delivery_Details wdd
2285: WHERE wda1.delivery_Detail_id = wdd.delivery_Detail_id
2286: and wdd.source_header_number = p_order_number);
2287:
2288: BEGIN

Line 2861: wsh_delivery_details wdd

2857: wsh_trip_stops wts,
2858: wsh_delivery_legs wdl,
2859: wsh_new_deliveries wnd,
2860: wsh_delivery_assignments_v wda,
2861: wsh_delivery_details wdd
2862: WHERE wt.trip_id = wts.trip_id
2863: AND wts.stop_id = wdl.pick_up_stop_id
2864: AND wdl.delivery_id = wnd.delivery_id
2865: AND wda.delivery_id = wnd.delivery_id