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_DIRECT_SHIP_PVT dependencies on WSH_NEW_DELIVERIES

Line 221: FROM wsh_new_deliveries_ob_grp_v wnd,

217: ,WMS_DIRECT_SHIP_PVT.GET_BOL(wnd.delivery_id)
218: ,nvl(wnd.status_code,'OP')
219: ,WMS_DIRECT_SHIP_PVT.GET_ENFORCE_SHIP
220: ,wts1.trip_id --2767767
221: FROM wsh_new_deliveries_ob_grp_v wnd,
222: -- 2767767
223: (SELECT wdl.delivery_id,wts.trip_id
224: FROM wsh_delivery_legs_ob_grp_v wdl,
225: wsh_trip_stops_ob_grp_v wts

Line 491: FROM wsh_new_deliveries_ob_grp_v

487: IF p_delivery_id IS NOT NULL THEN
488: BEGIN
489: SELECT name
490: INTO l_del_name
491: FROM wsh_new_deliveries_ob_grp_v
492: WHERE delivery_id =p_delivery_id;
493: EXCEPTION
494: WHEN no_data_found THEN
495: NULL;

Line 501: FROM wsh_new_deliveries_ob_grp_v

497: END IF;
498: BEGIN
499: SELECT 1
500: INTO temp_val
501: FROM wsh_new_deliveries_ob_grp_v
502: WHERE delivery_id = p_delivery_id
503: FOR UPDATE NOWAIT;
504: IF (l_debug = 1) THEN
505: debug('Lock delivery successful','Check_Delivery');

Line 511: /Failed to aquire locks on wsh_new_deliveries for /

507: EXCEPTION WHEN others THEN
508: x_return_Status := fnd_api.g_ret_sts_error;
509: fnd_message.set_name('WMS','WMS_DEL_LOCK_FAILURE');
510: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',l_del_name);
511: /*Failed to aquire locks on wsh_new_deliveries for */
512: fnd_msg_pub.add;
513: fnd_msg_pub.count_and_get( p_count => x_msg_count,
514: p_data => x_msg_data
515: );

Line 629: FROM wsh_new_deliveries_ob_grp_v

625: END IF;
626: BEGIN
627: SELECT name
628: INTO x_delivery_name
629: FROM wsh_new_deliveries_ob_grp_v
630: WHERE delivery_id = p_delivery_id;
631: FND_MESSAGE.SET_NAME('WMS','WMS_LPN_OTHER_DOCK');
632: FND_MESSAGE.SET_TOKEN('LPN_NAME',x_outermost_lpn);
633: FND_MESSAGE.SET_TOKEN('DOCK',l_loaded_dock_door);

Line 803: FROM wsh_new_deliveries_ob_grp_v

799:
800: IF p_delivery_id IS NOT NULL THEN
801: SELECT status_code
802: INTO l_status_code
803: FROM wsh_new_deliveries_ob_grp_v
804: WHERE delivery_id = p_delivery_id;
805:
806: IF l_status_code IN ('CL','CO','IT') THEN
807: RETURN ;

Line 831: FROM wsh_new_deliveries_ob_grp_v

827: IF p_delivery_id IS NOT NULL THEN
828: BEGIN
829: SELECT name
830: INTO l_del_name
831: FROM wsh_new_deliveries_ob_grp_v
832: WHERE delivery_id = p_delivery_id;
833: EXCEPTION
834: WHEN NO_DATA_FOUND THEN
835: NULL;

Line 1054: ,wsh_new_deliveries_ob_grp_v wnd

1050: msik.concatenated_segments,
1051: msik.description
1052: from wsh_delivery_details_ob_grp_v wdd
1053: ,wsh_delivery_assignments_v wda
1054: ,wsh_new_deliveries_ob_grp_v wnd
1055: ,mtl_system_items_kfv msik
1056: where wnd.delivery_id = p_delivery_id
1057: AND wnd.delivery_id = wda.delivery_id
1058: AND wda.delivery_detail_id = wdd.delivery_detail_id

Line 1131: l_tms_interface_flag wsh_new_deliveries.TMS_INTERFACE_FLAG%type;

1127:
1128: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1129:
1130: l_ignore_for_planning wsh_delivery_details.ignore_for_planning%type;
1131: l_tms_interface_flag wsh_new_deliveries.TMS_INTERFACE_FLAG%type;
1132: l_otm_trip_id wsh_trips.trip_id%type;
1133: l_otm_carrier_id wsh_trips.carrier_id%type;
1134: l_otm_ship_method_code wsh_trips.ship_method_code%type;
1135: l_otm_mode wsh_trips.mode_of_transport%type;

Line 1158: FROM wsh_new_deliveries_ob_grp_v

1154: and wts.trip_id=wt.trip_id;
1155:
1156: CURSOR c_get_delivery_info IS
1157: SELECT status_code,NAME,ignore_for_planning, tms_interface_flag
1158: FROM wsh_new_deliveries_ob_grp_v
1159: WHERE delivery_id = p_delivery_id;
1160:
1161: BEGIN
1162: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1539: ,WSH_NEW_DELIVERIES_OB_GRP_V WND

1535: l_trip_name VARCHAR2(30);
1536: CURSOR loaded_deliveries IS
1537: SELECT DISTINCT WSTT.delivery_id
1538: FROM WMS_SHIPPING_TRANSACTION_TEMP wstt
1539: ,WSH_NEW_DELIVERIES_OB_GRP_V WND
1540: WHERE wstt.organization_id = p_org_id
1541: AND wstt.dock_door_id = p_dock_door_id
1542: AND wstt.dock_appoint_flag = 'N'
1543: AND nvl(wstt.direct_ship_flag,'N') = 'Y'

Line 3028: FROM wms_shipping_transaction_temp wstt, wsh_new_deliveries_ob_grp_v wnd

3024: SELECT wstt.delivery_id
3025: , wnd.status_code
3026: INTO l_del_id
3027: , l_status_code
3028: FROM wms_shipping_transaction_temp wstt, wsh_new_deliveries_ob_grp_v wnd
3029: WHERE wstt.outermost_lpn_id = p_outermost_lpn_id
3030: AND wstt.direct_ship_flag = 'Y'
3031: AND wstt.delivery_id = wnd.delivery_id
3032: AND ROWNUM = 1;

Line 5014: FROM wsh_new_deliveries_ob_grp_v

5010:
5011:
5012: CURSOR c_Get_OTM_flag(v_del_id NUMBER) IS
5013: SELECT ignore_for_planning, tms_interface_flag
5014: FROM wsh_new_deliveries_ob_grp_v
5015: WHERE delivery_id = v_del_id ;
5016:
5017: l_delivery_detail_tab delivery_detail_tab;
5018: l_new_delivery_detail_id NUMBER;

Line 5096: l_tms_interface_flag wsh_new_deliveries.TMS_INTERFACE_FLAG%type;

5092: * variable to hold the ignore_for_planning flag of WDD.
5093: * Added for g-log changes
5094: **********************************/
5095: l_ignore_for_planning wsh_delivery_details.ignore_for_planning%type;
5096: l_tms_interface_flag wsh_new_deliveries.TMS_INTERFACE_FLAG%type;
5097:
5098:
5099:
5100: BEGIN

Line 7577: FROM wsh_new_deliveries_ob_grp_v wnd

7573: DEBUG('Unpack delivery_id is: ' || l_delivery_id, 'Container_Nesting');
7574:
7575: SELECT wnd.planned_flag
7576: INTO l_delivery_planned_flag
7577: FROM wsh_new_deliveries_ob_grp_v wnd
7578: WHERE wnd.delivery_id = l_delivery_id;
7579:
7580: DEBUG('Unpack delivery planned status: ' || l_delivery_planned_flag,'Container_Nesting');
7581: EXCEPTION

Line 11664: FROM wsh_new_deliveries_ob_grp_v

11660:
11661: --
11662: CURSOR closed_del(p_del_id NUMBER) IS
11663: SELECT delivery_id
11664: FROM wsh_new_deliveries_ob_grp_v
11665: WHERE delivery_id = p_del_id
11666: AND status_code IN('CL', 'IT');
11667:
11668: --