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.WSH_DELIVERY_AUTOCREATE dependencies on WSH_DELIVERY_DETAILS

Line 281: FROM wsh_delivery_details wdd,

277: NULL,
278: NULL, -- X-dock, is_xdocked_flag
279: wdd.client_id, -- LSP PROJECT
280: nvl(wdd.consignee_flag, 'C') -- RTV changes
281: FROM wsh_delivery_details wdd,
282: wsh_delivery_assignments_v wda
283: WHERE wdd.delivery_detail_id = p_dd_id AND
284: wdd.released_status <> 'D'AND
285: wda.delivery_detail_id = wdd.delivery_detail_id;

Line 1266: FROM wsh_delivery_details

1262: = nvl(d.organization_id, -1);
1263: -- LSP PROJECT: Added client_id
1264: CURSOR c_check_lpn(p_delivery_detail_id IN NUMBER) IS
1265: SELECT container_flag, organization_id, ship_from_location_id, customer_id,client_id
1266: FROM wsh_delivery_details
1267: WHERE delivery_detail_id = p_delivery_detail_id;
1268:
1269: l_container_flag VARCHAR2(1);
1270: l_organization_id NUMBER;

Line 2012: FROM wsh_delivery_details

2008:
2009: /* Bug 3206620 : cursor to get the container flag of the delivery detail*/
2010: cursor c_cont (p_entity_id NUMBER) is
2011: SELECT container_flag
2012: FROM wsh_delivery_details
2013: WHERE delivery_detail_id = p_entity_id;
2014:
2015: cursor c_matching_delivery(p_hash_value in number,
2016: p_hash_string in varchar2,

Line 2609: wsh_delivery_details_actions.assign_detail_to_delivery(

2605:
2606: END IF; --}
2607: -- 5415196 end
2608:
2609: wsh_delivery_details_actions.assign_detail_to_delivery(
2610: p_detail_id => l_attr_tab(i).entity_id,
2611: p_delivery_id => l_delivery_tab(l_attr_tab(i).group_id),
2612: x_return_status => x_return_status,
2613: p_caller => 'AUTOCREATE'); --bug 5100229

Line 2618: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_DELIVERY_DETAILS_ACTIONS.ASSIGN_DETAIL_TO_DELIVERY FOR '||P_LINE_ROWS ( I ) || ' TO '||L_DELIVERY_ID );

2614:
2615:
2616: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2617: IF l_debug_on THEN
2618: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_DELIVERY_DETAILS_ACTIONS.ASSIGN_DETAIL_TO_DELIVERY FOR '||P_LINE_ROWS ( I ) || ' TO '||L_DELIVERY_ID );
2619: END IF;
2620: --
2621: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2622: IF l_debug_on THEN

Line 2623: WSH_DEBUG_SV.logmsg(l_module_name, 'PROC WSH_DELIVERY_DETAILS_ACTIONS.ASSIGN_DETAIL_TO_DELIVERY RETURNED UNEXPECTED ERROR' );

2619: END IF;
2620: --
2621: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2622: IF l_debug_on THEN
2623: WSH_DEBUG_SV.logmsg(l_module_name, 'PROC WSH_DELIVERY_DETAILS_ACTIONS.ASSIGN_DETAIL_TO_DELIVERY RETURNED UNEXPECTED ERROR' );
2624: END IF;
2625: --
2626: raise others;
2627: ELSE

Line 2629: WSH_DEBUG_SV.logmsg(l_module_name, 'PROC WSH_DELIVERY_DETAILS_ACTIONS.ASSIGN_DETAIL_TO_DELIVERY RETURNED ERROR' );

2625: --
2626: raise others;
2627: ELSE
2628: IF l_debug_on THEN
2629: WSH_DEBUG_SV.logmsg(l_module_name, 'PROC WSH_DELIVERY_DETAILS_ACTIONS.ASSIGN_DETAIL_TO_DELIVERY RETURNED ERROR' );
2630: END IF;
2631: raise e_return_excp; -- LPN CONV. rv
2632: END IF;
2633:

Line 3096: FROM wsh_delivery_details

3092: ELSE
3093: FOR i in 1..p_line_rows.count LOOP
3094: SELECT organization_id
3095: INTO l_line_warehouse_ids(i).warehouse_id
3096: FROM wsh_delivery_details
3097: WHERE delivery_detail_id = p_line_rows(i);
3098: l_line_warehouse_ids(i).line_id := p_line_rows(i);
3099: END LOOP;
3100: END IF;

Line 3557: UPDATE wsh_delivery_details wdd

3553: IF (p_delivery_ids.count > 0) THEN
3554: -- Bug 2543667 : Grouping Attributes of LPN are retained after backordering at Pick Release
3555: -- Empty Containers should not have any grouping attributes
3556: FORALL l_counter in INDICES OF p_delivery_ids
3557: UPDATE wsh_delivery_details wdd
3558: SET wdd.customer_id = NULL,
3559: wdd.ship_to_location_id = NULL,
3560: wdd.intmed_ship_to_location_id = NULL,
3561: wdd.fob_code = NULL,

Line 3576: FROM wsh_delivery_details wdd1 ,

3572: SELECT wda1.delivery_detail_id
3573: FROM wsh_delivery_assignments_v wda1
3574: START WITH wda1.delivery_detail_id in (
3575: SELECT wda2.delivery_detail_id
3576: FROM wsh_delivery_details wdd1 ,
3577: wsh_delivery_assignments_v wda2
3578: WHERE wda2.delivery_id = p_delivery_ids(l_counter)
3579: AND wda2.delivery_detail_id = wdd1.delivery_detail_id
3580: AND wdd1.container_flag = 'N')

Line 3592: WSH_DEBUG_SV.logmsg(l_module_name, 'UPDATED '||SQL%ROWCOUNT||' RECORDS IN WSH_DELIVERY_DETAILS' );

3588: --
3589: -- Debug Statements
3590: --
3591: IF l_debug_on THEN
3592: WSH_DEBUG_SV.logmsg(l_module_name, 'UPDATED '||SQL%ROWCOUNT||' RECORDS IN WSH_DELIVERY_DETAILS' );
3593: END IF;
3594: --
3595: -- LPN CONV. rv
3596: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

Line 3840: WSH_DELIVERY_DETAILS_ACTIONS.Delete_Consol_Record(

3836: PARENT_DELIVERY_DETAIL_ID = NULL
3837: WHERE DELIVERY_DETAIL_ID = l_del_det_id_tbl(l_counter);
3838:
3839: -- MDC: Delete the consol record, if exists.
3840: WSH_DELIVERY_DETAILS_ACTIONS.Delete_Consol_Record(
3841: p_detail_id_tab => l_del_det_id_tbl,
3842: x_return_status => x_return_status);
3843:
3844:

Line 3858: FROM wsh_delivery_details wdd ,

3854: SELECT wda1.delivery_detail_id
3855: FROM wsh_delivery_assignments wda1
3856: START WITH wda1.delivery_detail_id in (
3857: SELECT wda2.delivery_detail_id
3858: FROM wsh_delivery_details wdd ,
3859: wsh_delivery_assignments wda2
3860: WHERE wda2.delivery_id = wda.delivery_id
3861: AND wda2.delivery_detail_id = wdd.delivery_detail_id
3862: AND wdd.container_flag = 'N')