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

Line 930: UPDATE wsh_new_deliveries

926:
927:
928: IF (p_delivery_id IS NOT NULl) THEN
929: --{
930: UPDATE wsh_new_deliveries
931: SET vendor_id = p_to_id,
932: party_id = p_to_party_id,
933: last_update_date = sysdate,
934: last_updated_by = fnd_global.user_id,

Line 940: WSH_DEBUG_SV.logmsg(l_module_name,'Updated wsh_new_deliveries. Number of Rows updated is ' || sql%rowcount, WSH_DEBUG_SV.C_STMT_LEVEL);

936: WHERE delivery_id = p_delivery_id
937: RETURNING name INTO l_dlvy_name;
938: IF l_debug_on THEN
939: --{
940: WSH_DEBUG_SV.logmsg(l_module_name,'Updated wsh_new_deliveries. Number of Rows updated is ' || sql%rowcount, WSH_DEBUG_SV.C_STMT_LEVEL);
941: --}
942: END IF;
943:
944: ELSE

Line 946: UPDATE wsh_new_deliveries

942: END IF;
943:
944: ELSE
945:
946: UPDATE wsh_new_deliveries
947: SET vendor_id = p_to_id,
948: party_id = p_to_party_id,
949: last_update_date = sysdate,
950: last_updated_by = fnd_global.user_id,

Line 971: WSH_DEBUG_SV.logmsg(l_module_name,'Updated wsh_new_deliveries. Number of Rows updated is ' || sql%rowcount, WSH_DEBUG_SV.C_STMT_LEVEL);

967: )
968: AND vendor_id = p_from_id;
969: IF l_debug_on THEN
970: --{
971: WSH_DEBUG_SV.logmsg(l_module_name,'Updated wsh_new_deliveries. Number of Rows updated is ' || sql%rowcount, WSH_DEBUG_SV.C_STMT_LEVEL);
972: --}
973: END IF;
974: --}
975: END IF;

Line 1548: Wsh_new_deliveries wnd

1544: d.delivery_detail_id
1545: FROM po_headers_all p,
1546: wsh_delivery_details d,
1547: wsh_delivery_assignments w,
1548: Wsh_new_deliveries wnd
1549: WHERE p.vendor_id = p_to_id
1550: AND d.source_code = 'PO'
1551: AND p.po_header_id = d.source_header_id
1552: AND p.vendor_site_id = p_to_site_id

Line 1583: FROM wsh_new_deliveries wnd,

1579: wnd.status_code,
1580: wnd.routing_response_id,
1581: wnd.name,
1582: wnd.ultimate_dropoff_location_id
1583: FROM wsh_new_deliveries wnd,
1584: wsh_delivery_details wdd,
1585: wsh_delivery_assignments wda
1586: WHERE wnd.delivery_id = p_del_id
1587: AND wnd.delivery_id = wda.delivery_id

Line 1644: wsh_new_deliveries wnd

1640: wnd.name
1641: FROM wsh_delivery_details wdd,
1642: wsh_delivery_assignments wda ,
1643: wsh_inbound_txn_history wth,
1644: wsh_new_deliveries wnd
1645: WHERE wda.delivery_id = p_delivery_id
1646: AND nvl(wda.type,'S') IN ('S','O')
1647: AND wda.delivery_detail_Id = wdd.delivery_detail_id
1648: AND wdd.routing_req_id = wth.transaction_id

Line 1690: l_dlvy_rr_tbl wsh_new_deliveries_pvt.Delivery_Attr_Tbl_Type;

1686: --
1687:
1688: l_delivery_cache_tbl wsh_util_core.id_tab_type;
1689: l_dlvy_rr_cache_tbl wsh_util_core.id_tab_type;
1690: l_dlvy_rr_tbl wsh_new_deliveries_pvt.Delivery_Attr_Tbl_Type;
1691: l_dlvy_tbl wsh_util_core.id_tab_type;
1692: l_chk_delivery_id NUMBER :=0;
1693: l_prev_new_rr_id NUMBER :=0;
1694: l_site_merge BOOLEAN;

Line 2004: --Update WSH_NEW_DELIVERIES with the merge to vendor

