APPS.WSH_MAPPING_DATA dependencies on WSH_NEW_DELIVERIES

Line 73: FROM wsh_new_deliveries

69: SELECT name,
70: customer_id,
71: organization_id,
72: ultimate_dropoff_location_id --bug 3920178
73: FROM wsh_new_deliveries
74: WHERE delivery_id = p_delivery_id;
75:
76: CURSOR l_get_dates_cur
77: IS

Line 434: FROM wsh_new_deliveries

430: ultimate_dropoff_location_id,
431: intmed_ship_to_location_id,
432: pooled_ship_to_location_id,
433: currency_code
434: FROM wsh_new_deliveries
435: WHERE delivery_id = p_delivery_id;
436:
437: /* Patchset I: Locations Project. Select address components from
438: wsh_ship_from_org_locations_v */

Line 1350: FROM wsh_new_deliveries

1346: SELECT name,
1347: customer_id,
1348: organization_id,
1349: ultimate_dropoff_location_id
1350: FROM wsh_new_deliveries
1351: WHERE delivery_id = p_delivery_id;
1352:
1353: CURSOR l_get_dates_cur
1354: IS

Line 1599: FROM wsh_new_deliveries wnd,

1595: WHERE delivery_id = p_delivery_id;
1596:
1597: SELECT wdi.sequence_number
1598: INTO x_bill_of_lading_num
1599: FROM wsh_new_deliveries wnd,
1600: wsh_delivery_legs wdl,
1601: wsh_trip_stops wts,
1602: wsh_document_instances wdi
1603: WHERE wnd.delivery_id = p_delivery_id

Line 2392: FROM wsh_new_deliveries

2388: SELECT organization_id,
2389: initial_pickup_location_id,
2390: intmed_ship_to_location_id,
2391: pooled_ship_to_location_id
2392: FROM wsh_new_deliveries
2393: WHERE delivery_id = p_delivery_id;
2394:
2395: CURSOR ship_from_info_cur(c_org_id NUMBER, c_loc_id NUMBER) IS
2396: SELECT

Line 2443: FROM wsh_new_deliveries wnd,

2439:
2440: CURSOR c_del_sites IS
2441: SELECT ol.ship_to_org_id,
2442: ol.invoice_to_org_id
2443: FROM wsh_new_deliveries wnd,
2444: wsh_delivery_assignments_v wda,
2445: wsh_delivery_details wdd,
2446: oe_order_lines_all ol
2447: WHERE wnd.delivery_id = p_delivery_id

Line 2601: from wsh_new_deliveries wnd,

2597:
2598: BEGIN
2599: select distinct ol.ship_to_contact_id
2600: into l_ship_to_contact_id
2601: from wsh_new_deliveries wnd,
2602: wsh_delivery_assignments_v wda,
2603: wsh_delivery_details wdd,
2604: oe_order_lines_all ol
2605: where wnd.delivery_id = p_delivery_id

Line 2661: from wsh_new_deliveries wnd,

2657:
2658: BEGIN
2659: select distinct ol.invoice_to_contact_id
2660: into l_bill_to_contact_id
2661: from wsh_new_deliveries wnd,
2662: wsh_delivery_assignments_v wda,
2663: wsh_delivery_details wdd,
2664: oe_order_lines_all ol
2665: where wnd.delivery_id = p_delivery_id