APPS.WMS_TASK_MGMT_PUB dependencies on WSH_DELIVERY_DETAILS

Line 248: FROM wsh_delivery_details wdd,

244: CURSOR carton_lpn_del_det (c_lpn_id NUMBER)
245: IS
246: SELECT wdd.delivery_detail_id,
247: wdd.move_order_line_id
248: FROM wsh_delivery_details wdd,
249: mtl_material_transactions_temp mmtt
250: WHERE wdd.move_order_line_id=mmtt.move_order_line_id
251: AND wdd.organization_id =mmtt.organization_id
252: AND (mmtt.transfer_lpn_id =c_lpn_id

Line 260: FROM wsh_delivery_details wdd,

256: /* CURSOR carton_lpn_del_det1 (c_lpn_id NUMBER)
257: IS
258: SELECT wdd.delivery_detail_id,
259: wdd.move_order_line_id
260: FROM wsh_delivery_details wdd,
261: mtl_material_transactions_temp mmtt
262: WHERE wdd.move_order_line_id=mmtt.move_order_line_id
263: AND wdd.organization_id =mmtt.organization_id
264: AND mmtt.cartonization_id = c_lpn_id

Line 401: FROM wsh_delivery_details wdd,

397: SELECT wdd.delivery_detail_id,
398: wdd.move_order_line_id
399: INTO l_temp_del_detail_id,
400: l_move_order_line_id
401: FROM wsh_delivery_details wdd,
402: mtl_material_transactions_temp mmtt
403: WHERE wdd.move_order_line_id = mmtt.move_order_line_id
404: AND mmtt.transaction_temp_id = p_task_table(i).transaction_number;
405: EXCEPTION

Line 455: WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping( p_line_rows => l_del_det_id_tab,

451: IF (l_del_id_tab_new.COUNT = 0) THEN
452: --all the delivery_id's are null,
453: --Call delivery_grouping API.
454:
455: WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping( p_line_rows => l_del_det_id_tab,
456: x_grouping_rows => l_grouping_rows,
457: x_return_status => l_return_status);
458:
459: IF l_return_status = 'S' then

Line 501: wsh_delivery_details_grp.detail_to_delivery(

497: IF (l_del_det_id_no_del_tab.COUNT > 0 ) THEN
498:
499: l_delivery_id := l_del_id_tab_new(1);
500:
501: wsh_delivery_details_grp.detail_to_delivery(
502: p_api_version => 1.0,
503: p_init_msg_list => FND_API.G_FALSE,
504: p_commit => FND_API.G_FALSE,
505: p_validation_level => l_validation_level,

Line 1221: FROM wsh_delivery_details wdd,

1217: CURSOR carton_lpn_del_det (c_lpn_id NUMBER)
1218: IS
1219: SELECT wdd.delivery_detail_id,
1220: wdd.move_order_line_id
1221: FROM wsh_delivery_details wdd,
1222: mtl_material_transactions_temp mmtt
1223: WHERE wdd.move_order_line_id=mmtt.move_order_line_id
1224: AND wdd.organization_id =mmtt.organization_id
1225: AND mmtt.transfer_lpn_id =c_lpn_id

Line 1231: FROM wsh_delivery_details wdd,

1227: CURSOR carton_lpn_del_det1 (c_lpn_id NUMBER)
1228: IS
1229: SELECT wdd.delivery_detail_id,
1230: wdd.move_order_line_id
1231: FROM wsh_delivery_details wdd,
1232: mtl_material_transactions_temp mmtt
1233: WHERE wdd.move_order_line_id=mmtt.move_order_line_id
1234: AND wdd.organization_id =mmtt.organization_id
1235: AND mmtt.cartonization_id = c_lpn_id

Line 1341: FROM wsh_delivery_details wdd,

1337: SELECT wdd.delivery_detail_id,
1338: wdd.move_order_line_id
1339: INTO l_temp_del_detail_id,
1340: l_move_order_line_id
1341: FROM wsh_delivery_details wdd,
1342: mtl_material_transactions_temp mmtt
1343: WHERE wdd.move_order_line_id = mmtt.move_order_line_id
1344: AND mmtt.transaction_temp_id = p_task_table(i).transaction_number;
1345: EXCEPTION