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_DELIVERY_DETAILS

Line 127: FROM wsh_delivery_details wdd,

123: -- with a particular SF location ID
124: --
125: SELECT 1
126: INTO l_query_count
127: FROM wsh_delivery_details wdd,
128: wsh_locations wl
129: WHERE wdd.ship_from_location_id = wl.wsh_location_id
130: AND wl.source_location_id = get_party_site_rec.location_id
131: AND wdd.party_id = p_party_id

Line 957: FROM wsh_delivery_details

953: IN ( SELECT delivery_id
954: FROM wsh_delivery_assignments
955: WHERE delivery_detail_id
956: IN ( SELECT delivery_detail_id
957: FROM wsh_delivery_details
958: WHERE source_code = 'PO'
959: AND vendor_id = p_from_id
960: AND ship_from_site_id = p_from_site_id
961: AND source_header_id

Line 1546: wsh_delivery_details d,

1542: CURSOR check_po IS
1543: SELECT w.delivery_id,
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'

Line 1584: wsh_delivery_details wdd,

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
1588: AND wdd.delivery_detail_id = wda.delivery_detail_id

Line 1613: wsh_delivery_details wdd

1609:
1610: CURSOR check_temp (p_delivery_id NUMBER) IS
1611: SELECT parent_delivery_detail_id
1612: FROM wsh_wms_sync_tmp wwst,
1613: wsh_delivery_details wdd
1614: WHERE wwst.delivery_id = p_delivery_id
1615: AND wwst.temp_col IS NOT NULL
1616: AND operation_type = 'VENDOR_MRG'
1617: AND wdd.delivery_detail_id = wwst.delivery_detail_id

Line 1641: FROM wsh_delivery_details wdd,

1637: wth.receipt_number rr_number,
1638: wth.revision_number,
1639: wnd.ultimate_dropoff_location_id,
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

Line 1867: UPDATE wsh_delivery_details

1863: END IF;
1864:
1865: --
1866: FORALL j IN l_dd_list.FIRST..l_dd_list.LAST
1867: UPDATE wsh_delivery_details
1868: SET vendor_id = p_to_id,
1869: ship_from_site_id = p_to_site_id,
1870: party_id = p_to_party_id,
1871: last_update_date = sysdate,

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

1888: --}
1889: END IF;
1890: IF l_debug_on THEN
1891: --{
1892: WSH_DEBUG_SV.logmsg(l_module_name,'Updated wsh_delivery_details. Number of Rows updated is ' || sql%rowcount, WSH_DEBUG_SV.C_STMT_LEVEL);
1893: --}
1894: END IF;
1895:
1896: --}

Line 2159: UPDATE wsh_delivery_details

2155: IF l_debug_on THEN
2156: wsh_debug_sv.log(l_module_name, 'Updating vendor info. on containers assigned to delivery', l_chk_delivery_id);
2157: END IF;
2158: --
2159: UPDATE wsh_delivery_details
2160: SET vendor_id = p_to_id,
2161: party_id = p_to_party_id,
2162: last_update_date = sysdate,
2163: last_updated_by = fnd_global.user_id,

Line 2406: UPDATE wsh_delivery_details

2402: wsh_debug_sv.log(l_module_name, 'WDD ID to update', l_dlvy_rr_rec.delivery_detail_id);
2403: wsh_debug_sv.log(l_module_name, 'Routing Req ID to update with', l_new_rr_id);
2404: END IF;
2405: --
2406: UPDATE wsh_delivery_details
2407: SET routing_req_Id = l_new_rr_id,
2408: last_update_date = sysdate,
2409: last_updated_by = fnd_global.user_id,
2410: last_update_login = fnd_global.login_id

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

2411: WHERE delivery_detail_id = l_dlvy_rr_rec.delivery_detail_id;
2412: --
2413: IF l_debug_on THEN
2414: --{
2415: WSH_DEBUG_SV.logmsg(l_module_name,'Updated wsh_delivery_details. Number of Rows updated is ' || sql%rowcount, WSH_DEBUG_SV.C_STMT_LEVEL);
2416: --}
2417: END IF;
2418:
2419: l_prev_old_rr_id := l_dlvy_rr_rec.routing_req_id;

Line 3055: -- Code is similar to WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_From_Cont

3051: -- p_volume array of volume
3052: -- x_return_status Returns the status of call
3053: --
3054: -- COMMENT :
3055: -- Code is similar to WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_From_Cont
3056: -- when p_entity_type is 'CONT'
3057: -- Code is similar to WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_From_Delivery
3058: -- when p_entity_type is 'DEL-CONT'
3059: -----------------------------------------------------------------------------------------

Line 3057: -- Code is similar to WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_From_Delivery

