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_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 10761: WSH_DELIVERY_DETAILS WDD

10757: wrd.demand_type_id
10758: FROM
10759: wms_replenishment_details WRD,
10760: MTL_TXN_REQUEST_LINES MTRL,
10761: WSH_DELIVERY_DETAILS WDD
10762: WHERE WRD.ORGANIZATION_ID = P_ORG_ID
10763: AND WRD.SOURCE_LINE_ID = p_mo_line_id
10764: AND wrd.demand_type_id <> 4 -- true only for first level of REPL
10765: AND WRD.SOURCE_LINE_ID = MTRL.LINE_ID

Line 10990: WSH_DELIVERY_DETAILS wdd

10986: L_TRIP_STOP_DATE_SORT),
10987: NULL))) as sort_attribute5
10988:
10989: FROM
10990: WSH_DELIVERY_DETAILS wdd
10991: WHERE
10992: wdd.source_code = 'OE'
10993: AND wdd.requested_quantity > 0
10994: And WDD.ORGANIZATION_ID = L_ORG_ID

Line 11581: FROM wsh_delivery_details wdd1

11577:
11578: IF l_task_type = 7 THEN
11579: SELECT COUNT(wdd2.lpn_id)
11580: INTO l_shipped_wdd_count_in_lpn
11581: FROM wsh_delivery_details wdd1
11582: , wsh_delivery_details wdd2
11583: , wsh_delivery_assignments_v wda
11584: , wms_license_plate_numbers wlpn
11585: WHERE wdd1.released_status = 'C'

Line 11582: , wsh_delivery_details wdd2

11578: IF l_task_type = 7 THEN
11579: SELECT COUNT(wdd2.lpn_id)
11580: INTO l_shipped_wdd_count_in_lpn
11581: FROM wsh_delivery_details wdd1
11582: , wsh_delivery_details wdd2
11583: , wsh_delivery_assignments_v wda
11584: , wms_license_plate_numbers wlpn
11585: WHERE wdd1.released_status = 'C'
11586: AND wda.delivery_detail_id = wdd1.delivery_detail_id

Line 15284: wsh_delivery_details wdd,

15280:
15281: CURSOR pick_delivery_cursor IS
15282: SELECT wda.delivery_id
15283: FROM wsh_delivery_assignments wda,
15284: wsh_delivery_details wdd,
15285: mtl_material_transactions_temp temp
15286: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
15287: AND wdd.move_order_line_id = temp.move_order_line_id
15288: AND wdd.organization_id = temp.organization_id

Line 15295: wsh_delivery_details wdd,

15291:
15292: CURSOR drop_delivery_cursor(l_lpn_id IN NUMBER) IS
15293: SELECT wda.delivery_id
15294: FROM wsh_delivery_assignments wda,
15295: wsh_delivery_details wdd,
15296: wms_license_plate_numbers lpn
15297: WHERE wda.parent_delivery_detail_id = wdd.delivery_detail_id
15298: AND wdd.lpn_id = lpn.lpn_id
15299: AND wdd.released_status = 'X' -- For LPN reuse ER : 6845650

Line 15407: FROM wsh_delivery_details

15403: /*Bug#4106176.The following block is added.*/
15404: BEGIN
15405: SELECT delivery_detail_id
15406: INTO l_line_rows(1)
15407: FROM wsh_delivery_details
15408: WHERE lpn_id = drop_lpn_rec.lpn_id
15409: AND rownum = 1 ;
15410:
15411: SELECT wdd.delivery_detail_id

Line 15413: FROM wsh_delivery_details wdd, Mtl_material_transactions_temp mmtt

15409: AND rownum = 1 ;
15410:
15411: SELECT wdd.delivery_detail_id
15412: INTO l_line_rows(2)
15413: FROM wsh_delivery_details wdd, Mtl_material_transactions_temp mmtt
15414: WHERE mmtt.move_order_line_id = wdd.move_order_line_id
15415: AND wdd.organization_id = mmtt.organization_id
15416: AND mmtt.organization_id= p_organization_id
15417: AND mmtt.transfer_lpn_id= p_pick_lpn_id

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

15417: AND mmtt.transfer_lpn_id= p_pick_lpn_id
15418: AND rownum = 1 ;
15419:
15420: --call to the shipping API.
15421: WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping( p_line_rows => l_line_rows,
15422: x_grouping_rows => l_grouping_rows,
15423: x_return_status => l_return_status);
15424: IF (l_debug = 1) THEN
15425: mydebug ('parameters : l_line_rows(1) :'||l_line_rows(1) ||',l_line_rows(2) :' || l_line_rows(2) );

Line 15542: wsh_delivery_details wdd,

15538:
15539: CURSOR pick_delivery_cursor IS
15540: SELECT wda.delivery_id
15541: FROM wsh_delivery_assignments wda,
15542: wsh_delivery_details wdd,
15543: mtl_material_transactions_temp temp
15544: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
15545: AND wdd.move_order_line_id = temp.move_order_line_id
15546: AND wdd.organization_id = temp.organization_id

Line 15556: wsh_delivery_details wdd,

15552: l_drop_loc_c IN NUMBER ) IS
15553: --Bug Fix 4622935 Added hint as suggested by Ben Chihaoui
15554: SELECT /*+ index(wda WSH_DELIVERY_ASSIGNMENTS_N1) ORDERED USE_NL (WDA WDD WLPN) */ wlpn.outermost_lpn_id
15555: FROM wsh_delivery_assignments wda,
15556: wsh_delivery_details wdd,
15557: wms_license_plate_numbers wlpn
15558: WHERE wda.delivery_id = l_delivery_id_c
15559: AND wda.parent_delivery_detail_id = wdd.delivery_detail_id
15560: AND wdd.organization_id = p_organization_id