DBA Data[Home] [Help]

APPS.INV_RESERVATION_VALIDATE_PVT dependencies on WSH_DELIVERY_DETAILS

Line 5665: wsh_delivery_details wdd

5661: SELECT distinct
5662: inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id),
5663: wdd.source_line_id INTO l_demand_source_header_id, l_demand_source_line_id
5664: FROM mtl_txn_request_lines mtrl, wms_license_plate_numbers wlpn,
5665: wsh_delivery_details wdd
5666: WHERE mtrl.organization_id = p_orig_rsv_rec.organization_id
5667: AND mtrl.inventory_item_id = p_orig_rsv_rec.inventory_item_id
5668: AND mtrl.line_status <> 5 -- not closed move order lines
5669: AND NVL(mtrl.quantity_delivered, 0) = 0

Line 6045: wsh_delivery_details wdd

6041: SELECT distinct
6042: inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id),
6043: wdd.source_line_id INTO l_demand_source_header_id, l_demand_source_line_id
6044: FROM mtl_txn_request_lines mtrl, wms_license_plate_numbers wlpn,
6045: wsh_delivery_details wdd
6046: WHERE mtrl.organization_id = p_to_rsv_rec.organization_id
6047: AND mtrl.inventory_item_id = p_to_rsv_rec.inventory_item_id
6048: AND mtrl.line_status <> 5 -- not closed move order lines
6049: AND NVL(mtrl.quantity_delivered, 0) = 0