APPS.MRP_FLOW_SCHEDULE_UTIL dependencies on WIP_LPN_COMPLETIONS

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

8045:
8046: if p_use_open_quantity = 'Y' then
8047: SELECT nvl(SUM(mtrl.primary_quantity),0)
8048: INTO l_wip_state_qty
8049: FROM mtl_txn_request_lines mtrl, wms_license_plate_numbers wlpn, wip_lpn_completions wlc
8050: WHERE mtrl.organization_id = p_org_id
8051: AND mtrl.inventory_item_id = p_item_id
8052: AND NVL(mtrl.quantity_delivered, 0) = 0
8053: AND mtrl.line_status <> inv_globals.g_to_status_closed