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_CATCH_WEIGHT_PVT dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 809: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd

805:
806: CURSOR wdd_cur IS
807: SELECT wdd.delivery_detail_id, wdd.picked_quantity, wdd.requested_quantity_uom,
808: wdd.picked_quantity2, wdd.requested_quantity_uom2
809: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd
810: WHERE wda.parent_delivery_detail_id = p_parent_del_det_id
811: AND wdd.delivery_detail_id = wda.delivery_detail_id
812: AND wdd.organization_id = p_organization_id
813: AND wdd.inventory_item_id = p_inventory_item_id

Line 1378: , wsh_delivery_assignments_v wda

1374: ) primary_picked_qty
1375: , wdd2.requested_quantity_uom
1376: FROM wms_license_plate_numbers wlpn
1377: , wsh_delivery_details wdd1
1378: , wsh_delivery_assignments_v wda
1379: , wsh_delivery_details wdd2
1380: , mtl_system_items msi
1381: WHERE wlpn.lpn_id = p_lpn_id
1382: AND wlpn.lpn_context = 11

Line 3595: wsh_delivery_assignments_v wda

3591: CURSOR wdd_item_cur (p_parent_delivery_detail_id NUMBER) IS
3592: SELECT distinct wdd.organization_id, wdd.inventory_item_id, msi.primary_uom_code, msi.secondary_uom_code
3593: FROM mtl_system_items msi,
3594: wsh_delivery_details wdd,
3595: wsh_delivery_assignments_v wda
3596: WHERE wda.parent_delivery_detail_id = p_parent_delivery_detail_id
3597: AND wdd.delivery_detail_id = wda.delivery_detail_id
3598: AND wdd.line_direction = 'O'
3599: AND wdd.picked_quantity2 IS NULL

Line 3685: wsh_delivery_assignments_v wda

3681: WHERE EXISTS (
3682: SELECT 1
3683: FROM mtl_system_items msi,
3684: wsh_delivery_details wdd,
3685: wsh_delivery_assignments_v wda
3686: WHERE wda.parent_delivery_detail_id = wdd_nested_lpn_rec.delivery_detail_id
3687: AND wdd.delivery_detail_id = wda.delivery_detail_id
3688: AND wdd.line_direction = 'O'
3689: AND wdd.picked_quantity2 IS NULL

Line 3952: FROM wsh_delivery_assignments wda

3948: SELECT 'x'
3949: FROM wsh_delivery_details wdd,
3950: mtl_system_items msi
3951: WHERE wdd.delivery_detail_id IN (SELECT delivery_detail_id
3952: FROM wsh_delivery_assignments wda
3953: START WITH parent_delivery_detail_id = p_lpn_wdd_id
3954: CONNECT BY PRIOR delivery_detail_id = parent_delivery_detail_id)
3955: AND wdd.inventory_item_id = NVL(p_inventory_item_id,wdd.inventory_item_id)
3956: AND wdd.container_flag = 'N'

Line 3967: FROM wsh_delivery_assignments wda

3963: CURSOR c_get_wdd_to_upd (p_lpn_wdd_id IN NUMBER) IS
3964: SELECT 'x'
3965: FROM wsh_delivery_details wdd
3966: WHERE wdd.delivery_detail_id IN (SELECT delivery_detail_id
3967: FROM wsh_delivery_assignments wda
3968: WHERE parent_delivery_detail_id IN
3969: ( SELECT parent_delivery_detail_id
3970: FROM wsh_delivery_assignments wda2
3971: START WITH wda2.parent_delivery_detail_id = p_lpn_wdd_id

Line 3970: FROM wsh_delivery_assignments wda2

3966: WHERE wdd.delivery_detail_id IN (SELECT delivery_detail_id
3967: FROM wsh_delivery_assignments wda
3968: WHERE parent_delivery_detail_id IN
3969: ( SELECT parent_delivery_detail_id
3970: FROM wsh_delivery_assignments wda2
3971: START WITH wda2.parent_delivery_detail_id = p_lpn_wdd_id
3972: CONNECT BY PRIOR wda2.delivery_detail_id = wda2.parent_delivery_detail_id)
3973: AND EXISTS (SELECT 1
3974: FROM wsh_delivery_details wdd2,

Line 4651: FROM wsh_delivery_assignments_v wda,

4647: AND wdd.organization_id = msib.organization_id
4648: AND NVL(wdd.revision,'@@@') = NVL(NVL(p_from_item_revision,wdd.revision),'@@@')
4649: AND NVL(wdd.lot_number,'@@@') = NVL(p_from_item_lot_number,'@@@')
4650: AND wdd.delivery_detail_id in (SELECT wda.delivery_detail_id
4651: FROM wsh_delivery_assignments_v wda,
4652: wsh_delivery_details wdd1
4653: WHERE wdd1.lpn_id = in_lpn_id
4654: AND wdd1.released_status = 'X' -- For LPN reuse ER : 6845650
4655: AND wdd1.delivery_detail_id = wda.parent_delivery_Detail_id

Line 4808: FROM wsh_delivery_assignments_v wda,

4804: AND wdd.organization_id = msib.organization_id
4805: AND NVL(wdd.revision,'@@@') = NVL(p_from_item_revision,'@@@')
4806: AND NVL(wdd.lot_number,'@@@') = NVL(p_from_item_lot_number,'@@@')
4807: AND wdd.delivery_detail_id in (SELECT wda.delivery_detail_id
4808: FROM wsh_delivery_assignments_v wda,
4809: wsh_delivery_Details wdd1
4810: WHERE wdd1.lpn_id = p_from_lpn_id
4811: AND wdd1.released_status = 'X' -- For LPN reuse ER : 6845650
4812: AND wdd1.delivery_detail_id = wda.parent_delivery_Detail_id

Line 4956: FROM wsh_delivery_assignments_v wda,

4952: FROM wsh_delivery_Details wdd,
4953: mtl_system_items msi
4954: WHERE wdd.delivery_detail_id in
4955: (SELECT wda.delivery_detail_id
4956: FROM wsh_delivery_assignments_v wda,
4957: wsh_new_deliveries wnd
4958: WHERE wda.delivery_id = wnd.delivery_id
4959: AND wnd.name = p_delivery_name
4960: AND wda. PARENT_DELIVERY_DETAIL_ID is not NULL)