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_NEW_DELIVERY_ACTIONS dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 88: FROM wsh_delivery_assignments_v

84: IS
85:
86: CURSOR get_container(detail_id NUMBER) IS
87: SELECT parent_delivery_detail_id
88: FROM wsh_delivery_assignments_v
89: WHERE delivery_detail_id = detail_id;
90:
91: CURSOR get_lines (cont_id NUMBER) IS
92: SELECT delivery_detail_id

Line 93: FROM wsh_delivery_assignments_v

89: WHERE delivery_detail_id = detail_id;
90:
91: CURSOR get_lines (cont_id NUMBER) IS
92: SELECT delivery_detail_id
93: FROM wsh_delivery_assignments_v
94: START WITH parent_delivery_detail_id = cont_id
95: CONNECT BY PRIOR delivery_detail_id = parent_delivery_detail_id;
96:
97: l_container_id NUMBER := NULL;

Line 390: from wsh_delivery_assignments_v wda,

386:
387: cursor l_del_contents_csr (p_del_id IN NUMBER,
388: p_cnt_flag IN VARCHAR2) is
389: select 'N'
390: from wsh_delivery_assignments_v wda,
391: wsh_delivery_details wdd,
392: mtl_system_items msi
393: where wda.delivery_detail_id = wdd.delivery_detail_id
394: and wdd.inventory_item_id = msi.inventory_item_id

Line 667: wsh_delivery_assignments_v wda

663:
664: Cursor c_num_of_staged_lines(p_delivery_id NUMBER) IS
665: SELECT count(wdd.delivery_detail_id)
666: FROM wsh_delivery_details wdd,
667: wsh_delivery_assignments_v wda
668: WHERE wdd.delivery_detail_id = wda.delivery_detail_id AND
669: wda.delivery_id = p_delivery_id AND
670: wda.delivery_id is not NULL AND
671: wdd.container_flag = 'N' AND

Line 679: wsh_delivery_assignments_v wda

675:
676: Cursor c_get_line_status_in_delivery(p_delivery_id NUMBER) IS
677: SELECT wdd.released_status
678: FROM wsh_delivery_details wdd,
679: wsh_delivery_assignments_v wda
680: WHERE wdd.delivery_detail_id = wda.delivery_detail_id AND
681: wda.delivery_id = p_delivery_id AND
682: wda.delivery_id is not NULL AND
683: wdd.container_flag = 'N' AND

Line 2565: FROM wsh_delivery_assignments_v wda

2561:
2562: -- Bug 1729723 : Updating number_of_lpn for delivery
2563: CURSOR number_of_lpn(l_delivery_id NUMBER) IS
2564: SELECT count(distinct wda.delivery_detail_id)
2565: FROM wsh_delivery_assignments_v wda
2566: WHERE wda.parent_delivery_detail_id is null
2567: AND LEVEL > 1
2568: CONNECT BY PRIOR wda.parent_delivery_detail_id = wda.delivery_detail_id
2569: START WITH wda.delivery_id = l_delivery_id;

Line 2638: wsh_delivery_assignments_v da

2634: dd.locator_id,
2635: dd.source_code, /*Bug 2096052 for OKE */
2636: dd.source_line_id -- Consolidation of BO Delivery Details project
2637: FROM wsh_delivery_details dd,
2638: wsh_delivery_assignments_v da
2639: WHERE da.delivery_id = v_delivery_id AND
2640: da.delivery_id IS NOT NULL AND
2641: da.delivery_detail_id = dd.delivery_detail_id AND
2642: dd.container_flag = 'N';

Line 2657: FROM wsh_delivery_assignments_v

2653: AND wts.trip_id=wt.trip_id;
2654:
2655: CURSOR Get_Containers (v_delivery_detail_id NUMBER) IS
2656: SELECT delivery_detail_id
2657: FROM wsh_delivery_assignments_v
2658: WHERE delivery_detail_id <> v_delivery_detail_id
2659: START WITH delivery_detail_id = v_delivery_detail_id
2660: CONNECT BY PRIOR parent_delivery_detail_id = delivery_detail_id;
2661:

Line 2664: FROM wsh_delivery_assignments_v da,

2660: CONNECT BY PRIOR parent_delivery_detail_id = delivery_detail_id;
2661:
2662: CURSOR get_empty_containers(v_delivery_id NUMBER) IS
2663: SELECT da.delivery_detail_id
2664: FROM wsh_delivery_assignments_v da,
2665: WSH_DELIVERY_DETAILS dd
2666: WHERE da.delivery_id = v_delivery_id
2667: AND da.delivery_detail_id = dd.delivery_detail_id
2668: AND dd.container_flag = 'Y'