3053: --
3054: -- COMMENT :
3055: -- Code is similar to WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_From_Cont
3056: -- when p_entity_type is 'CONT'
3057: -- Code is similar to WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_From_Delivery
3058: -- when p_entity_type is 'DEL-CONT'
3059: -----------------------------------------------------------------------------------------
3060:
3061: PROCEDURE Adjust_Weight_Volume (

Line 3210: -- Code is similar to WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_From_Cont

3206: -- p_volume_uom array of volume UOM code
3207: -- x_return_status Returns the status of call
3208: --
3209: -- COMMENT :
3210: -- Code is similar to WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_From_Cont
3211: -- when p_entity_type is 'CONT'
3212: -- Code is similar to WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_From_Delivery
3213: -- when p_entity_type is 'DEL-CONT'
3214: -- ===============================================================================

Line 3212: -- Code is similar to WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_From_Delivery

3208: --
3209: -- COMMENT :
3210: -- Code is similar to WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_From_Cont
3211: -- when p_entity_type is 'CONT'
3212: -- Code is similar to WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_From_Delivery
3213: -- when p_entity_type is 'DEL-CONT'
3214: -- ===============================================================================
3215: PROCEDURE Adjust_Parent_WV (
3216: p_entity_type IN VARCHAR2,

Line 3394: wsh_delivery_details wdd,

3390: wdd.gross_weight, wdd.net_weight, wdd.volume,
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

Line 3417: wsh_delivery_details wdd,

3413: c_party_site_id NUMBER,
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

Line 3439: wsh_delivery_details wdd,

3435: wdd.inventory_item_id,wdd.organization_id,
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'

Line 3457: Wsh_delivery_details det

3453: AND wnd.delivery_id = tmp.column1
3454: AND EXISTS
3455: ( SELECT 'x'
3456: FROM wsh_delivery_assignments assgn,
3457: Wsh_delivery_details det
3458: WHERE det.container_flag = 'N'
3459: AND det.delivery_detail_id = assgn.delivery_detail_id
3460: AND assgn.delivery_id = wnd.delivery_id
3461: AND det.ship_to_location_id = wnd.ultimate_dropoff_location_id )

Line 3466: FROM wsh_delivery_details wdd,

3462: FOR UPDATE OF WDA.DELIVERY_DETAIL_ID NOWAIT;
3463:
3464: CURSOR get_delivery_containers IS
3465: SELECT wdd.rowid
3466: FROM wsh_delivery_details wdd,
3467: wsh_delivery_assignments wda,
3468: wsh_tmp tmp
3469: WHERE wdd.container_flag = 'Y'
3470: AND wdd.delivery_detail_id = wda.parent_delivery_detail_id

Line 3517: from wsh_delivery_details

3513: select 'x'
3514: from dual
3515: where exists (
3516: select 1
3517: from wsh_delivery_details
3518: where consignee_flag = 'V'
3519: and customer_id = c_vendor_id);
3520:
3521: CURSOR c_check_vendor_wnd (c_vendor_id NUMBER) IS

Line 3680: UPDATE wsh_delivery_details

3676: IF l_debug_on THEN
3677: WSH_DEBUG_SV.log(l_module_name, 'l_delivery_id.count', l_delivery_id.count);
3678: END IF;
3679: FORALL I IN l_delivery_id.first..l_delivery_id.last
3680: UPDATE wsh_delivery_details
3681: SET customer_id = decode(customer_id,
3682: p_from_vendor_id, p_to_vendor_id,
3683: customer_id),
3684: ship_to_site_use_id = decode(container_flag,

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

3696: WHERE delivery_id = l_delivery_id(i) );
3697:
3698: l_sql_count := SQL%rowcount;
3699: IF l_debug_on THEN
3700: WSH_DEBUG_SV.logmsg(l_module_name,'Updated wsh_delivery_details. Number of Rows updated is ' || l_sql_count, WSH_DEBUG_SV.C_STMT_LEVEL);
3701: END IF;
3702: EXIT WHEN l_delivery_id.count < G_LIMIT;
3703: END LOOP;
3704: CLOSE get_shipped_details;

Line 3731: UPDATE wsh_delivery_details

3727: WSH_DEBUG_SV.log(l_module_name, 'l_wdd_rowid.count', l_wdd_rowid.count);
3728: END IF;
3729:
3730: FORALL I IN l_wdd_rowid.first..l_wdd_rowid.last
3731: UPDATE wsh_delivery_details
3732: SET customer_id = decode(customer_id,
3733: p_from_vendor_id, p_to_vendor_id,
3734: customer_id),
3735: ship_to_site_use_id = l_to_party_site_use_id,

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

3742: program_update_date = SYSDATE
3743: WHERE ROWID = l_wdd_rowid(i);
3744: l_sql_count := SQL%rowcount;
3745: IF l_debug_on THEN
3746: WSH_DEBUG_SV.logmsg(l_module_name,'Updated wsh_delivery_details. Number of Rows updated is ' || l_sql_count, WSH_DEBUG_SV.C_STMT_LEVEL);
3747: END IF;
3748: -- Unpack delivery lines if it is packed but not yet assigned to delivery
3749:
3750: -- Start:

Line 4161: UPDATE wsh_delivery_details

4157: IF l_debug_on THEN
4158: WSH_DEBUG_SV.log(l_module_name, 'l_wdd_rowid.count', l_wdd_rowid.count);
4159: END IF;
4160: FORALL I IN l_wdd_rowid.FIRST..l_wdd_rowid.LAST
4161: UPDATE wsh_delivery_details
4162: SET customer_id = decode(customer_id,
4163: p_from_vendor_id, p_to_vendor_id,
4164: customer_id),
4165: ship_to_location_id = l_to_location_id,

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

4171: program_update_date = SYSDATE
4172: WHERE ROWID = l_wdd_rowid(i);
4173: l_sql_count := SQL%rowcount;
4174: IF l_debug_on THEN
4175: WSH_DEBUG_SV.logmsg(l_module_name,'Updated wsh_delivery_details (Containers). Number of Rows updated is ' || l_sql_count, WSH_DEBUG_SV.C_STMT_LEVEL);
4176: END IF;
4177:
4178: EXIT WHEN l_wdd_rowid.count < G_LIMIT;
4179: