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

2530:
2531: -- Bug 1729723 : Updating number_of_lpn for delivery
2532: CURSOR number_of_lpn(l_delivery_id NUMBER) IS
2533: SELECT count(distinct wda.delivery_detail_id)
2534: FROM wsh_delivery_assignments_v wda
2535: WHERE wda.parent_delivery_detail_id is null
2536: AND LEVEL > 1
2537: CONNECT BY PRIOR wda.parent_delivery_detail_id = wda.delivery_detail_id
2538: START WITH wda.delivery_id = l_delivery_id;

Line 2605: wsh_delivery_assignments_v da

2601: dd.locator_id,
2602: dd.source_code, /*Bug 2096052 for OKE */
2603: dd.source_line_id -- Consolidation of BO Delivery Details project
2604: FROM wsh_delivery_details dd,
2605: wsh_delivery_assignments_v da
2606: WHERE da.delivery_id = v_delivery_id AND
2607: da.delivery_id IS NOT NULL AND
2608: da.delivery_detail_id = dd.delivery_detail_id AND
2609: dd.container_flag = 'N';

Line 2624: FROM wsh_delivery_assignments_v

2620: AND wts.trip_id=wt.trip_id;
2621:
2622: CURSOR Get_Containers (v_delivery_detail_id NUMBER) IS
2623: SELECT delivery_detail_id
2624: FROM wsh_delivery_assignments_v
2625: WHERE delivery_detail_id <> v_delivery_detail_id
2626: START WITH delivery_detail_id = v_delivery_detail_id
2627: CONNECT BY PRIOR parent_delivery_detail_id = delivery_detail_id;
2628:

Line 2631: FROM wsh_delivery_assignments_v da,

2627: CONNECT BY PRIOR parent_delivery_detail_id = delivery_detail_id;
2628:
2629: CURSOR get_empty_containers(v_delivery_id NUMBER) IS
2630: SELECT da.delivery_detail_id
2631: FROM wsh_delivery_assignments_v da,
2632: WSH_DELIVERY_DETAILS dd
2633: WHERE da.delivery_id = v_delivery_id
2634: AND da.delivery_detail_id = dd.delivery_detail_id
2635: AND dd.container_flag = 'Y'

Line 2638: FROM wsh_delivery_assignments_v da2

2634: AND da.delivery_detail_id = dd.delivery_detail_id
2635: AND dd.container_flag = 'Y'
2636: AND NOT EXISTS(
2637: SELECT delivery_detail_id
2638: FROM wsh_delivery_assignments_v da2
2639: WHERE da2.parent_delivery_detail_id = da.delivery_detail_id) ;
2640:
2641: -- Bug 2713285, added batch_id
2642: CURSOR get_delivery_name(v_delivery_id NUMBER) IS

Line 7342: from wsh_delivery_assignments_v wda,

7338: cursor l_get_cnt_attr_csr(p_delivery_id IN NUMBER) is
7339: select wdd.organization_id organization_id,
7340: nvl(wdd.line_direction,'O') line_direction,
7341: wdd.delivery_detail_id delivery_detail_id
7342: from wsh_delivery_assignments_v wda,
7343: wsh_delivery_details wdd
7344: where wda.delivery_detail_id = wdd.delivery_detail_id
7345: and wdd.container_flag IN ('Y','C')
7346: and nvl(wdd.line_direction,'O') IN ('O', 'IO')

Line 7510: FROM wsh_delivery_assignments_v

7506: last_updated_by = l_user_id,
7507: last_update_login = l_login_id
7508: WHERE delivery_detail_id IN (
7509: SELECT delivery_Detail_id
7510: FROM wsh_delivery_assignments_v
7511: WHERE delivery_id = p_in_rec.delivery_id
7512: )
7513: AND released_status <> 'D'
7514: RETURNING delivery_detail_id BULK COLLECT INTO l_detail_tab; -- Added for DBI Project

Line 8996: 'wsh_delivery_assignments_v da '||

8992: -- Bug 1421549: Changed the logic for load sequencing
8993: cont_str VARCHAR2(1000) :=
8994: 'SELECT dd.delivery_detail_id '||
8995: 'FROM wsh_delivery_details dd, '||
8996: 'wsh_delivery_assignments_v da '||
8997: 'WHERE dd.delivery_detail_id = da.delivery_detail_id AND '||
8998: 'da.parent_delivery_detail_id = :cont_id AND '||
8999: 'container_flag = ''N'' '||
9000: 'ORDER BY customer_prod_seq ';

Line 9012: 'wsh_delivery_assignments_v da '||

9008: 'SELECT da.parent_delivery_detail_id, '||
9009: 'avg(customer_prod_seq) avg_prod_seq, '||
9010: 'count(*) '||
9011: 'FROM wsh_delivery_details dd, '||
9012: 'wsh_delivery_assignments_v da '||
9013: 'WHERE dd.delivery_detail_id = da.delivery_detail_id AND '||
9014: 'dd.customer_prod_seq IS NOT NULL AND '||
9015: 'dd.container_flag = ''N'' AND '||
9016: 'da.parent_delivery_detail_id IS NOT NULL AND '||

Line 9413: wsh_delivery_assignments_v wda

9409: CURSOR line_csr (p_delivery_id IN NUMBER)
9410: IS
9411: SELECT distinct freight_terms_code
9412: FROM wsh_delivery_details wdd,
9413: wsh_delivery_assignments_v wda
9414: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
9415: AND wda.delivery_id = p_delivery_id
9416: AND NVL(wdd.container_flag,'N') = 'N';
9417: --

Line 9926: FROM wsh_delivery_assignments_v

9922: last_updated_by = FND_GLOBAL.USER_ID,
9923: last_update_login = FND_GLOBAL.LOGIN_ID
9924: WHERE delivery_detail_id IN (
9925: SELECT delivery_detail_id
9926: FROM wsh_delivery_assignments_v
9927: WHERE delivery_id = p_delivery_id
9928: );
9929: --
9930: --

Line 10065: FROM wsh_delivery_assignments_v

10061: last_updated_by = FND_GLOBAL.USER_ID,
10062: last_update_login = FND_GLOBAL.LOGIN_ID
10063: WHERE delivery_detail_id IN (
10064: SELECT delivery_detail_id
10065: FROM wsh_delivery_assignments_v
10066: WHERE delivery_id = pickup_dlvy_rec.delivery_id
10067: );
10068: --
10069: --