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_DELIVERY_VALIDATIONS dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 42: wsh_delivery_assignments_v da

38:
39: CURSOR check_ship_set IS
40: SELECT dd.delivery_detail_id
41: FROM wsh_delivery_details dd,
42: wsh_delivery_assignments_v da
43: WHERE ((NVL(da.delivery_id, -1) <> p_delivery_id) OR
44: (da.delivery_id = p_delivery_id AND dd.requested_quantity > dd.shipped_quantity
45: AND da.delivery_id IS NOT NULL AND dd.shipped_quantity <> 0)) AND
46: da.delivery_detail_id = dd.delivery_detail_id AND

Line 53: wsh_delivery_assignments_v da

49: dd.source_code = 'OE' AND
50: (dd.ship_set_id, dd.source_header_id) IN
51: (SELECT DISTINCT dd.ship_set_id, dd.source_header_id
52: FROM wsh_delivery_details dd,
53: wsh_delivery_assignments_v da
54: WHERE da.delivery_id = p_delivery_id AND
55: da.delivery_id IS NOT NULL AND
56: da.delivery_detail_id = dd.delivery_detail_id AND
57: dd.container_flag <> 'Y' AND

Line 63: wsh_delivery_assignments_v da

59: dd.ship_set_id IS NOT NULL );
60: CURSOR check_all_lines_imported IS
61: SELECT DISTINCT dd.source_code, dd.ship_set_id, dd.source_header_id
62: FROM wsh_delivery_details dd,
63: wsh_delivery_assignments_v da
64: WHERE da.delivery_id = p_delivery_id AND
65: da.delivery_id IS NOT NULL AND
66: da.delivery_detail_id = dd.delivery_detail_id AND
67: dd.container_flag <> 'Y' AND

Line 177: FROM WSH_DELIVERY_DETAILS WDD, OE_ORDER_LINES_ALL OEL, wsh_delivery_assignments_v WDA

173: -- Bug 2284000
174: CURSOR check_smc(top_model_line NUMBER) IS
175: SELECT MAX(OEL.ORDERED_QUANTITY) child_ord_qty, SUM(NVL(WDD.SHIPPED_QUANTITY,0)) child_shp_qty,
176: OEL.LINE_ID
177: FROM WSH_DELIVERY_DETAILS WDD, OE_ORDER_LINES_ALL OEL, wsh_delivery_assignments_v WDA
178: WHERE OEL.LINE_ID = WDD.SOURCE_LINE_ID
179: AND WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
180: AND WDD.SHIP_MODEL_COMPLETE_FLAG = 'Y'
181: AND WDD.SOURCE_CODE = 'OE'

Line 191: FROM wsh_delivery_details dd, wsh_delivery_assignments_v da, oe_order_lines_all oe

187: check_smc_rec check_smc%rowtype;
188:
189: cursor get_top_model IS
190: SELECT DISTINCT dd.top_model_line_id, dd.source_header_id , oe.ordered_quantity
191: FROM wsh_delivery_details dd, wsh_delivery_assignments_v da, oe_order_lines_all oe
192: WHERE da.delivery_id = p_delivery_id
193: AND da.delivery_id IS NOT NULL
194: AND dd.ship_model_complete_flag = 'Y'
195: AND da.delivery_detail_id = dd.delivery_detail_id

Line 212: FROM wsh_delivery_details dd, wsh_delivery_assignments_v da

208: ( ato_line_id IS NOT NULL AND item_type_code = 'CONFIG' )
209: )
210: MINUS
211: SELECT source_line_id
212: FROM wsh_delivery_details dd, wsh_delivery_assignments_v da
213: WHERE dd.source_header_id = header_id
214: AND dd.source_code = 'OE'
215: AND dd.container_flag <> 'Y'
216: AND da.delivery_id IS NOT NULL

Line 397: wsh_delivery_assignments_v da

