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 987: DELETE FROM wsh_tmp WHERE column1 = l_deliveryIdTab(delCnt);

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

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

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

Line 1120: FROM Wsh_Tmp;

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

Line 1222: Wsh_Tmp Tmp

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

Line 1239: Wsh_Tmp Tmp

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

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

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

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

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

Line 1750: DELETE FROM Wsh_Tmp

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

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

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

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

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

Line 2062: DELETE FROM wsh_tmp

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

Line 2078: FROM WSH_TMP

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

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

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

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

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

Line 2807: FROM Wsh_Tmp

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

Line 2834: FROM WSH_TMP;

2830: END IF;
2831:
2832: SELECT COUNT(*)
2833: INTO l_tmp_cnt
2834: FROM WSH_TMP;
2835:
2836: IF ( l_tmp_cnt > 0 )
2837: THEN
2838: Process_Deliveries (

Line 2850: -- Deleting records from Wsh_Tmp table

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

Line 2851: DELETE FROM Wsh_Tmp;

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

Line 3195: DELETE FROM Wsh_Tmp;

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