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_CUST_MERGE dependencies on WSH_TMP

Line 569: Wsh_Tmp Tmp

565: ( SELECT Wdd.Delivery_Detail_Id
566: FROM WSH_DELIVERY_DETAILS Wdd,
567: WSH_DELIVERY_ASSIGNMENTS Wda,
568: WSH_NEW_DELIVERIES Wnd,
569: Wsh_Tmp Tmp
570: WHERE Wdd.Container_Flag = 'N'
571: AND Wdd.Released_Status IN ( 'R', 'N', 'X', 'Y', 'S', 'B' )
572: AND Wdd.Customer_id = p_customer_id
573: AND Wdd.Ship_To_Location_Id = p_location_id

Line 609: Wsh_Tmp Tmp

605: FROM WSH_DELIVERY_DETAILS Wdd,
606: WSH_DELIVERY_ASSIGNMENTS Wda,
607: WSH_NEW_DELIVERIES Wnd,
608: Wsh_Freight_Costs Wfc,
609: Wsh_Tmp Tmp
610: WHERE Wdd.Container_Flag = 'N'
611: AND Wdd.Released_Status IN ( 'R', 'N', 'X', 'Y', 'S', 'B' )
612: AND Wdd.Customer_id = p_customer_id
613: AND Wdd.Ship_To_Location_Id = p_location_id

Line 990: DELETE FROM wsh_tmp WHERE column1 = l_deliveryIdTab(delCnt);

986:
987: IF ( l_deliveryIdTab.COUNT > 0 )
988: THEN
989: FORALL delCnt in l_deliveryIdTab.FIRST..l_deliveryIdTab.LAST
990: DELETE FROM wsh_tmp WHERE column1 = l_deliveryIdTab(delCnt);
991: END IF;
992: -- }
993: END IF;
994:

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

1100: -- PROCEDURE : GET_DELIVERY_HASH
1101: --
1102: -- DESCRIPTION :
1103: -- Get_Delivery_Hash generates new hash value and hash string for
1104: -- deliveries(from wsh_tmp table) which are to be updated with new
1105: -- Customer/Location ids
1106: --
1107: -- PARAMETERS :
1108: -- x_hash_string_tab => Contains array of Hash String for deliveries

Line 1123: FROM Wsh_Tmp;

1119: IS
1120: CURSOR Get_Tmp_Deliveries
1121: IS
1122: SELECT to_number(Column1) delivery_id, Column3
1123: FROM Wsh_Tmp;
1124:
1125: l_grp_attr_tab_type WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;
1126: l_action_code VARCHAR2(30);
1127: l_return_status VARCHAR2(1);

Line 1225: Wsh_Tmp Tmp

1221: IS
1222: SELECT Wdd.Delivery_Detail_Id, Wdd.Rowid
1223: FROM Wsh_Delivery_Details Wdd,
1224: Wsh_Delivery_Assignments Wda,
1225: Wsh_Tmp Tmp
1226: WHERE Wdd.Container_Flag = 'Y'
1227: AND Wdd.Delivery_Detail_Id = Wda.Parent_Delivery_Detail_Id
1228: AND Parent_Delivery_Detail_Id IS NOT NULL
1229: AND Wda.Delivery_Id = Tmp.Column1

Line 1242: Wsh_Tmp Tmp

1238: NVL(Wnd.ignore_for_planning, 'N') --OTM R12
1239: FROM Wsh_New_Deliveries Wnd,
1240: Wsh_Delivery_Legs Wdl,
1241: Wsh_Trip_Stops Wts,
1242: Wsh_Tmp Tmp
1243: WHERE Wnd.Ultimate_Dropoff_Location_Id = p_location_id
1244: AND Wts.Stop_Id = Wdl.Drop_Off_Stop_Id
1245: AND Wnd.Delivery_Id = Wdl.Delivery_Id
1246: AND Wdl.Delivery_Id = Tmp.Column1

Line 1744: --For OTM related deliveries, all the deliveries will be removed from wsh_tmp,

1740: WHERE Delivery_Leg_Id = l_deliveryLegIdTab(delCnt);
1741: END IF;
1742: END IF;
1743:
1744: --For OTM related deliveries, all the deliveries will be removed from wsh_tmp,
1745: --so removing them here is okay since OTM flow will only unassign more deliveries than
1746: --the original flow.
1747: IF ( l_tempRowidTab.COUNT > 0 )
1748: THEN

Line 1749: -- Deletes records from Wsh_Tmp table, so that locations are not

1745: --so removing them here is okay since OTM flow will only unassign more deliveries than
1746: --the original flow.
1747: IF ( l_tempRowidTab.COUNT > 0 )
1748: THEN
1749: -- Deletes records from Wsh_Tmp table, so that locations are not
1750: -- updated for stops which has deliveries with different dropoff
1751: -- locations.
1752: FORALL delCnt IN l_tempRowidTab.FIRST..l_tempRowidTab.LAST
1753: DELETE FROM Wsh_Tmp

Line 1753: DELETE FROM Wsh_Tmp

1749: -- Deletes records from Wsh_Tmp table, so that locations are not
1750: -- updated for stops which has deliveries with different dropoff
1751: -- locations.
1752: FORALL delCnt IN l_tempRowidTab.FIRST..l_tempRowidTab.LAST
1753: DELETE FROM Wsh_Tmp
1754: WHERE Rowid = l_tempRowidTab(delCnt);
1755: END IF;
1756:
1757: EXIT WHEN Get_Del_Unassign_From_Stop%NOTFOUND;