2000: );
2001:
2002: l_chk_delivery_id := l_new_delivery_id;
2003:
2004: --Update WSH_NEW_DELIVERIES with the merge to vendor
2005: IF l_debug_on THEN
2006: --{
2007: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_VENDOR_PARTY_MERGE_PKG.UPDATE_NEW_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
2008: --}

Line 2095: FROM wsh_new_deliveries

2091: --
2092: SELECT initial_pickup_location_id, routing_response_id,
2093: name, status_code
2094: INTO l_location_id, l_routing_response_id, l_dlvy_name, l_dlvy_status_code
2095: FROM wsh_new_deliveries
2096: WHERE delivery_id = l_delivery_rec.delivery_id;
2097: --
2098: --Update WSH_NEW_DELIVERIES with the merge to vendor
2099: IF l_debug_on THEN

Line 2098: --Update WSH_NEW_DELIVERIES with the merge to vendor

2094: INTO l_location_id, l_routing_response_id, l_dlvy_name, l_dlvy_status_code
2095: FROM wsh_new_deliveries
2096: WHERE delivery_id = l_delivery_rec.delivery_id;
2097: --
2098: --Update WSH_NEW_DELIVERIES with the merge to vendor
2099: IF l_debug_on THEN
2100: --{
2101: --wsh_debug_sv.log(l_module_name, 'l_dup', l_dup);
2102: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_VENDOR_PARTY_MERGE_PKG.UPDATE_NEW_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 2472: FROM wsh_new_deliveries

2468: l_dlvy_rr_tbl(l_respIndex).delivery_id := l_dlvy_rr_cache_tbl( l_cache_index );
2469: --
2470: SELECT organization_id
2471: INTO l_dlvy_rr_tbl(l_respIndex).organization_id
2472: FROM wsh_new_deliveries
2473: WHERE delivery_id = l_dlvy_rr_tbl(l_respIndex).delivery_id;
2474: --
2475: l_cache_index := l_dlvy_rr_cache_tbl.Next( l_cache_index );
2476: --}

Line 3395: wsh_new_deliveries wnd,

3391: wdd.weight_uom_code,wdd.volume_uom_code,
3392: wda.parent_delivery_detail_id, wda.delivery_id, wts.stop_id
3393: FROM wsh_delivery_assignments wda,
3394: wsh_delivery_details wdd,
3395: wsh_new_deliveries wnd,
3396: wsh_delivery_legs wdl,
3397: wsh_trip_stops wts
3398: WHERE wts.stop_id (+) = wdl.drop_off_stop_id
3399: AND wdl.delivery_id (+) = wnd.delivery_id

Line 3418: wsh_new_deliveries wnd

3414: c_location_id NUMBER ) IS
3415: SELECT wda.delivery_id
3416: FROM wsh_delivery_assignments wda,
3417: wsh_delivery_details wdd,
3418: wsh_new_deliveries wnd
3419: WHERE wnd.status_code IN ( 'CO', 'IT', 'CL' )
3420: AND wnd.delivery_id = wda.delivery_id
3421: AND wda.delivery_detail_id = wdd.delivery_detail_id
3422: AND wdd.source_code = 'RTV'

Line 3440: wsh_new_deliveries wnd,

3436: wdd.gross_weight, wdd.net_weight, wdd.volume,
3437: wdd.weight_uom_code,wdd.volume_uom_code
3438: FROM wsh_delivery_assignments wda,
3439: wsh_delivery_details wdd,
3440: wsh_new_deliveries wnd,
3441: wsh_tmp tmp
3442: WHERE wdd.container_flag = 'N'
3443: AND wdd.source_code = 'RTV'
3444: AND wdd.released_status = 'X'

Line 3479: wsh_new_deliveries wnd,

3475: CURSOR get_unassign_stops ( c_to_location_id NUMBER) IS
3476: SELECT wdl.rowid, tmp.rowid, wnd.delivery_id, wdl.delivery_leg_id, wts.trip_id,
3477: wts.stop_id, wnd.gross_weight, wnd.net_weight, wnd.volume
3478: FROM wsh_delivery_legs wdl,
3479: wsh_new_deliveries wnd,
3480: Wsh_trip_stops wts,
3481: wsh_tmp tmp
3482: WHERE wnd.ultimate_dropoff_location_id = c_to_location_id
3483: AND wts.stop_id = wdl.drop_off_stop_id

