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

423: --Bug 12397111 : Added union to fetch cancelled delivery lines while purging
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

Line 434: FROM wsh_delivery_assignments_v wda,

430: AND wda.delivery_detail_id = wdd.delivery_detail_id
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

Line 455: wsh_delivery_assignments_v wda,

451: CURSOR c_delivery_empty_containers IS
452: SELECT wnd.delivery_id
453: --wda.delivery_detail_id
454: FROM wsh_new_deliveries wnd,
455: wsh_delivery_assignments_v wda,
456: wsh_delivery_legs wdl
457: WHERE wnd.delivery_id = wda.delivery_id
458: AND wnd.delivery_id = wdl.delivery_id(+)
459: AND wdl.delivery_leg_id IS NULL

Line 463: wsh_delivery_assignments_v wda1

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

Line 477: wsh_delivery_assignments_v wda,

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

Line 486: wsh_delivery_assignments_v wda2

482: wda.delivery_id IS NULL AND
483: NOT EXISTS (
484: SELECT 1
485: FROM
486: wsh_delivery_assignments_v wda2
487: WHERE
488: wda2.parent_delivery_detail_id = wda.delivery_detail_id
489: ) ;
490: */

Line 677: wsh_delivery_assignments_v wda,

673: delivery_sql := 'SELECT
674: wnd.delivery_id,wnd.name
675: FROM
676: wsh_new_deliveries wnd,
677: wsh_delivery_assignments_v wda,
678: wsh_delivery_legs wdl
679: WHERE
680: wda.delivery_id(+) = wnd.delivery_id AND
681: wnd.delivery_id = wdl.delivery_id(+) AND

Line 751: wsh_delivery_assignments_v wda,

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

Line 774: wsh_delivery_assignments_v wda2

770: empty_container_sql := empty_container_sql || '
771: AND NOT EXISTS (
772: SELECT 1
773: FROM
774: wsh_delivery_assignments_v wda2
775: WHERE
776: wda2.parent_delivery_detail_id = wda.delivery_detail_id
777: ) ' ;
778:

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

1922: END IF;
1923: END IF;
1924:
1925: DELETE
1926: FROM wsh_delivery_assignments_v
1927: WHERE delivery_detail_id = l_detail_id;
1928:
1929: IF SQL%FOUND THEN
1930: IF l_debug_on THEN

Line 1931: 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);

1927: WHERE delivery_detail_id = l_detail_id;
1928:
1929: IF SQL%FOUND THEN
1930: IF l_debug_on THEN
1931: 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);
1932: END IF;
1933: END IF;
1934:
1935: DELETE

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

2028: END IF;
2029: END IF;
2030:
2031: DELETE
2032: FROM wsh_delivery_assignments_v
2033: WHERE delivery_detail_id = l_container_id;
2034:
2035: IF SQL%FOUND THEN
2036: IF l_debug_on THEN

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

2033: WHERE delivery_detail_id = l_container_id;
2034:
2035: IF SQL%FOUND THEN
2036: IF l_debug_on THEN
2037: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_delivery_assignments_v: CONTAINER_ID=' || l_container_id, WSH_DEBUG_SV.C_PROC_LEVEL);
2038: END IF;
2039: END IF;
2040:
2041: DELETE

Line 2262: FROM wsh_delivery_assignments_v wda,

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

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

2276: */
2277:
2278: CURSOR c_containers_for_so(p_order_number varchar2) IS
2279: SELECT DISTINCT wda.parent_delivery_detail_id
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

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

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