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.

[Home] [Help]

APPS.WMS_TASK_DISPATCH_GEN dependencies on WSH_DELIVERY_DETAILS

Line 7980: , wsh_delivery_details wdd

7976:
7977: CURSOR others_in_mmtt_delivery_cursor(l_lpn_id IN NUMBER) IS
7978: SELECT wda.delivery_id
7979: FROM wsh_delivery_assignments_v wda
7980: , wsh_delivery_details wdd
7981: , mtl_material_transactions_temp mmtt
7982: WHERE mmtt.transfer_lpn_id = l_lpn_id
7983: AND wda.delivery_detail_id = wdd.delivery_detail_id
7984: AND wdd.move_order_line_id = mmtt.move_order_line_id

Line 8005: , wsh_delivery_details wdd

8001:
8002: CURSOR current_delivery_cursor IS
8003: SELECT wda.delivery_id
8004: FROM wsh_delivery_assignments_v wda
8005: , wsh_delivery_details wdd
8006: , mtl_material_transactions_temp mmtt
8007: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
8008: AND wdd.move_order_line_id = mmtt.move_order_line_id
8009: AND wdd.organization_id = mmtt.organization_id

Line 8015: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd

8011: AND mmtt.organization_id = p_organization_id;
8012:
8013: CURSOR drop_delivery_cursor(l_lpn_id IN NUMBER) IS
8014: SELECT wda.delivery_id
8015: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd
8016: WHERE wda.parent_delivery_detail_id = wdd.delivery_detail_id
8017: AND wdd.lpn_id = l_lpn_id
8018: AND wdd.released_status = 'X' -- For LPN reuse ER : 6845650
8019: AND wdd.organization_id = p_organization_id;

Line 8472: FROM wsh_delivery_details wdd

8468:
8469: --Bug#4440585. Added this block
8470: BEGIN
8471: SELECT wdd.delivery_detail_id INTO l_line_rows(1)
8472: FROM wsh_delivery_details wdd
8473: , mtl_material_transactions_temp mmtt
8474: WHERE mmtt.transaction_temp_id = p_temp_id
8475: AND wdd.move_order_line_id = mmtt.move_order_line_id
8476: AND wdd.organization_id = mmtt.organization_id;

Line 8479: FROM wsh_delivery_details wdd

8475: AND wdd.move_order_line_id = mmtt.move_order_line_id
8476: AND wdd.organization_id = mmtt.organization_id;
8477:
8478: SELECT wdd.delivery_detail_id INTO l_line_rows(2)
8479: FROM wsh_delivery_details wdd
8480: , mtl_material_transactions_temp mmtt
8481: WHERE mmtt.transfer_lpn_id = pick_to_lpn_rec.lpn_id
8482: AND wdd.move_order_line_id = mmtt.move_order_line_id
8483: AND wdd.organization_id = mmtt.organization_id

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

8482: AND wdd.move_order_line_id = mmtt.move_order_line_id
8483: AND wdd.organization_id = mmtt.organization_id
8484: AND rownum<2;
8485: IF (l_debug = 1) THEN
8486: mydebug('validate_pick_to_lpn: Before calling WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping() to decide if we can load into this LPN');
8487: mydebug('Parameters : delivery_detail_id(1):'|| l_line_rows(1) ||' , delivery_detail_id(2) :'||l_line_rows(2));
8488: END IF;
8489: --call to the shipping API.
8490: WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping(

Line 8490: WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping(

8486: mydebug('validate_pick_to_lpn: Before calling WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping() to decide if we can load into this LPN');
8487: mydebug('Parameters : delivery_detail_id(1):'|| l_line_rows(1) ||' , delivery_detail_id(2) :'||l_line_rows(2));
8488: END IF;
8489: --call to the shipping API.
8490: WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping(
8491: p_line_rows => l_line_rows,
8492: x_grouping_rows => l_grouping_rows,
8493: x_return_status => l_return_status);
8494:

Line 10792: WSH_DELIVERY_DETAILS WDD

10788: wrd.demand_type_id
10789: FROM
10790: wms_replenishment_details WRD,
10791: MTL_TXN_REQUEST_LINES MTRL,
10792: WSH_DELIVERY_DETAILS WDD
10793: WHERE WRD.ORGANIZATION_ID = P_ORG_ID
10794: AND WRD.SOURCE_LINE_ID = p_mo_line_id
10795: AND wrd.demand_type_id <> 4 -- true only for first level of REPL
10796: AND WRD.SOURCE_LINE_ID = MTRL.LINE_ID

Line 11027: WSH_DELIVERY_DETAILS wdd

11023: L_TRIP_STOP_DATE_SORT),
11024: NULL))) as sort_attribute5
11025:
11026: FROM
11027: WSH_DELIVERY_DETAILS wdd
11028: WHERE
11029: wdd.source_code = 'OE'
11030: AND wdd.requested_quantity > 0
11031: And WDD.ORGANIZATION_ID = L_ORG_ID

Line 11718: FROM wsh_delivery_details wdd1

11714: IF l_task_type = 7 THEN
11715: -- 8714995 added released_status 'X' condition
11716: SELECT COUNT(wdd2.lpn_id)
11717: INTO l_open_wdd_count_in_lpn
11718: FROM wsh_delivery_details wdd1
11719: , wsh_delivery_details wdd2
11720: , wsh_delivery_assignments_v wda
11721: , wms_license_plate_numbers wlpn
11722: WHERE wdd2.released_status = 'X'

