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_DELIVERY_DETAILS

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

202: -- p_volume array of volume
203: -- x_return_status Returns the status of call
204: --
205: -- COMMENT :
206: -- Code is similar to WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_From_Cont
207: -- when p_entity_type is 'CONT'
208: -- Code is similar to WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_From_Delivery
209: -- when p_entity_type is 'DEL-CONT'
210: -----------------------------------------------------------------------------------------

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

204: --
205: -- COMMENT :
206: -- Code is similar to WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_From_Cont
207: -- when p_entity_type is 'CONT'
208: -- Code is similar to WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_From_Delivery
209: -- when p_entity_type is 'DEL-CONT'
210: -----------------------------------------------------------------------------------------
211:
212: PROCEDURE Adjust_Weight_Volume (

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

392: -- p_volume_uom array of volume UOM code
393: -- x_return_status Returns the status of call
394: --
395: -- COMMENT :
396: -- Code is similar to WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_From_Cont
397: -- when p_entity_type is 'CONT'
398: -- Code is similar to WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_From_Delivery
399: -- when p_entity_type is 'DEL-CONT'
400: -- ===============================================================================

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

394: --
395: -- COMMENT :
396: -- Code is similar to WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_From_Cont
397: -- when p_entity_type is 'CONT'
398: -- Code is similar to WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_From_Delivery
399: -- when p_entity_type is 'DEL-CONT'
400: -- ===============================================================================
401: PROCEDURE Adjust_Parent_WV (
402: p_entity_type IN VARCHAR2,

Line 553: FROM Wsh_Delivery_Details Det,

549: p_location_id NUMBER )
550: IS
551: SELECT Det.Delivery_Detail_Id, Det.Rowid,
552: Dlvy.Customer_Id
553: FROM Wsh_Delivery_Details Det,
554: Wsh_Delivery_Assignments DelAsgn,
555: Wsh_New_Deliveries Dlvy
556: WHERE Dlvy.Delivery_Id = DelAsgn.Delivery_Id
557: AND DelAsgn.Delivery_Detail_Id = Det.Delivery_Detail_Id

Line 566: FROM WSH_DELIVERY_DETAILS Wdd,

562: WHERE Asgn.Parent_Delivery_Detail_Id IS NOT NULL
563: CONNECT BY PRIOR Asgn.Parent_Delivery_Detail_Id = Asgn.Delivery_Detail_Id
564: START WITH Asgn.delivery_detail_id IN
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'

Line 584: WSH_DELIVERY_DETAILS WDD1

580: AND Wnd.Delivery_Id = Tmp.Column1
581: AND exists
582: ( SELECT 'x'
583: FROM WSH_DELIVERY_ASSIGNMENTS WDA1,
584: WSH_DELIVERY_DETAILS WDD1
585: WHERE WDD1.DELIVERY_DETAIL_ID = WDA1.DELIVERY_DETAIL_ID
586: AND WDD1.Container_Flag = 'N'
587: AND WDA1.Delivery_Id = WND.Delivery_Id
588: AND WDD1.Ship_To_Location_id = WND.Ultimate_Dropoff_Location_Id ) ) )

Line 605: FROM WSH_DELIVERY_DETAILS Wdd,

601: Wdd.Weight_Uom_Code, Wdd.Volume_Uom_Code,
602: Wdd.Organization_Id, Wdd.Inventory_Item_Id,
603: Wdd.Move_Order_Line_Id, Wdd.Released_Status,
604: Wnd.Ignore_For_Planning -- OTM R12 : unassign delivery detail
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

Line 626: WSH_DELIVERY_DETAILS WDD1

622: AND Wnd.Delivery_Id = Tmp.Column1
623: AND exists (
624: SELECT 'x'
625: FROM WSH_DELIVERY_ASSIGNMENTS WDA1,
626: WSH_DELIVERY_DETAILS WDD1
627: WHERE WDD1.DELIVERY_DETAIL_ID = WDA1.DELIVERY_DETAIL_ID
628: AND WDD1.Container_Flag = 'N'
629: AND WDA1.Delivery_Id = WND.Delivery_Id
630: AND WDD1.Ship_To_Location_id = WND.Ultimate_Dropoff_Location_Id)

