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 230: FROM wsh_delivery_details wdd,

226: wdd.container_flag,
227: NULL,
228: NULL,
229: NULL -- X-dock, is_xdocked_flag
230: FROM wsh_delivery_details wdd,
231: wsh_delivery_assignments_v wda
232: WHERE wdd.delivery_detail_id = p_dd_id AND
233: wdd.released_status <> 'D'AND
234: wda.delivery_detail_id = wdd.delivery_detail_id;

Line 1101: FROM wsh_delivery_details

1097: = nvl(d.organization_id, -1);
1098:
1099: CURSOR c_check_lpn(p_delivery_detail_id IN NUMBER) IS
1100: SELECT container_flag, organization_id, ship_from_location_id, customer_id
1101: FROM wsh_delivery_details
1102: WHERE delivery_detail_id = p_delivery_detail_id;
1103:
1104: l_container_flag VARCHAR2(1);
1105: l_organization_id NUMBER;

Line 1782: FROM wsh_delivery_details

1778:
1779: /* Bug 3206620 : cursor to get the container flag of the delivery detail*/
1780: cursor c_cont (p_entity_id NUMBER) is
1781: SELECT container_flag
1782: FROM wsh_delivery_details
1783: WHERE delivery_detail_id = p_entity_id;
1784:
1785: cursor c_matching_delivery(p_hash_value in number,
1786: p_hash_string in varchar2,

Line 2359: wsh_delivery_details_actions.assign_detail_to_delivery(

2355:
2356: END IF; --}
2357: -- 5415196 end
2358:
2359: wsh_delivery_details_actions.assign_detail_to_delivery(
2360: p_detail_id => l_attr_tab(i).entity_id,
2361: p_delivery_id => l_delivery_tab(l_attr_tab(i).group_id),
2362: x_return_status => x_return_status,
2363: p_caller => 'AUTOCREATE'); --bug 5100229

Line 2368: 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 );

2364:
2365:
2366: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2367: IF l_debug_on THEN
2368: 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 );
2369: END IF;
2370: --
2371: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2372: IF l_debug_on THEN

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

2369: END IF;
2370: --
2371: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2372: IF l_debug_on THEN
2373: WSH_DEBUG_SV.logmsg(l_module_name, 'PROC WSH_DELIVERY_DETAILS_ACTIONS.ASSIGN_DETAIL_TO_DELIVERY RETURNED UNEXPECTED ERROR' );
2374: END IF;
2375: --
2376: raise others;
2377: ELSE

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

2375: --
2376: raise others;
2377: ELSE
2378: IF l_debug_on THEN
2379: WSH_DEBUG_SV.logmsg(l_module_name, 'PROC WSH_DELIVERY_DETAILS_ACTIONS.ASSIGN_DETAIL_TO_DELIVERY RETURNED ERROR' );
2380: END IF;
2381: raise e_return_excp; -- LPN CONV. rv
2382: END IF;
2383:

Line 2846: FROM wsh_delivery_details

2842: ELSE
2843: FOR i in 1..p_line_rows.count LOOP
2844: SELECT organization_id
2845: INTO l_line_warehouse_ids(i).warehouse_id
2846: FROM wsh_delivery_details
2847: WHERE delivery_detail_id = p_line_rows(i);
2848: l_line_warehouse_ids(i).line_id := p_line_rows(i);
2849: END LOOP;
2850: END IF;

Line 3299: UPDATE wsh_delivery_details wdd

3295: IF (p_delivery_ids.count > 0) THEN
3296: -- Bug 2543667 : Grouping Attributes of LPN are retained after backordering at Pick Release
3297: -- Empty Containers should not have any grouping attributes
3298: FORALL l_counter in INDICES OF p_delivery_ids
3299: UPDATE wsh_delivery_details wdd
3300: SET wdd.customer_id = NULL,
3301: wdd.ship_to_location_id = NULL,
3302: wdd.intmed_ship_to_location_id = NULL,
3303: wdd.fob_code = NULL,

Line 3317: FROM wsh_delivery_details wdd1 ,

3313: SELECT wda1.delivery_detail_id
3314: FROM wsh_delivery_assignments_v wda1
3315: START WITH wda1.delivery_detail_id in (
3316: SELECT wda2.delivery_detail_id
3317: FROM wsh_delivery_details wdd1 ,
3318: wsh_delivery_assignments_v wda2
3319: WHERE wda2.delivery_id = p_delivery_ids(l_counter)
3320: AND wda2.delivery_detail_id = wdd1.delivery_detail_id
3321: AND wdd1.container_flag = 'N')

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

3329: --
3330: -- Debug Statements
3331: --
3332: IF l_debug_on THEN
3333: WSH_DEBUG_SV.logmsg(l_module_name, 'UPDATED '||SQL%ROWCOUNT||' RECORDS IN WSH_DELIVERY_DETAILS' );
3334: END IF;
3335: --
3336: -- LPN CONV. rv
3337: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

Line 3581: WSH_DELIVERY_DETAILS_ACTIONS.Delete_Consol_Record(

3577: PARENT_DELIVERY_DETAIL_ID = NULL
3578: WHERE DELIVERY_DETAIL_ID = l_del_det_id_tbl(l_counter);
3579:
3580: -- MDC: Delete the consol record, if exists.
3581: WSH_DELIVERY_DETAILS_ACTIONS.Delete_Consol_Record(
3582: p_detail_id_tab => l_del_det_id_tbl,
3583: x_return_status => x_return_status);
3584:
3585:

Line 3599: FROM wsh_delivery_details wdd ,

3595: SELECT wda1.delivery_detail_id
3596: FROM wsh_delivery_assignments wda1
3597: START WITH wda1.delivery_detail_id in (
3598: SELECT wda2.delivery_detail_id
3599: FROM wsh_delivery_details wdd ,
3600: wsh_delivery_assignments wda2
3601: WHERE wda2.delivery_id = wda.delivery_id
3602: AND wda2.delivery_detail_id = wdd.delivery_detail_id
3603: AND wdd.container_flag = 'N')