Line 3488: FROM wsh_new_deliveries del,

3484: AND wdl.delivery_id = wnd.delivery_id
3485: AND wnd.delivery_id = tmp.column1
3486: AND EXISTS
3487: ( SELECT 'x'
3488: FROM wsh_new_deliveries del,
3489: wsh_delivery_legs legs
3490: WHERE del.ultimate_dropoff_location_id <> c_to_location_id
3491: AND del.delivery_id = legs.delivery_id
3492: AND legs.drop_off_stop_id = wdl.drop_off_stop_id );

Line 3501: FROM wsh_new_deliveries wnd

3497: wnd.intmed_ship_to_location_id,wnd.fob_code,wnd.freight_terms_code,
3498: wnd.ship_method_code,wnd.carrier_id,wnd.source_header_id,wnd.organization_id,
3499: wnd.initial_pickup_date,wnd.ultimate_dropoff_date,wnd.ignore_for_planning,
3500: wnd.shipment_direction,wnd.shipping_control,wnd.party_id,wnd.client_id
3501: FROM wsh_new_deliveries wnd
3502: WHERE nvl(Wnd.Customer_Id, c_vendor_id) = c_vendor_id
3503: AND nvl(wnd.consignee_flag, 'C') = 'V'
3504: AND Wnd.Ultimate_Dropoff_Location_Id = c_location_id
3505: AND Wnd.Status_Code = 'OP'

Line 3526: from wsh_new_deliveries

3522: select 'x'
3523: from dual
3524: where exists (
3525: select 1
3526: from wsh_new_deliveries
3527: where consignee_flag = 'V'
3528: and customer_id = c_vendor_id);
3529:
3530: l_from_location_id NUMBER;

Line 4215: UPDATE wsh_new_deliveries

4211: WSH_DEBUG_SV.log(l_module_name, 'l_delivery_id_tab.count', l_delivery_id_tab.count);
4212: END IF;
4213:
4214: FORALL I IN l_delivery_id_tab.first..l_delivery_id_tab.last
4215: UPDATE wsh_new_deliveries
4216: SET customer_id = decode(customer_id,
4217: p_from_vendor_id, p_to_vendor_id,
4218: customer_id ),
4219: ultimate_dropoff_location_id = l_to_location_id,

Line 4231: WSH_DEBUG_SV.logmsg(l_module_name,'Updated wsh_new_deliveries. Number of Rows updated is ' || l_sql_count, WSH_DEBUG_SV.C_STMT_LEVEL);

4227: program_update_date = SYSDATE
4228: WHERE delivery_id = l_delivery_id_tab(i);
4229: l_sql_count := SQL%rowcount;
4230: IF l_debug_on THEN
4231: WSH_DEBUG_SV.logmsg(l_module_name,'Updated wsh_new_deliveries. Number of Rows updated is ' || l_sql_count, WSH_DEBUG_SV.C_STMT_LEVEL);
4232: END IF;
4233: -- Update deliveries
4234: -- END
4235:

Line 4419: UPDATE wsh_new_deliveries

4415: WSH_DEBUG_SV.log(l_module_name, 'l_delivery_id.count', l_delivery_id.count);
4416: END IF;
4417:
4418: FORALL I IN l_delivery_id.first..l_delivery_id.last
4419: UPDATE wsh_new_deliveries
4420: SET customer_id = decode(customer_id,
4421: p_from_vendor_id, p_to_vendor_id,
4422: customer_id ),
4423: ultimate_dropoff_location_id = l_to_location_id,

Line 4436: WSH_DEBUG_SV.logmsg(l_module_name,'Updated wsh_new_deliveries(Empty deliveries). Number of Rows updated is ' || l_sql_count, WSH_DEBUG_SV.C_STMT_LEVEL);

4432: WHERE delivery_id = l_delivery_id(i);
4433:
4434: l_sql_count := SQL%rowcount;
4435: IF l_debug_on THEN
4436: WSH_DEBUG_SV.logmsg(l_module_name,'Updated wsh_new_deliveries(Empty deliveries). Number of Rows updated is ' || l_sql_count, WSH_DEBUG_SV.C_STMT_LEVEL);
4437: END IF;
4438:
4439: EXIT WHEN l_delivery_id.count < G_LIMIT;
4440: END LOOP;