Line 720: UPDATE Wsh_Delivery_Details Wdd

716:
717: IF ( l_deliveryDetailRowidTab.COUNT > 0 )
718: THEN
719: FORALL updCnt in l_deliveryDetailRowidTab.FIRST..l_deliveryDetailRowidTab.LAST
720: UPDATE Wsh_Delivery_Details Wdd
721: SET Customer_Id = l_customerIdTab(updCnt),
722: last_update_date = SYSDATE,
723: last_updated_by = fnd_global.user_id,
724: last_update_login = fnd_global.conc_login_id,

Line 731: setARMessageRowCount( 'WSH_DELIVERY_DETAILS', SQL%ROWCOUNT );

727: program_update_date = SYSDATE
728: WHERE rowid = l_deliveryDetailRowidTab(updCnt);
729:
730: --
731: setARMessageRowCount( 'WSH_DELIVERY_DETAILS', SQL%ROWCOUNT );
732: END IF;
733:
734: EXIT WHEN Get_Cont_Unassign_Details%NOTFOUND;
735: -- }

Line 1223: FROM Wsh_Delivery_Details Wdd,

1219: -- which are assigned to delivery
1220: CURSOR Get_Delivery_Containers
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

Line 1284: wsh_delivery_details wdd

1280: AND NOT EXISTS
1281: (
1282: SELECT 1
1283: FROM wsh_delivery_assignments wda,
1284: wsh_delivery_details wdd
1285: WHERE wda.delivery_id = wnd.delivery_id
1286: AND wda.delivery_detail_id = wdd.delivery_detail_id
1287: AND wdd.container_flag = 'N'
1288: );

Line 1399: UPDATE Wsh_Delivery_Details Wdd

1395: -- { count > 0
1396: -- For container records ship_to_site_use_id and deliver_to_site_use_id
1397: -- is null
1398: FORALL updCnt IN l_deliveryDetailRowidTab.FIRST..l_deliveryDetailRowidTab.LAST
1399: UPDATE Wsh_Delivery_Details Wdd
1400: SET customer_id = decode( customer_id,
1401: G_FROM_CUSTOMER_ID, G_TO_CUSTOMER_ID,
1402: customer_id ),
1403: ship_to_location_id = decode( ship_to_location_id,

Line 1419: setARMessageRowCount( 'WSH_DELIVERY_DETAILS', SQL%ROWCOUNT );

1415: program_update_date = SYSDATE
1416: WHERE Wdd.Rowid = l_deliveryDetailRowidTab(updCnt);
1417:
1418: --
1419: setARMessageRowCount( 'WSH_DELIVERY_DETAILS', SQL%ROWCOUNT );
1420:
1421: IF ( G_PROFILE_VAL IS NOT NULL AND G_PROFILE_VAL = 'Y' )
1422: THEN
1423: l_return_status := NULL;

Line 1427: p_table_name => 'WSH_DELIVERY_DETAILS',

1423: l_return_status := NULL;
1424:
1425: Insert_Log_Table (
1426: p_id_tab => l_deliveryDetailIdTab,
1427: p_table_name => 'WSH_DELIVERY_DETAILS',
1428: p_req_id => p_req_id,
1429: x_return_status => l_return_status );
1430:
1431: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )

Line 2226: FROM Wsh_Delivery_Details Det,

2222: p_location_id NUMBER )
2223: IS
2224: SELECT Det.Delivery_Detail_Id, Dlvy.Delivery_Id,
2225: Det.Rowid, Dlvy.Rowid
2226: FROM Wsh_Delivery_Details Det,
2227: Wsh_Delivery_Assignments Asg,
2228: Wsh_New_Deliveries Dlvy
2229: WHERE Det.Delivery_Detail_Id = Asg.Delivery_Detail_Id
2230: AND Asg.Delivery_Id = Dlvy.Delivery_Id

Line 2233: FROM Wsh_Delivery_Details Wdd,

2229: WHERE Det.Delivery_Detail_Id = Asg.Delivery_Detail_Id
2230: AND Asg.Delivery_Id = Dlvy.Delivery_Id
2231: AND Dlvy.Delivery_Id in
2232: ( SELECT Wnd.Delivery_Id
2233: FROM Wsh_Delivery_Details Wdd,
2234: Wsh_Delivery_Assignments Wda,
2235: Wsh_New_Deliveries Wnd
2236: WHERE Wdd.Container_Flag = 'Y'
2237: AND Wdd.Delivery_Detail_Id = Wda.Delivery_Detail_id

Line 2249: FROM Wsh_Delivery_Details dd,

2245: WHERE Asgn.Parent_Delivery_Detail_Id = Wdd.Delivery_Detail_Id
2246: AND Asgn.Delivery_Id = Wnd.Delivery_Id )
2247: AND NOT EXISTS
2248: ( SELECT 'X'
2249: FROM Wsh_Delivery_Details dd,
2250: Wsh_Delivery_Assignments da
2251: WHERE dd.Container_Flag = 'N'
2252: AND dd.Delivery_Detail_Id = da.Delivery_Detail_Id
2253: AND da.Delivery_Id = Wnd.Delivery_Id ) )

Line 2403: UPDATE Wsh_Delivery_Details Wdd

2399: END IF;
2400: END IF;
2401: IF l_deliveryDetailRowidTab.COUNT > 0 THEN
2402: FORALL updCnt in l_deliveryDetailRowidTab.FIRST..l_deliveryDetailRowidTab.LAST
2403: UPDATE Wsh_Delivery_Details Wdd
2404: SET customer_id = decode( customer_id,
2405: G_FROM_CUSTOMER_ID, G_TO_CUSTOMER_ID,
2406: customer_id ),
2407: ship_to_location_id = decode( ship_to_location_id,

Line 2423: setARMessageRowCount( 'WSH_DELIVERY_DETAILS', SQL%ROWCOUNT );

2419: program_update_date = SYSDATE
2420: WHERE Wdd.Rowid = l_deliveryDetailRowidTab(updCnt);
2421: END IF;
2422: --
2423: setARMessageRowCount( 'WSH_DELIVERY_DETAILS', SQL%ROWCOUNT );
2424:
2425: IF ( G_PROFILE_VAL IS NOT NULL AND G_PROFILE_VAL = 'Y' )
2426: THEN
2427: l_return_status := NULL;

Line 2431: p_table_name => 'WSH_DELIVERY_DETAILS',

2427: l_return_status := NULL;
2428:
2429: Insert_Log_Table (
2430: p_id_tab => l_deliveryDetailIdTab,
2431: p_table_name => 'WSH_DELIVERY_DETAILS',
2432: p_req_id => p_req_id,
2433: x_return_status => l_return_status );
2434:
2435: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )

Line 2506: FROM Wsh_Delivery_Details WDD,

2502: WDD.Net_Weight, WDD.Gross_Weight,
2503: WDD.Volume, Wdd.Weight_Uom_code, Wdd.Volume_Uom_Code,
2504: Wdd.Inventory_Item_Id, Wdd.Organization_Id,
2505: WDD.Rowid, WDA.Rowid
2506: FROM Wsh_Delivery_Details WDD,
2507: Wsh_Delivery_Assignments WDA,
2508: Wsh_New_Deliveries WND,
2509: Wsh_Delivery_Legs WDL,
2510: Wsh_Trip_Stops WTS

Line 2601: UPDATE Wsh_Delivery_Details Wdd

2597:
2598: -- Update non-container lines
2599: IF l_deliveryDetailRowidTab.count > 0 THEN
2600: FORALL bulkCnt in l_deliveryDetailRowidTab.FIRST..l_deliveryDetailRowidTab.LAST
2601: UPDATE Wsh_Delivery_Details Wdd
2602: SET customer_id = decode( customer_id,
2603: G_FROM_CUSTOMER_ID, G_TO_CUSTOMER_ID,
2604: customer_id ),
2605: ship_to_site_use_id = decode( ship_to_site_use_id,

Line 2633: setARMessageRowCount( 'WSH_DELIVERY_DETAILS', SQL%ROWCOUNT );

2629: program_update_date = SYSDATE
2630: WHERE Wdd.Rowid = l_deliveryDetailRowidTab(bulkCnt);
2631: END IF;
2632: --
2633: setARMessageRowCount( 'WSH_DELIVERY_DETAILS', SQL%ROWCOUNT );
2634:
2635: IF ( G_PROFILE_VAL IS NOT NULL AND G_PROFILE_VAL = 'Y' )
2636: THEN
2637: l_return_status := NULL;

Line 2641: p_table_name => 'WSH_DELIVERY_DETAILS',

2637: l_return_status := NULL;
2638:
2639: Insert_Log_Table (
2640: p_id_tab => l_deliveryDetailIdTab,
2641: p_table_name => 'WSH_DELIVERY_DETAILS',
2642: p_req_id => p_req_id,
2643: x_return_status => l_return_status );
2644:
2645: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )

Line 2893: -- Description: New code to merge customer and site information in WSH_DELIVERY_DETAILS.

2889:
2890: -----------------------------------------------------------------------------------------
2891: --
2892: -- Procedure: Delivery_Details
2893: -- Description: New code to merge customer and site information in WSH_DELIVERY_DETAILS.
2894: -- Usage: Called by WSH_CUST_MERGE.Merge
2895: --
2896: --
2897: -- Assumptions

Line 2919: FROM Wsh_Delivery_Details Det

