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

Line 518: FROM wsh_new_deliveries_ob_grp_v wnd

514: , wnd.weight_uom_code
515: , wnd.waybill
516: , ' ' trip_name,
517: INV_SHIPPING_TRANSACTION_PUB.GET_SHIPMETHOD_MEANING(wnd.ship_method_code)
518: FROM wsh_new_deliveries_ob_grp_v wnd
519: WHERE wnd.delivery_id = p_delivery_id;
520: END get_delivery_info;
521:
522: PROCEDURE GET_STAGING_LANE(x_staging_lane_LOV OUT NOCOPY t_genref,

Line 717: FROM wsh_new_deliveries_ob_grp_v

713: BEGIN
714: IF (l_delivery_id is not null) then
715: SELECT name, status_code
716: INTO l_delivery_name, l_delivery_status_code
717: FROM wsh_new_deliveries_ob_grp_v
718: WHERE delivery_id = l_delivery_id;
719: ELSE
720: l_delivery_name := NULL;
721: l_delivery_status_code := NULL;

Line 875: from wsh_new_deliveries_ob_grp_v

871: if p_delivery_id is null then return ' ';
872: else
873: select name
874: into p_name
875: from wsh_new_deliveries_ob_grp_v
876: where delivery_id = p_delivery_id;
877: end if;
878: return p_name;
879: EXCEPTION

Line 920: , wsh_new_deliveries_ob_grp_v wnd

916: , wnd.delivery_id,wnd.name
917: , nvl(wdd.load_seq_number,0) as load_seq_num
918: from wms_license_plate_numbers lpn
919: , wms_license_plate_numbers wlpn
920: , wsh_new_deliveries_ob_grp_v wnd
921: , wsh_delivery_legs_ob_grp_v wdl
922: , wsh_delivery_details_ob_grp_v wdd
923: , wsh_delivery_assignments_v wda
924: , wsh_delivery_details_ob_grp_v wdd2

Line 953: ,wsh_new_deliveries_ob_grp_v wndv

949: from wsh_delivery_details_ob_grp_v wdd
950: , wsh_delivery_assignments_v wda
951: , wms_license_plate_numbers lpn
952: ,wms_license_plate_numbers wlpn
953: ,wsh_new_deliveries_ob_grp_v wndv
954: where wdd.delivery_detail_id = wda.delivery_detail_id
955: and wdd.lpn_id is not null
956: and wdd.lpn_id = lpn.outermost_lpn_id
957: and wdd.released_status = 'X' -- For LPN reuse ER : 6845650

Line 1000: ,wsh_new_deliveries_ob_grp_v wndv

996: from wsh_delivery_details_ob_grp_v wdd
997: , wsh_delivery_assignments_v wda
998: , wms_license_plate_numbers lpn
999: ,wms_license_plate_numbers wlpn
1000: ,wsh_new_deliveries_ob_grp_v wndv
1001: where wdd.delivery_detail_id = wda.delivery_detail_id
1002: and wdd.lpn_id is not null
1003: and wdd.lpn_id = lpn.lpn_id
1004: and wdd.released_status = 'X' -- For LPN reuse ER : 6845650

Line 1048: , wsh_new_deliveries_ob_grp_v wnd

1044: , wlpn.license_plate_number
1045: , wnd.delivery_id,wnd.name
1046: from wms_license_plate_numbers lpn
1047: , wms_license_plate_numbers wlpn
1048: , wsh_new_deliveries_ob_grp_v wnd
1049: , wsh_delivery_legs_ob_grp_v wdl
1050: , wsh_delivery_details_ob_grp_v wdd
1051: , wsh_delivery_assignments_v wda
1052: , wsh_delivery_details_ob_grp_v wdd2

Line 1085: ,wsh_new_deliveries_ob_grp_v wndv

1081: from wsh_delivery_details_ob_grp_v wdd
1082: , wsh_delivery_assignments_v wda
1083: , wms_license_plate_numbers lpn
1084: ,wms_license_plate_numbers wlpn
1085: ,wsh_new_deliveries_ob_grp_v wndv
1086: where wdd.delivery_detail_id = wda.delivery_detail_id
1087: and wdd.lpn_id is not null -- for performance, bug 2418639
1088: and wdd.lpn_id = lpn.outermost_lpn_id
1089: and wdd.released_status = 'X' -- For LPN reuse ER : 6845650

Line 1557: from wsh_new_deliveries_ob_grp_v

1553: fetch lpn_in_other_dock into x_loaded_dock_door;
1554: if lpn_in_other_dock%FOUND then
1555: select name
1556: into x_delivery_name
1557: from wsh_new_deliveries_ob_grp_v
1558: where delivery_id = l_delivery_id;
1559: x_result := 1;
1560: close lpn_in_other_dock;
1561: close deliveries_in_lpn;

Line 2061: l_tms_interface_flag wsh_new_deliveries.TMS_INTERFACE_FLAG%TYPE;

2057: **********************************/
2058:
2059:
2060: l_ignore_for_planning wsh_delivery_details.ignore_for_planning%type;
2061: l_tms_interface_flag wsh_new_deliveries.TMS_INTERFACE_FLAG%TYPE;
2062:
2063:
2064: cursor delivery_for_trip is
2065: select distinct delivery_id

Line 2082: FROM wsh_new_deliveries_ob_grp_v

2078: AND nvl(direct_ship_flag,'N')='N';
2079:
2080: CURSOR c_get_otm_flags IS
2081: SELECT ignore_for_planning, tms_interface_flag
2082: FROM wsh_new_deliveries_ob_grp_v
2083: WHERE delivery_id = l_delivery_id;
2084:
2085: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2086: l_debug number;

Line 2286: FROM wsh_new_deliveries_ob_grp_v wnd

2282: * on ship confirm page . We will use the one returned from
2283: * create_delvery API for the LastLPN*/
2284: SELECT wnd.delivery_type
2285: INTO l_delivery_type
2286: FROM wsh_new_deliveries_ob_grp_v wnd
2287: WHERE wnd.delivery_id = p_delivery_id;
2288:
2289: IF l_delivery_type = 'CONSOLIDATION' THEN
2290: NULL ; --we will pick up the first delivery of the outermost LPN

Line 2376: ,wsh_new_deliveries_ob_grp_v wnd

2372:
2373: cursor open_deliveries_cur is
2374: select DISTINCT WSTT.delivery_id
2375: from WMS_SHIPPING_TRANSACTION_TEMP wstt
2376: ,wsh_new_deliveries_ob_grp_v wnd
2377: where wstt.delivery_id = wnd.delivery_id
2378: AND wnd.status_code ='OP'
2379: AND WSTT.organization_id = p_organization_id
2380: and WSTT.dock_door_id = p_dock_door_id

Line 2434: from wsh_delivery_assignments_v wda, wsh_new_deliveries_ob_grp_v wnd

2430: -- Add the following code in case user created delivery manually from
2431: -- desktop
2432: select wda.delivery_id, wnd.name
2433: into l_delivery_id, l_delivery_name
2434: from wsh_delivery_assignments_v wda, wsh_new_deliveries_ob_grp_v wnd
2435: where wda.delivery_id = wnd.delivery_id
2436: and wda.delivery_detail_id = l_delivery_detail_id;
2437:
2438: update wms_shipping_transaction_temp

Line 2589: from wsh_delivery_assignments_v wda, wsh_new_deliveries_ob_grp_v wnd

2585:
2586: for l_del_count in 1..l_del_rows.COUNT LOOP
2587: select wda.delivery_id, wnd.name
2588: into l_delivery_id, l_delivery_name
2589: from wsh_delivery_assignments_v wda, wsh_new_deliveries_ob_grp_v wnd
2590: where wda.delivery_id = wnd.delivery_id
2591: and wda.delivery_detail_id = l_del_rows(l_del_count);
2592:
2593: update wms_shipping_transaction_temp

Line 2638: FROM wsh_new_deliveries wnd,wms_shipping_transaction_temp wstt

2634: OPEN x_deliveryLOV for
2635: SELECT distinct wstt.delivery_name, wnd.delivery_id, wnd.gross_weight, wnd.weight_uom_code,
2636: wnd.waybill,
2637: INV_SHIPPING_TRANSACTION_PUB.GET_SHIPMETHOD_MEANING(wnd.ship_method_code)
2638: FROM wsh_new_deliveries wnd,wms_shipping_transaction_temp wstt
2639: WHERE wnd.delivery_id = wstt.delivery_id
2640: and wstt.trip_id = p_trip_id
2641: and wstt.dock_door_id = p_dock_door_id
2642: and wstt.organization_id = p_organization_id

Line 2651: FROM wsh_new_deliveries wnd,wms_shipping_transaction_temp wstt

2647: OPEN x_deliveryLOV for
2648: SELECT distinct wstt.delivery_name, wnd.delivery_id, wnd.gross_weight, wnd.weight_uom_code,
2649: wnd.waybill,
2650: INV_SHIPPING_TRANSACTION_PUB.GET_SHIPMETHOD_MEANING(wnd.ship_method_code)
2651: FROM wsh_new_deliveries wnd,wms_shipping_transaction_temp wstt
2652: WHERE wnd.delivery_id = wstt.delivery_id
2653: and wstt.dock_appoint_flag = 'N'
2654: and nvl(wstt.direct_ship_flag,'N') = 'N'
2655: and wstt.dock_door_id = p_dock_door_id

Line 2779: l_tms_interface_flag wsh_new_deliveries.TMS_INTERFACE_FLAG%TYPE;

2775: l_msg_data VARCHAR2(2000);
2776: l_summary_buffer VARCHAR2(2000);
2777:
2778: l_ignore_for_planning wsh_delivery_details.ignore_for_planning%TYPE;
2779: l_tms_interface_flag wsh_new_deliveries.TMS_INTERFACE_FLAG%TYPE;
2780:
2781: CURSOR c_get_otm_flags is
2782: SELECT ignore_for_planning, tms_interface_flag
2783: FROM wsh_new_deliveries_ob_grp_v

Line 2783: FROM wsh_new_deliveries_ob_grp_v

2779: l_tms_interface_flag wsh_new_deliveries.TMS_INTERFACE_FLAG%TYPE;
2780:
2781: CURSOR c_get_otm_flags is
2782: SELECT ignore_for_planning, tms_interface_flag
2783: FROM wsh_new_deliveries_ob_grp_v
2784: WHERE delivery_id = p_delivery_id;
2785:
2786:
2787:

Line 2967: wsh_delivery_details_ob_grp_v wdd2,wsh_new_deliveries_ob_grp_v wnd,wms_license_plate_numbers wlpn

2963: milk.concatenated_segments,
2964: wnd.name
2965: from wms_license_plate_numbers lpn, mtl_item_locations_kfv milk,wsh_trip_stops_ob_grp_v pickup_stop,
2966: wsh_delivery_legs_ob_grp_v wdl,wsh_delivery_assignments_v wda,wsh_delivery_details_ob_grp_v wdd,
2967: wsh_delivery_details_ob_grp_v wdd2,wsh_new_deliveries_ob_grp_v wnd,wms_license_plate_numbers wlpn
2968: where wdd.delivery_detail_id = wda.delivery_detail_id
2969: and wdd.released_status = 'Y'
2970: and wdd2.delivery_detail_id = wda.parent_delivery_detail_id
2971: and wda.delivery_id = wdl.delivery_id

Line 2990: wsh_delivery_details_ob_grp_v wdd2,wsh_new_deliveries_ob_grp_v wnd,wms_license_plate_numbers wlpn

2986: milk.concatenated_segments,
2987: wnd.name
2988: from wms_license_plate_numbers lpn, mtl_item_locations_kfv milk,
2989: wsh_delivery_assignments_v wda,wsh_delivery_details_ob_grp_v wdd,
2990: wsh_delivery_details_ob_grp_v wdd2,wsh_new_deliveries_ob_grp_v wnd,wms_license_plate_numbers wlpn
2991: where wdd.delivery_detail_id = wda.delivery_detail_id
2992: and wdd.released_status = 'Y'
2993: and wdd2.delivery_detail_id = wda.parent_delivery_detail_id
2994: and wda.delivery_id in ( select distinct delivery_id

Line 3055: ,wsh_new_deliveries_ob_grp_v wnd

3051: ,wms_license_plate_numbers lpn
3052: ,wms_license_plate_numbers wlpn
3053: -- 5582189 dherring added table in from clause so that
3054: -- the status code can be checked
3055: ,wsh_new_deliveries_ob_grp_v wnd
3056: Where pickup_stop.trip_id = p_trip_id
3057: and wdl.pick_up_stop_id = pickup_stop.stop_id
3058: and wda.delivery_id = wdl.delivery_id
3059: and wdd.delivery_detail_id = wda.delivery_detail_id

Line 3093: , wsh_new_deliveries_ob_grp_v wnd

3089: , wsh_delivery_legs_ob_grp_v wdl
3090: , wsh_delivery_assignments_v wda
3091: , wsh_delivery_details_ob_grp_v wdd
3092: , wsh_delivery_details_ob_grp_v wdd2
3093: , wsh_new_deliveries_ob_grp_v wnd
3094: , wms_license_plate_numbers wlpn
3095: where wdd.delivery_detail_id = wda.delivery_detail_id
3096: and wdd.released_status = 'Y'
3097: and wdd2.delivery_detail_id = wda.parent_delivery_detail_id

Line 3117: ,wsh_new_deliveries_ob_grp_v wnd

3113: BEGIN
3114: select count(distinct lpn.outermost_lpn_id)
3115: into l_count
3116: from wsh_delivery_assignments_v wda
3117: ,wsh_new_deliveries_ob_grp_v wnd
3118: ,wsh_delivery_details_ob_grp_v wdd
3119: ,wsh_delivery_details_ob_grp_v wdd2
3120: ,wms_license_plate_numbers lpn
3121: ,wms_license_plate_numbers wlpn

Line 3175: , wsh_new_deliveries_ob_grp_v wnd

3171: , mtl_item_locations_kfv milk
3172: , wsh_delivery_assignments_v wda
3173: , wsh_delivery_details_ob_grp_v wdd
3174: , wsh_delivery_details_ob_grp_v wdd2
3175: , wsh_new_deliveries_ob_grp_v wnd
3176: , wms_license_plate_numbers wlpn
3177: where wdd.delivery_detail_id = wda.delivery_detail_id
3178: and wdd.released_status = 'Y'
3179: and wdd2.delivery_detail_id = wda.parent_delivery_detail_id

Line 3275: , wsh_new_deliveries_ob_grp_v wnd

3271: , msik.concatenated_segments
3272: , msik.description
3273: from wsh_delivery_details_ob_grp_v wdd
3274: , wsh_delivery_assignments_v wda
3275: , wsh_new_deliveries_ob_grp_v wnd
3276: , wsh_delivery_legs_ob_grp_v wdl
3277: , wsh_trip_Stops_ob_grp_v pickup_stop
3278: , mtl_system_items_kfv msik
3279: where wnd.delivery_id = wda.delivery_id

Line 3348: , wsh_new_deliveries_ob_grp_v wnd

3344: , msiv.description
3345: from wsh_delivery_details_ob_grp_v wdd
3346: , wsh_delivery_assignments_v wda
3347: , mtl_system_items_vl msiv
3348: , wsh_new_deliveries_ob_grp_v wnd
3349: where wda.delivery_detail_id = wdd.delivery_detail_id
3350: and wdd.lpn_id is null
3351: and wda.delivery_id in (select distinct delivery_id
3352: from wms_shipping_transaction_temp

Line 3861: from wms_shipping_transaction_temp wstt,wsh_new_deliveries_ob_grp_v wnd

3857: p_close_trip_flag IN VARCHAR2 DEFAULT 'N',
3858: p_allow_ship_set_break IN VARCHAR2 DEFAULT 'N') IS
3859: cursor Deliveries_in_trip is
3860: select distinct wstt.delivery_id, wnd.ship_method_code
3861: from wms_shipping_transaction_temp wstt,wsh_new_deliveries_ob_grp_v wnd
3862: where wstt.trip_id = p_trip_id
3863: and wstt.dock_door_id = p_dock_door_id
3864: and wstt.organization_id = p_organization_id
3865: and nvl(wstt.direct_ship_flag,'N') = 'N'

Line 3870: from wms_shipping_transaction_temp wstt,wsh_new_deliveries_ob_grp_v wnd

3866: AND wstt.delivery_id = wnd.delivery_id;
3867:
3868: cursor Deliveries is
3869: select distinct wstt.delivery_id,wnd.ship_method_code
3870: from wms_shipping_transaction_temp wstt,wsh_new_deliveries_ob_grp_v wnd
3871: where wstt.dock_appoint_flag = 'N'
3872: and nvl(wstt.direct_ship_flag,'N') = 'N'
3873: and wstt.dock_door_id = p_dock_door_id
3874: and wstt.organization_id = p_organization_id

Line 3900: from wms_shipping_transaction_temp wstt,wsh_new_deliveries_ob_grp_v wnd

3896: CONNECT BY parent_lpn_id = PRIOR lpn_id;
3897:
3898: cursor Deliveries_without_trip is
3899: select distinct wstt.delivery_id,wnd.ship_method_code
3900: from wms_shipping_transaction_temp wstt,wsh_new_deliveries_ob_grp_v wnd
3901: where wstt.dock_appoint_flag = 'N'
3902: and nvl(wstt.direct_ship_flag,'N') = 'N'
3903: and wstt.dock_door_id = p_dock_door_id
3904: and wstt.trip_id is null

Line 3910: from wms_shipping_transaction_temp wstt, wsh_new_deliveries_ob_grp_v wnd

3906: AND wstt.delivery_id = wnd.delivery_id ;
3907:
3908: cursor Deliveries_with_trip is
3909: select distinct wstt.delivery_id,wnd.ship_method_code
3910: from wms_shipping_transaction_temp wstt, wsh_new_deliveries_ob_grp_v wnd
3911: where wstt.dock_appoint_flag = 'N'
3912: and nvl(wstt.direct_ship_flag,'N') = 'N'
3913: and wstt.dock_door_id = p_dock_door_id
3914: and wstt.trip_id is not null

Line 3963: wsh_new_deliveries wnd

3959:
3960: CURSOR Check_Last_Trip (l_delivery_id NUMBER) IS
3961: SELECT wdt1.trip_id
3962: FROM wsh_delivery_trips_v wdt1,
3963: wsh_new_deliveries wnd
3964: WHERE wdt1.delivery_id <> l_delivery_id
3965: AND wdt1.delivery_id = wnd.delivery_id
3966: AND wnd.status_code = 'OP'
3967: AND wdt1.trip_id IN (SELECT wdt2.trip_id

Line 3988: TYPE ship_method_tbl_type IS TABLE OF wsh_new_deliveries.ship_method_code%TYPE INDEX BY BINARY_INTEGER;

3984: l_sc_close_trip_flag VARCHAR2(1);
3985: l_sc_defer_interface_flag VARCHAR2(1);
3986: l_open_delivery_id NUMBER;
3987:
3988: TYPE ship_method_tbl_type IS TABLE OF wsh_new_deliveries.ship_method_code%TYPE INDEX BY BINARY_INTEGER;
3989: l_ship_method_tbl ship_method_tbl_type;
3990: l_ship_method VARCHAR2(30);
3991:
3992: l_actual_dep_date DATE := SYSDATE;

Line 4108: from wsh_new_deliveries_ob_grp_v

4104:
4105: -- get the document set id
4106: select organization_id
4107: into l_org_id
4108: from wsh_new_deliveries_ob_grp_v
4109: where delivery_id = l_delivery_id;
4110:
4111: if( nvl(l_report_set_id, -1) = -1) then
4112: BEGIN

Line 5043: FROM wsh_new_deliveries

5039: IF l_delivery_id_tab(1) is NOT NULL
5040: THEN
5041: SELECT PLANNED_FLAG
5042: INTO L_PLANNED_FLAG
5043: FROM wsh_new_deliveries
5044: WHERE delivery_id = l_delivery_id_tab(1);
5045: ELSE
5046:
5047: -- {{ Test a case where delivery does not exist before ship confirm, to see,}}

Line 5062: FROM wsh_new_deliveries wnd,

5058:
5059: BEGIN
5060: SELECT wnd.planned_flag
5061: INTO l_planned_flag
5062: FROM wsh_new_deliveries wnd,
5063: wsh_delivery_details wdd,
5064: wsh_delivery_assignments wda
5065: WHERE wdd.delivery_detail_id = l_delivery_details(1)
5066: AND wda.delivery_detail_id = wdd.delivery_detail_id

Line 5588: wsh_new_deliveries_ob_grp_v wnd,

5584: SELECT COUNT(*)
5585: INTO l_count
5586: FROM wsh_delivery_details_ob_grp_v wdd,
5587: wsh_delivery_assignments_v wda,
5588: wsh_new_deliveries_ob_grp_v wnd,
5589: wsh_delivery_legs_ob_grp_v wdl,
5590: wsh_trip_Stops_ob_grp_v pickup_stop,
5591: mtl_system_items_kfv msik
5592: WHERE wnd.delivery_id = wda.delivery_id

Line 5621: wsh_new_deliveries_ob_grp_v wnd,

5617: msik.concatenated_segments,
5618: msik.description
5619: FROM wsh_delivery_details_ob_grp_v wdd,
5620: wsh_delivery_assignments_v wda,
5621: wsh_new_deliveries_ob_grp_v wnd,
5622: wsh_delivery_legs_ob_grp_v wdl,
5623: wsh_trip_stops_ob_grp_v pickup_stop,
5624: mtl_system_items_kfv msik
5625: WHERE wnd.delivery_id = wda.delivery_id

Line 5642: msik, wsh_new_deliveries_ob_grp_v wnd

5638: INTO l_count
5639: FROM wsh_delivery_details_ob_grp_v wdd,
5640: wsh_delivery_assignments_v wda,
5641: mtl_system_items_kfv
5642: msik, wsh_new_deliveries_ob_grp_v wnd
5643: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
5644: AND wdd.lpn_id IS NULL
5645: AND wda.delivery_id IN (SELECT DISTINCT delivery_id
5646: FROM wms_shipping_transaction_temp

Line 5687: msik, wsh_new_deliveries_ob_grp_v wnd

5683: msik.description
5684: FROM wsh_delivery_details_ob_grp_v wdd,
5685: wsh_delivery_assignments_v wda,
5686: mtl_system_items_kfv
5687: msik, wsh_new_deliveries_ob_grp_v wnd
5688: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
5689: AND wdd.lpn_id IS NULL
5690: AND wda.delivery_id IN (SELECT DISTINCT delivery_id
5691: FROM wms_shipping_transaction_temp