APPS.INV_ABC_ASSIGNMENTS_PVT dependencies on MTL_SYSTEM_ITEMS_FVL

Line 57: FROM mtl_system_items_fvl

53: CURSOR check_item_exists (
54: p_item_id NUMBER,
55: p_org_id NUMBER) IS
56: SELECT inventory_item_id
57: FROM mtl_system_items_fvl
58: WHERE inventory_item_id = p_item_id
59: AND organization_id = p_org_id
60: AND enabled_flag = 'Y'
61: AND trunc(SYSDATE) between nvl(trunc(start_date_active),trunc(SYSDATE)) and nvl(trunc(end_date_active),trunc(SYSDATE)) ;