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_PARTY_MERGE dependencies on WSH_DELIVERY_DETAILS

Line 548: FROM wsh_delivery_details wdd,

544: -- with a particular SF location ID
545: --
546: SELECT 1
547: INTO l_query_count
548: FROM wsh_delivery_details wdd,
549: hz_party_Sites hps,
550: wsh_locations wl
551: WHERE hps.party_site_id = p_from_fk_id
552: AND wdd.ship_from_location_id = wl.wsh_location_id

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

902: --
903: -- COMMENT :
904: -- API to decrement the delivery detail weight from LPN/Delivery while
905: -- unassigning delivery line from LPN/Delivery
906: -- Code is similar to WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_From_Cont
907: -- when p_entity_type is 'CONT'
908: -- Code is similar to WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_From_Delivery
909: -- when p_entity_type is 'DEL-CONT'
910: -- ===============================================================================

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

904: -- API to decrement the delivery detail weight from LPN/Delivery while
905: -- unassigning delivery line from LPN/Delivery
906: -- Code is similar to WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_From_Cont
907: -- when p_entity_type is 'CONT'
908: -- Code is similar to WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_From_Delivery
909: -- when p_entity_type is 'DEL-CONT'
910: -- ===============================================================================
911: -- Bug 5606960# G-Log Changes: Removed Weight/Volume calculation while
912: -- unassigning delivery from Trip.

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

1072: -- x_return_status Returns the status of call
1073: --
1074: -- COMMENT :
1075: -- API to adjust the 'Fill Percent' if Percent Fill Basis is defined as Quantity.
1076: -- Code is similar to WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_From_Cont
1077: -- when p_entity_type is 'CONT'
1078: -- Code is similar to WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_From_Delivery
1079: -- when p_entity_type is 'DEL-CONT'
1080: -- ===============================================================================

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

