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 10670: , wsh_delivery_details_ob_grp_v wdd

10666:
10667: CURSOR others_in_mmtt_delivery_cursor(l_lpn_id IN NUMBER) IS
10668: SELECT wda.delivery_id
10669: FROM wsh_delivery_assignments_v wda
10670: , wsh_delivery_details_ob_grp_v wdd
10671: , mtl_material_transactions_temp mmtt
10672: WHERE mmtt.transfer_lpn_id = l_lpn_id
10673: AND wda.delivery_detail_id = wdd.delivery_detail_id
10674: AND wdd.move_order_line_id = mmtt.move_order_line_id

Line 10689: , wsh_delivery_details_ob_grp_v wdd

10685:
10686: CURSOR current_delivery_cursor IS
10687: SELECT wda.delivery_id
10688: FROM wsh_delivery_assignments_v wda
10689: , wsh_delivery_details_ob_grp_v wdd
10690: , mtl_material_transactions_temp mmtt
10691: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
10692: AND wdd.move_order_line_id = mmtt.move_order_line_id
10693: AND wdd.organization_id = mmtt.organization_id

Line 10700: , wsh_delivery_details_ob_grp_v wdd

10696:
10697: CURSOR drop_delivery_cursor(l_lpn_id IN NUMBER) IS
10698: SELECT wda.delivery_id
10699: FROM wsh_delivery_assignments_v wda
10700: , wsh_delivery_details_ob_grp_v wdd
10701: WHERE wda.parent_delivery_detail_id = wdd.delivery_detail_id
10702: AND wdd.lpn_id = l_lpn_id
10703: AND wdd.organization_id = p_organization_id
10704: AND wdd.released_status = 'X'; -- For LPN reusability ER : 6845650

Line 10750: FROM wsh_delivery_details wdd, wsh_delivery_assignments wda

10746: -- Bug 6168447 : Cursot to check if there are any wdd present for the LPN
10747:
10748: CURSOR c_wdd_exists(p_lpn_id NUMBER,p_organization_id NUMBER) is
10749: SELECT distinct wda.delivery_id
10750: FROM wsh_delivery_details wdd, wsh_delivery_assignments wda
10751: WHERE wdd.lpn_id IN (select lpn_id from wms_license_plate_numbers
10752: where organization_id = p_organization_id
10753: and (lpn_id = p_lpn_id
10754: or parent_lpn_id = p_lpn_id

Line 10853: FROM wsh_delivery_details_ob_grp_v wdd

10849: or outermost_lpn_id = pick_to_lpn_rec.lpn_id);
10850:
10851: SELECT wdd.released_status,wdd.delivery_detail_id
10852: INTO l_status_code,l_delivery_detail_id
10853: FROM wsh_delivery_details_ob_grp_v wdd
10854: WHERE wdd.container_name = l_lpn_name
10855: AND wdd.released_status = 'X'; -- For LPN reusability ER : 6845650
10856:
10857: /* Release 12(K): LPN Synchronization

Line 11479: FROM wsh_delivery_details wdd

11475: /*
11476: BEGIN
11477: --{
11478: SELECT wdd.delivery_detail_id INTO l_line_rows(1)
11479: FROM wsh_delivery_details wdd
11480: , mtl_material_transactions_temp mmtt
11481: WHERE mmtt.transaction_temp_id = p_temp_id
11482: AND wdd.move_order_line_id = mmtt.move_order_line_id
11483: AND wdd.organization_id = mmtt.organization_id;

Line 11486: FROM wsh_delivery_details wdd

11482: AND wdd.move_order_line_id = mmtt.move_order_line_id
11483: AND wdd.organization_id = mmtt.organization_id;
11484: --
11485: SELECT wdd.delivery_detail_id INTO l_line_rows(2)
11486: FROM wsh_delivery_details wdd
11487: , mtl_material_transactions_temp mmtt
11488: WHERE mmtt.transfer_lpn_id = pick_to_lpn_rec.lpn_id
11489: AND wdd.move_order_line_id = mmtt.move_order_line_id
11490: AND wdd.organization_id = mmtt.organization_id

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

11490: AND wdd.organization_id = mmtt.organization_id
11491: AND rownum<2;
11492: --
11493: IF (l_debug = 1) THEN
11494: mydebug('validate_pick_to_lpn: Before calling WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping() to decide if we can load into this LPN');
11495: mydebug('Parameters : delivery_detail_id(1):'|| l_line_rows(1) ||' , delivery_detail_id(2) :'||l_line_rows(2));
11496: END IF;
11497: --
11498: -- call to the shipping API.

Line 11500: WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping(

11496: END IF;
11497: --
11498: -- call to the shipping API.
11499: --
11500: WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping(
11501: p_line_rows => l_line_rows,
11502: x_grouping_rows => l_grouping_rows,
11503: x_return_status => l_return_status);
11504: --