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_V

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 392: wsh_delivery_assignments_v da

388: SELECT 1 from dual
389: WHERE exists (
390: SELECT 1
391: FROM wsh_delivery_details dd,
392: wsh_delivery_assignments_v da
393: WHERE ((NVL(da.delivery_id, -1) <> p_delivery_id) OR
394: (da.delivery_id = p_delivery_id AND dd.requested_quantity > dd.shipped_quantity
395: AND da.delivery_id IS NOT NULL AND dd.shipped_quantity <> 0))
396: AND da.delivery_detail_id = dd.delivery_detail_id

Line 402: wsh_delivery_assignments_v da

398: AND dd.source_code = 'OE'
399: AND (dd.arrival_set_id, dd.source_header_id) IN
400: (SELECT DISTINCT dd.arrival_set_id, dd.source_header_id
401: FROM wsh_delivery_details dd,
402: wsh_delivery_assignments_v da
403: WHERE da.delivery_id = p_delivery_id
404: AND da.delivery_id IS NOT NULL
405: AND da.delivery_detail_id = dd.delivery_detail_id
406: AND dd.container_flag <> 'Y'

Line 1187: FROM wsh_delivery_assignments_v da,

1183:
1184:
1185: CURSOR delivery_details IS
1186: SELECT da.delivery_detail_id
1187: FROM wsh_delivery_assignments_v da,
1188: wsh_delivery_details dd
1189: WHERE dd.delivery_detail_id = da.delivery_detail_id AND
1190: da.delivery_id = p_delivery_id AND
1191: da.delivery_id IS NOT NULL AND

Line 2552: FROM wsh_delivery_assignments_v da,

2548: WHERE delivery_id = p_delivery_id;
2549:
2550: CURSOR detail_info IS
2551: SELECT da.parent_delivery_detail_id
2552: FROM wsh_delivery_assignments_v da,
2553: wsh_delivery_details dd
2554: WHERE dd.delivery_detail_id = da.delivery_detail_id AND
2555: da.delivery_id = p_delivery_id AND
2556: da.delivery_id IS NOT NULL AND

Line 3837: FROM wsh_delivery_assignments_v

3833: di.status IN ('OPEN','PLANNED');
3834:
3835: CURSOR have_details(l_delivery_id NUMBER) IS
3836: SELECT delivery_detail_id
3837: FROM wsh_delivery_assignments_v
3838: WHERE delivery_id = l_delivery_id
3839: AND rownum = 1;
3840:
3841: CURSOR have_legs(l_delivery_id NUMBER) IS

Line 4188: FROM wsh_delivery_assignments_v

4184: --
4185: --
4186: CURSOR have_details (p_delivery_id NUMBER) IS
4187: SELECT 1
4188: FROM wsh_delivery_assignments_v
4189: WHERE delivery_id = p_delivery_id
4190: AND rownum = 1;
4191: --
4192: --

Line 4585: FROM wsh_delivery_assignments_v

4581: WHERE delivery_id = p_delivery_id;
4582:
4583: CURSOR detail_info IS
4584: SELECT delivery_detail_id
4585: FROM wsh_delivery_assignments_v
4586: WHERE delivery_id = p_delivery_id
4587: FOR UPDATE NOWAIT;
4588:
4589: CURSOR leg_info IS

Line 4877: FROM wsh_delivery_assignments_v da,

4873: WHERE delivery_id = p_delivery_id;
4874:
4875: CURSOR detail_info IS
4876: SELECT count(*)
4877: FROM wsh_delivery_assignments_v da,
4878: wsh_delivery_details dd
4879: WHERE da.delivery_id = p_delivery_id AND
4880: da.delivery_id IS NOT NULL AND
4881: da.delivery_detail_id = dd.delivery_detail_id AND

Line 5035: FROM wsh_delivery_assignments_v

5031:
5032: CURSOR has_delivery_lines
5033: IS
5034: SELECT delivery_detail_id
5035: FROM wsh_delivery_assignments_v
5036: WHERE delivery_id = p_delivery_id
5037: AND ROWNUM=1;
5038:
5039: CURSOR has_delivery_legs

Line 5749: from wsh_delivery_assignments_v da,

5745: dd.ship_tolerance_above, -- Bug 2181132
5746: dd.ship_tolerance_below, -- Bug 2181132
5747: dd.requested_quantity_uom, -- Bug 2181132
5748: dd.requested_quantity_uom2 -- Bug 2181132
5749: from wsh_delivery_assignments_v da,
5750: wsh_Delivery_details dd
5751: where dd.delivery_detail_id = da.delivery_detail_id
5752: and da.delivery_id = v_delivery_id
5753: and dd.container_flag = 'N'

Line 5826: wsh_delivery_assignments_v wda

5822: wdd.src_requested_quantity_uom2 ,
5823: wdd.requested_quantity_uom2 ,
5824: wdd.inventory_item_id
5825: from wsh_delivery_details wdd,
5826: wsh_delivery_assignments_v wda
5827: where wdd.source_line_id = v_source_line_id
5828: and wdd.released_status <> ('D')
5829: and wdd.source_code = v_source_code
5830: and wdd.delivery_detail_id = wda.delivery_detail_id

Line 6244: wsh_delivery_assignments_v wda

6240:
6241: cursor del_to_det_cur( p_delivery_id IN NUMBER ) is
6242: select distinct 'X'
6243: from wsh_delivery_details wdd,
6244: wsh_delivery_assignments_v wda
6245: where wda.delivery_id = p_delivery_id
6246: and wdd.delivery_detail_id = wda.delivery_detail_id
6247: and wdd.source_code = 'WSH'
6248: and wdd.container_flag = 'N';

Line 6269: wsh_delivery_assignments_v wda

6265:
6266: cursor det_stat_cur( p_delivery_id IN NUMBER) is
6267: select distinct 'X'
6268: from wsh_delivery_details wdd,
6269: wsh_delivery_assignments_v wda
6270: where wdd.source_code = 'WSH'
6271: and wdd.container_flag = 'N'
6272: and wdd.delivery_detail_id = wda.delivery_detail_id
6273: and wda.delivery_id = p_delivery_id;

Line 10476: from wsh_delivery_assignments_v wda

10472: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'DERIVE_NUMBER_OF_LPN';
10473: --
10474: cursor lpn_cur is
10475: select count (distinct wda.delivery_detail_id)
10476: from wsh_delivery_assignments_v wda
10477: where wda.parent_delivery_detail_id is null
10478: and wda.delivery_id is NOT NULL
10479: and level > 1
10480: connect by prior wda.parent_delivery_detail_id = wda.delivery_detail_id

Line 11053: wsh_delivery_assignments_v wda

11049: CURSOR line_csr (p_delivery_id IN NUMBER)
11050: IS
11051: SELECT 'Y'
11052: FROM wsh_delivery_details wdd,
11053: wsh_delivery_assignments_v wda
11054: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
11055: AND wda.delivery_id = p_delivery_id
11056: AND NVL(wdd.container_flag,'N') = 'N'
11057: AND rownum = 1;

Line 11397: wsh_delivery_assignments_v wda

11393: CURSOR line_csr(p_delivery_id NUMBER)
11394: IS
11395: SELECT 'Y'
11396: FROM wsh_delivery_details wdd,
11397: wsh_delivery_assignments_v wda
11398: WHERE wda.delivery_id = p_delivery_id
11399: AND wdd.delivery_detail_id = wda.delivery_detail_id
11400: AND NVL(wdd.container_flag,'N') = 'N'
11401: AND routing_req_id IS NOT NULL

Line 12599: wsh_delivery_assignments_v wda

12595:
12596: cursor c_detail (p_delivery_id NUMBER) is
12597: select 1
12598: from wsh_delivery_details wdd,
12599: wsh_delivery_assignments_v wda
12600: where wdd.delivery_detail_id = wda.delivery_detail_id
12601: and wdd.released_status in ('R','B','X')
12602: and nvl(wdd.replenishment_status,'C') = 'C' --bug# 6719369 (replenishment project)
12603: and wdd.source_code = 'OE'