393: SELECT 1 from dual
394: WHERE exists (
395: SELECT 1
396: FROM wsh_delivery_details dd,
397: wsh_delivery_assignments_v da
398: WHERE ((NVL(da.delivery_id, -1) <> p_delivery_id) OR
399: (da.delivery_id = p_delivery_id AND dd.requested_quantity > dd.shipped_quantity
400: AND da.delivery_id IS NOT NULL AND dd.shipped_quantity <> 0))
401: AND da.delivery_detail_id = dd.delivery_detail_id

Line 407: wsh_delivery_assignments_v da

403: AND dd.source_code = 'OE'
404: AND (dd.arrival_set_id, dd.source_header_id) IN
405: (SELECT DISTINCT dd.arrival_set_id, dd.source_header_id
406: FROM wsh_delivery_details dd,
407: wsh_delivery_assignments_v da
408: WHERE da.delivery_id = p_delivery_id
409: AND da.delivery_id IS NOT NULL
410: AND da.delivery_detail_id = dd.delivery_detail_id
411: AND dd.container_flag <> 'Y'

Line 1212: FROM wsh_delivery_assignments_v da,

1208:
1209:
1210: CURSOR delivery_details IS
1211: SELECT da.delivery_detail_id
1212: FROM wsh_delivery_assignments_v da,
1213: wsh_delivery_details dd
1214: WHERE dd.delivery_detail_id = da.delivery_detail_id AND
1215: da.delivery_id = p_delivery_id AND
1216: da.delivery_id IS NOT NULL AND

Line 2592: FROM wsh_delivery_assignments_v da,

2588: WHERE delivery_id = p_delivery_id;
2589:
2590: CURSOR detail_info IS
2591: SELECT da.parent_delivery_detail_id
2592: FROM wsh_delivery_assignments_v da,
2593: wsh_delivery_details dd
2594: WHERE dd.delivery_detail_id = da.delivery_detail_id AND
2595: da.delivery_id = p_delivery_id AND
2596: da.delivery_id IS NOT NULL AND

Line 2877: wsh_delivery_details wdd2, wsh_delivery_assignments wda

2873:
2874: -- 11728970: Cursor to Get the LPN -id
2875: CURSOR C_GET_LPN_ID ( p_detail_id NUMBER) IS
2876: SELECT wdd1.lpn_id from wsh_delivery_details wdd1,
2877: wsh_delivery_details wdd2, wsh_delivery_assignments wda
2878: WHERE wdd2.delivery_detail_id = p_detail_id
2879: AND wdd2.delivery_detail_id = wda.delivery_detail_id
2880: AND wda.parent_delivery_detail_id IS NOT NULL
2881: AND wda.parent_delivery_detail_id = wdd1.delivery_detail_id

Line 3927: FROM wsh_delivery_assignments_v

3923: di.status IN ('OPEN','PLANNED');
3924:
3925: CURSOR have_details(l_delivery_id NUMBER) IS
3926: SELECT delivery_detail_id
3927: FROM wsh_delivery_assignments_v
3928: WHERE delivery_id = l_delivery_id
3929: AND rownum = 1;
3930:
3931: CURSOR have_legs(l_delivery_id NUMBER) IS

Line 4278: FROM wsh_delivery_assignments_v

4274: --
4275: --
4276: CURSOR have_details (p_delivery_id NUMBER) IS
4277: SELECT 1
4278: FROM wsh_delivery_assignments_v
4279: WHERE delivery_id = p_delivery_id
4280: AND rownum = 1;
4281: --
4282: --

Line 4675: FROM wsh_delivery_assignments_v

4671: WHERE delivery_id = p_delivery_id;
4672:
4673: CURSOR detail_info IS
4674: SELECT delivery_detail_id
4675: FROM wsh_delivery_assignments_v
4676: WHERE delivery_id = p_delivery_id
4677: FOR UPDATE NOWAIT;
4678:
4679: CURSOR leg_info IS

Line 4967: FROM wsh_delivery_assignments_v da,

4963: WHERE delivery_id = p_delivery_id;
4964:
4965: CURSOR detail_info IS
4966: SELECT count(*)
4967: FROM wsh_delivery_assignments_v da,
4968: wsh_delivery_details dd
4969: WHERE da.delivery_id = p_delivery_id AND
4970: da.delivery_id IS NOT NULL AND
4971: da.delivery_detail_id = dd.delivery_detail_id AND

Line 5125: FROM wsh_delivery_assignments_v

5121:
5122: CURSOR has_delivery_lines
5123: IS
5124: SELECT delivery_detail_id
5125: FROM wsh_delivery_assignments_v
5126: WHERE delivery_id = p_delivery_id
5127: AND ROWNUM=1;
5128:
5129: CURSOR has_delivery_legs

Line 5852: from wsh_delivery_assignments_v da,

5848: dd.ship_tolerance_above, -- Bug 2181132
5849: dd.ship_tolerance_below, -- Bug 2181132
5850: dd.requested_quantity_uom, -- Bug 2181132
5851: dd.requested_quantity_uom2 -- Bug 2181132
5852: from wsh_delivery_assignments_v da,
5853: wsh_Delivery_details dd
5854: where dd.delivery_detail_id = da.delivery_detail_id
5855: and da.delivery_id = v_delivery_id
5856: and dd.container_flag = 'N'

Line 5929: wsh_delivery_assignments_v wda

5925: wdd.src_requested_quantity_uom2 ,
5926: wdd.requested_quantity_uom2 ,
5927: wdd.inventory_item_id
5928: from wsh_delivery_details wdd,
5929: wsh_delivery_assignments_v wda
5930: where wdd.source_line_id = v_source_line_id
5931: and wdd.released_status <> ('D')
5932: and wdd.source_code = v_source_code
5933: and wdd.delivery_detail_id = wda.delivery_detail_id

Line 6403: wsh_delivery_assignments_v wda

6399:
6400: cursor del_to_det_cur( p_delivery_id IN NUMBER ) is
6401: select distinct 'X'
6402: from wsh_delivery_details wdd,
6403: wsh_delivery_assignments_v wda
6404: where wda.delivery_id = p_delivery_id
6405: and wdd.delivery_detail_id = wda.delivery_detail_id
6406: and wdd.source_code = 'WSH'
6407: and wdd.container_flag = 'N';

Line 6428: wsh_delivery_assignments_v wda

6424:
6425: cursor det_stat_cur( p_delivery_id IN NUMBER) is
6426: select distinct 'X'
6427: from wsh_delivery_details wdd,
6428: wsh_delivery_assignments_v wda
6429: where wdd.source_code = 'WSH'
6430: and wdd.container_flag = 'N'
6431: and wdd.delivery_detail_id = wda.delivery_detail_id
6432: and wda.delivery_id = p_delivery_id;

Line 6482: wsh_delivery_assignments_v wda

6478: --RTV changes
6479: cursor del_to_det_sc_cur( p_delivery_id IN NUMBER ) is
6480: select 'X'
6481: from wsh_delivery_details wdd,
6482: wsh_delivery_assignments_v wda
6483: where wda.delivery_id = p_delivery_id
6484: and wdd.delivery_detail_id = wda.delivery_detail_id
6485: and wdd.source_code NOT IN ('OE','WSH','OKE')
6486: and wdd.container_flag = 'N';

Line 10748: from wsh_delivery_assignments_v wda

10744: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'DERIVE_NUMBER_OF_LPN';
10745: --
10746: cursor lpn_cur is
10747: select count (distinct wda.delivery_detail_id)
10748: from wsh_delivery_assignments_v wda
10749: where wda.parent_delivery_detail_id is null
10750: and wda.delivery_id is NOT NULL
10751: and level > 1
10752: connect by prior wda.parent_delivery_detail_id = wda.delivery_detail_id

Line 11325: wsh_delivery_assignments_v wda

11321: CURSOR line_csr (p_delivery_id IN NUMBER)
11322: IS
11323: SELECT 'Y'
11324: FROM wsh_delivery_details wdd,
11325: wsh_delivery_assignments_v wda
11326: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
11327: AND wda.delivery_id = p_delivery_id
11328: AND NVL(wdd.container_flag,'N') = 'N'
11329: AND rownum = 1;

Line 11669: wsh_delivery_assignments_v wda

11665: CURSOR line_csr(p_delivery_id NUMBER)
11666: IS
11667: SELECT 'Y'
11668: FROM wsh_delivery_details wdd,
11669: wsh_delivery_assignments_v wda
11670: WHERE wda.delivery_id = p_delivery_id
11671: AND wdd.delivery_detail_id = wda.delivery_detail_id
11672: AND NVL(wdd.container_flag,'N') = 'N'
11673: AND routing_req_id IS NOT NULL

Line 12878: wsh_delivery_assignments_v wda

12874:
12875: cursor c_detail (p_delivery_id NUMBER) is
12876: select 1
12877: from wsh_delivery_details wdd,
12878: wsh_delivery_assignments_v wda
12879: where wdd.delivery_detail_id = wda.delivery_detail_id
12880: and wdd.released_status in ('R','B','X')
12881: and nvl(wdd.replenishment_status,'C') = 'C' --bug# 6719369 (replenishment project)
12882: and wdd.source_code = 'OE'