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 1220: FROM Wsh_Delivery_Details Wdd,

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

Line 1281: wsh_delivery_details wdd

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

Line 1396: UPDATE Wsh_Delivery_Details Wdd

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

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

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

Line 1424: p_table_name => 'WSH_DELIVERY_DETAILS',

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

Line 2223: FROM Wsh_Delivery_Details Det,

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

Line 2230: FROM Wsh_Delivery_Details Wdd,

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

Line 2246: FROM Wsh_Delivery_Details dd,

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

Line 2400: UPDATE Wsh_Delivery_Details Wdd

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

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

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

Line 2428: p_table_name => 'WSH_DELIVERY_DETAILS',

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

Line 2503: FROM Wsh_Delivery_Details WDD,

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

Line 2598: UPDATE Wsh_Delivery_Details Wdd

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

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

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

Line 2638: p_table_name => 'WSH_DELIVERY_DETAILS',

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

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

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

Line 2916: FROM Wsh_Delivery_Details Det

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

Line 2925: FROM Wsh_Delivery_Details WDD,

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

Line 2950: FROM Wsh_Delivery_Details WDD,

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

Line 3000: setARMessageLockTable('WSH_DELIVERY_DETAILS');

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

Line 3081: UPDATE Wsh_Delivery_Details WDD

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

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

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

Line 3109: p_table_name => 'WSH_DELIVERY_DETAILS',

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

Line 3145: UPDATE Wsh_Delivery_Details Wdd

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

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

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

Line 3172: p_table_name => 'WSH_DELIVERY_DETAILS',

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

Line 3749: FROM wsh_delivery_details wdd,

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