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_TMP

Line 1242: -- deliveries(from wsh_tmp table) which are to be updated with new

1238: -- PROCEDURE : GET_DELIVERY_HASH
1239: --
1240: -- DESCRIPTION :
1241: -- Get_Delivery_Hash generates new hash value and hash string for
1242: -- deliveries(from wsh_tmp table) which are to be updated with new
1243: -- Customer/Location ids
1244: --
1245: -- PARAMETERS :
1246: -- p_delivery_id => Delivery Id for which Hash String to be generated

Line 1671: Wsh_Tmp Tmp

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' )
1674: AND Wdd.delivery_detail_id = Wda.Delivery_Detail_Id
1675: AND Wda.Delivery_Id = Tmp.Column1

Line 1690: Wsh_Tmp Tmp

1686: Wdl.Rowid, Tmp.Rowid
1687: FROM Wsh_Trip_Stops Wts,
1688: Wsh_New_Deliveries Wnd,
1689: Wsh_Delivery_Legs Wdl,
1690: Wsh_Tmp Tmp
1691: WHERE Wnd.Ultimate_DropOff_Location_Id = p_to_location_id
1692: AND nvl(Wnd.Shipment_Direction, 'O') in ( 'O', 'IO' )
1693: AND Wnd.Delivery_Id = Wdl.Delivery_Id
1694: AND Wts.Stop_Location_Id = p_from_location_id

Line 1754: FROM Wsh_Tmp wt,

1750: -- Bug 5606960# Cursor added for G-Log Changes
1751: CURSOR Get_Tmp_Deliveries
1752: IS
1753: SELECT wnd.delivery_id, wnd.rowid, to_number(wt.Column3) delivery_detail_id
1754: FROM Wsh_Tmp wt,
1755: Wsh_New_Deliveries Wnd
1756: WHERE Wnd.Delivery_Id = to_number(Wt.Column1);
1757:
1758: -- Create Pl/Sql table type for storing RowIds

Line 1903: DELETE FROM WSH_TMP;

1899: RETURN;
1900: END IF;
1901:
1902: -- Deleting records from from temp table before processing
1903: DELETE FROM WSH_TMP;
1904:
1905:
1906: --
1907: IF l_debug_on THEN

Line 2098: INSERT INTO wsh_tmp(column1, column2, column3)

2094: IF ( l_delivery_id_tab.COUNT > 0 ) THEN
2095: -- Inserting records in bulk into temp table for future reference during processing
2096: -- Dulplicate entries are avoided using NOT EXISTS condition
2097: FORALL i IN l_delivery_id_tab.FIRST..l_delivery_id_tab.LAST
2098: INSERT INTO wsh_tmp(column1, column2, column3)
2099: SELECT l_delivery_id_tab(i), l_stop_id_tab(i), l_del_detail_id_tab(i)
2100: FROM dual
2101: WHERE l_delivery_id_tab(i) is not null
2102: AND NOT EXISTS

Line 2104: FROM Wsh_Tmp

2100: FROM dual
2101: WHERE l_delivery_id_tab(i) is not null
2102: AND NOT EXISTS
2103: ( SELECT 'x'
2104: FROM Wsh_Tmp
2105: WHERE Column1 = l_delivery_id_tab(i)
2106: AND ( Column2 = l_stop_id_tab(i) OR l_stop_id_tab(i) IS NULL ) );
2107:
2108: --

Line 2280: DELETE FROM wsh_tmp WHERE column1 = l_delivery_id_tab(i);

2276:
2277:
2278: IF ( l_delivery_id_tab.COUNT > 0 ) THEN
2279: FORALL i IN l_delivery_id_tab.FIRST..l_delivery_id_tab.LAST
2280: DELETE FROM wsh_tmp WHERE column1 = l_delivery_id_tab(i);
2281:
2282: --
2283: IF l_debug_on THEN
2284: WSH_DEBUG_SV.logmsg(l_module_name, 'No of records deleted from wsh_tmp table after unassigning from delivery : '

Line 2284: WSH_DEBUG_SV.logmsg(l_module_name, 'No of records deleted from wsh_tmp table after unassigning from delivery : '

2280: DELETE FROM wsh_tmp WHERE column1 = l_delivery_id_tab(i);
2281:
2282: --
2283: IF l_debug_on THEN
2284: WSH_DEBUG_SV.logmsg(l_module_name, 'No of records deleted from wsh_tmp table after unassigning from delivery : '
2285: || sql%rowcount || ', Time : '
2286: || TO_CHAR(SYSDATE,'YYYY/MM/DD HH24:MI:SS') );
2287: END IF;
2288: --

Line 2359: FROM WSH_TMP;

2355: CLOSE Get_Wsh_Unassign_Details;
2356:
2357: SELECT COUNT(*)
2358: INTO l_tmp_cnt
2359: FROM WSH_TMP;
2360:
2361: IF ( l_tmp_cnt > 0 )
2362: THEN -- { Temp Table Count
2363:

Line 2549: -- Delete the records from Wsh_Tmp table, so that location are not

2545: END IF;
2546:
2547: IF ( l_tmp_rowid_tab.COUNT > 0 )
2548: THEN
2549: -- Delete the records from Wsh_Tmp table, so that location are not
2550: -- updated for stops which are assigned to deliveries with different
2551: -- locations after party merge.
2552: FORALL updCnt IN l_tmp_rowid_tab.FIRST..l_tmp_rowid_tab.LAST
2553: DELETE FROM Wsh_Tmp

Line 2553: DELETE FROM Wsh_Tmp

2549: -- Delete the records from Wsh_Tmp table, so that location are not
2550: -- updated for stops which are assigned to deliveries with different
2551: -- locations after party merge.
2552: FORALL updCnt IN l_tmp_rowid_tab.FIRST..l_tmp_rowid_tab.LAST
2553: DELETE FROM Wsh_Tmp
2554: WHERE Rowid = l_tmp_rowid_tab(updCnt);
2555:
2556: --
2557: IF l_debug_on THEN

Line 2558: WSH_DEBUG_SV.logmsg(l_module_name, 'No of records deleted from Wsh_Tmp : '

2554: WHERE Rowid = l_tmp_rowid_tab(updCnt);
2555:
2556: --
2557: IF l_debug_on THEN
2558: WSH_DEBUG_SV.logmsg(l_module_name, 'No of records deleted from Wsh_Tmp : '
2559: || sql%rowcount || ', Time : '
2560: || TO_CHAR(SYSDATE,'YYYY/MM/DD HH24:MI:SS') );
2561: END IF;
2562: --

Line 2641: FROM WSH_TMP

2637: program_id = fnd_global.conc_program_id,
2638: program_update_date = SYSDATE
2639: WHERE Wts.Stop_Id in (
2640: SELECT Column2
2641: FROM WSH_TMP
2642: WHERE Column2 IS NOT NULL);
2643:
2644: --
2645: IF l_debug_on THEN

Line 2653: DELETE FROM wsh_tmp;

2649: END IF;
2650: --
2651:
2652: -- Deleting records from temp table
2653: DELETE FROM wsh_tmp;
2654:
2655: --
2656: IF l_debug_on THEN
2657: WSH_DEBUG_SV.logmsg(l_module_name, 'No of records deleted from temp table : '