1074: -- COMMENT :
1075: -- API to adjust the 'Fill Percent' if Percent Fill Basis is defined as Quantity.
1076: -- Code is similar to WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_From_Cont
1077: -- when p_entity_type is 'CONT'
1078: -- Code is similar to WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_From_Delivery
1079: -- when p_entity_type is 'DEL-CONT'
1080: -- ===============================================================================
1081: PROCEDURE Adjust_Parent_WV (
1082: p_entity_type IN VARCHAR2,

Line 1370: from wsh_delivery_details wdd,

1366: IS
1367: CURSOR C1
1368: IS
1369: SELECT DISTINCT wdd.organization_id
1370: from wsh_delivery_details wdd,
1371: wsh_delivery_assignments_v wda,
1372: hz_cust_acct_sites_all ca,
1373: hz_cust_site_uses_all su
1374: where wda.parent_delivery_detail_id is not null

Line 1388: from wsh_delivery_details wdd,

1384:
1385: CURSOR C2
1386: IS
1387: SELECT DISTINCT wdd.organization_id
1388: from wsh_delivery_details wdd,
1389: wsh_delivery_assignments_v wda,
1390: hz_cust_acct_sites_all ca,
1391: hz_cust_site_uses_all su
1392: where wda.parent_delivery_detail_id is not null

Line 1404: from wsh_delivery_details det,

1400: and su.cust_acct_site_id = ca.cust_acct_site_id
1401: and ca.party_site_id = p_party_site_id
1402: and exists
1403: ( select 'X'
1404: from wsh_delivery_details det,
1405: wsh_delivery_assignments_v asgn
1406: where det.ship_to_site_use_id <> wdd.ship_to_site_use_id
1407: and det.delivery_detail_id = asgn.delivery_detail_id
1408: and asgn.delivery_id = wda.delivery_id );

Line 1563: -- To update locations in Wsh_Delivery_Details, Wsh_New_Deliveries,

1559: -- that is being merged
1560: -- x_return_status Returns the status of call
1561: --
1562: -- COMMENT :
1563: -- To update locations in Wsh_Delivery_Details, Wsh_New_Deliveries,
1564: -- Wsh_Trip_Stops tables for Unshipped delivery lines during party
1565: -- merge. Also updates Wsh_Picking_Rules tables during party merge.
1566: -- ============================================================================
1567: PROCEDURE merge_location(

Line 1607: FROM WSH_DELIVERY_DETAILS WDD,

1603: Wda.Parent_Delivery_Detail_Id Parent_Delivery_Detail_Id,
1604: Wdd.Net_Weight, Wdd.Gross_Weight, Wdd.Volume,
1605: Wdd.Weight_Uom_code, Wdd.Volume_Uom_Code, Wdd.Inventory_Item_Id,
1606: Wdd.Organization_Id, WDA.Rowid Wda_Rowid
1607: FROM WSH_DELIVERY_DETAILS WDD,
1608: WSH_DELIVERY_ASSIGNMENTS_V WDA,
1609: WSH_NEW_DELIVERIES WND,
1610: WSH_DELIVERY_LEGS WDL,
1611: WSH_TRIP_STOPS WTS,

Line 1639: FROM WSH_DELIVERY_DETAILS WDD,

1635: Wdd.Net_Weight, Wdd.Gross_Weight, Wdd.Volume,
1636: Wdd.Weight_Uom_code, Wdd.Volume_Uom_Code, Wdd.Inventory_Item_Id,
1637: Wdd.Organization_Id, Wnd.Name Delivery_Name,
1638: Wdd.Move_Order_Line_Id, Wdd.Released_Status
1639: FROM WSH_DELIVERY_DETAILS WDD,
1640: WSH_DELIVERY_ASSIGNMENTS_V WDA,
1641: WSH_NEW_DELIVERIES WND,
1642: HZ_CUST_ACCT_SITES_ALL CA,
1643: HZ_CUST_SITE_USES_ALL SU

Line 1659: WSH_DELIVERY_DETAILS WDD1

1655: AND WND.Delivery_Id = WDA.Delivery_Id
1656: AND exists (
1657: SELECT 'x'
1658: FROM WSH_DELIVERY_ASSIGNMENTS_V WDA1,
1659: WSH_DELIVERY_DETAILS WDD1
1660: WHERE WDD1.DELIVERY_DETAIL_ID = WDA1.DELIVERY_DETAIL_ID
1661: AND WDD1.Container_Flag = 'N'
1662: AND WDA1.Delivery_Id = WND.Delivery_Id
1663: AND WDD1.Ship_To_Location_id = WND.Ultimate_Dropoff_Location_Id)

Line 1669: FROM Wsh_Delivery_Details Wdd,

1665:
1666: CURSOR Get_Delivery_Containers
1667: IS
1668: SELECT Wdd.Rowid
1669: FROM Wsh_Delivery_Details Wdd,
1670: Wsh_Delivery_Assignments_V Wda,
1671: Wsh_Tmp Tmp
1672: WHERE Wdd.container_flag = 'Y'
1673: AND NVL(WDD.Line_Direction, 'O') in ( 'O', 'IO' )

Line 1712: FROM WSH_DELIVERY_DETAILS WDD,

1708: -- different from ship_to_site_use_id.
1709: CURSOR Get_Deliver_Loc_Details ( p_party_site_id NUMBER, p_location_id NUMBER )
1710: IS
1711: SELECT WDD.Rowid
1712: FROM WSH_DELIVERY_DETAILS WDD,
1713: HZ_CUST_ACCT_SITES_ALL CA,
1714: HZ_CUST_SITE_USES_ALL SU
1715: WHERE SU.Cust_Acct_Site_Id = CA.Cust_Acct_Site_Id
1716: AND CA.Party_Site_Id = p_party_site_id

Line 1733: FROM WSH_DELIVERY_DETAILS WDD,

1729: WHERE WDA.Parent_Delivery_Detail_Id IS NOT NULL
1730: CONNECT BY PRIOR WDA.Parent_Delivery_Detail_Id = WDA.Delivery_Detail_Id
1731: START WITH wda.delivery_detail_id IN
1732: ( SELECT WDD.Delivery_Detail_Id
1733: FROM WSH_DELIVERY_DETAILS WDD,
1734: HZ_CUST_ACCT_SITES_ALL CA,
1735: HZ_CUST_SITE_USES_ALL SU
1736: WHERE SU.Cust_Acct_Site_Id = CA.Cust_Acct_Site_Id
1737: AND CA.Party_Site_Id = p_party_site_id

Line 2000: -- Update Ship_to_Location and Deliver_to_Location in Wsh_Delivery_Details

1996: WSH_DEBUG_SV.log(l_module_name, 'No of rows fetched from Get_Wsh_Details', l_del_detail_rowid_tab.COUNT);
1997: END IF;
1998: --
1999:
2000: -- Update Ship_to_Location and Deliver_to_Location in Wsh_Delivery_Details
2001: -- table during party merge.
2002:
2003: IF ( l_del_detail_rowid_tab.COUNT > 0 )
2004: THEN -- { WDD Update

Line 2006: UPDATE WSH_DELIVERY_DETAILS Wdd

2002:
2003: IF ( l_del_detail_rowid_tab.COUNT > 0 )
2004: THEN -- { WDD Update
2005: FORALL i IN l_del_detail_rowid_tab.FIRST..l_del_detail_rowid_tab.LAST
2006: UPDATE WSH_DELIVERY_DETAILS Wdd
2007: SET ship_to_location_id = l_to_location_id,
2008: deliver_to_location_id = decode( nvl(deliver_to_site_use_id, ship_to_site_use_id),
2009: ship_to_site_use_id, l_to_location_id,
2010: deliver_to_location_id ),

Line 2066: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_from_Cont (

2062: l_delivery_id_tab(unassignCnt) IS NULL )
2063: THEN
2064: l_return_status := NULL;
2065: -- Calling Standard api to unassign detail from container
2066: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_from_Cont (
2067: p_detail_id => l_del_detail_id_tab(unassignCnt),
2068: x_return_status => l_return_status );
2069:
2070: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,

Line 2250: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_from_delivery (

2246: FOR unassignDelCnt in l_del_detail_id_tab.FIRST..l_del_detail_id_tab.LAST
2247: LOOP
2248: l_return_status := NULL;
2249: -- Calling Standard api to unassign detail from delivery
2250: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_from_delivery (
2251: p_detail_id => l_del_detail_id_tab(unassignDelCnt),
2252: x_return_status => l_return_status );
2253:
2254: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,

Line 2375: UPDATE WSH_DELIVERY_DETAILS Wdd

2371:
2372: IF ( l_del_detail_rowid_tab.COUNT > 0 )
2373: THEN
2374: FORALL updCnt IN l_del_detail_rowid_tab.FIRST..l_del_detail_rowid_tab.LAST
2375: UPDATE WSH_DELIVERY_DETAILS Wdd
2376: SET ship_to_location_id = l_to_location_id,
2377: deliver_to_location_id = decode(deliver_to_location_id,
2378: ship_to_location_id, l_to_location_id,
2379: deliver_to_location_id),

Line 2680: -- Update Deliver to Locations in Wsh_Delivery_Details table during

2676: WSH_DEBUG_SV.log(l_module_name, 'No of Records Fetched from Get_Deliver_Loc_details', l_del_detail_rowid_tab.COUNT);
2677: END IF;
2678: --
2679:
2680: -- Update Deliver to Locations in Wsh_Delivery_Details table during
2681: -- party merge.
2682:
2683: IF ( l_del_detail_rowid_tab.COUNT > 0 )
2684: THEN -- { WDD Update

Line 2687: UPDATE WSH_DELIVERY_DETAILS Wdd

2683: IF ( l_del_detail_rowid_tab.COUNT > 0 )
2684: THEN -- { WDD Update
2685:
2686: FORALL i IN l_del_detail_rowid_tab.FIRST..l_del_detail_rowid_tab.LAST
2687: UPDATE WSH_DELIVERY_DETAILS Wdd
2688: SET deliver_to_location_id = l_to_location_id,
2689: last_update_date = SYSDATE,
2690: last_updated_by = fnd_global.user_id,
2691: last_update_login = fnd_global.conc_login_id,

Line 2724: -- Update Deliver to Locations in Wsh_Delivery_Details table during

2720: WSH_DEBUG_SV.log(l_module_name, 'No of Records Fetched from Get_Del_Loc_Cont_Details', l_del_detail_id_tab.COUNT);
2721: END IF;
2722: --
2723:
2724: -- Update Deliver to Locations in Wsh_Delivery_Details table during
2725: -- party merge for Container records.
2726: IF ( l_del_detail_id_tab.COUNT > 0 )
2727: THEN -- { WDD Cont Update
2728:

Line 2730: UPDATE WSH_DELIVERY_DETAILS Wdd

2726: IF ( l_del_detail_id_tab.COUNT > 0 )
2727: THEN -- { WDD Cont Update
2728:
2729: FORALL i IN l_del_detail_id_tab.FIRST..l_del_detail_id_tab.LAST
2730: UPDATE WSH_DELIVERY_DETAILS Wdd
2731: SET deliver_to_location_id = l_to_location_id,
2732: last_update_date = SYSDATE,
2733: last_updated_by = fnd_global.user_id,
2734: last_update_login = fnd_global.conc_login_id,