DBA Data[Home] [Help]

APPS.INV_RESERVATION_VALIDATE_PVT dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 5664: FROM mtl_txn_request_lines mtrl, wms_license_plate_numbers wlpn,

5660: BEGIN
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

Line 6044: FROM mtl_txn_request_lines mtrl, wms_license_plate_numbers wlpn,

6040: BEGIN
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