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_ASSIGNMENTS

Line 954: FROM wsh_delivery_assignments

950: last_updated_by = fnd_global.user_id,
951: last_update_login = fnd_global.login_id
952: WHERE delivery_id
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'

Line 1547: wsh_delivery_assignments w,

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'
1551: AND p.po_header_id = d.source_header_id

Line 1585: wsh_delivery_assignments wda

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
1589: AND wdd.ship_from_site_id <> p_from_site_id

Line 1642: wsh_delivery_assignments wda ,

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
1646: AND nvl(wda.type,'S') IN ('S','O')

Line 2170: FROM wsh_delivery_assignments

2166: AND vendor_id = p_from_id
2167: AND delivery_detail_id
2168: IN (
2169: SELECT delivery_detail_id
2170: FROM wsh_delivery_assignments
2171: WHERE nvl(type,'S') in ('S','O')
2172: AND delivery_id = l_chk_delivery_id
2173: );
2174: --

Line 3393: FROM wsh_delivery_assignments wda,

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

Line 3416: FROM wsh_delivery_assignments wda,

3412: CURSOR get_shipped_details ( c_from_vendor_id NUMBER,
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

Line 3438: FROM wsh_delivery_assignments wda,

3434: wda.parent_delivery_detail_id,
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'

Line 3456: FROM wsh_delivery_assignments assgn,

3452: AND wnd.status_code = 'OP'
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

Line 3467: wsh_delivery_assignments wda,

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
3471: AND wda.parent_delivery_detail_id IS NOT NULL

Line 3508: FROM wsh_delivery_assignments wda

3504: AND Wnd.Ultimate_Dropoff_Location_Id = c_location_id
3505: AND Wnd.Status_Code = 'OP'
3506: AND NOT EXISTS
3507: ( SELECT 'x'
3508: FROM wsh_delivery_assignments wda
3509: WHERE wda.delivery_id = wnd.delivery_id )
3510: FOR UPDATE NOWAIT;
3511:
3512: CURSOR c_check_vendor_wdd (c_vendor_id NUMBER) IS

Line 3695: FROM wsh_delivery_assignments wda

3691: program_id = fnd_global.conc_program_id,
3692: program_update_date = SYSDATE
3693: WHERE delivery_detail_id IN
3694: ( SELECT wda.delivery_detail_id
3695: FROM wsh_delivery_assignments wda
3696: WHERE delivery_id = l_delivery_id(i) );
3697:
3698: l_sql_count := SQL%rowcount;
3699: IF l_debug_on THEN

Line 3779: UPDATE wsh_delivery_assignments

3775: --
3776: END IF;
3777:
3778: FORALL I IN l_wda_rowid.first..l_wda_rowid.last
3779: UPDATE wsh_delivery_assignments
3780: SET parent_delivery_detail_id = NULL,
3781: last_update_date = SYSDATE,
3782: last_updated_by = fnd_global.user_id,
3783: last_update_login = fnd_global.conc_login_id,

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

3789: AND delivery_id IS NULL;
3790:
3791: l_sql_count := SQL%rowcount;
3792: IF l_debug_on THEN
3793: WSH_DEBUG_SV.logmsg(l_module_name,'Updated wsh_delivery_assignments. Number of Rows updated is ' || l_sql_count, WSH_DEBUG_SV.C_STMT_LEVEL);
3794: END IF;
3795:
3796: Adjust_Parent_WV (
3797: p_entity_type => 'CONT',

Line 3976: UPDATE wsh_delivery_assignments

3972: IF l_debug_on THEN
3973: WSH_DEBUG_SV.log(l_module_name, 'l_wda_rowid.count', l_wda_rowid.count);
3974: END IF;
3975: FORALL I IN l_wda_rowid.FIRST..l_wda_rowid.LAST
3976: UPDATE wsh_delivery_assignments
3977: SET parent_delivery_detail_id = NULL,
3978: delivery_id = NULL,
3979: last_update_date = SYSDATE,
3980: last_updated_by = fnd_global.user_id,

Line 3988: WSH_DEBUG_SV.logmsg(l_module_name,'Updated wsh_delivery_assignments(unassign n unpack from del). Number of Rows updated is ' || l_sql_count, WSH_DEBUG_SV.C_STMT_LEVEL);

3984: program_update_date = SYSDATE
3985: WHERE ROWID = l_wda_rowid(i);
3986: l_sql_count := SQL%rowcount;
3987: IF l_debug_on THEN
3988: WSH_DEBUG_SV.logmsg(l_module_name,'Updated wsh_delivery_assignments(unassign n unpack from del). Number of Rows updated is ' || l_sql_count, WSH_DEBUG_SV.C_STMT_LEVEL);
3989: END IF;
3990:
3991: Adjust_Parent_WV (
3992: p_entity_type => 'DEL-CONT',