2915: p_site_use_id NUMBER,
2916: p_location_id NUMBER )
2917: IS
2918: SELECT Det.Delivery_Detail_Id, Det.Rowid
2919: FROM Wsh_Delivery_Details Det
2920: WHERE Det.Container_Flag = 'Y'
2921: AND Det.Delivery_Detail_Id IN
2922: ( SELECT Wda.Parent_Delivery_Detail_Id
2923: FROM Wsh_Delivery_Assignments Wda

Line 2928: FROM Wsh_Delivery_Details WDD,

2924: WHERE Wda.Parent_Delivery_Detail_Id IS NOT NULL
2925: CONNECT BY PRIOR Wda.Parent_Delivery_Detail_Id = Wda.Delivery_Detail_Id
2926: START WITH wda.delivery_detail_id IN
2927: ( SELECT WDD.Delivery_Detail_Id
2928: FROM Wsh_Delivery_Details WDD,
2929: Wsh_Delivery_Assignments WDA,
2930: Wsh_New_Deliveries WND
2931: WHERE Wnd.Status_Code in ( 'CO', 'CL', 'IT' )
2932: -- Added Parent_Delivery_Detail_Id for Perf. improvement,

Line 2953: FROM Wsh_Delivery_Details WDD,

2949: p_site_use_id NUMBER,
2950: p_location_id NUMBER )
2951: IS
2952: SELECT Wdd.Delivery_Detail_Id, Wdd.Rowid
2953: FROM Wsh_Delivery_Details WDD,
2954: Wsh_Delivery_Assignments WDA,
2955: Wsh_New_Deliveries WND
2956: WHERE Wnd.Status_Code in ( 'CO', 'CL', 'IT' )
2957: AND Wnd.Delivery_Id = Wda.Delivery_Id

Line 3003: setARMessageLockTable('WSH_DELIVERY_DETAILS');

2999: arp_message.set_line('WSH_CUST_MERGE.Delivery_Details()+' || getTimeStamp );
3000: END IF;
3001:
3002: IF (process_mode = 'LOCK') THEN
3003: setARMessageLockTable('WSH_DELIVERY_DETAILS');
3004: NULL;
3005: ELSE
3006: --{ Not Process Lock
3007: -- WSH tables stores only transactions for SHIP_TO and DELIVER_TO transactions

Line 3084: UPDATE Wsh_Delivery_Details WDD

3080: THEN
3081: -- {
3082: -- Update Container lines
3083: FORALL bulkCnt in l_deliveryDetailRowidTab.FIRST..l_deliveryDetailRowidTab.LAST
3084: UPDATE Wsh_Delivery_Details WDD
3085: SET customer_id = decode(customer_id, G_FROM_CUSTOMER_ID,
3086: G_TO_CUSTOMER_ID, customer_id ),
3087: ship_to_site_use_id = decode(ship_to_site_use_id,
3088: G_FROM_CUST_SITE_ID, G_TO_CUST_SITE_ID,

Line 3104: setARMessageRowCount( 'WSH_DELIVERY_DETAILS', SQL%ROWCOUNT );

3100: WHERE Wdd.Container_Flag = 'Y'
3101: AND Wdd.Rowid = l_deliveryDetailRowidTab(bulkCnt);
3102:
3103: --
3104: setARMessageRowCount( 'WSH_DELIVERY_DETAILS', SQL%ROWCOUNT );
3105:
3106: IF ( G_PROFILE_VAL IS NOT NULL AND G_PROFILE_VAL = 'Y' )
3107: THEN
3108: l_return_status := NULL;

Line 3112: p_table_name => 'WSH_DELIVERY_DETAILS',

3108: l_return_status := NULL;
3109:
3110: Insert_Log_Table (
3111: p_id_tab => l_deliveryDetailIdTab,
3112: p_table_name => 'WSH_DELIVERY_DETAILS',
3113: p_req_id => req_id,
3114: x_return_status => l_return_status );
3115:
3116: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )

Line 3148: UPDATE Wsh_Delivery_Details Wdd

3144: -- {
3145: -- Update non-container lines
3146: IF l_deliveryDetailRowidTab.COUNT > 0 THEN
3147: FORALL bulkCnt in l_deliveryDetailRowidTab.FIRST..l_deliveryDetailRowidTab.LAST
3148: UPDATE Wsh_Delivery_Details Wdd
3149: SET customer_id = decode(customer_id, G_FROM_CUSTOMER_ID,
3150: G_TO_CUSTOMER_ID, customer_id ),
3151: ship_to_site_use_id = decode(ship_to_site_use_id,
3152: G_FROM_CUST_SITE_ID, G_TO_CUST_SITE_ID,

Line 3167: setARMessageRowCount( 'WSH_DELIVERY_DETAILS', SQL%ROWCOUNT );

3163: program_update_date = SYSDATE
3164: WHERE Wdd.Rowid = l_deliveryDetailRowidTab(bulkCnt);
3165: END IF;
3166: --
3167: setARMessageRowCount( 'WSH_DELIVERY_DETAILS', SQL%ROWCOUNT );
3168:
3169: IF ( G_PROFILE_VAL IS NOT NULL AND G_PROFILE_VAL = 'Y' )
3170: THEN
3171: l_return_status := NULL;

Line 3175: p_table_name => 'WSH_DELIVERY_DETAILS',

3171: l_return_status := NULL;
3172:
3173: Insert_Log_Table (
3174: p_id_tab => l_deliveryDetailIdTab,
3175: p_table_name => 'WSH_DELIVERY_DETAILS',
3176: p_req_id => req_id,
3177: x_return_status => l_return_status );
3178:
3179: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )

Line 3752: FROM wsh_delivery_details wdd,

3748: CURSOR C1 IS
3749: SELECT 1 FROM DUAL
3750: WHERE EXISTS
3751: ( SELECT 'x'
3752: FROM wsh_delivery_details wdd,
3753: wsh_delivery_assignments wda,
3754: ra_customer_merges rcm,
3755: mtl_parameters mtl
3756: WHERE mtl.wms_enabled_flag = 'Y'