Line 2057: -- Filter the list in wsh_tmp which has column1 as delivery_id

2053:
2054:
2055: --OTM R12: customer merge
2056: IF (l_gc3_is_installed = 'Y' AND l_dlvy_id_tab.count > 0) THEN
2057: -- Filter the list in wsh_tmp which has column1 as delivery_id
2058: -- and column2 as stop id
2059: -- Delete the records from wsh_tmp where column1 = include for
2060: -- planning delivery ids selected above
2061: -- the filter here is done because we don't want to update OTM trip stops,

Line 2059: -- Delete the records from wsh_tmp where column1 = include for

2055: --OTM R12: customer merge
2056: IF (l_gc3_is_installed = 'Y' AND l_dlvy_id_tab.count > 0) THEN
2057: -- Filter the list in wsh_tmp which has column1 as delivery_id
2058: -- and column2 as stop id
2059: -- Delete the records from wsh_tmp where column1 = include for
2060: -- planning delivery ids selected above
2061: -- the filter here is done because we don't want to update OTM trip stops,
2062: -- and the update sql right after updates the trip stops.
2063:

Line 2065: DELETE FROM wsh_tmp

2061: -- the filter here is done because we don't want to update OTM trip stops,
2062: -- and the update sql right after updates the trip stops.
2063:
2064: FORALL delCnt IN l_dlvy_id_tab.FIRST..l_dlvy_id_tab.LAST
2065: DELETE FROM wsh_tmp
2066: WHERE column1 = l_dlvy_id_tab(delCnt);
2067: END IF;
2068: -- End of OTM R12 : customer merge
2069:

Line 2081: FROM WSH_TMP

2077: program_id = arp_standard.profile.program_id,
2078: program_update_date = SYSDATE
2079: WHERE Wts.Stop_Id in (
2080: SELECT Column2
2081: FROM WSH_TMP
2082: WHERE Column2 IS NOT NULL )
2083: RETURNING Wts.Stop_Id BULK COLLECT INTO l_stopIdTab;
2084:
2085: --

Line 2788: -- Insert delivery and stop details into wsh_tmp table

2784: END LOOP;
2785: -- }
2786: END IF;
2787:
2788: -- Insert delivery and stop details into wsh_tmp table
2789: IF ( l_deliveryIdTab.COUNT > 0 and
2790: G_SITE_USE_CODE = 'SHIP_TO' )
2791: THEN
2792: -- Inserting records in bulk into temp table for future reference

Line 2796: INSERT INTO Wsh_Tmp ( Column1, Column2, Column3 )

2792: -- Inserting records in bulk into temp table for future reference
2793: -- during processing.
2794: -- Dulplicate entries are avoided using NOT EXISTS condition
2795: FORALL insCnt in l_deliveryIdTab.FIRST..l_deliveryIdTab.LAST
2796: INSERT INTO Wsh_Tmp ( Column1, Column2, Column3 )
2797: SELECT l_deliveryIdTab(insCnt), l_stopIdTab(insCnt), l_deliveryDetailIdTab(insCnt)
2798: FROM DUAL
2799: WHERE l_deliveryIdTab(insCnt) IS NOT NULL
2800: --Start of fix for bug 5900667

Line 2810: FROM Wsh_Tmp

2806: AND delivery_id = l_deliveryIdTab(insCnt) )
2807: --End of fix for bug 5900667
2808: AND NOT EXISTS
2809: ( SELECT 'x'
2810: FROM Wsh_Tmp
2811: WHERE Column1 = l_deliveryIdTab(insCnt)
2812: AND ( Column2 = l_stopIdTab(insCnt) OR l_stopIdTab(insCnt) is null ) );
2813: END IF;
2814:

Line 2837: FROM WSH_TMP;

2833: END IF;
2834:
2835: SELECT COUNT(*)
2836: INTO l_tmp_cnt
2837: FROM WSH_TMP;
2838:
2839: IF ( l_tmp_cnt > 0 )
2840: THEN
2841: Process_Deliveries (

Line 2853: -- Deleting records from Wsh_Tmp table

2849: END IF;
2850: -- } site use code
2851: END IF;
2852:
2853: -- Deleting records from Wsh_Tmp table
2854: DELETE FROM Wsh_Tmp;
2855:
2856: --
2857: IF l_debug_on THEN

Line 2854: DELETE FROM Wsh_Tmp;

2850: -- } site use code
2851: END IF;
2852:
2853: -- Deleting records from Wsh_Tmp table
2854: DELETE FROM Wsh_Tmp;
2855:
2856: --
2857: IF l_debug_on THEN
2858: arp_message.set_line('WSH_CUST_MERGE.Process_Open_Lines()+' || getTimeStamp );

Line 3198: DELETE FROM Wsh_Tmp;

3194: END LOOP;
3195:
3196: CLOSE Get_Shipped_Lines;
3197:
3198: DELETE FROM Wsh_Tmp;
3199:
3200: -- Processes open delivery detail lines
3201: -- All others necessary values are taken from Global Variables
3202: Process_Open_Lines (