[Home] [Help]
791:
792: CURSOR wdd_cur IS
793: SELECT wdd.delivery_detail_id, wdd.picked_quantity, wdd.requested_quantity_uom,
794: wdd.picked_quantity2, wdd.requested_quantity_uom2
795: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd
796: WHERE wda.parent_delivery_detail_id = p_parent_del_det_id
797: AND wdd.delivery_detail_id = wda.delivery_detail_id
798: AND wdd.organization_id = p_organization_id
799: AND wdd.inventory_item_id = p_inventory_item_id
1260: CURSOR wdd_item_cur (p_parent_delivery_detail_id NUMBER) IS
1261: SELECT distinct wdd.organization_id, wdd.inventory_item_id, msi.primary_uom_code, msi.secondary_uom_code
1262: FROM mtl_system_items msi,
1263: wsh_delivery_details wdd,
1264: wsh_delivery_assignments_v wda
1265: WHERE wda.parent_delivery_detail_id = p_parent_delivery_detail_id
1266: AND wdd.delivery_detail_id = wda.delivery_detail_id
1267: AND wdd.line_direction = 'O'
1268: AND wdd.picked_quantity2 IS NULL
1350: WHERE EXISTS (
1351: SELECT 1
1352: FROM mtl_system_items msi,
1353: wsh_delivery_details wdd,
1354: wsh_delivery_assignments_v wda
1355: WHERE wda.parent_delivery_detail_id = wdd_nested_lpn_rec.delivery_detail_id
1356: AND wdd.delivery_detail_id = wda.delivery_detail_id
1357: AND wdd.line_direction = 'O'
1358: AND wdd.picked_quantity2 IS NULL
1633: AND EXISTS (
1634: SELECT msi.inventory_item_id, wddl.lpn_id
1635: FROM mtl_system_items_b msi,
1636: wsh_delivery_details wddl,
1637: wsh_delivery_assignments_v wda,
1638: wsh_delivery_details wddit
1639: WHERE wddit.organization_id = msi.organization_id
1640: AND wddit.inventory_item_id = msi.inventory_item_id
1641: AND msi.ont_pricing_qty_source = 'S'
1802: (SELECT wda.delivery_detail_id,
1803: wdd.inventory_item_id,
1804: wdd.lpn_id,wdd.container_name
1805: FROM wsh_delivery_details wdd,
1806: wsh_delivery_assignments_v wda
1807: WHERE wdd.lpn_id in (
1808: SELECT wlpn.lpn_id
1809: FROM wms_license_plate_numbers wlpn
1810: WHERE outermost_lpn_id = p_outer_lpn_id)
2112: AND wdd1. picked_quantity2 is NULL
2113: AND wdd1.delivery_detail_id in
2114: (SELECT wda.delivery_detail_id
2115: FROM wsh_delivery_details wdd,
2116: wsh_delivery_assignments_v wda
2117: WHERE wdd.lpn_id= p_lpn_id
2118: AND wdd.released_status = 'X' -- For LPN reuse ER : 6845650
2119: AND wdd.delivery_detail_id = wda.parent_delivery_detail_id
2120: AND wdd.organization_id = p_org_id
2148: AND wdd.organization_id = msib.organization_id
2149: AND NVL(wdd.revision,'@@@') = NVL(NVL(p_from_item_revision,wdd.revision),'@@@')
2150: AND NVL(wdd.lot_number,'@@@') = NVL(p_from_item_lot_number,'@@@')
2151: AND wdd.delivery_detail_id in (SELECT wda.delivery_detail_id
2152: FROM wsh_delivery_assignments_v wda,
2153: wsh_delivery_details wdd1
2154: WHERE wdd1.lpn_id = in_lpn_id
2155: AND wdd1.released_status = 'X' -- For LPN reuse ER : 6845650
2156: AND wdd1.delivery_detail_id = wda.parent_delivery_Detail_id
2305: AND wdd.organization_id = msib.organization_id
2306: AND NVL(wdd.revision,'@@@') = NVL(p_from_item_revision,'@@@')
2307: AND NVL(wdd.lot_number,'@@@') = NVL(p_from_item_lot_number,'@@@')
2308: AND wdd.delivery_detail_id in (SELECT wda.delivery_detail_id
2309: FROM wsh_delivery_assignments_v wda,
2310: wsh_delivery_Details wdd1
2311: WHERE wdd1.lpn_id = p_from_lpn_id
2312: AND wdd1.released_status = 'X' -- For LPN reuse ER : 6845650
2313: AND wdd1.delivery_detail_id = wda.parent_delivery_Detail_id
2453: FROM wsh_delivery_Details wdd,
2454: mtl_system_items msi
2455: WHERE wdd.delivery_detail_id in
2456: (SELECT wda.delivery_detail_id
2457: FROM wsh_delivery_assignments_v wda,
2458: wsh_new_deliveries wnd
2459: WHERE wda.delivery_id = wnd.delivery_id
2460: AND wnd.name = p_delivery_name
2461: AND wda. PARENT_DELIVERY_DETAIL_ID is not NULL)