Line 2671: FROM wsh_delivery_assignments_v da2

2667: AND da.delivery_detail_id = dd.delivery_detail_id
2668: AND dd.container_flag = 'Y'
2669: AND NOT EXISTS(
2670: SELECT delivery_detail_id
2671: FROM wsh_delivery_assignments_v da2
2672: WHERE da2.parent_delivery_detail_id = da.delivery_detail_id) ;
2673:
2674: -- Bug 2713285, added batch_id
2675: CURSOR get_delivery_name(v_delivery_id NUMBER) IS

Line 7482: from wsh_delivery_assignments_v wda,

7478: cursor l_get_cnt_attr_csr(p_delivery_id IN NUMBER) is
7479: select wdd.organization_id organization_id,
7480: nvl(wdd.line_direction,'O') line_direction,
7481: wdd.delivery_detail_id delivery_detail_id
7482: from wsh_delivery_assignments_v wda,
7483: wsh_delivery_details wdd
7484: where wda.delivery_detail_id = wdd.delivery_detail_id
7485: and wdd.container_flag IN ('Y','C')
7486: and nvl(wdd.line_direction,'O') IN ('O', 'IO')

Line 7660: FROM wsh_delivery_assignments_v

7656: last_updated_by = l_user_id,
7657: last_update_login = l_login_id
7658: WHERE delivery_detail_id IN (
7659: SELECT delivery_Detail_id
7660: FROM wsh_delivery_assignments_v
7661: WHERE delivery_id = p_in_rec.delivery_id
7662: )
7663: AND released_status <> 'D'
7664: RETURNING delivery_detail_id,client_id BULK COLLECT INTO l_detail_tab,l_client_id_tab; -- Added for DBI Project, LSP PROJECT :Added l_client_id_tab

Line 9192: 'wsh_delivery_assignments_v da '||

9188: -- Bug 1421549: Changed the logic for load sequencing
9189: cont_str VARCHAR2(1000) :=
9190: 'SELECT dd.delivery_detail_id '||
9191: 'FROM wsh_delivery_details dd, '||
9192: 'wsh_delivery_assignments_v da '||
9193: 'WHERE dd.delivery_detail_id = da.delivery_detail_id AND '||
9194: 'da.parent_delivery_detail_id = :cont_id AND '||
9195: 'container_flag = ''N'' '||
9196: 'ORDER BY customer_prod_seq ';

Line 9208: 'wsh_delivery_assignments_v da '||

9204: 'SELECT da.parent_delivery_detail_id, '||
9205: 'avg(customer_prod_seq) avg_prod_seq, '||
9206: 'count(*) '||
9207: 'FROM wsh_delivery_details dd, '||
9208: 'wsh_delivery_assignments_v da '||
9209: 'WHERE dd.delivery_detail_id = da.delivery_detail_id AND '||
9210: 'dd.customer_prod_seq IS NOT NULL AND '||
9211: 'dd.container_flag = ''N'' AND '||
9212: 'da.parent_delivery_detail_id IS NOT NULL AND '||

Line 9609: wsh_delivery_assignments_v wda

9605: CURSOR line_csr (p_delivery_id IN NUMBER)
9606: IS
9607: SELECT distinct freight_terms_code
9608: FROM wsh_delivery_details wdd,
9609: wsh_delivery_assignments_v wda
9610: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
9611: AND wda.delivery_id = p_delivery_id
9612: AND NVL(wdd.container_flag,'N') = 'N';
9613: --

Line 10122: FROM wsh_delivery_assignments_v

10118: last_updated_by = FND_GLOBAL.USER_ID,
10119: last_update_login = FND_GLOBAL.LOGIN_ID
10120: WHERE delivery_detail_id IN (
10121: SELECT delivery_detail_id
10122: FROM wsh_delivery_assignments_v
10123: WHERE delivery_id = p_delivery_id
10124: );
10125: --
10126: --

Line 10261: FROM wsh_delivery_assignments_v

10257: last_updated_by = FND_GLOBAL.USER_ID,
10258: last_update_login = FND_GLOBAL.LOGIN_ID
10259: WHERE delivery_detail_id IN (
10260: SELECT delivery_detail_id
10261: FROM wsh_delivery_assignments_v
10262: WHERE delivery_id = pickup_dlvy_rec.delivery_id
10263: );
10264: --
10265: --