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.WMS_TASK_LOAD dependencies on WSH_DELIVERY_DETAILS

Line 12966: , wsh_delivery_details_ob_grp_v wdd

12962:
12963: CURSOR others_in_mmtt_delivery_cursor(l_lpn_id IN NUMBER) IS
12964: SELECT wda.delivery_id
12965: FROM wsh_delivery_assignments_v wda
12966: , wsh_delivery_details_ob_grp_v wdd
12967: , mtl_material_transactions_temp mmtt
12968: WHERE mmtt.transfer_lpn_id = l_lpn_id
12969: AND wda.delivery_detail_id = wdd.delivery_detail_id
12970: AND wdd.move_order_line_id = mmtt.move_order_line_id

Line 12985: , wsh_delivery_details_ob_grp_v wdd

12981:
12982: CURSOR current_delivery_cursor IS
12983: SELECT wda.delivery_id
12984: FROM wsh_delivery_assignments_v wda
12985: , wsh_delivery_details_ob_grp_v wdd
12986: , mtl_material_transactions_temp mmtt
12987: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
12988: AND wdd.move_order_line_id = mmtt.move_order_line_id
12989: AND wdd.organization_id = mmtt.organization_id

Line 12996: , wsh_delivery_details_ob_grp_v wdd

12992:
12993: CURSOR drop_delivery_cursor(l_lpn_id IN NUMBER) IS
12994: SELECT wda.delivery_id
12995: FROM wsh_delivery_assignments_v wda
12996: , wsh_delivery_details_ob_grp_v wdd
12997: WHERE wda.parent_delivery_detail_id = wdd.delivery_detail_id
12998: AND wdd.lpn_id = l_lpn_id
12999: AND wdd.organization_id = p_organization_id
13000: AND wdd.released_status = 'X'; -- For LPN reusability ER : 6845650

Line 13046: FROM wsh_delivery_details wdd, wsh_delivery_assignments wda

13042: -- Bug 6168447 : Cursot to check if there are any wdd present for the LPN
13043:
13044: CURSOR c_wdd_exists(p_lpn_id NUMBER,p_organization_id NUMBER) is
13045: SELECT distinct wda.delivery_id
13046: FROM wsh_delivery_details wdd, wsh_delivery_assignments wda
13047: WHERE wdd.lpn_id IN (select lpn_id from wms_license_plate_numbers
13048: where organization_id = p_organization_id
13049: and (lpn_id = p_lpn_id
13050: or parent_lpn_id = p_lpn_id

Line 13149: FROM wsh_delivery_details_ob_grp_v wdd

13145: or outermost_lpn_id = pick_to_lpn_rec.lpn_id);
13146:
13147: SELECT wdd.released_status,wdd.delivery_detail_id
13148: INTO l_status_code,l_delivery_detail_id
13149: FROM wsh_delivery_details_ob_grp_v wdd
13150: WHERE wdd.container_name = l_lpn_name
13151: AND wdd.released_status = 'X'; -- For LPN reusability ER : 6845650
13152:
13153: /* Release 12(K): LPN Synchronization

Line 13786: FROM wsh_delivery_details wdd

13782: -- uncommenting for bug#10062741
13783: BEGIN
13784: --{
13785: SELECT wdd.delivery_detail_id INTO l_line_rows(1)
13786: FROM wsh_delivery_details wdd
13787: , mtl_material_transactions_temp mmtt
13788: WHERE mmtt.transaction_temp_id = p_temp_id
13789: AND wdd.move_order_line_id = mmtt.move_order_line_id
13790: AND wdd.organization_id = mmtt.organization_id;

Line 13793: FROM wsh_delivery_details wdd

13789: AND wdd.move_order_line_id = mmtt.move_order_line_id
13790: AND wdd.organization_id = mmtt.organization_id;
13791: --
13792: SELECT wdd.delivery_detail_id INTO l_line_rows(2)
13793: FROM wsh_delivery_details wdd
13794: , mtl_material_transactions_temp mmtt
13795: WHERE mmtt.transfer_lpn_id = pick_to_lpn_rec.lpn_id
13796: AND wdd.move_order_line_id = mmtt.move_order_line_id
13797: AND wdd.organization_id = mmtt.organization_id

Line 13801: mydebug('validate_pick_to_lpn: Before calling WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping() to decide if we can load into this LPN');

13797: AND wdd.organization_id = mmtt.organization_id
13798: AND rownum<2;
13799: --
13800: IF (l_debug = 1) THEN
13801: mydebug('validate_pick_to_lpn: Before calling WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping() to decide if we can load into this LPN');
13802: mydebug('Parameters : delivery_detail_id(1):'|| l_line_rows(1) ||' , delivery_detail_id(2) :'||l_line_rows(2));
13803: END IF;
13804: --
13805: -- call to the shipping API.

Line 13807: WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping(

13803: END IF;
13804: --
13805: -- call to the shipping API.
13806: --
13807: WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping(
13808: p_line_rows => l_line_rows,
13809: x_grouping_rows => l_grouping_rows,
13810: x_return_status => l_return_status);
13811: --