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_ASSIGNMENTS_V

Line 265: FROM wsh_delivery_assignments_v wda,

261: CURSOR c_get_deliv_id
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

Line 289: FROM wsh_delivery_assignments_v wda,

285:
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

Line 966: , wsh_delivery_assignments_v wda

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
970: WHERE wlpn.outermost_lpn_id = p_lpn_id))

Line 993: , wsh_delivery_assignments_v wda

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
997: AND

Line 3550: , wsh_delivery_assignments_v wda

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
3554: AND ( (mmtt.parent_line_id IS NOT NULL

Line 4530: FROM wsh_delivery_assignments_v wda

4526: , p_subinv IN VARCHAR2
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

Line 7677: , wsh_delivery_assignments_v wda

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
7681: AND wdd.delivery_detail_id = wda.parent_delivery_detail_id;

Line 7695: , wsh_delivery_assignments_v wda

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
7699: AND mtrl.line_id = wdd.move_order_line_id (+)

Line 7711: , wsh_delivery_assignments_v wda

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
7715: AND wdd.released_status = 'X' -- For LPN reuse ER : 6845650

Line 10527: FROM wsh_delivery_assignments_v wda

10523: ( p_del_id IN NUMBER
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

Line 10792: FROM wsh_delivery_assignments_v wda

10788: ( p_lpn_id IN NUMBER
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