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.WMS_SHIPPING_TRANSACTION_PUB dependencies on WSH_NEW_DELIVERIES_OB_GRP_V

Line 571: FROM wsh_new_deliveries_ob_grp_v wnd

567: , wnd.weight_uom_code
568: , wnd.waybill
569: , ' ' trip_name,
570: INV_SHIPPING_TRANSACTION_PUB.GET_SHIPMETHOD_MEANING(wnd.ship_method_code)
571: FROM wsh_new_deliveries_ob_grp_v wnd
572: WHERE wnd.delivery_id = p_delivery_id;
573: END get_delivery_info;
574:
575: PROCEDURE GET_STAGING_LANE(x_staging_lane_LOV OUT NOCOPY t_genref,

Line 770: FROM wsh_new_deliveries_ob_grp_v

766: BEGIN
767: IF (l_delivery_id is not null) then
768: SELECT name, status_code
769: INTO l_delivery_name, l_delivery_status_code
770: FROM wsh_new_deliveries_ob_grp_v
771: WHERE delivery_id = l_delivery_id;
772: ELSE
773: l_delivery_name := NULL;
774: l_delivery_status_code := NULL;

Line 928: from wsh_new_deliveries_ob_grp_v

924: if p_delivery_id is null then return ' ';
925: else
926: select name
927: into p_name
928: from wsh_new_deliveries_ob_grp_v
929: where delivery_id = p_delivery_id;
930: end if;
931: return p_name;
932: EXCEPTION

Line 973: , wsh_new_deliveries_ob_grp_v wnd

969: , wnd.delivery_id,wnd.name
970: , nvl(wdd.load_seq_number,0) as load_seq_num
971: from wms_license_plate_numbers lpn
972: , wms_license_plate_numbers wlpn
973: , wsh_new_deliveries_ob_grp_v wnd
974: , wsh_delivery_legs_ob_grp_v wdl
975: , wsh_delivery_details_ob_grp_v wdd
976: , wsh_delivery_assignments_v wda
977: , wsh_delivery_details_ob_grp_v wdd2

Line 1006: ,wsh_new_deliveries_ob_grp_v wndv

1002: from wsh_delivery_details_ob_grp_v wdd
1003: , wsh_delivery_assignments_v wda
1004: , wms_license_plate_numbers lpn
1005: ,wms_license_plate_numbers wlpn
1006: ,wsh_new_deliveries_ob_grp_v wndv
1007: where wdd.delivery_detail_id = wda.delivery_detail_id
1008: and wdd.lpn_id is not null
1009: and wdd.lpn_id = lpn.outermost_lpn_id
1010: and wdd.released_status = 'X' -- For LPN reuse ER : 6845650

Line 1053: ,wsh_new_deliveries_ob_grp_v wndv

1049: from wsh_delivery_details_ob_grp_v wdd
1050: , wsh_delivery_assignments_v wda
1051: , wms_license_plate_numbers lpn
1052: ,wms_license_plate_numbers wlpn
1053: ,wsh_new_deliveries_ob_grp_v wndv
1054: where wdd.delivery_detail_id = wda.delivery_detail_id
1055: and wdd.lpn_id is not null
1056: and wdd.lpn_id = lpn.lpn_id
1057: and wdd.released_status = 'X' -- For LPN reuse ER : 6845650

Line 1101: , wsh_new_deliveries_ob_grp_v wnd

1097: , wlpn.license_plate_number
1098: , wnd.delivery_id,wnd.name
1099: from wms_license_plate_numbers lpn
1100: , wms_license_plate_numbers wlpn
1101: , wsh_new_deliveries_ob_grp_v wnd
1102: , wsh_delivery_legs_ob_grp_v wdl
1103: , wsh_delivery_details_ob_grp_v wdd
1104: , wsh_delivery_assignments_v wda
1105: , wsh_delivery_details_ob_grp_v wdd2

Line 1138: ,wsh_new_deliveries_ob_grp_v wndv

1134: from wsh_delivery_details_ob_grp_v wdd
1135: , wsh_delivery_assignments_v wda
1136: , wms_license_plate_numbers lpn
1137: ,wms_license_plate_numbers wlpn
1138: ,wsh_new_deliveries_ob_grp_v wndv
1139: where wdd.delivery_detail_id = wda.delivery_detail_id
1140: and wdd.lpn_id is not null -- for performance, bug 2418639
1141: and wdd.lpn_id = lpn.outermost_lpn_id
1142: and wdd.released_status = 'X' -- For LPN reuse ER : 6845650

Line 1615: from wsh_new_deliveries_ob_grp_v

1611: fetch lpn_in_other_dock into x_loaded_dock_door;
1612: if lpn_in_other_dock%FOUND then
1613: select name
1614: into x_delivery_name
1615: from wsh_new_deliveries_ob_grp_v
1616: where delivery_id = l_delivery_id;
1617: x_result := 1;
1618: close lpn_in_other_dock;
1619: close deliveries_in_lpn;

Line 2143: FROM wsh_new_deliveries_ob_grp_v

2139: AND nvl(direct_ship_flag,'N')='N';
2140:
2141: CURSOR c_get_otm_flags IS
2142: SELECT ignore_for_planning, tms_interface_flag
2143: FROM wsh_new_deliveries_ob_grp_v
2144: WHERE delivery_id = l_delivery_id;
2145:
2146: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2147: l_debug number;

Line 2347: FROM wsh_new_deliveries_ob_grp_v wnd

2343: * on ship confirm page . We will use the one returned from
2344: * create_delvery API for the LastLPN*/
2345: SELECT wnd.delivery_type
2346: INTO l_delivery_type
2347: FROM wsh_new_deliveries_ob_grp_v wnd
2348: WHERE wnd.delivery_id = p_delivery_id;
2349:
2350: IF l_delivery_type = 'CONSOLIDATION' THEN
2351: NULL ; --we will pick up the first delivery of the outermost LPN

Line 2437: ,wsh_new_deliveries_ob_grp_v wnd

2433:
2434: cursor open_deliveries_cur is
2435: select DISTINCT WSTT.delivery_id
2436: from WMS_SHIPPING_TRANSACTION_TEMP wstt
2437: ,wsh_new_deliveries_ob_grp_v wnd
2438: where wstt.delivery_id = wnd.delivery_id
2439: AND wnd.status_code ='OP'
2440: AND WSTT.organization_id = p_organization_id
2441: and WSTT.dock_door_id = p_dock_door_id

Line 2495: from wsh_delivery_assignments_v wda, wsh_new_deliveries_ob_grp_v wnd

2491: -- Add the following code in case user created delivery manually from
2492: -- desktop
2493: select wda.delivery_id, wnd.name
2494: into l_delivery_id, l_delivery_name
2495: from wsh_delivery_assignments_v wda, wsh_new_deliveries_ob_grp_v wnd
2496: where wda.delivery_id = wnd.delivery_id
2497: and wda.delivery_detail_id = l_delivery_detail_id;
2498:
2499: update wms_shipping_transaction_temp

Line 2650: from wsh_delivery_assignments_v wda, wsh_new_deliveries_ob_grp_v wnd

2646:
2647: for l_del_count in 1..l_del_rows.COUNT LOOP
2648: select wda.delivery_id, wnd.name
2649: into l_delivery_id, l_delivery_name
2650: from wsh_delivery_assignments_v wda, wsh_new_deliveries_ob_grp_v wnd
2651: where wda.delivery_id = wnd.delivery_id
2652: and wda.delivery_detail_id = l_del_rows(l_del_count);
2653:
2654: update wms_shipping_transaction_temp

Line 2844: FROM wsh_new_deliveries_ob_grp_v

2840: l_tms_interface_flag wsh_new_deliveries.TMS_INTERFACE_FLAG%TYPE;
2841:
2842: CURSOR c_get_otm_flags is
2843: SELECT ignore_for_planning, tms_interface_flag
2844: FROM wsh_new_deliveries_ob_grp_v
2845: WHERE delivery_id = p_delivery_id;
2846:
2847:
2848:

Line 3028: wsh_delivery_details_ob_grp_v wdd2,wsh_new_deliveries_ob_grp_v wnd,wms_license_plate_numbers wlpn

3024: milk.concatenated_segments,
3025: wnd.name
3026: from wms_license_plate_numbers lpn, mtl_item_locations_kfv milk,wsh_trip_stops_ob_grp_v pickup_stop,
3027: wsh_delivery_legs_ob_grp_v wdl,wsh_delivery_assignments_v wda,wsh_delivery_details_ob_grp_v wdd,
3028: wsh_delivery_details_ob_grp_v wdd2,wsh_new_deliveries_ob_grp_v wnd,wms_license_plate_numbers wlpn
3029: where wdd.delivery_detail_id = wda.delivery_detail_id
3030: and wdd.released_status = 'Y'
3031: and wdd2.delivery_detail_id = wda.parent_delivery_detail_id
3032: and wda.delivery_id = wdl.delivery_id

Line 3051: wsh_delivery_details_ob_grp_v wdd2,wsh_new_deliveries_ob_grp_v wnd,wms_license_plate_numbers wlpn

3047: milk.concatenated_segments,
3048: wnd.name
3049: from wms_license_plate_numbers lpn, mtl_item_locations_kfv milk,
3050: wsh_delivery_assignments_v wda,wsh_delivery_details_ob_grp_v wdd,
3051: wsh_delivery_details_ob_grp_v wdd2,wsh_new_deliveries_ob_grp_v wnd,wms_license_plate_numbers wlpn
3052: where wdd.delivery_detail_id = wda.delivery_detail_id
3053: and wdd.released_status = 'Y'
3054: and wdd2.delivery_detail_id = wda.parent_delivery_detail_id
3055: and wda.delivery_id in ( select distinct delivery_id

Line 3116: ,wsh_new_deliveries_ob_grp_v wnd

3112: ,wms_license_plate_numbers lpn
3113: ,wms_license_plate_numbers wlpn
3114: -- 5582189 dherring added table in from clause so that
3115: -- the status code can be checked
3116: ,wsh_new_deliveries_ob_grp_v wnd
3117: Where pickup_stop.trip_id = p_trip_id
3118: and wdl.pick_up_stop_id = pickup_stop.stop_id
3119: and wda.delivery_id = wdl.delivery_id
3120: and wdd.delivery_detail_id = wda.delivery_detail_id

Line 3154: , wsh_new_deliveries_ob_grp_v wnd

3150: , wsh_delivery_legs_ob_grp_v wdl
3151: , wsh_delivery_assignments_v wda
3152: , wsh_delivery_details_ob_grp_v wdd
3153: , wsh_delivery_details_ob_grp_v wdd2
3154: , wsh_new_deliveries_ob_grp_v wnd
3155: , wms_license_plate_numbers wlpn
3156: where wdd.delivery_detail_id = wda.delivery_detail_id
3157: and wdd.released_status = 'Y'
3158: and wdd2.delivery_detail_id = wda.parent_delivery_detail_id

Line 3178: ,wsh_new_deliveries_ob_grp_v wnd

3174: BEGIN
3175: select count(distinct lpn.outermost_lpn_id)
3176: into l_count
3177: from wsh_delivery_assignments_v wda
3178: ,wsh_new_deliveries_ob_grp_v wnd
3179: ,wsh_delivery_details_ob_grp_v wdd
3180: ,wsh_delivery_details_ob_grp_v wdd2
3181: ,wms_license_plate_numbers lpn
3182: ,wms_license_plate_numbers wlpn

Line 3236: , wsh_new_deliveries_ob_grp_v wnd

3232: , mtl_item_locations_kfv milk
3233: , wsh_delivery_assignments_v wda
3234: , wsh_delivery_details_ob_grp_v wdd
3235: , wsh_delivery_details_ob_grp_v wdd2
3236: , wsh_new_deliveries_ob_grp_v wnd
3237: , wms_license_plate_numbers wlpn
3238: where wdd.delivery_detail_id = wda.delivery_detail_id
3239: and wdd.released_status = 'Y'
3240: and wdd2.delivery_detail_id = wda.parent_delivery_detail_id

Line 3336: , wsh_new_deliveries_ob_grp_v wnd

3332: , msik.concatenated_segments
3333: , msik.description
3334: from wsh_delivery_details_ob_grp_v wdd
3335: , wsh_delivery_assignments_v wda
3336: , wsh_new_deliveries_ob_grp_v wnd
3337: , wsh_delivery_legs_ob_grp_v wdl
3338: , wsh_trip_Stops_ob_grp_v pickup_stop
3339: , mtl_system_items_kfv msik
3340: where wnd.delivery_id = wda.delivery_id

Line 3409: , wsh_new_deliveries_ob_grp_v wnd

3405: , msiv.description
3406: from wsh_delivery_details_ob_grp_v wdd
3407: , wsh_delivery_assignments_v wda
3408: , mtl_system_items_vl msiv
3409: , wsh_new_deliveries_ob_grp_v wnd
3410: where wda.delivery_detail_id = wdd.delivery_detail_id
3411: and wdd.lpn_id is null
3412: and wda.delivery_id in (select distinct delivery_id
3413: from wms_shipping_transaction_temp

Line 3997: from wms_shipping_transaction_temp wstt,wsh_new_deliveries_ob_grp_v wnd

3993: p_close_trip_flag IN VARCHAR2 DEFAULT 'N',
3994: p_allow_ship_set_break IN VARCHAR2 DEFAULT 'N') IS
3995: cursor Deliveries_in_trip is
3996: select distinct wstt.delivery_id, wnd.ship_method_code
3997: from wms_shipping_transaction_temp wstt,wsh_new_deliveries_ob_grp_v wnd
3998: where wstt.trip_id = p_trip_id
3999: and wstt.dock_door_id = p_dock_door_id
4000: and wstt.organization_id = p_organization_id
4001: and nvl(wstt.direct_ship_flag,'N') = 'N'

Line 4006: from wms_shipping_transaction_temp wstt,wsh_new_deliveries_ob_grp_v wnd

4002: AND wstt.delivery_id = wnd.delivery_id;
4003:
4004: cursor Deliveries is
4005: select distinct wstt.delivery_id,wnd.ship_method_code
4006: from wms_shipping_transaction_temp wstt,wsh_new_deliveries_ob_grp_v wnd
4007: where wstt.dock_appoint_flag = 'N'
4008: and nvl(wstt.direct_ship_flag,'N') = 'N'
4009: and wstt.dock_door_id = p_dock_door_id
4010: and wstt.organization_id = p_organization_id

Line 4036: from wms_shipping_transaction_temp wstt,wsh_new_deliveries_ob_grp_v wnd

4032: CONNECT BY parent_lpn_id = PRIOR lpn_id;
4033:
4034: cursor Deliveries_without_trip is
4035: select distinct wstt.delivery_id,wnd.ship_method_code
4036: from wms_shipping_transaction_temp wstt,wsh_new_deliveries_ob_grp_v wnd
4037: where wstt.dock_appoint_flag = 'N'
4038: and nvl(wstt.direct_ship_flag,'N') = 'N'
4039: and wstt.dock_door_id = p_dock_door_id
4040: and wstt.trip_id is null

Line 4046: from wms_shipping_transaction_temp wstt, wsh_new_deliveries_ob_grp_v wnd

4042: AND wstt.delivery_id = wnd.delivery_id ;
4043:
4044: cursor Deliveries_with_trip is
4045: select distinct wstt.delivery_id,wnd.ship_method_code
4046: from wms_shipping_transaction_temp wstt, wsh_new_deliveries_ob_grp_v wnd
4047: where wstt.dock_appoint_flag = 'N'
4048: and nvl(wstt.direct_ship_flag,'N') = 'N'
4049: and wstt.dock_door_id = p_dock_door_id
4050: and wstt.trip_id is not null

Line 4268: from wsh_new_deliveries_ob_grp_v

4264:
4265: -- get the document set id
4266: select organization_id
4267: into l_org_id
4268: from wsh_new_deliveries_ob_grp_v
4269: where delivery_id = l_delivery_id;
4270:
4271: if( nvl(l_report_set_id, -1) = -1) then
4272: BEGIN

Line 5765: wsh_new_deliveries_ob_grp_v wnd,

5761: SELECT COUNT(*)
5762: INTO l_count
5763: FROM wsh_delivery_details_ob_grp_v wdd,
5764: wsh_delivery_assignments_v wda,
5765: wsh_new_deliveries_ob_grp_v wnd,
5766: wsh_delivery_legs_ob_grp_v wdl,
5767: wsh_trip_Stops_ob_grp_v pickup_stop,
5768: mtl_system_items_kfv msik
5769: WHERE wnd.delivery_id = wda.delivery_id

Line 5798: wsh_new_deliveries_ob_grp_v wnd,

5794: msik.concatenated_segments,
5795: msik.description
5796: FROM wsh_delivery_details_ob_grp_v wdd,
5797: wsh_delivery_assignments_v wda,
5798: wsh_new_deliveries_ob_grp_v wnd,
5799: wsh_delivery_legs_ob_grp_v wdl,
5800: wsh_trip_stops_ob_grp_v pickup_stop,
5801: mtl_system_items_kfv msik
5802: WHERE wnd.delivery_id = wda.delivery_id

Line 5819: msik, wsh_new_deliveries_ob_grp_v wnd

5815: INTO l_count
5816: FROM wsh_delivery_details_ob_grp_v wdd,
5817: wsh_delivery_assignments_v wda,
5818: mtl_system_items_kfv
5819: msik, wsh_new_deliveries_ob_grp_v wnd
5820: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
5821: AND wdd.lpn_id IS NULL
5822: AND wda.delivery_id IN (SELECT DISTINCT delivery_id
5823: FROM wms_shipping_transaction_temp

Line 5864: msik, wsh_new_deliveries_ob_grp_v wnd

5860: msik.description
5861: FROM wsh_delivery_details_ob_grp_v wdd,
5862: wsh_delivery_assignments_v wda,
5863: mtl_system_items_kfv
5864: msik, wsh_new_deliveries_ob_grp_v wnd
5865: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
5866: AND wdd.lpn_id IS NULL
5867: AND wda.delivery_id IN (SELECT DISTINCT delivery_id
5868: FROM wms_shipping_transaction_temp