Line 11719: , wsh_delivery_details wdd2

11715: -- 8714995 added released_status 'X' condition
11716: SELECT COUNT(wdd2.lpn_id)
11717: INTO l_open_wdd_count_in_lpn
11718: FROM wsh_delivery_details wdd1
11719: , wsh_delivery_details wdd2
11720: , wsh_delivery_assignments_v wda
11721: , wms_license_plate_numbers wlpn
11722: WHERE wdd2.released_status = 'X'
11723: AND wda.parent_delivery_detail_id = wdd2.delivery_detail_id

Line 11730: FROM wsh_delivery_details wdd1

11726: AND wlpn.outermost_lpn_id = l_content_lpn_id;
11727:
11728: SELECT COUNT(wdd2.lpn_id)
11729: INTO l_shipped_wdd_count_in_lpn
11730: FROM wsh_delivery_details wdd1
11731: , wsh_delivery_details wdd2
11732: , wsh_delivery_assignments_v wda
11733: , wms_license_plate_numbers wlpn
11734: WHERE wdd1.released_status = 'C'

Line 11731: , wsh_delivery_details wdd2

11727:
11728: SELECT COUNT(wdd2.lpn_id)
11729: INTO l_shipped_wdd_count_in_lpn
11730: FROM wsh_delivery_details wdd1
11731: , wsh_delivery_details wdd2
11732: , wsh_delivery_assignments_v wda
11733: , wms_license_plate_numbers wlpn
11734: WHERE wdd1.released_status = 'C'
11735: AND wda.delivery_detail_id = wdd1.delivery_detail_id

Line 15684: wsh_delivery_details wdd,

15680:
15681: CURSOR pick_delivery_cursor IS
15682: SELECT wda.delivery_id
15683: FROM wsh_delivery_assignments wda,
15684: wsh_delivery_details wdd,
15685: mtl_material_transactions_temp temp
15686: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
15687: AND wdd.move_order_line_id = temp.move_order_line_id
15688: AND wdd.organization_id = temp.organization_id

Line 15695: wsh_delivery_details wdd,

15691:
15692: CURSOR drop_delivery_cursor(l_lpn_id IN NUMBER) IS
15693: SELECT wda.delivery_id
15694: FROM wsh_delivery_assignments wda,
15695: wsh_delivery_details wdd,
15696: wms_license_plate_numbers lpn
15697: WHERE wda.parent_delivery_detail_id = wdd.delivery_detail_id
15698: AND wdd.lpn_id = lpn.lpn_id
15699: AND wdd.released_status = 'X' -- For LPN reuse ER : 6845650

Line 15807: FROM wsh_delivery_details

15803: /*Bug#4106176.The following block is added.*/
15804: BEGIN
15805: SELECT delivery_detail_id
15806: INTO l_line_rows(1)
15807: FROM wsh_delivery_details
15808: WHERE lpn_id = drop_lpn_rec.lpn_id
15809: AND rownum = 1 ;
15810:
15811: SELECT wdd.delivery_detail_id

Line 15813: FROM wsh_delivery_details wdd, Mtl_material_transactions_temp mmtt

15809: AND rownum = 1 ;
15810:
15811: SELECT wdd.delivery_detail_id
15812: INTO l_line_rows(2)
15813: FROM wsh_delivery_details wdd, Mtl_material_transactions_temp mmtt
15814: WHERE mmtt.move_order_line_id = wdd.move_order_line_id
15815: AND wdd.organization_id = mmtt.organization_id
15816: AND mmtt.organization_id= p_organization_id
15817: AND mmtt.transfer_lpn_id= p_pick_lpn_id

Line 15821: WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping( p_line_rows => l_line_rows,

15817: AND mmtt.transfer_lpn_id= p_pick_lpn_id
15818: AND rownum = 1 ;
15819:
15820: --call to the shipping API.
15821: WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping( p_line_rows => l_line_rows,
15822: x_grouping_rows => l_grouping_rows,
15823: x_return_status => l_return_status);
15824: IF (l_debug = 1) THEN
15825: mydebug ('parameters : l_line_rows(1) :'||l_line_rows(1) ||',l_line_rows(2) :' || l_line_rows(2) );

Line 15942: wsh_delivery_details wdd,

15938:
15939: CURSOR pick_delivery_cursor IS
15940: SELECT wda.delivery_id
15941: FROM wsh_delivery_assignments wda,
15942: wsh_delivery_details wdd,
15943: mtl_material_transactions_temp temp
15944: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
15945: AND wdd.move_order_line_id = temp.move_order_line_id
15946: AND wdd.organization_id = temp.organization_id

Line 15956: wsh_delivery_details wdd,

15952: l_drop_loc_c IN NUMBER ) IS
15953: --Bug Fix 4622935 Added hint as suggested by Ben Chihaoui
15954: SELECT /*+ index(wda WSH_DELIVERY_ASSIGNMENTS_N1) ORDERED USE_NL (WDA WDD WLPN) */ wlpn.outermost_lpn_id
15955: FROM wsh_delivery_assignments wda,
15956: wsh_delivery_details wdd,
15957: wms_license_plate_numbers wlpn
15958: WHERE wda.delivery_id = l_delivery_id_c
15959: AND wda.parent_delivery_detail_id = wdd.delivery_detail_id
15960: AND wdd.organization_id = p_organization_id