APPS.FLM_KANBAN_TRANSFER dependencies on WSH_DELIVERY_DETAILS

Line 198: FROM wsh_delivery_details wdd,

194: CURSOR c_delivery_dtl_ids(p_header_id IN NUMBER,
195: p_line_id IN NUMBER)
196: IS
197: SELECT wdd.delivery_detail_id
198: FROM wsh_delivery_details wdd,
199: wsh_delivery_assignments wda
200: WHERE wdd.source_header_id = p_header_id
201: AND wdd.source_line_id = p_line_id
202: AND wda.delivery_detail_id = wdd.delivery_detail_id

Line 216: FROM wsh_delivery_details wdd,

212: wdd.original_subinventory,
213: wda.delivery_id,
214: wnd.name delivery_name,
215: wnd.ship_method_code
216: FROM wsh_delivery_details wdd,
217: wsh_delivery_assignments wda,
218: wsh_new_deliveries wnd
219: WHERE wdd.source_header_id = p_header_id
220: AND wdd.source_line_id = p_line_id

Line 232: wsh_delivery_details wdd

228: mtrh.move_order_type,
229: mtrl.line_id
230: FROM mtl_txn_request_headers mtrh,
231: mtl_txn_request_lines mtrl,
232: wsh_delivery_details wdd
233: WHERE mtrh.header_id = mtrl.header_id
234: AND mtrl.line_id = wdd.move_order_line_id
235: AND wdd.delivery_detail_id = p_delivery_detail_id;
236:

Line 282: -- Calculating the ln_ship_tolerance_above value to be updated in OE_ORDER_LINES_ALL and WSH_DELIVERY_DETAILS Table

278:
279: IF l_tolerance_param = 1 AND p_transfer_qty > p_kanban_size THEN
280:
281: -- ********************************************************************************************************************
282: -- Calculating the ln_ship_tolerance_above value to be updated in OE_ORDER_LINES_ALL and WSH_DELIVERY_DETAILS Table
283: -- ********************************************************************************************************************
284:
285: l_ship_tolerance_above := (((p_transfer_qty - p_kanban_size) * 100) / p_kanban_size) + 1;
286:

Line 296: UPDATE wsh_delivery_details wdd1

292: SET ship_tolerance_above = ROUND(l_ship_tolerance_above)
293: WHERE header_id = p_header_id
294: AND line_id=p_line_id;
295:
296: UPDATE wsh_delivery_details wdd1
297: SET wdd1.ship_tolerance_above = ROUND(l_ship_tolerance_above)
298: WHERE wdd1.delivery_detail_id IN
299: (SELECT delivery_detail_id
300: FROM wsh_delivery_details wdd2,

Line 300: FROM wsh_delivery_details wdd2,

296: UPDATE wsh_delivery_details wdd1
297: SET wdd1.ship_tolerance_above = ROUND(l_ship_tolerance_above)
298: WHERE wdd1.delivery_detail_id IN
299: (SELECT delivery_detail_id
300: FROM wsh_delivery_details wdd2,
301: oe_order_lines_all oel
302: WHERE wdd2.source_header_id = oel.header_id
303: AND wdd2.source_line_id = oel.line_id
304: AND oel.source_document_id = p_inter_order_id

Line 321: 'Calling WSH_DELIVERY_DETAILS_PUB.autocreate_deliveries');

317:
318: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
319: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
320: l_log_module || '.autocreate_deliveries',
321: 'Calling WSH_DELIVERY_DETAILS_PUB.autocreate_deliveries');
322: END IF;
323:
324: --**************************************************************************************************************
325: -- The Autocreate_Deliveries procedure is called to automatically create deliveries for multiple delivery lines.

Line 327: WSH_DELIVERY_DETAILS_PUB.autocreate_deliveries

323:
324: --**************************************************************************************************************
325: -- The Autocreate_Deliveries procedure is called to automatically create deliveries for multiple delivery lines.
326: --**************************************************************************************************************
327: WSH_DELIVERY_DETAILS_PUB.autocreate_deliveries
328: ( p_api_version_number => 1.0,
329: p_init_msg_list => FND_API.G_FALSE,
330: p_commit => FND_API.G_FALSE,
331: x_return_status => x_retcode,

Line 342: 'After WSH_DELIVERY_DETAILS_PUB.autocreate_deliveries: ' ||

338:
339: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
340: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
341: l_log_module || '.autocreate_deliveries',
342: 'After WSH_DELIVERY_DETAILS_PUB.autocreate_deliveries: ' ||
343: 'x_return_status = ' || x_retcode || ', ' ||
344: 'x_msg_count = ' || l_msg_count || ', ' ||
345: 'x_msg_data = ' || x_errmsg);
346:

Line 1128: wsh_delivery_details wdd,

1124: oel.line_id line_id,
1125: oel.header_id header_id
1126: FROM oe_order_headers_all oeh,
1127: oe_order_lines_all oel ,
1128: wsh_delivery_details wdd,
1129: mtl_kanban_cards mkc,
1130: mtl_kanban_card_activity mkca
1131: WHERE oeh.source_document_id = mkca.document_header_id
1132: AND oeh.header_id = oel.header_id