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_PICK_DROP_PVT dependencies on WSH_DELIVERY_DETAILS

Line 266: wsh_delivery_details_ob_grp_v wdd,

262: ( p_tmp_id IN NUMBER
263: ) IS
264: SELECT wda.delivery_id
265: FROM wsh_delivery_assignments_v wda,
266: wsh_delivery_details_ob_grp_v wdd,
267: mtl_material_transactions_temp mmtt
268: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
269: AND wdd.move_order_line_id = mmtt.move_order_line_id
270: AND wdd.organization_id = mmtt.organization_id

Line 290: wsh_delivery_details_ob_grp_v wdd,

286: IF p_drop_type = 'CONS_STG_MV' THEN
287: SELECT wda.delivery_id
288: INTO x_delivery_id
289: FROM wsh_delivery_assignments_v wda,
290: wsh_delivery_details_ob_grp_v wdd,
291: mtl_material_transactions_temp mmtt
292: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
293: AND wdd.organization_id = mmtt.organization_id
294: AND mmtt.transaction_temp_id = p_temp_id

Line 965: , wsh_delivery_details_ob_grp_v wdd

961: )
962: )
963: FROM mtl_material_transactions_temp mmtt
964: , mtl_txn_request_lines mtrl
965: , wsh_delivery_details_ob_grp_v wdd
966: , wsh_delivery_assignments_v wda
967: WHERE mmtt.organization_id = p_org_id
968: --Modified for Bug 6717052
969: AND (mmtt.transfer_lpn_id = p_lpn_id OR mmtt.transfer_lpn_id IN (SELECT wlpn.lpn_id FROM wms_license_plate_numbers wlpn

Line 992: , wsh_delivery_details_ob_grp_v wdd

988: ) IS
989: SELECT Count(DISTINCT wda.delivery_id)
990: FROM mtl_material_transactions_temp mmtt
991: , mtl_txn_request_lines mtrl
992: , wsh_delivery_details_ob_grp_v wdd
993: , wsh_delivery_assignments_v wda
994: WHERE mmtt.organization_id = p_org_id
995: AND mmtt.transfer_lpn_id = p_lpn_id
996: AND ( (mmtt.parent_line_id IS NOT NULL

Line 1018: , wsh_delivery_details wdd

1014: ) IS
1015: SELECT DISTINCT delivery_detail_id
1016: FROM mtl_material_transactions_temp mmtt
1017: , mtl_txn_request_lines mtrl
1018: , wsh_delivery_details wdd
1019: WHERE mmtt.organization_id = p_org_id
1020: AND mmtt.transfer_lpn_id = p_lpn_id
1021: AND ( (mmtt.parent_line_id IS NOT NULL
1022: AND

Line 1433: print_debug('Before calling WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping(),Printing l_delivery_cnt:::'||l_delivery_cnt, l_api_name);

1429: OPEN c_delivery_cnt (p_organization_id, p_transfer_lpn_id);
1430: FETCH c_delivery_cnt INTO l_delivery_cnt;
1431: CLOSE c_delivery_cnt;
1432: IF (l_debug = 1) THEN
1433: print_debug('Before calling WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping(),Printing l_delivery_cnt:::'||l_delivery_cnt, l_api_name);
1434: END IF;
1435: --Bug 13644027 END
1436: -- bug#10062741
1437: IF (l_drop_count = 1 AND l_delivery_cnt = 0) THEN

Line 1444: print_debug('Before calling WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping() to decide if we can drop into 1 LPN', l_api_name);

1440: FETCH c_stg_delivery_details BULK COLLECT INTO l_line_rows;
1441: CLOSE c_stg_delivery_details;
1442:
1443: IF (l_debug = 1) THEN
1444: print_debug('Before calling WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping() to decide if we can drop into 1 LPN', l_api_name);
1445: END IF;
1446: --
1447: -- call to the shipping API.
1448: --

Line 1449: WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping(

1445: END IF;
1446: --
1447: -- call to the shipping API.
1448: --
1449: WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping(
1450: p_line_rows => l_line_rows,
1451: x_grouping_rows => l_grouping_rows,
1452: x_return_status => l_return_status);
1453: --

Line 3549: , wsh_delivery_details_ob_grp_v wdd

3545: FROM mtl_material_transactions_temp mmtt
3546: , mtl_secondary_inventories msi
3547: , mtl_item_locations mil
3548: , mtl_txn_request_lines mtrl
3549: , wsh_delivery_details_ob_grp_v wdd
3550: , wsh_delivery_assignments_v wda
3551: WHERE mmtt.organization_id = p_org_id
3552: AND mmtt.transfer_lpn_id = p_lpn_id
3553: AND mmtt.transaction_action_id = 28

Line 3969: print_debug('Before calling WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping() to decide if we can drop in the same task', l_api_name);

3965: l_line_rows(1) := c_tasks_orig_rec.delivery_detail_id;
3966: l_line_rows(2) := c_tasks_curr_rec.delivery_detail_id;
3967:
3968: IF (l_debug = 1) THEN
3969: print_debug('Before calling WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping() to decide if we can drop in the same task', l_api_name);
3970: print_debug('Parameters : delivery_detail_id(1):'|| l_line_rows(1) ||' , delivery_detail_id(2) :'||l_line_rows(2), l_api_name);
3971: END IF;
3972: --
3973: -- call to the shipping API.

Line 3975: WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping(

3971: END IF;
3972: --
3973: -- call to the shipping API.
3974: --
3975: WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping(
3976: p_line_rows => l_line_rows,
3977: x_grouping_rows => l_grouping_rows,
3978: x_return_status => l_return_status);
3979: --

Line 4531: , wsh_delivery_details_ob_grp_v wdd

4527: , p_loc_id IN NUMBER
4528: ) IS
4529: SELECT wlpn.outermost_lpn_id
4530: FROM wsh_delivery_assignments_v wda
4531: , wsh_delivery_details_ob_grp_v wdd
4532: , wms_license_plate_numbers wlpn
4533: WHERE wda.delivery_id = p_deliv_id
4534: AND wda.parent_delivery_detail_id = wdd.delivery_detail_id
4535: AND wdd.organization_id = p_org_id

Line 7676: FROM wsh_delivery_details_ob_grp_v wdd

7672: ( p_lpn_id IN NUMBER
7673: , p_org_id IN NUMBER
7674: ) IS
7675: SELECT wda.delivery_id
7676: FROM wsh_delivery_details_ob_grp_v wdd
7677: , wsh_delivery_assignments_v wda
7678: WHERE wdd.lpn_id = p_lpn_id
7679: AND wdd.released_status = 'X' -- For LPN reuse ER : 6845650
7680: AND wdd.organization_id = p_org_id

Line 7694: , wsh_delivery_details_ob_grp_v wdd

7690: , mtrl.carton_grouping_id
7691: , wda.delivery_id
7692: FROM mtl_material_transactions_temp mmtt
7693: , mtl_txn_request_lines mtrl
7694: , wsh_delivery_details_ob_grp_v wdd
7695: , wsh_delivery_assignments_v wda
7696: WHERE mmtt.organization_id = p_org_id
7697: AND mmtt.transfer_lpn_id = p_lpn_id
7698: AND mmtt.move_order_line_id = mtrl.line_id

Line 7710: FROM wsh_delivery_details_ob_grp_v wdd

7706: ( p_lpn_id IN NUMBER
7707: , p_org_id IN NUMBER
7708: ) IS
7709: SELECT mtrl.carton_grouping_id
7710: FROM wsh_delivery_details_ob_grp_v wdd
7711: , wsh_delivery_assignments_v wda
7712: , wsh_delivery_details_ob_grp_v wdd2
7713: , mtl_txn_request_lines mtrl
7714: WHERE wdd.lpn_id = p_lpn_id

Line 7712: , wsh_delivery_details_ob_grp_v wdd2

7708: ) IS
7709: SELECT mtrl.carton_grouping_id
7710: FROM wsh_delivery_details_ob_grp_v wdd
7711: , wsh_delivery_assignments_v wda
7712: , wsh_delivery_details_ob_grp_v wdd2
7713: , mtl_txn_request_lines mtrl
7714: WHERE wdd.lpn_id = p_lpn_id
7715: AND wdd.released_status = 'X' -- For LPN reuse ER : 6845650
7716: AND wdd.organization_id = p_org_id

Line 10528: , wsh_delivery_details_ob_grp_v wdd

10524: ) IS
10525: SELECT MIN(ooha.order_number)
10526: , COUNT(DISTINCT ooha.order_number)
10527: FROM wsh_delivery_assignments_v wda
10528: , wsh_delivery_details_ob_grp_v wdd
10529: , oe_order_lines_all oola
10530: , oe_order_headers_all ooha
10531: WHERE wda.delivery_id = p_del_id
10532: AND wda.delivery_detail_id = wdd.delivery_detail_id

Line 10793: , wsh_delivery_details_ob_grp_v wdd

10789: , p_org_id IN NUMBER
10790: ) IS
10791: SELECT wda.delivery_id
10792: FROM wsh_delivery_assignments_v wda
10793: , wsh_delivery_details_ob_grp_v wdd
10794: , wms_license_plate_numbers lpn
10795: WHERE wda.parent_delivery_detail_id = wdd.delivery_detail_id
10796: AND wdd.organization_id = p_org_id
10797: AND wdd.lpn_id = lpn.lpn_id

Line 11101: FROM wsh_delivery_details_ob_grp_v

11097: /*Bug#4106176.The following block is added.*/
11098: /* BEGIN -- mrana: need to figure this out later
11099: SELECT delivery_detail_id
11100: INTO l_line_rows(1)
11101: FROM wsh_delivery_details_ob_grp_v
11102: WHERE lpn_id = drop_lpn_rec.lpn_id
11103: AND rownum = 1 ;
11104:
11105: SELECT wdd.delivery_detail_id

Line 11107: FROM wsh_delivery_details_ob_grp_v wdd, Mtl_material_transactions_temp mmtt

11103: AND rownum = 1 ;
11104:
11105: SELECT wdd.delivery_detail_id
11106: INTO l_line_rows(2)
11107: FROM wsh_delivery_details_ob_grp_v wdd, Mtl_material_transactions_temp mmtt
11108: WHERE mmtt.move_order_line_id = wdd.move_order_line_id
11109: AND wdd.organization_id = mmtt.organization_id
11110: AND mmtt.organization_id= p_organization_id
11111: AND mmtt.transfer_lpn_id= p_transfer_lpn_id

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

11111: AND mmtt.transfer_lpn_id= p_transfer_lpn_id
11112: AND rownum = 1 ;
11113:
11114: --call to the shipping API.
11115: WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping( p_line_rows => l_line_rows,
11116: x_grouping_rows => l_grouping_rows,
11117: x_return_status => x_return_status);
11118: IF (l_debug = 1) THEN
11119: print_debug ('parameters : l_line_rows(1) :'||l_line_rows(1) ||',l_line_rows(2) :' || l_line_rows(2), l_api_name);