DBA Data[Home] [Help]

APPS.WSH_INBOUND_UTIL_PKG dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 1290: wsh_delivery_assignments wda,

1286: IS
1287: SELECT wdd.delivery_detail_id,
1288: wda.parent_delivery_detail_id
1289: FROM wsh_delivery_details wdd,
1290: wsh_delivery_assignments wda,
1291: wsh_wms_sync_tmp wwst
1292: WHERE wwst.delivery_id = p_delivery_id
1293: AND nvl(wda.type,'S') IN ('S','O')
1294: AND wdd.delivery_detail_id = wda.delivery_detail_id

Line 1452: UPDATE wsh_delivery_assignments_v

1448: --
1449: -- Assign input lines to new delivery.
1450: --
1451: FORALL i IN p_delivery_detail_id_tbl.FIRST..p_delivery_detail_id_tbl.LAST
1452: UPDATE wsh_delivery_assignments_v
1453: SET delivery_id = l_delivery_id,
1454: last_update_date = SYSDATE,
1455: last_updated_by = FND_GLOBAL.USER_ID,
1456: last_update_login = FND_GLOBAL.LOGIN_ID

Line 1535: wsh_delivery_assignments wda

1531: --{
1532: SELECT wdd.delivery_detail_id
1533: INTO l_new_parent_wdd_id
1534: FROM wsh_delivery_Details wdd,
1535: wsh_delivery_assignments wda
1536: WHERE wda.delivery_id = l_delivery_id
1537: AND wda.delivery_detail_id = wdd.delivery_detail_id
1538: AND NVL(wda.type,'S') IN ('S','O')
1539: AND wdd.lpn_id = l_lpn_id;

Line 1555: UPDATE wsh_delivery_assignments

1551: IF l_new_parent_wdd_id IS NOT NULL THEN
1552: --{
1553: FORALL I in l_tmp_wdd_id_tbl.first..l_tmp_wdd_id_tbl.last
1554: --
1555: UPDATE wsh_delivery_assignments
1556: SET parent_delivery_detail_id = l_new_parent_wdd_id
1557: WHERE delivery_detail_id = l_tmp_wdd_id_tbl(i);
1558: --
1559: IF l_debug_on THEN

Line 1605: FROM wsh_delivery_assignments

1601: --}
1602: END IF; --IF l_new_parent_wdd_id IS NOT NULL
1603: --
1604: SELECT count(1) INTO l_query_count
1605: FROM wsh_delivery_assignments
1606: WHERE delivery_id = p_delivery_id
1607: AND parent_delivery_detail_id = l_parent_wdd_id
1608: AND nvl(type,'S') IN ('S','O');
1609: --

Line 1616: DELETE FROM wsh_delivery_assignments

1612: END IF;
1613: --
1614: IF l_query_count = 0 THEN
1615: --{
1616: DELETE FROM wsh_delivery_assignments
1617: WHERE delivery_detail_id = l_parent_wdd_id;
1618: --
1619: DELETE FROM wsh_delivery_details
1620: WHERE delivery_detail_id = l_parent_wdd_id;

Line 3412: wsh_delivery_assignments_v wda

3408:
3409: CURSOR get_routing_response IS
3410: SELECT wnd.routing_response_id
3411: FROM wsh_new_deliveries wnd,
3412: wsh_delivery_assignments_v wda
3413: WHERE wnd.delivery_id = wda.delivery_id
3414: AND wda.delivery_detail_id = p_delivery_detail_id
3415: AND wnd.routing_response_id IS NOT NULL;
3416: