APPS.MRP_FLOW_SCHEDULE_UTIL dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 8076: FROM mtl_txn_request_lines mtrl, wms_license_plate_numbers wlpn, wip_lpn_completions wlc

8072:
8073: if p_use_open_quantity = 'Y' then
8074: SELECT nvl(SUM(mtrl.primary_quantity),0)
8075: INTO l_wip_state_qty
8076: FROM mtl_txn_request_lines mtrl, wms_license_plate_numbers wlpn, wip_lpn_completions wlc
8077: WHERE mtrl.organization_id = p_org_id
8078: AND mtrl.inventory_item_id = p_item_id
8079: AND NVL(mtrl.quantity_delivered, 0) = 0
8080: AND mtrl.line_status <> inv_globals.g_to_status_closed